CAD CAD Performance & Optimization 1 — Questions and Answers
Question 1: Which SAPUI5 feature allows lazy loading of application modules to reduce initial page load time?
- XML Fragment pre-fetching
- Component-preload.js bundling with async require (Correct answer)
- Synchronous script tags
- Inline CSS animations
Correct answer: Component-preload.js bundling with async require
Bundling code into Component-preload.js and using asynchronous module loading minimizes initial payload and defers non-critical code.
Question 2: In SAP HANA, what is the effect of creating a Calculation View instead of a Scripted Calculation View for performance-sensitive queries?
- Scripted views are always faster because they use SQL
- Graphical Calculation Views allow the HANA optimizer to push down operations more efficiently (Correct answer)
- Scripted views bypass column store entirely
- Both perform identically regardless of complexity
Correct answer: Graphical Calculation Views allow the HANA optimizer to push down operations more efficiently
Graphical Calculation Views expose the execution plan to the HANA optimizer, enabling better push-down and pruning compared to opaque scripted SQL.
Question 3: What is the recommended strategy to reduce unnecessary OData backend calls in a SAPUI5 application?
- Disable HTTP caching headers
- Use batch requests ($batch) to group multiple OData operations into a single HTTP call (Correct answer)
- Make all requests synchronous
- Reload the entire page on each user action
Correct answer: Use batch requests ($batch) to group multiple OData operations into a single HTTP call
$batch combines multiple OData read/write operations into one HTTP request, reducing network round trips and improving perceived performance.
Question 4: Which SAP BTP feature helps a CAD developer cache frequently read configuration data and reduce database hits?
- SAP Alert Notification Service
- SAP BTP Redis Cache or Application-level caching via CAP (Correct answer)
- SAP Build Work Zone
- SAP Transport Management Service
Correct answer: SAP BTP Redis Cache or Application-level caching via CAP
Redis Cache or CAP's built-in caching layer stores frequently accessed data in memory, avoiding repeated database reads for the same data.
Question 5: In ABAP, which optimization technique avoids loading entire database table contents into internal tables unnecessarily?
- Using SELECT * without WHERE clause
- Using SELECT with a targeted WHERE clause and UP TO n ROWS (Correct answer)
- Using full table scans for simplicity
- Disabling buffering on the table
Correct answer: Using SELECT with a targeted WHERE clause and UP TO n ROWS
A targeted WHERE clause with UP TO n ROWS limits data transfer between the database and application server, improving runtime and memory use.
Question 6: What does 'index server CPU saturation' indicate in an SAP HANA performance alert?
- The disk storage is full
- The in-memory column store processing cores are overloaded, causing query queuing (Correct answer)
- The network interface card is failing
- The backup job is running
Correct answer: The in-memory column store processing cores are overloaded, causing query queuing
HANA's index server handles all column-store operations; CPU saturation means query parallelism is exhausted and queries begin queuing.
CAD CAD Performance & Optimization 1
Which SAPUI5 feature allows lazy loading of application modules to reduce initial page load time?