Online Access Free E_HANABW_12 Practice Test

Which objects can you use to go from a persistent to a logical data warehouse based on new layered scalable architecture (LSA++) for SAP Business Warehouse 7.4?
There are 2 correct answers to this question.
Response:

• A.New Eclipse-based CompositeProvider
• B.Open ODS view
• C.Virtual key figures
• D.VirtualProvider

When would you store a table as row-based?
There are 2 correct answers to this question.
Response:

• A.When aggregation is not required
• B.When the number of records is huge
• C.When the table contains several repeated values
• D.When all columns of the table are relevant

Which of the following is not a feature of Agile Data Mart Layer and BW Workspace Layer?
Please choose the correct answer.
Response:

• A.Reduce layer size
• B.Migrate to HANA - optimize object
• C.Streamline EDW core
• D.Resulting LSA++

Which component is a part of Enterprise Data Warehouse Layer?
Please choose the correct answer.
Response:

• A.Proportional Layer
• B.Reporting Layer
• C.Transactional Layer
• D.Data acquisition Layer

Which component is not a part of Query Performance
Please choose the correct answer.
Response:

• A.Flat InfoCubes contain master data SIDs directly in the fact table
• B.Data Activation uses the Delta Merge mechanism of the SAP HANA
• C.Reading from a DSO is faster, due to the columnar storage and parallel execution of read processes.
• D.Calculations and aggregations are faster, since they are evaluated by the database server instead of the application server.