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
