In SAP BW/4HANA, you decide to use the COLD Store of the Data Tiering Optimization (DTO) concept. Where can the data be managed?

Question

Options

• ASAP HANA Cloud, data lake
• BSAP IQ Database
• CHadoop Distributed File System
• DSAP Data sphere, SAP BW Bridge

• B
  90% (28)
• C
  6% (2)
• D
  3% (1)

Explanation

SAP IQ Database is the designated COLD Store in BW/4HANA's Data Tiering Optimization concept because it is the only SAP-supported nearline storage solution for rarely accessed, historical data within the DTO framework - data is offloaded from the HOT (HANA in-memory) or WARM (NSE/Dynamic Tiering) tiers to SAP IQ to reduce memory costs while keeping data queryable.

Why the distractors are wrong:

• A (SAP HANA Cloud, data lake): This is a cloud-native storage layer unrelated to the on-premise DTO architecture's COLD Store definition.
• C (Hadoop HDFS): While Hadoop can integrate with some SAP solutions, it is not a supported target for DTO's COLD Store.
• D (SAP Datasphere / BW Bridge): SAP Datasphere is a separate data fabric platform, and BW Bridge is a migration tool for bringing BW objects into Datasphere - neither serves as the DTO COLD Store.

Memory tip: Think of temperature tiers like a freezer analogy - HOT (in-memory HANA), WARM (NSE disk), and COLD (IQ). SAP IQ = Icy/cold storage. SAP IQ (formerly Sybase IQ) was specifically designed as a column-based nearline archive, making it the natural fit for BW/4HANA's coldest data tier.

No community discussion yet for this question.