SAP BW Certification Exam - My Experience

My SAP BW Certification Experience - The exam contains 80 questions and the time allotted for this 3 hours.

Time duration is more than enough for 80 questions. The only thing you should have is Patience because you really get tired after reading all this questions and the respective 5 options for each question and that too confusing ones. I really got impatient when I was nearing 64, 65th question. And I think this is the reason I did very badly in my last section (Data Modeling). Data Modeling was one of the topics, which I was fully confident of scoring well but to my surprise I got the lowest marks. I finished my exam in 2:10hours. I would say that you use all the time allotted to you and go through all the questions again.

I got 73% (I know it is not a good score but at the end of the day I am happy that I got it.)

The exam is divided in to 6 sections. The first section is Extraction and in this section you have 16 questions. Majority of the questions are based on Delta, I would say like 85% of this section is on delta.  The questions I remember are: what is the architecture of delta? What is the concept behind Early Delta initialization? What was the problem with LIS? Data connect is related to…………?.

The most surprising part was that they didn't ask me any questions on FI/CO, COPA AND FI-SL. So make sure that you have read everything in connection to Delta.

The Second section is based on Reporting and this section contains the maximum number of question compared to other sections. The total numbers of questions in this section are 26. It test your knowledge completely on BEx tool. The note in BW CLASS INPUT FOR REORTING is really excellent. Make sure that you also go through REPORTING MADE EASY GUIDE. You don't have to go through all 500 pages. Just read chapters 3,4,6,7 and 8. It just takes 2 days to read these chapters in detail. When you read these guide try to work on the system as much as possible and build as many queries as possible. This will help you in remembering the concepts. Working on the system is really necessary because there are so many things which you can realize only when you build query. This will help you a lot when answering the question on reporting.

REPORTING MADE EASY GUIDE is based on BW 2.0B. But chapters 3, 4, 6, and 7 does not have as many changes compare to BW 3.0B. You will have to read some extra documents for chapter 8 (Reporting Agent) because it only covers Exceptions and Printing. You have to read some papers on CRYSTAL REPORTING, WEB TEMPLATE AND BOOKMARKS. Also, I followed all the point in BW CLASS INPUT for WAD and started working on the system.

The 3rd section is WARE HOUSE MANAGEMENT. This section contains 20 question. I was asked some questions on Document Integration and XML files.

The 4th section is Project. There are only 4 questions in this section and I think that u should not miss a single scoring
opportunity this section. The questions in these sections were like what steps are taken after a Blueprint? What all you do in analysis? How important the end users are while defining a data model.

The 5th section is Authorization. There are only 4 questions in this section and even in this section you should not miss a single scoring opportunity this section.

The last section is SAP BW Data Modeling. It contains 10 questions. Make sure that your concepts are clear for attributes, hierarchy and aggregates. I remember one question: what is the difference between star schema and classic schema model.  Question on hierarchy were really confusing.

This was my experience giving the exam. At the end of the exam even I was not sure whether I will make it or lose it.

*-- Rajendra

See Also

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

Back to:
SAP BW (Business Warehouse) Hints and Tips

Return to :-
SAP ABAP/4 Programming, Basis Administration, Configuration Hints and Tips

(c) www.gotothings.com All material on this site is Copyright.
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk.
All product names are trademarks of their respective companies.  The site www.gotothings.com is in no way affiliated with SAP AG.
Any unauthorised copying or mirroring is prohibited.