Comments
Modeling and Performance
1. When should a DSO be used?
a) When Data needs to be overwritten.
b) When highly granular data is required in reports
c) All of the above. Ans : c
2. Can data be edited in PSA when the request is available in the Data Target?
a) Yes
b) No Ans : b
3. Can a request be reconstructed when there is no PSA?
a) No
b) Yes Ans : a
4. When can we have a Line Item Dimension?
a) When we have multiple Line Items
b) When we have a Single Characteristic in a Dimension
c) When we have less number of Characteristics in a Dimension. Ans : b
5. How do we decide on the Characteristics to be included in a Dimension?
a) When the fields (InfoObjects) have m: n relationship.
b) When the fields (InfoObjects) have 1: m relationship.
c) When the fields (InfoObjects) have m: 1 relationship. Ans : a
6. Criteria for selecting PSA and IDOC methods for Data Transfer
a) Load performance.
b) Query performance.
c) Volume of Data. Ans : c
7. All InfoProviders physically hold data
a) True
b) False Ans : b
8. When can we use InfoSets?
a) When Union is required.
b) When Joins are required.
c) All of the above Ans : b
9. Can InfoCubes be included in InfoSets in BI7?
a) No
b) Yes Ans : b
10. What needs to be done to make Attributes Navigable in Queries?
a) Exclude them from the Cube
b) Include them in the Cube
c) Nothing needs to be done. Ans : b
11. Can Queries be used after changes are made to the InfoProvider?
a) Yes
b) No
c) Maybe Ans : a
12. What needs to be done to make the queries work after changes are made to an InfoProvider?
a) Delete and re-create the queries.
b) Re-Generate the queries.
c) Nothing can be done. Ans : b
13. Can a single InfoSource be used to load Data to different InfoProviders?
a) Yes
b) No Ans : a
14. What are Aggregates?
a) Subset of an InfoCube.
b) Outset of a Cube.
c) None of the above. Ans : a
15. Definition of the Cube Dimensions with Master Data Tables can be checked from TCodes
a) LISTCUBE.
b) RSRV.
c) LISTSCHEMA.
d) All of the above. Ans : c
16. Pre-Configuring of ID’s like SID’s, DIM ID’s etc is called
a) Caching.
b) Blobbing.
c) Number Range Buffering.
d) None of the above. Ans : c
17. Application Component Hierarchies can be made available in BW by
a) Importing them in BW.
b) Transferring from SAP R/3.
c) Replicating in BW. Ans : b
18. Post Processing of DataSources is done in
a) RSA3
b) RSA4
c) RSA5
d) RSA6
e) None of the above. Ans : d
19. Testing the Extraction is done by
a) Running a Data Load.
b) Do an Extraction Check in SAP R/3.
c) Running a Query.
d) None of the above. Ans : b
20. How to check the Indices in a Cube?
PerformanceMangea) InfoCube
b) RSRT.
c) All of the above. Ans : c
Dear all,
Do you have some more questions?
Am preparing my certification test and like to test myself over and over :).
Thanks in Advance!
Hi all
Nice questions on modelling and performance
are these real exam questions (brain dump) or just sample created by someone.
Hi,
5. How do we decide on the Characteristics to be included in a Dimension?
a) When the fields (InfoObjects) have m: n relationship.
b) When the fields (InfoObjects) have 1: m relationship.
c) When the fields (InfoObjects) have m: 1 relationship
Answer to this question will be b) 1:m relationship.
Reason:
m:n relationship would lead to larger dimension table. In BI, we should avoid larger dimension tables.
http://searchsap.techtarget.com/generic/0,295582,sid21_gci1182832,00.html
hai can any one give me fresher sample resume
hai can any one give sample bw/bi resume
WHCIH SITE IS BEST FOR BUYING SAP BI 7.0 CERTIFICATION MATERIALS. PLEASE CAN SOMEONE HELP
if anyone need sap bi 7.0 certification materials just email me on praxs@live.com ..i have tbw10, tbw20, tbw41, tbw42 n tbw45
11. Can Queries be used after changes are made to the InfoProvider?
a) Yes
b) No
c) Maybe Ans : a
I think this should be c) maybe. There are times that you cannot just use and run the queries immediately after you change an infoprovider for example, when you delete a characteristic in the infoprovider and that characteristic was used in the query. You may need to do some "repair" infoobjects first in the query. Well, if it's just addition of a characteristic in the infoprovider then, the existing infoprovider queries should just be ok. What do you think BI experts?
thanx for the questions. do u have any more?
if u give more info on common problems and solution that will be greatly appreciated thanks
pls i should be writing my SAP BI exam soon can anyone send me the sample exam questions and answer .
dimkirchoff@yahoo.com
can anyone send me the sample exam questions and answer .
Hi Guys,
Need help from every1 on Tips and any sample Questions which you may have for BI Certification/Exam. Please send what ever you think can help in passing the test for SAP BI7.
Thanks in Advance
Adeel
Havengreen@aol.com
Does anyone know roughly how many questions there are on each major area, I am (for no reason whatsoever) expecting:
15% 1) Data Modelling
25% 2) ETL
05% 3) Business Content
25% 4) Delta Management
15% 5) Bex and Reporting
10% 6) Performance & Security
05% 7) Integrated Planning
Regroup and add others if you prefer...
It is available on http://www.sap.com/services/education/certification/certificationtest.epx?context=[[C_TBW45_70|G]]|
can u please send me more interview questions and answers related SAP BI,
my mail id:shiva.bi7@gmail.com
these questions are very helpful.thanks for posting these qstns
There's some good sample questions on http://www.saptest.net
Best regards, Sasha
Hi all,
I'm going to sit BI Certification this year. can you please send me any sample Questions whatever u have to pass the test!
Thanking you in anticipation for ur kind help.
Kamrul
kamrulibm@gmail.com
HI ,
Can anybody have SAP BI 7.0 certification sample test papers , if so please send it to my mail. haneef.sapbw@gmail.com
For those who were successful in passing their certification exam -- if you want to receive a logo to use on your resume, business card, or email signature, send me an email with the following information:
1. Your S-userid
2. The exam passed
3. Exam location and approx. date
4. Your email address
Once I verify your credentials, a logo will be emailed to you.
Thanks,
Ken Schieffer
SAP Education North America - Education Principal
Hey can anyone send me SAP BI questions and answers.
Email:rajesh11sinha@gmail.com
thanx in advance
plz give the business scenario for reporting concepts...........
regards
venubabu
hi this is arun,
could any one of u tell me how to get a modle resume for freshers on sap-bi
this is very urgent
I'm also preparing for my SAP BI 7.0 Associate certifiction. Could someone please drop me an email with the material (questions and answers)? Thanks. My email is nkalavumisa@hotmail.com
Thanks for questions and answers.
Please send me some more sample questions and answers if anybody have.I am taking exam next week.
Thanks for great help.
Bharati
HI ,
Can anybody have SAP BI 7.0 certification sample test papers , if so please send it to my mail id jenillia@gmail.com
Can anyone please email BI 7.0 resume format & study material to dpkmelbourne@gmail.com
cheers
Hi,
Can anybody have SAP BI 7.0 certification sample test papers , if so please send it to my mail.
su7213@gmail.com
THX
HI there,
Could you please send me BI7.0 certification sample questions and test papers....to my mail id usrkraju1@gmail.com
Any suggestions from those who pass the exam is highly appreciated...
Thanks in advance
Hi, there
can u send me sample reume 0 to 2 yrs exp send to mail id satish kumar.salla@gmail.com i will be appreciate
Hi all,
Could you please send me BI7.0 certification sample questions and test papers....to my mail id darshandesai@hotmail.co.uk any suggestions from those who pass the exam is highly appreciated...
Please email me sample questions and test papers for BI 7.0 certification exam at "milan.hoogan@gmail.com" . It quite urgent so all help will be appreciated. Thanks.
Hi all,
I am planning to take bi7.0 certification next month.could anyone please send me sample question and test papers to my gmail id shikha.saraswat@gmail.com.
It would be a great help.
Thanks.
Dear Friends,
I am planning to take BI 7.0 Certification in May 2012. Can anyone please send me sample questions and any test papers to my gmail id boyinapalli@gmail.com.
It would be a great help.
Thanks.