Questions and answers for exam Preparation

MCQs

Total Questions : 25 | Page 1 of 3 pages

Question 1. Which of the following is correct about Profile Generator?

It is a tool to automatically generate Authorization Profile
It is a tool existing in OLTP systems only
Complete the Administrator work with extra tasks to set up authorization
A tool that can be used by end users to modify their authorizations

Discuss Question

Answer: Option A. -> It is a tool to automatically generate Authorization Profile

Question 2. The following statements are not true about navigational attributes

An attribute of an info object cannot be made navigational if the attribute-only flag on the attribute info object has been checked
Navigational attributes can be used to create aggregates
It is possible to make a display attribute to navigational in an info cube data without deleting all the data from the info cube
Once an attribute is made navigational in an info cube, it is possible to change it back to a display attribute if the data has been deleted from the info cube

Discuss Question

Answer: Option D. -> Once an attribute is made navigational in an info cube, it is possible to change it back to a display attribute if the data has been deleted from the info cube

Question 3. Where can data transformation cannot take place in BW?

Update rules
Transfer rules
Transfer routine
Extract routine

Discuss Question

Answer: Option D. -> Extract routine

Question 4. Which of the following is correct about SAP BW Statistics?

Data volume of the SAP BW Statistics cannot be anticipated
SAP BW Statistics are delivered as a part of the technical content
All SAP BW Statistics query objects start with OSAP
All SAP BW Statistics InfoObject catalogues start with OSAP

Discuss Question

Answer: Option B. -> SAP BW Statistics are delivered as a part of the technical content

Question 5. The following statements are true for an info cube.

Each characteristic of info cube should be assigned to at least one dimension
One characteristic can be assigned to more than one dimensions
One dimension can have more than one characteristic
More than one characteristic can be assigned to one line item dimension

Discuss Question

Answer: Option C. -> One dimension can have more than one characteristic

Question 6. In SAP BW/BI what are the main areas and activities?

Data Warehouse: Integrating, collecting and managing entire company's data
Analyzing and Planning: Using the data stored in data warehouse
Reporting: BI provides the tools for reporting in web-browser, Excel etc
All of these

Discuss Question

Answer: Option D. -> All of these

Question 7. A setup table is basically a....

Transparent Table
Pooled table
Cluster Table
Structure

Discuss Question

Answer: Option C. -> Cluster Table

Question 8. Using BI accelerator the query performance can be boosted by

10-100
10-1000
1-10
None

Discuss Question

Answer: Option A. -> 10-100

Question 9. Select the correct statements about ODS settings.

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

Discuss Question

Answer: Option A. -> Performance of the ODS activation improves when the BEx reporting flag is switched to off

Question 10. What should you do after an InfoCube is converted to be in-memory optimized?