My SAP BW Certification Experience

These are some questions which I remembered after completing my certification. 

In certification 3 hrs is very sufficient and more time we will spend for understanding questions than writing answers. 

1) Project Implementation (4 Questions):

1. What are the activities will be done during Realisation Phase.

a. BW Dev system Installation will be done during this period. 
True or False

b. Basis help is highly required during this phase. 
True or false.

Like this 5 choice below each questions and each choice carries mark as we have to specify true or false.

2. In which Phase Data source will be determined.

a. During Realisation phase all team members will be discussing about the datasource that need to be used to fit the Requirement. (True or False).

b. Same question asked as Design Phase.

(II). Data Modeling (8 Questions):

SAP Data Modeling Book is sufficient for this. 
Nothing reqd more than that.

1. To which kind of Data Target compression is done.
(this Q has one answer).

2. What are the ways to improve data Loading performance. 

a. Line item Dimension
b. Creating Indexes to ODS.
c. Adding a primary key to ODS
d. Fact table smaller than dimension table
e. Dimension Table smaller than fact table.

LIKE THIS 8 QUESTIONS. 
In this part all the questions were bit confusing. Each question we have to read twice and answer. 
Here Lot of scenarios given and asking how we will design. Whether as ODS, Infoobject and Cube, Navigational attr. 

(III) Warehouse Management. (24 Questions)

Very Easy. All the questions are very straight forward. Basic SAP BW questions.

1. What are the data target that can be used for a Multi providers.

Give five choices we have to choose the correct ones.

2. Aggregates can be done for ODS?

True or false.

(IV) Reporting: (24 Questions)]

Here also questions are easy. More questions on style sheets.

1. What is the extension for saving style sheets.

a. .CSS ext
b. .TXT ext

Like this 5 choices were Given.

2. What are the functions in Reporting Agent?

a. Printing
b. Saving workbooks.

Also some questions on Workbooks.

In reporting they gave some scenarios and we have to choose which option is correct for creating reports.
Like, we have to create as Restricted Key fig or Cal Key Gig or as Replacement Path variable. Forgot the scenarios. Each questions are like a paragraph so it was tough to remember questions.

(V) Extract ions. 

Here I had one question from LO and 1 question from CO-PA and 0 questions from LIS. More questions on Generic extractor, Delta type and more questions on S-API.

1. Will S-API sends delta records to BW.

True or False.

2. S-API needs to be installed in both BW and R/3 System?

5 choices we have to choose it.

3. In CO-PA when we create a datasources which is created automatically.

a. One table and 2 structures.
b. Two table and two structure.
c. Two tale and one structure.

Like this 5 choices. We have to think and write but they are easy.

(VI). Authorisation.

All the four questions are with Scenarios.

1. Is the Authorisation S_RS_COMP sufficient for an User to create Reports. 

5 choices and every choices carries marks. Just like Project implementation.

2. What are the authorisation need to be given for a Key Users.

I hope this will give some idea. I am posting this so any one can make use of it.

All the Best. It will be very easy be cool and relaxed. 

Cheers!

Tips by : Bhuvana

SAP BW Tips

Interview Questions on BW
SAP BW Interview Questions 1

Get help for your SAP BW problems
SAP BW Forum - Do you have a SAP BW Question?

SAP Business Warehouse Books
SAP BW Books - Certification, Interview Questions and Configuration

SAP BW Tips
SAP BW Tips and Business Information Warehouse

Main Index
SAP ERP Modules, Basis, ABAP and Other IMG Stuff

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.  The site www.erpgreat.com is in no way affiliated with SAP AG.
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk.
 The content on this site may not be reproduced or redistributed without the express written permission of
www.erpgreat.com or the content authors.