SAP Bi Quiz (Tbw42 Part 2)

26 Questions | By Wneedham | Last updated: Mar 21, 2022 | Total Attempts: 1057

Questions

Settings

Create your own Quiz

Quiz for TBW42 Part 2 unit 4

Questions and Answers

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