1

Sample SAP BI Certification Questions

Approximate Section wise distribution was:

Modeling 38 questions
Planning 12 questions
Bex tools 14 questions
Reporting 13Questions
APD 3 questions


1) Several data targets can be supplied with data from single InfoSource
a) True
b) False

2) Fact table consists of
a) Dimensional IDs
b) Key figures
c) Characteristic values

3) Which of the following are created first while loading master data?
a) SID
b) DIM ID
c) HID


4) Aggregates will have which properties
a)Status properties
b)Key figure properties

5) What are all the objects that can be analyzed through BW statistics?
MultiCube, InfoCubes, Queries, Workbooks, InfoSources, Transfer Rules, Update
Rules,InfoPackages, InfoPackage Groups,Role

6) What mechanism is followed to transfer data from the delta queue to BW info providers?

7) What are the data targets in the source system for which delta extraction is possible?
Source System: SAP,db,UD,BODS.
12) Name the sub areas of technical content?
a) BW statistics
b) BW data slice

13) What is the Architecture used in ODS object.
a) Relational DB tables with request dependent key
b) Relational DB tables with semantic key
c) BW Star schema
2


14) What are the possible data sources in an Open hub service?
a) Basic cubes
b) ODS Objects
c) Characteristic InfoObjects

15) What are the extraction methods available for extracting the data from the source system

16) True or False The record can be add in DSO and InfoCube if a data record in delta upgrade
provides the before and after image

17) When General Remote Cube is used, the external system transfers the requested data to the
OLAP processor via
A) SAPI
B) BAPI
c) UD Connect

18) Which Architecture is used in data mart to retrieve data from comprehensive data
warehouse?
a) Aggregation architecture
b) Multiple architecture

19) Which of the following are the advantages of PSA?
a) Improved performance
b) Possible to work with error handling

20) If 80% of the companys revenues are coming from 20% of the customers then which
analysis is used?
a) ABC analysis
b) Clustering


22) The following Connectors provide multidimensional data.
a.) The JDBC Connector
b) The OLAP ODBO Connector
c) The XMLA Connector
d) BI SAP Query Connector
e) XI


24)Which statement(s) is/are true related to Navigational attributes vs Dimensional attributes?
a)Dimensional attributes have a performance advantage over Navigational attributes for queries
b)Change history will be available if an attribute is defined as navigational
c)History of changes is available if an attribute is included as a characteristic in the cube
d) All of the above

25) The template work area consists of the following tab pages
3
a)Standard
b)Generic
c) Specific
d)HTML


26) What is the primary purpose of having multi-dimensional data models?
a) To deliver structured information that the business user can easily navigate by using any
possible combination of business terms to show the KPIs.
b) To make it easier for developers to build applications, that will be helpful for the business
users.
c) To make it easier to store data in the database and avoid redundancy.
d) All of the above.

27) The following statements are not true about navigational attributes.
a) An attribute of an info object cannot be made navigational if the attribute-only flag on the
attribute info object has been checked.
b) Navigational attributes can be used to create aggregates.
c) It is possible to make a display attribute to navigational in an InfoCube data without deleting
all the data from the info cube.
d) Once an attribute is made navigational in an info cube, it is possible to change it back to a
display attribute if the data has been deleted from the info cube.

28) Multi dimension data sources can be loaded into sap bw using
a) DBconnect
b) UDconnect
c) Unique connector
d) MDM connector
e) SAPBW connector

29) Which is the interface that is used for communication between b/w SAP BI & external
systems?
a) BAPI
b) SAPI
c) File
d) UD Connect


32 The main task of staging engine is:
a) Data loading
b) Data processing
c) Preparing data
d) all of the above

33 OLAP area tools can be used to analyze several dimensions simultaneously like
a) Time
b) Place
c) Product
4

34 Which is the key figure for which key values must be posted in every time unit that is being
reported?
a) Non cumulative values
b) Cumulative
c) Aggregation
d) Time unit

