SAP Bi Quiz (Tbw42 Part 2)
Settings
Quiz for TBW42 Part 2 unit 4
- 1.On activation of an Info Cube the how many technical tables are generated for the fact table
- A.
1
- B.
2
- C.
3
- D.
4
- E.
None
- 2.Regarding Info Cubes : The F Table is optimized for loading data and the E table is optimized for data Requests
- A.
True
- B.
False
- 3.On activation of info Cubes the "D" table (/BIC/D...) is generated for each Dimension
- A.
True
- B.
False
- 4.The dimension tables contains the data for each Characteristic with a DIM ID as the primary key of the Table
- A.
True
- B.
False
- 5.In a ________ all descriptive attributes are located in other dimensions
- A.
Degenerated Dimension
- B.
Optimized Dimension
- C.
Line item Dimension
- D.
Non-Attribute Dimension
- 6.The setting _________ is used to change the method for dimention indexing in Oracle DB Only
- A.
Optimized Indexing
- B.
Low Indexing
- C.
High Cardinality
- 7.Characteristics with an N:M relationship can be combined in the same dimension if the Maximum number of records are clearly defined and the Cartesian product of the Characteristic results only in a small dimension table
- A.
True
- B.
False
- 8.The MultiProvider does not contain any data itself. Its data comes exclusively from the InfoProviders on which it is based, which are grouped together in a join operation.
- A.
True
- B.
False
- 9.A MultiProvider can be made up of various combinations of the following InfoProviders: InfoCube, DataStore object, InfoObject, InfoSet, VirtualProvider, and aggregation level.
- A.
True
- B.
False
- 10.Since MultiProviders do not save any data, performance aspects do not affect the way dimensions of the MultiProvider are modeled.
- A.
True
- B.
False
- 11.The MultiProvider also optimizes read access since _________ subqueries are executed on every InfoProvider involved in the MultiProvider.
- A.
Optimized
- B.
Parallel
- C.
Smaller
- 12.You can include the __________ characteristic in the query selection criteria and specify the basic InfoProvider against which the query is executed.
- A.
0SOURCE
- B.
0INFOPROVIDER
- C.
0INFOPROV
- D.
0SUBSET
- 13.Do not use more than one InfoCube with non-cumulative key figures in a MultiProvider, otherwise the numbers in the query may be incorrect.
- A.
True
- B.
False
- 14.The tools of the OLAP for performance optimization (such as caching and aggregation) can be used for a MultiProvider even if the InfoProviders involved does not support these tools.
- A.
True
- B.
False
- 15.Parallel processing is not possible with InfoSets.
- A.
True
- B.
False
- 16.Infosets can be based on which of the following Info providers.
- A.
Data Store Object
- B.
Master data Charateristics
- C.
Multiprovidors
- D.
Infosource
- E.
Infocubes
- 17.Wich of the following are joins supported by InfoSets
- A.
Temporal Join
- B.
Union
- C.
Inner join
- D.
Outer join
- E.
Key join
- 18.When creating an InfoSet from several characteristics, you can map transitive attributes and use these to report on master data
- A.
True
- B.
False
- 19.A dimension for the valid time interval (VALIDTIMEINTERVAL) exists for each InfoSet that represents a temporal join. This is only visible in the Query Designer and only used for the time selection.
- A.
True
- B.
False
- 20.The term qualok refers to
- A.
Quantity correct
- B.
Quantity Unit conversion ok
- C.
Qualitatively correct
- D.
Quality of data model is correct/ok
- 21.Within an InfoSet, it is possible to access BI accelerator indexes.
- A.
True
- B.
False
- 22.For InfoSets it is possible to define an InfoCube as a right operand of a left outer join.
- A.
True
- B.
False
- 23.What is the Maximum amount of infocubes permitted in an Infoset?
- A.
1
- B.
2
- C.
3
- D.
4
- 24.Which of the following is not yet possible to remodel
- A.
InfoCubes
- B.
InfoObjects
- C.
DataStore objects
- 25.In remodeling, you can use a customer exit to fill added or replaced characteristics and key figures with initial values. The interface _______ Should be used in such a case.
- A.
IF_RSCNV_EXIT
- B.
IF_RSCUST_EXIT
- C.
IF_REMOD_CUST_EXIT
- D.
IF_REMODEL
- 26.You cannot use the remodeling toolbox if:
- A.
You want to use more than one characteristic in line item dimensions.
- B.
You want to completely remove an existing dimension from an InfoCube or create a new dimension.
- C.
Replace exsisting charateristics
- D.
Delete key figures
- E.
You want to change the granularity of the fact table for your InfoCube by adding or deleting characteristics.
Back to top