A BW/4HANA system needs to keep infrequently accessed but still queried data out of HANA memory while leaving it available inside the database. Which feature should be used?
Show answer and explanation
Answer: A
NSE marks tables, columns, or partitions as page loadable, so their data lives on disk in the HANA data volume and only accessed pages move into a separate buffer cache. Queries and transactions still work through normal HANA SQL, but the memory footprint drops and a smaller certified instance can be used. It is intended for warm data that may still change, unlike archiving or deletion.
Why the other options are wrong
- B. Buying larger memory hosts every time data grows defeats the cost goal and does not change the data temperature.
- C. Tape archiving removes data from online HANA access and is for cold data that no longer changes.
- D. Deleting data destroys retention and reporting history and is not a tiering mechanism.
Exam tip. Warm data that is still queried in HANA uses NSE page-loadable storage on disk.