CAD Data Management & Integration Flashcards

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

Answer: PATCH

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

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

Answer: Querying multiple heterogeneous data sources as if they were one

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

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

Answer: Hash join with column pruning

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

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

Answer: Use two separate destinations and a routing layer or integration flow

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

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

Answer: DECIMAL(p, s)

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

What is the advantage of using delta loads over full loads when synchronizing data in a SAP CAD integration scenario?

Answer: Delta loads transfer only changed records, reducing bandwidth and processing time

Delta loads extract only new or modified records since the last run, significantly reducing data transfer volume and system load.