CAD CAD Performance & Optimization 3

Question 1

Which SAP CAD design pattern helps decouple UI components from business logic to improve testability and maintainability?

Accepted Answer

Model-View-Controller (MVC) with Separation of Concerns

Answer

MVC with strict Separation of Concerns keeps UI rendering, data handling, and business logic in independent layers, enabling unit testing each layer independently.

Question 2

In SAP CAD performance tuning, what does 'delta merge' refer to in the HANA column store?

Accepted Answer

Moving newly inserted records from the write-optimized delta store to the read-optimized main store

Answer

Delta merge is the background process that migrates inserted or updated rows from HANA's row-based delta store into the compressed, sorted column-store main store.

Question 3

Which SAPUI5 best practice reduces the number of synchronous XMLHttpRequests during application startup?

Accepted Answer

Using the sap.ui.loader with async:true and preloading via Component-preload.js

Answer

Configuring async:true in the SAPUI5 loader and shipping a preload bundle allows all modules to load in parallel, eliminating startup blocking.

Question 4

What is the recommended approach to handle long-running processes in a SAP CAD application without blocking the user interface?

Accepted Answer

Offload to a background job (e.g., ABAP batch job or BTP Job Scheduling Service) and poll for status

Answer

Background jobs decouple long-running work from the HTTP request cycle; the UI polls or subscribes to a status endpoint for completion.

Question 5

Which SQL technique in ABAP or HANA avoids redundant computation when the same sub-query result is needed multiple times in a query?

Accepted Answer

Common Table Expressions (WITH clause) to define reusable sub-query results

Answer

CTEs (WITH clause) let you name and reference a sub-query result multiple times in one statement, computed only once by the optimizer.

(CAD) Certified Application Developer Practice Test

(CAD) Certified Application Developer Practice Test

CAD CAD Performance & Optimization 3