What is used to develop BW queries in SAP BW/4HANA?
A. BEx Query Designer
B. Eclipse-based Query Designer
C. SAP Analysis for Microsoft Office
D. BEx Web Application Designer
Which of the following statements are true?
A. RDA supports operational reporting.
B. You have more to learn.
C. VirtualProviders can cause a load on the OLTP system and BI at the same time.
D. InfoSets join more than one target to a logical set for reporting.
Exception aggregation has no effect on the saving of data in the fact table because it is only effective for reporting. Determine whether this statement is true or false.
A. True
B. False
For which of the following objects in SAP BW/4HANA can you create an SAP HANA calculation view? Note: There are 2 correct answers to this question.
A. Data transfer processes.
B. SAP BW/4HANA queries.
C. Open hub destinations.
D. Analysis Process Designer.
E. CompositeProviders and DataStore objects (advanced).
How can SAP BW/4HANA allocate temperature using Data Tiering Optimization (DTO)? Note: There are 2 correct answers to this question.
A. By access patterns identified from the system automatically
B. By partition.
C. By DataStore object (advanced).
D. By data archiving process (DAP)
What are the three predefined dimensions in SAP BW?
A. Time
B. Date
C. Unit
D. DataPackage
What are the core predictive functions to answer business questions? Note: There are 2 correct answers to this question.
A. Gaussian normal distribution
B. Classification and regression
C. XRF spectroscopy
D. Segmentation or clustering
Which of the following are advantages of column tables?
A. Elimination of additional indexe
B. Elimination of parallel execution
C. Elimination of materialized aggregates
D. Higher data compression rates
Which statement for field-based modeling in SAP BW/4HANA is true?
A. Field-based modeling is only available for SAP sources.
B. Field-based modeling cannot leverage the SAP BW/4HANA authorization concept.
C. Field-based modeling complements InfoObject modeling and is fully integrated with existing SAP BW/4HANA objects/models and SAP BW/4HANA authorizations.
D. Field-based modeling is not recommended for mass data loads.
Which of the following items are part of an InfoObject definition?
A. Attributes
B. Transaction codes
C. Text Information
D. Dimension
E. Hierarchies
For which scenario do you recommend an InfoSource?
A. Allow the creation of delta records.
B. Use it as a source for the data transfer process.
C. Connect multiple sources and targets.
D. Store intermediate results
Which of the following are types of SAP BW Infocubes?
A. Inverted cube
B. Basic cube
C. Relational cube
D. Multicube
E. Virtual cube
Which sources can you use to create a generic DataSource in SAP ERP?
Note: There are 3 correct answers to this question.
A. SAP HANA calculation view
B. InfoSet query
C. Function module
D. BW query
E. Database view
Which of the following are characteristics of the DevOps methodology? Note: There are 2 correct answers to this question.
A. Automation of repetitive tasks.
B. Shortened lead time between fixes.
C. SAP HANA data warehousing foundation
D. A clear separation of development and operations tasks on an organizational level.
How are virtual tables created in SAP HANA by SAP BW/4HANA.
A. The administrator has to create them manually.
B. They are created by the SAP HANA DataSource in SAP BW/4HANA.
C. Virtual tables are not necessary because data always resides in memory.
D. They are transported automatically.