35 Modeling deals with
a. Physical Objects
b. Virtual Cubes
c. Fact Table
d. SID Table



36) Transfer rules are specific to the-
a) Data target
b) Source system
c) communication structure
d) metadata

37) The central tool in the SAP BW system is
a) staging engine
b) BW server
c) administrator workbench
d) source system

38) By which option you can view data before loading into SAP BW system
a. view
b. preview
c. monitor
d. search

39) Advantages of ETL Tools
a. Accelerate the development of extraction processes
b. Extraction processes are documented uniquely
c. Used as central admin tool for extracting data from external systems, since the
data is integrated in homogeneous environment

40) What is transformation engine does?
a) Executes OLTP processes.
b) Executes ETL processes.
c) Executes OLAP processes.
d) Executes function for reporting and analysis purpose.

41) XML data is made available to the BW system through?
a) BAPI
5
b) SOAP
c) SAPI
d) OMG

42) Which are the 3 object version?
a) Active passive modified
b) Active positive delivery
c) Delivery active modified
d) None of the above

43) ______________ tool provides analysis & optimization
a) BW data slice
b) Demo Content
c) BW statistics
d) All of the above

44) What are the 3 terms which comes under BW statistics workbench
a) OLAP
b) OLTP
c) Aggregate
d) Warehouse Management(WHM)

45) Aggregate cube will consists of
a) E table
b) F table
c) Package dimension
d) Aggregate table

46) What tables do ODS objects consist of?
This question has more than one answer
a. Active table
b. Extended table
c. Change log table
d. Modified and new table
e. None of the above

47) What kind of reporting is used in ODS object.
a. Flat Reporting
b. Multidimensional reporting
c. detailed reporting
d. selective reporting

48) What is the method followed in ODS object for consolidation of data.
a. Aggregation
b. Hamonization
c. Buffering
d. Summation

6
49 )Which of the following have its own data
a. Basic Cube
b. Virtual Cube
c. MultiProvider
d. InfoObject

50) What all possible operations are allowed in ODS object?
a. Overwriting of data
b. addition of data
c. Deletion of Data
d. a & b & c


7
1. Data source for Report Designer:
-Inforprovoder.
-Query View.
-Query Designer.

2. State TRUE/FALSE: While extracting Data from Web services

-WAD eliminates the need of detailed knowledge of HTML&CSS elements.
-Daemon is runs periodically after specified time.
-Data is pushed to BI system from Web service.
-Variables in Authorization through type Authorization use $.
-Process Chain improve the performance.

8.TRUE/FALSE in Report Designer:
-Highly formatted reporting is possible in Report Designer.
- Must contain specific Font style, Header& footer, Charts Graphics.
-Reports need to be printed and Broadcasted.

9.Through Drag & Drop in BEx Analyzer we can:
- swap the fields.
-Include char. for drill down from Navigation Pane.
-Include records for particular charteristic.

10.In BEx analyzer exception through wizard are used for
- cloring by setting threshold value.
-set data as per selection condition.
Choice can be made between Status & Trend.

11.80% of the revenue of compay comes from 20% of the customers. How will group the the
data.
-ABC analysis.
-Clustering.
-Weighted Score.
-Decision Tree.

12.CKFs is:
-that once defined in InfoProvider level, can be used in all the queries defined on it.
-can be based on basic Key Figure of Infoprovider.

17.Format to Broadcast:
-PDF
-HTML
-other 2 options.


20.TRUE/FALSE for Bi7.0
-Infosource is mandatory.
-PSA is mandatory.
8

9
Data Mining question.

1) One organization found that their 80% revenue is generated by 20% of the customers. What
kind of analysis should be used for this?
a. ABC Analysis
b. Association Analysis
c. Score ranking Analysis

2) What are the features of BI Accelerator?
a. Low maintenance cost
b. Reduce use of OLAP Cache
c. Highly Scalable
d. Reduce Aggregate maintenance
e. Reduce downtime

