What helps in the “Data Activation uses the Delta Merge mechanism of the SAP HANA database, replacing the old algorithm”? Please choose the correct answer.
- A . Query Performance
- B . Data Mart
- C . Layer Mart
- D . Load Performance
Identify the three major components of SAP NetWeaver Business Warehouse C EDW Persistency and Performance Management? There are 3 correct answers to this question.
- A . Processors
- B . BWA
- C . BW Star Schema
- D . Achieve
- E . Checking errors
What are the tools provide within EDW to repair or redo unexpected failures during load processes? There are 3 correct answers to this question.
- A . Metadata Management
- B . Process Chains
- C . Admin Cockpit
- D . Hidden Repair Chains
- E . Copy Error DTPs
When sizing an SAP HANA database with the sizing report for SAP BW powered by SAP HANA, which of the following features are available? There are 2 correct answers to this question.
- A . Table-specific compression factors
- B . Partitioning concept
- C . Non-active data concept
- D . Sizing of an LSA++ implementation
What are the special methods required for managing planning sessions commands? There are 2 correct answers to this question.
- A . Rapid prototyping
- B . Ad-hoc scenarios
- C . BW Workspaces
- D . Open
- E . Close
How can HANA-optimized Data Store Objects leverage SAP HANA technology? Identify from the following options. There are 3 correct answers to this question.
- A . Reduce the amount of physical storage
- B . Accelerate data loads
- C . Allow faster Remodeling of structural changes
- D . No adoption of processes
- E . Multi Provider
Your customer runs SAP Business Warehouse (SAP BW) 7.4 on SAP HANA and would like to build a BEx Query on top of an existing native SAP HANA calculation view.
The query should make use of a master data hierarchy that is already available in SAP BW.
What is the recommended approach for this scenario? Please choose the correct answer.
- A . Create a SAP BusinessObjects BI Universe and copy the hierarchy from SAP BW to the field of the SAP HANA calculation view.
- B . Create a VirtualProvider and associate all fields of the SAP HANA view with SAP BW InfoObjects.
- C . Create a CompositeProvider in Eclipse and associate the relevant field of the SAP HANA calculation view with the corresponding SAP BW InfoObject.
- D . Create a TransientProvider and associate only the relevant field of the SAP HANA calculation view with the corresponding SAP BW InfoObject.
When Data Store objects can only be converted to SAP HANA optimized Data Store objects? There are 2 correct answers to this question.
- A . Allow faster modeling.
- B . They are not part of a Hybrid Provider
- C . They are not supplied with data using real-time data acquisition
- D . Increase the amount of storage
Identify which of the following function is not a part of Accelerated Planning Functions? Please choose the correct answer.
- A . Aggregation
- B . Disaggregation
- C . Conversions
- D . Faster modelling
What information You can acquire from the font and the color of the text? There are 3 correct answers to this question.
- A . Red text: All time availability
- B . Black text: Normal provider fields
- C . Italic text: Calculated characteristic and constant
- D . Blue text: Join field
- E . Grey text: Users
What are the steps involved in procedure for HANA- Optimized infocube- Conversion? There are 2 correct answers to this question.
- A . Describe the Conversion process
- B . Elaborate the typical business scenarios where SAP HANA optimized InfoCubes can be used
- C . You can now use in put help to select InfoCubes for conversion.
- D . You can specify whether the log is displayed after conversion
To optimize utilization of the main memory, you want to make sure the following for non-active data:
There are 2 correct answers to this question.
- A . All columns of the object are accessed.
- B . If the main memory has sufficient capacity
- C . Non-active data is available directly in the main memory
- D . No optimal access to data that is relevant for reporting
What is the result when the Trigger Delta Merge process chain step is executed for a given data target? Please choose the correct answer.
- A . The delta between the new data and the already loaded data is calculated in the data target.
- B . Data is transferred from the delta store to the main store of the data target.
- C . The before and after images of the delta queue are merged and sent to the data target.
- D . Only data from the delta queue is extracted and merged into the data target.
What combines data from multiple provider sand builds the union sets for the relevant data? Please choose the correct answer.
- A . A Join
- B . A Inner
- C . A Union
- D . A Left Inner
Identify the two main characteristics of Virtual Data Marts on Open ODS and/or EDW? There are 2 correct answers to this question.
- A . Flexibility
- B . Time- to market
- C . Virtual Provider
- D . Transient Provider
What is the procedure for BW Workspace Designer C Composite Provider? There are 2 correct answers to this question.
- A . Select data source
- B . File data source
- C . Choose start
- D . Enter a name for your compositeprovider
What are the requirements for DTPs to manage inventory data? There are 2 correct answers to this question.
- A . First, the DTP which loads the initial data set.
- B . You need a second DTP for regular movements
- C . Extraction Mode of the RDA
- D . DSOs movements
What are the requirements for DTPs to manage inventory data? There are 2 correct answers to this question.
- A . First, the DTP which loads the initial data set.
- B . You need a second DTP for regular movements
- C . Extraction Mode of the RDA
- D . DSOs movements
When would you store a table as row-based? There are 2 correct answers to this question.
- A . When the number of records is huge
- B . When all columns of the table are relevant
- C . When the table contains several repeated values
- D . When aggregation is not required
What are the key benefits of Key Benefits of Enterprise Data Warehousing? There are 2 correct answers to this question.
- A . Reusability
- B . Integration
- C . Rigidness
- D . Blockage of info
The SAP HANA C Optimized infocubes consist of main Properties.
What are they? There are 3 correct answers to this question.
- A . Choose Execute. The InfoCubes are converted
- B . All newly created infocubes are SAP HANA optimized
- C . The SIDs are directly written to the fact table
- D . BW accelerator obsolete
- E . Need a second DTP for regular movements
Which of the following is not a function of Delta Merge Operation? Please choose the correct answer.
- A . The delta merge operation is executed on table level.
- B . Itspurposeistomovechangescollectedinwriteoptimizeddeltastorageinto the compressed
and read optimized main storage - C . The delta merge operation is decoupled from the execution of the transaction that performs the changes
- D . Memory consumption of delta storage exceeds specified limit
What should you do after an InfoCube is converted to be in-memory optimized? Please choose the correct answer.
- A . Review customer-specific programs that access tables belonging to the InfoCube.
- B . Delete obsolete process types from process chains containing the InfoCube.
- C . Activate all MultiProviders that include the InfoCube.
- D . Reload data into the InfoCube.
Which is not an element of BI Projects Built on Customer LSA Standards? Please choose the correct answer.
- A . SAP’S -LSA standards
- B . Customer- LSA operations standards
- C . Storage Management standards
- D . Customer-LSA implementation standards
Which component is a part of Enterprise Data Warehouse Layer? Please choose the correct answer.
- A . Data acquisition Layer
- B . Proportional Layer
- C . Transactional Layer
- D . Reporting Layer
What are the means to Optimized SAP HANA Data Load into SAP NetWeaver BW? There are 2 correct answers to this question.
- A . Enable direct loading from HANA Views via DTP into BW managed schema
- B . Data persistency in PSA optional Mass data loading
- C . You create an ODP source system to connect the source
- D . You create a Data Source for an operational data provider
What allows you to hide entire providers, to modify the horizontal distance between the nodes and to deactive automatic highlighting? Please choose the correct answer.
- A . Properties
- B . Standards
- C . Settings
- D . Menu
List down the tools required to repair or redo unexpected failures during load processes within the EDW? There are 3 correct answers to this question.
- A . Data Store Object
- B . Integrated Planning
- C . Metadata Management
- D . Process Chains
- E . Admin Cockpit
What problem occurs If data is classified incorrectly, and is used frequently In hardware sizing of SAP HANA DB? Please choose the correct answer.
- A . Indexes
- B . Database
- C . Main memory management
- D . Non- active data
How you can see where the first data row begins, and how many headers there are? Please choose the correct answer.
- A . Meta Data
- B . DB Data
- C . Display Data
- D . Core Data