On which of the following objects can you restrict a characteristic?
A. Formula
B. Exception
C. Condition
D. Hierarchy node
Which sources are available for a generic SAP Business Warehouse DataSource? Note: There are 3 correct answers to this question.
A. SAP HANA information view
B. Function module
C. SAP HANA remote source table
D. DB view or table
E. SAP query (InfoSet)
The PSA consists of transparent table for sorting the detailed request in the format of the Transfer structure. Determine the statement True or False.
A. True
B. False
In which of the following elements can data transformation take place in Data Flow 3.X?
A. Extract rule
B. Report result
C. Transfer routine
D. Transfer rules
E. Update rules
A transformation can contain multiple rule groups, and rule groups allow you to combine various rules. Determine the statement is True or False.
A. True
B. False
To create new objects to store data for BI, you would access Administration tab of the DWWB. Determine whether the statement is True or False.
A. True
B. False
InfoProviders are technical tables joined in some way. They are constructed using fields in BI that we call _______. Choose the correct answer(s).
A. Business fields.
B. InfoObects.
C. Special fields.
D. InfoItems.
Which statements about the BI ETL process (NetWeaver 2004s) are true?
A. A DTP loads data to a PSA.
B. An InfoPackage loads data directly to the BI InfoProvider.
C. A transformation loads data to a PSA.
D. A transformation occurs on the data before it leaves the source system.
E. None of the above.
XML would be good for: Choose the correct answer(s):
A. Loading a shopping cart from an Internet application.
B. Efficiently loading 10,000 records.
C. Extracting from a SAP R/3 system.
D. Extracting from another BI system.
Some advantages of BI Content are: Choose the correct answer(s):
A. It is preconfigured and end-to-end in scope.
B. It speeds implementation.
C. It costs additional millions of dollars.
D. It allows quick prototyping.
Modeling with SAP HANA, you can use a virtual table in a view. Which of the following are advantages of this virtual data model?
A. Fewer objects are needed
B. The model is highly flexible
C. The data footprint is reduced
D. Data is only replicated once
E. The data is always up to date
Business Content available for SAP BW on SAP HANA uses the LSA++ design concept with a DataSource, a Corporate Memory and a persistent propagator ADSO. Determine Whether this statement is true or false.
A. True
B. False
Which of the following are the correct terminology about hierarchies? Choose the correct answers.
A. An entity in a hierarchy is called a node
B. Nodes that have no parents are called orphan nodes
C. Nodes that have no children nodes are called leaf nodes or leaves
D. A relationship between a node and its parent node is called a family tree
E. A hierarchy with leaves on different levels is an unbalanced hierarchy
Which of the following is required to perform currency conversion in an SAP HANA information model?
A. An innerjoin is required between the Open ODS View measures and the exchange rate table
B. A set of technical tables are required to store currencies and exchange rate types and rates
C. Setting a semantic type to a measure so the amount always includes a currency
D. Storing the currency and the exchange rate on the day of the transaction will improve performance
E. An interface to define how the currency conversion should be processed
The EDW Core Layer includes all layers that contain consolidated and harmonized data. Determine Whether this statement is true or false.
A. True
B. False