E_BW4HANA214 · Question #28
In an SAP BW/4HANA system you plan to leverage Data Tiering Optimization (DTO) for a DataStore object (advanced). Which activities are required to set up the HOT tier as well as the COLD tier for…
The correct answer is A. Choose between Temperature Maintenance "On Partition Level" or "On Object Level". B. Define the planned temperature for each partition. Setting up DTO for a aDSO requires two configuration steps within the DTO framework itself: first, deciding the granularity of temperature control (Option A - whether to manage temperature at the entire object level or per individual partition), and second, assigning the actual…
Question
In an SAP BW/4HANA system you plan to leverage Data Tiering Optimization (DTO) for a DataStore object (advanced). Which activities are required to set up the HOT tier as well as the COLD tier for this object? Note: There are 2 correct answers to this question
Options
- AChoose between Temperature Maintenance "On Partition Level" or "On Object Level".
- BDefine the planned temperature for each partition
- CSpecify partitions for the Data Store object (advanced)
- DCreate a Data Archiving Process (DAP) for the Data Store object (advanced).
How the community answered
(26 responses)- A85% (22)
- C12% (3)
- D4% (1)
Explanation
Setting up DTO for a aDSO requires two configuration steps within the DTO framework itself: first, deciding the granularity of temperature control (Option A - whether to manage temperature at the entire object level or per individual partition), and second, assigning the actual planned temperature (HOT, WARM, COLD) to each partition (Option B). These two steps directly configure the tiering behavior in the HANA database.
Why C is wrong: Partitioning the aDSO is a prerequisite infrastructure task, not a DTO-specific setup activity. The DTO configuration assumes partitioning is already in place; you don't "specify partitions" as part of the DTO setup steps themselves.
Why D is wrong: A Data Archiving Process (DAP) belongs to nearline storage / data archiving workflows, which is a separate concept entirely. DTO manages temperature tiering within SAP HANA (HOT = in-memory, COLD = disk/dynamic tiering), whereas DAP moves data out of the HANA database to an external nearline storage system.
Memory tip: Think of DTO setup as answering two questions in order - "How do I manage temperature?" (Object vs. Partition level = Option A), then "What temperature goes where?" (assign HOT/COLD to each partition = Option B). DAP is for archiving out, not tiering within.
Topics
Community Discussion
No community discussion yet for this question.