Get started Bring yourself up to speed with our introductory content.

Quiz: SAP BI/BW -- intermediate level

Test yourself on SAP BI and SAP BW in this intermediate-level quiz from BI/BW expert Jay Narayanan covers all basic BW topics, like key figured, info cubes, info objects and aggregates.

Data warehousing is the foundation for all business intelligence (BI) solutions, and SAP BW is no exception. If you're an aspiring SAP BI/BW consultant, it is important to have extensive knowledge and experience with SAP BW.'s quiz series is designed to help you evaluate your BI/BW skill set. This quiz is the second part of a three-part series written by SAP BI/BW expert Jay Narayanan. It is an intermediate-level quiz and it covers SAP BI/BW architecture, modeling, extraction and information retrieval.

Note: This quiz is based on the BW release 3.5, which is a part of SAP NetWeaver 2004.

Check out the other quizzes in this series.

* SAP BI/BW Quiz – Beginner level
* SAP BI/BW Quiz -- Advanced level

How to take the quiz:

* After reading the question, note the letter of your answer.
NOTE: Some questions may have more than one appropriate answer!
* Check your answers by clicking the link to the answer key at the end of the quiz.
* To learn more about a topic and the correct response to the question, open the link that follows the response on the answer page.

Want to learn even more about BI and BW? Submit your score for a chance to win a copy of SAP BW Data Modeling!

1. Identify the statement(s) that is/are true. A change run...

a. Activates the new Master data and Hierarchy data
b. Aggregates are realigned and recalculated
c. Always reads data from the InfoCube to realign aggregates
d. Aggregates are not affected by change run

2. Which statement(s) is/are true about Multiproviders?

a. This is a virtual Infoprovider that does not store data
b. They can contain InfoCubes, ODSs, info objects and info sets
c. More than one info provider is required to build a Multiprovider
d It is similar to joining the data tables

3. The structure of the PSA table created for an info source will be...

a. Featuring the exact same structure as Transfer structure
b. Similar to the transfer rules
c. Similarly structured as the Communication structure
d. The same as Transfer structure, plus four more fields in the beginning

4. In BW, special characters are not permitted unless it has been defined using this transaction:

a. rrmx
b. rskc
c. rsa15
d. rrbs

5. Select the true statement(s) about info sources:

a. One info source can have more than one source system assigned to it
b. One info source can have more than one data source assigned to it provided the data sources are in different source systems
c. Communication structure is a part of an info source
d. None of the above

6. Select the statement(s) that is/are true about the data sources in a BW system:

a. If the hide field indicator is set in a data source, this field will not be transferred to BW even after replicating the data source
b. A field in a data source won't be usable unless the selection field indicator has been set in the data source
c. A field in an info package will not be visible for filtering unless the selection field has been checked in the data source
d. All of the above

7. Select the statement(s) which is/are true about the 'Control parameters for data transfer from the Source System':

a. The table used to store the control parameters is ROIDOCPRMS
b. Field max lines is the maximum number of records in a packet
c. Max Size is the maximum number of records that can be transferred to BW
d. All of the above

8. The indicator 'Do not condense requests into one request when activation takes place' during ODS activation applies to condensation of multiple requests into one request to store it in the active table of the ODS.

a. True
b. False

9. Select the statement(s) which is/are not true related to flat file uploads:

a. CSV and ASCII files can be uploaded
b. The table used to store the flat file load parameters is RSADMINC
c. The transaction for setting parameters for flat file upload is RSCUSTV7
d. None of the above

10. Which statement(s) is/are true related to Navigational attributes vs Dimensional attributes?

a. Dimensional attributes have a performance advantage over Navigational attributes for queries
b. Change history will be available if an attribute is defined as navigational
c. History of changes is available if an attribute is included as a characteristic in the cube
d. All of the above

11. When a Dimension is created as a line item dimension in a cube, Dimensions IDs will be same as that of SIDs.

a. True
b. False

12. Select the true statement(s) related to the start routine in the update rules:

a. All records in the data packet can be accessed
b. Variables declared in the global area is available for individual routines
c. Returncode greater than 0 will be abort the whole packet
d. None of the above

13. If a characteristic value has been entered in InfoCube-specific properties of an InfoCube, only these values can be loaded to the cube for that characteristic.

a. True
b. False

14. After any changes have been done to an info set it needs to be adjusted using transaction RSISET.

a. True
b. False

15. Select the true statement(s) about read modes in BW:

a. Read mode determines how the OLAP processor retrieves data during query execution and navigation
b. Three different types of read modes are available
c. Can be set only at individual query level
d. None of the above


Dig Deeper on SAP Business Warehouse