3) Regional manager knows about the low performance about particular regions. But he is
using a old query to analyze the performance. He wants alerts to be sent about the
performance to his mail. What should he use for this?
a. A e-mail should be sent to his account
b. Whenever a region has a performance <10% a alert mail will be sent.


4) What are the data providers can be used in APD transformation process?
a. Standard DSO
b. Infocube
c. Direct Update DSO
d. Master data objects
e. Infosets

5) Which info provider contains data physically?
a. Infocube
b. Masterdata attribute object
c. Infosets
d. Write optimized DSO
e. Virtual Providers

6) You have one Standard Infocube containing actual data and another Realtime Infocube.
What will you do to load data in real time infocube for farther comparison?
a. Create an aggregation level on Realtime infocube and run a plan query on top of a
Multiprovider which contains both Standerd infocube and aggregation level.
b. Add both the infocubes to a multiprovider and create an aggregation level on it. Use
a plan query to load data from Standard Infocube to Realtime Infocube.
c. Using transformation load Realtime Infocube through DTP.


7) You are the manager of an organization. You want to make your instructions accessible to all
the employees under you. How will you do it?
10
a. Send mail to every employee
b. Put the instructions in enterprise portal public folder.
c. Create a query which is authorized for all users and integrate a document with it
containing the instructions.
d. Make printout copy of the instruction and distribute among the employees


8. Plan queries can be created on
1. Aggregation level
2. Multi provider
3. Info cubes
4. Info Providers

1. Prequery is Used to fill precalculated value sets before query execution. State whether the
statement is True/False.

2. Which attribute is by default in an info object navigational/ Display.

3. Precalculated value sets are used in broadcaster;
a. precalculated with mime
b. precalculated with doc
c. precalculated with soap

4. Which Datasources are used in APD?
a. Standard DSO
b. Write Optimised DSO
c. Direct Update DSO

5. Question on keydate .where u will set in integration planning?

6. Which u will use for relational databases?
a. jdbc
b. odbo
c. xmla
d. sapquery

7. Dataproviders for report designer are
a. Query
b. Query View
c. Infoprovider
d. Filter
e. Workbook

8. Variables are used in
a. Characteristic
b. Keyfigure
c. Filters
d. Data Slices
11
e. Characterstic Attributes


9. Filters r used in ________________



10. Temporal join of infosets are used to identify following data,
List of all employees who changed their teams across a period of time.
Judge whether the given statement is True/False


11. Features of Report Designer?
1. Standard formatting, for example, font, font style, font color, underlining, border, -
True/False
2. Insertion of texts, pictures, and charts- True/False
3. Insertion of report headers and footers, page headers and footers, page breaks, and
page numbers- True/False
4. Use of portal styles. - True/False

12. Output formats of Information Broadcasting
1. MHTML
2. PDF
3. OLAP cache
4. MDX cache

13. Data Targets for an APD
1. Standard DSO-True/False
2. Direct Update DSO-True
3. Attributes of a Characteristic-True/False
4. CRM-True

14. Daemon can write back data to a Virtual Provider with the help of a RDA DTP-True/False?

15. Function of a Data Warehousing workbench
1. Modeling DSO- True/False
2. Monitoring Process Chains- True/False
3. Transporting objects- True/False
4. Creating global variables- True/False

16. Which data providers do WAD support?
1. Query View
2. Filter
3. Query
4. Info provider

17. You have to explain to your client about the advantages of having BIA, Advantages of BIA?
1. Scalability
12
2. Increase in Performance
3. Stable query response time
4. Reduction in processing time

18. What has replaced Ad Hoc designer?

19. Can we embed a URL into a Report using report designer?

20. Which data mining method will be used for finding the relationship between customer
buying behaviors in order to develop a proper catalogue?
1. ABC
2. Clustering
3. Decision Trees
4. Association Analysis

21. Where does APD extract data from?
1. Source System
2. Files
3. Info provider
4. Characteristics

22. Key Date you can specify in IP Modeler at Aggregation level tab in order to model time
dependent hierarchies-True/False?

