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

Quiz: SAP BI/BW -- advanced level offers quizzes for SAP professionals to gauge their skills and advance their education. This quiz is the final part of a three-part quiz series on SAP BI/BW by expert Jay Narayanan. If you passed the beginner and intermediate quiz, you are ready for this advanced-level quiz.

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 final part of the three-part series written by SAP BI/BW expert Jay Narayanan. It is an advanced-level quiz and it covers Multiproviders and Infosets, change runs, navigational attributes and other advanced BW scenerios.

Check out the other quizzes in this series:

* SAP BI/BW Quiz -- beginner level
* SAP BI/BW Quiz -- intermediate 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.

Good luck!

1. Select the correct statements about the steps executed by a change run.

a. The steps activate the new master data and hierarchy data changes.
b. All aggregates are realigned and recalculated.
c. Aggregates containing navigational attributes are realigned and recalculated for the master data changes.
d. The steps delete the 'A' (active) records for which the 'M' (modified) records exist from master data tables, and makes all modified records active.
e. All of the above.

2. Key figures that are set for exception aggregation MIN or MAX in an aggregate cause the aggregates to be completely rebuilt for each change run alignment.

a. True
b. False

3. If special characters are not defined in transaction RSKC in BW then:

a. These characters cannot be loaded into BW at all.
b. These characters can only be loaded into text fields.
c. These characters can be loaded into attributes and texts.
d. BW won't be able to generate the SIDs for these characters because all the fields where SIDs are generated cannot be loaded.
e. None of the above.

4. A change run updates the 'E' table of the aggregates while doing the alignment for changes in the master data.

a. True
b. False

5. Select the correct statements related to the control parameters for a data transfer in table ROIDOCPRMS in the BW source system.

a. The field MAXSIZE is the maximum number of records which can be transferred to BW in a single packet.
b. The field MAXSIZE is the size in KB which is used to calculate the number of records per data packet.
c. MAXLINES is the maximum number of records which can be transferred to BW per data load.
d. If the number of data records per packet exceeds MAXLINES value the extraction process fails.

6. Identify the differences between an Infoset and a Multiprovider.

a. Both Multiproviders and Infosets can contain all the info providers in BW.
b. Queries built on Multiproviders use 'union' and queries on Infosets use 'join' to retrieve data from different info providers.
c. Both Multiproviders and Infosets do not have data, but data is accessed from the basic info providers used in these objects.
d. None of the above.

7. Select the correct statements about the OLAP Cache Monitor in BW.

a. The transaction for the OLAP Cache Monitor is RSRCACHE.
b. If the persistent mode is inactive then the cache is inactive and query results will not be cached in memory.
c. A 'read flag' is set in the Cache Monitor when data is read from the cache.
d. When new data is loaded into the info provider which the query is built on, the cache for that query is invalidated.
e. All of the above.

8. Select the correct statements about ODS settings.

a. Performance of the ODS activation improves when the BEx reporting flag is switched to off.
b. Overwriting a data record is not allowed if the 'unique' data record flag is set.
c. Data targets are updated from the ODS regardless of the ODS activation status.
d. All of the above.

9. It is not possible to activate an ODS which contains a request from a full load and a Delta Initialization load of the same data source.

a. True
b. False

10. Select the correct statements regarding data deletion settings in an InfoPackage.

a. It is possible to set an InfoPackage to delete all the data in an InfoCube during the loads.
b. Only uncompressed data can be set to be deleted from the cube in an InfoPackage during the loads.
c. Deletion settings can be done only for basic InfoCubes.
d. Data deletion settings in an InfoPackage are possible only for full loads.
e. All of the above.

11. Select the correct statements about parallel processing in Multiproviders.

a. Multiprovider queries create one process per info provider involved and are processed parallel by default.
b. It is not possible to make Multiprovider queries run sequential.
c. Multiprovider queries create a parent process which provides a synchronization point to collect the overall result from other sub processes.
d. Parallel processing is always faster than sequential processing in Multiproviders.
e. All of the above.

12. Select the correct statements about the ALPHA conversion routine in BW.

a. An ALPHA conversion routine is assigned to a characteristic info object automatically when it is created.
b. An ALPHA conversion routine is used to convert characteristic values from 'external to internal' values only.
c. Conversion is done on alphabets and numeric input values.
d. An ALPHA conversion routine removes the spaces on the right side of numeric values and right aligns them.
e. The left side of the numeric input values are filled with zeros.

13. Select the correct statements related to navigational attributes.

a. It is better to avoid using navigational attributes from a query performance point of view.
b.If a navigational attribute is used in an aggregate, the aggregate needs to be adjusted every time there is a change in the values of this attribute.
c. An attribute included as a characteristic in the InfoCube has the same effect as being used as a navigational attribute in the cube.
d. A navigational attribute can be made to display an attribute without removing data from the InfoCube.
e. None of the above.

14. A 'Check for Referential Integrity' can only be possible for information sources with flexible updating.

a. True
b. False

15. Select the correct statements about physical partitioning in BW.

a. New partitions on F table of an InfoCube are created during data loads to the InfoCube.
b. An E fact table is created when activating an InfoCube with a number of partitions corresponding to the partition value range.
c. If a cube is not partitioned before populating with data, it is not possible to partition the cube without removing all the data.
d. PSA table partitions can contain more than one request.
e. All of the above.


Dig Deeper on SAP Business Warehouse