SAP Bi Quiz (Tbw42 Part 2)

26 Questions | By Wneedham | Last updated: Jul 30, 2011 | Total Attempts: 1046

Questions

Settings

or Create Online Exam

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

Related Topics

More Sap Quizzes

SAP Hr Certification Sample Test I

The human resource department is designed to find the best fitting people to work within the firm and ensuring all the goals set for them are met. Planning to become a human resource employee? This test is to practice the topic...

Questions: 10 | Attempts: 13901 | Last updated: Jan 18, 2021

Sample Question
Elements of the enterprise structure?

CLIENT

COMPANY CODE

PERSONAL SUBAREA

EMPLOYEE SUBGROUP

EMPLOYEE GROUP

SAP Basis Online Test

Basis is essentially the operating system for all SAP applications, including Advanced Business Application Programming. It provides a number of services and benefits. Do you know them? Find out in this quiz on SAP Basis!

Questions: 20 | Attempts: 7586 | Last updated: Nov 18, 2020

Sample Question
What is the transaction used to import SAP-provided support packages into your system.

SPAM

SAPM

SNOTE

SARA

Saptec - Fundamentals Of Application Platform

The questions were taken from SAP course SAPTEC (course version 2003 / Q2). SAPTEC is part of SAP ABAP certification and most of material is covered in TAW10 / TAW12 certification preparation courses.

Questions: 54 | Attempts: 3526 | Last updated: Jan 3, 2013