23. STS can be used in with both BPS and IP-True/False?

24. IP is used to integrate
1. Front end
2. Back end
3. Both Font end & Back end

25. Which of the following are true regarding info provider?
1. All info providers are data targets.
2. Info providers are used for creating queries
3. Virtual providers can hold data and can be used to load data to the higher targets

26. Which of the following can be part multi provider
1. Info cube
2. DSO
3. Info set
4. Virtual providers
5. Multi provider.

27. Which is the correct requirement in BIA?
1. BIA-> Pre calculation -> OLAP
2. Pre calculation -> OLAP -> BIA
3. OLAP-> Pre calculation -> BIA
28. BI Admin Cockpit allows you to do the following activities
13

29. In BIA index is created on the basis of
1. per Info Cube
2. Per Aggregated
3. per Column
4. per Row


30. Master Data Reporting is available on
a. Dso
b. Infocube
c. Infoset
d. PSA
e. Infoobject

31. Variables can be created on
a. Characterstic
b. Filters
c. Planning Sequences
d. Data Slices
e. Queries

32. Processing type used by Characteristic Variables are
a. Manual Entry
b. Replacement Path
c. Batch Processing
d. Customer Exit
e. Authorization

33. UD Connect is used in
a. Where we cant use DBConnect
b. Supports Multi Dimensional Database Only
c. Can be used for Webservices only
d. All of the above
e. None of the above

34. In Integrated Planning
a. Aggregation level can be based on one Realtime Infoprovider.
b. Aggregation level based on Multiprovider which is based on Aggregation Level.
c. Aggregation level based on Multiprovider and it includes one Realtime Infoprovider.
d. Aggregation level which is built on another aggregation level

35. During rollup can you perform reporting on infocube T/F

36. If u have to explain the benefits of BI Accelerator, what are the main features you would
explain
a. Flexibility
b. Fast Access
14
c. Increased Revenue

37. We change a DSO from Write Optimized DSO to Direct Update DSO, from the DSO settings.
State whether the statement is True/False

38. What is the purpose of Keydate in a Query?


39. Analysis Authorizations will be checked while
a. Opening the workbook

b. Refreshing the Workbook

40. If u include 2 queries in a Workbook
a. The result of first query will affect the second query
b. User will be able to access First query only
c. The Display area of second query will be affected by result of first query.

41 Which data mining method will be used for finding cross selling opportunities in
supermarket
a. ABC
b. Clustering
c. Decision Trees
d. Association Analysis


45. Which of the following are used in Adhoc Analysis
a. Report Designer
b. BEX Analyser
c. BEX WEB Application Designer

46. Data Providers for the APD
a. Query
b. query view
c. external source
d. system info cube

47. BI Admin Cockpit allows you to do the following activities
a. Monitoring Query Statistics
b. Monitoring BI statistics
c. Administrating Process Chains
d. None of these


48. Which of the following are Java Connectors
a. XMLA
b. SAP QUERY
c. JDBC
15
d. ODBO

49. Can we give authorization to key figures or to characteristics?

50. which of the following "Document class" are used in "Document Integration" ?
a. Metadata
b. Masterdata
c. Infoprovider class

51. which of the following is must for "dimension Table"
a. Line dimensions
b. Dim IDs
c. SIDs

52. In BI XI, which of the following are used in "Maximum Quality"
a. Proxy server
b. SOAP server
c. XMLA server

53. Which of the following are used for "AGGREGATES"
a. Hierarchies
b. DSO

55. A question based on "Keydate" for "Inrtegrated Planning"?

56. Where does APD extract data from?
a. Source System
b. Files
c. Info provider
d. Characteristics

57. which is "Valid preprocessing Type" ?
a. Replacement path
b. Manual Entry
c. SAP exit
d. customer exit
e. query view

58. What are steps included in "Write optimized DSO" ?

59. A question based on "Roll up" for Aggregates? (Difficult)

60. A Conceptual Question on "RDA" (give diff scenarios)