BI Revision

A visually appealing abstract representation of data flow and business intelligence concepts, with elements like charts, graphs, and digital data streams.

BI Revision Quiz

Enhance your understanding of Business Intelligence concepts with our engaging BI Revision Quiz. This comprehensive assessment covers essential topics such as Layered Scalable Architecture, InfoCubes, and ETL processes.

Test your knowledge with questions that include:

Master Data and Transaction Data
Data Transfer Processes
Data Warehousing Concepts

25 Questions6 MinutesCreated by AnalyzingData247

1. What is another name for PSA layer in the Layered Scalable Architecture?

Data System

Data Sources

Data File

Data Mining

2. LSA stands for

Layered Scable Architecture

Layered Scalable Arhitecture

Layer System Architecture

Layer Source Architecture

3. Which of the following is true?

Master Data changes more frequently than Transaction Data

Master Data has a larger volume than Transaction Data

DSO are used to manage Master Data

'List of Suppliers' is an example of Master Data

4. Data Transfer Process is required for creating an infoset.

True

False

5. Select all statements which are true.

DSO gives detailed data

Data in DSO are stored in 2 dimensional format

InfoCubes are infoproviders

InfoCubes do not give summarized data

6. InfoCubes can have up to 16 user-defined dimensions.

True

False

7. John buys 20 kg of rice on 20190702. Here, 20 is an example of:

Unit infoObject

Time Characteristic

Characteristic infoObject

Key Figure

8. The name of system defined infoObjects in SAP BW start with:

9. The t-code for creating tables is:

SE38

SE11

SE37

RSA1

10. MetaData are:

Data input by the user

Data outside the program

Data about data

None of the above

11. Which of the infoproviders have overwrite capabilities?

DSO

Cube

Both of them

Neither of them

12. BW system can take data from non-SAP sources.

True

False

13. Which of the following types of infocube can be used for planning?

Basic

Real Time

Virtual

None of the Above

14. Transformation moves data from source to target.

True

False

15. Which of the following types of infocube can be used for direct access?

Basic

Real Time

Virtual

None of the Above

16. The following code indicates: write: /5 'I Love ABAP'.

Output 'I Lov' on the current line

Output 'I Love ABAP' starting at column 5 on the current line

Output 'I Lov' on a new line

Output 'I Love ABAP' starting at column 5 on a new line

17. In extended star schema, SID stands for:

Star ID

Schema ID

Surrogate ID

System ID

18. Master Data changes less frequently than transaction data.

True

False

19. Which of the following statements are true about infosets?

They are infoproviders

They bring data from different multple infoproviders

They do UNION operation

They do JOIN operation

20. What does OLAP stand for?

Online Analytical Process

Online Analytical Processing

Online Analysis Process

Online Analysis Processing

21. OLTP (Online Transaction Processing) makes use of historical data.

True

False

22. In which of the following types of DSOs, you need an activation process in order to be able to display data or create reports?

Write-optimized DSO

Standard DSO

Direct Update DSO

None of above

23. In SAP BW system, we perform ETL process to load the data to Persistent Storage area. Which of the following is true?

Transformation are used for data load

DTP is used for data load to PSA

DB connect is used to load the data to PSA

InfoPackage are used for data load to PSA

24. What is the maximum of key fields you can have in DSO?

148

248

25. To allow the user to enter a single value on a selection screen, use the ABAP keyword ____.

SELECT-OPTIONS

PARAMETERS

RANGES

DATA

BI Revision

BI Revision Quiz

More Quizzes