CAD CAD Data Management & Integration 2 — Questions and Answers
Question 1: Which HTTP method should a CAD developer use to partially update an existing OData entity?
- GET
- POST
- PUT
- PATCH (Correct answer)
Correct answer: PATCH
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?
- Replicating data to a local cache
- Querying multiple heterogeneous data sources as if they were one (Correct answer)
- Encrypting data at rest
- Archiving old records to cold storage
Correct 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.
Question 3: When using SAP HANA as the database layer, which JOIN strategy is recommended for large fact tables to improve performance?
- Nested loop join
- Hash join with column pruning (Correct answer)
- Merge join with row store
- Cross join with indexing
Correct 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.
Question 4: Which SAP CAD best practice applies when an application must consume the same OData entity set from two different back-end systems?
- Hard-code both URLs in the controller
- Use two separate destinations and a routing layer or integration flow (Correct answer)
- Merge both entity sets into a single CDS view locally
- Disable CSRF protection to simplify calls
Correct 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.
Question 5: In SAP CAD, which data type is recommended for storing monetary values to avoid floating-point precision errors?
- FLOAT
- DOUBLE
- DECIMAL(p, s) (Correct answer)
- SMALLINT
Correct answer: DECIMAL(p, s)
DECIMAL with explicit precision and scale ensures exact representation of monetary values without rounding errors caused by binary floating point.
Question 6: What is the advantage of using delta loads over full loads when synchronizing data in a SAP CAD integration scenario?
- Delta loads encrypt data automatically
- Delta loads transfer only changed records, reducing bandwidth and processing time (Correct answer)
- Delta loads bypass all authorization checks
- Delta loads always guarantee real-time consistency
Correct 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.
CAD CAD Data Management & Integration 2
Which HTTP method should a CAD developer use to partially update an existing OData entity?