BI Revision
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
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:
S
0
Z
Y
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?
16
13
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
{"name":"BI Revision", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"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 DataData Transfer ProcessesData Warehousing Concepts","img":"https:/images/course8.png"}
More Quizzes
HANA DATA SERVICES 01
8040132
Bonus Quiz for BI
10529
Microsoft 70-463 Practice Questions 4
31160
SAP BODS Quiz
940
Introduction to database concept
1050
Master Data Management
1050
Big Data 1
94242
Module 1.1 : What is a database?
840
MDM Questions
10527
Power BI training - Session 1
1050
IM101
7035144
ADW Bootcamp Week 3 PreQuiz
10517