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 speciy true or false.

2. In which Phase Data source will be determined.

a. During Realisation phase all team memebers will be discussing abt the datasource that need to be used to fit the Requiremnet. (True or False).

b. Same question asked as Design Phase.

(II). Data Modelling (8 Questions):

SAP Data Modelling 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 BW questions.

1. What are the data traget 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) Extractions. 

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 choces. We have to think and write but they are easy.

(VI). Authorisation.

All the four quesions 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

Interview Questions on BW
SAP BW Interview Questions 1

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

SAP Books
SAP Business Warehouse, Functional, Basis Administration and ABAP Programming Reference Books

SAP BW Tips
SAP BW Tips and Business Information Warehouse Discussion Forum

Best regards,
SAP Basis, ABAP Programming and Other IMG Stuff
http://www.sap-img.com