1.
On activation of an Info Cube the how many technical tables are generated for the fact table
A. 
B. 
C. 
D. 
E. 
2.
Regarding Info Cubes : The F Table is optimized for loading data and the E table is optimized for data Requests
3.
On activation of info Cubes the "D" table (/BIC/D...) is generated for each Dimension
4.
The dimension tables contains the data for each Characteristic with a DIM ID as the primary key of the Table
5.
In a ________ all descriptive attributes are located in other dimensions
A. 
B. 
C. 
D. 
6.
The setting _________ is used to change the method for dimention indexing in Oracle DB Only
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
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.
9.
A MultiProvider can be made up of various combinations of the following InfoProviders: InfoCube, DataStore object, InfoObject, InfoSet, VirtualProvider, and aggregation level.
10.
Since MultiProviders do not save any data, performance aspects do not affect the way dimensions of the MultiProvider are modeled.
11.
The MultiProvider also optimizes read access since _________ subqueries are executed on every InfoProvider involved in the MultiProvider.
12.
You can include the __________ characteristic in the query selection criteria and specify the basic InfoProvider against which the query is executed.
A. 
B. 
C. 
D. 
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.
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.
15.
Parallel processing is not possible with InfoSets.
16.
Infosets can be based on which of the following Info providers.
A. 
B. 
Master data Charateristics
C. 
D. 
E. 
17.
Wich of the following are joins supported by InfoSets
A. 
B. 
C. 
D. 
E. 
18.
When creating an InfoSet from several characteristics, you can map transitive attributes and use these to report on master data
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.
20.
The term qualok refers to
A. 
B. 
Quantity Unit conversion ok
C. 
D. 
Quality of data model is correct/ok
21.
Within an InfoSet, it is possible to access BI accelerator indexes.
22.
For InfoSets it is possible to define an InfoCube as a right operand of a left outer join.
23.
What is the Maximum amount of infocubes permitted in an Infoset?
A. 
B. 
C. 
D. 
24.
Which of the following is not yet possible to remodel
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. 
B. 
C. 
D.