CAD CAD Data Management & Integration 2

Question 1

Which HTTP method should a CAD developer use to partially update an existing OData entity?

Accepted Answer

PATCH

Answer

PATCH sends only the changed fields to partially update a resource, whereas PUT replaces the entire entity.

Question 2

What does the term 'data federation' mean in the context of SAP CAD applications?

Accepted Answer

Querying multiple heterogeneous data sources as if they were one

Answer

Data federation allows a single query to span multiple data sources without physically moving the data, providing a unified view.

Question 3

When using SAP HANA as the database layer, which JOIN strategy is recommended for large fact tables to improve performance?

Accepted Answer

Hash join with column pruning

Answer

Hash joins combined with column pruning leverage HANA's columnar storage and in-memory processing for large analytical datasets.

Question 4

Which SAP CAD best practice applies when an application must consume the same OData entity set from two different back-end systems?

Accepted Answer

Use two separate destinations and a routing layer or integration flow

Answer

Using separate BTP Destinations and an integration/routing layer keeps connectivity configurations maintainable and secure.

Question 5

In SAP CAD, which data type is recommended for storing monetary values to avoid floating-point precision errors?

Accepted Answer

DECIMAL(p, s)

Answer

DECIMAL with explicit precision and scale ensures exact representation of monetary values without rounding errors caused by binary floating point.

(CAD) Certified Application Developer Practice Test