SAP BW/BI Certification Sample Question Set

To make you familiar with SAP Business Intelligence with SAP BW and SAP BI certification exam structure, we have prepared this sample question set. We suggest you to try our Demo SAP BW/BI Certification Practice Exam to test your understanding of SAP BW/BI process with real SAP certification exam environment.

If you are planning to write the SAP BW/BI certification exam(C_TBI30_74, C_TBI30_73), we strongly recommend you to use our Premium SAP BW/BI Certification Practice Exam to clear it with good score.

Sample Questions:

01. How could you optimize the performance of a BEx query? 
There are 2 correct answers to this question.
a) Create aggregates.
b) Use excludes in the filter settings.
c) Update the database statistics.
d) Create virtual key figures.
 
02. How do you schedule a Web Intelligence document? 
Please choose the correct answer.
a) Use the Lifecycle Management tool.
b) Use the Universe Design tool.
c) Use the BI launch pad.
d) Use the Information Design tool.
 
03. In BEx Web Application Designer, which types of files do you need to display data in a map? 
There are 3 correct answers to this question.
a) The .dbf file storing attributes or values for the geo-element
b) The *.shx file storing an index to reduce map access time
c) The *.map file storing the mapping information of the SAPBWKEY
d) The *.dbx file storing an index to speed up the map rendering
e) The *.shp file storing the information that forms the map
 
04. What information should you provide for a SAP Business Warehouse connection in dashboards? 
There are 2 correct answers to this question.
a) The refreshing cycle, for example, every Monday morning at 8:30, or triggered on data load
b) The mapping of the input and output parameters to the Microsoft Excel spreadsheet
c) The query or query view used as the data source
d) The fixed authorization user used to access the data
 
05. What information should you provide for a SAP NetWeaver BW connection in dashboards? 
There are 2 correct answers to this question.
a) The mapping of the input and output parameters to the Excel spreadsheet
b) The query or query view used as the data source
c) The refreshing cycle, for example, every Monday morning at 8:30, or triggered on data load
d) The fixed authorization user used to access the data
 
06.What is a key capability of SAP BusinessObjects Analysis, edition for Microsoft Office? 
Please choose the correct answer.
a) Analyze data from OLAP universes.
b) Provide a unified information modeling design environment.
c) Analyze SAP BW data in Microsoft Excel.
d) Change the BEx query definition.
 
07. What is the benefit of implementing data warehousing for reporting and analysis? 
Please choose the correct answer.
a) To grant access to real-time data on mobile devices
b) To consolidate and harmonize data from multiple systems and applications
c) To guarantee data accuracy
d) To reduce the number of transactional systems
 
08. Which of the following tools can consume analysis views? 
There are 2 correct answers to this question.
a) SAP BusinessObjects Web Intelligence
b) SAP Crystal Reports 2013
c) SAP BI workspaces
d) SAP BusinessObjects Analysis, edition for OLAP
 
09. You want to ensure that the SAP BusinessObjects Analysis Add-In is started automatically with your VBA code executed. Where do you call the start-up procedure for the Analysis Add-In? 
Please choose the correct answer.
a) In the properties settings of the VBA Editor
b) In the After Redisplay registered callback
c) In the workbook properties of the Components tab
d) In the standard Workbook_Open event
 
10. You want to insert a chart in a SAP Crystal Reports report . The chart should be displayed only on the first page of the report. In which section do you insert the chart? 
Please choose the correct answer.
a) Report Header
b) Page Header
c) Details
d) Group Header
 

Solutions:

QUESTION: 01

Answer: a, c

QUESTION: 02

Answer: c

QUESTION: 03

Answer: a, b, e

QUESTION: 04

Answer: b, c

QUESTION: 05

Answer: a, b

QUESTION: 06

Answer: c

QUESTION: 07

Answer: b

QUESTION: 08

Answer: a, d

QUESTION: 09

Answer: d

QUESTION: 10

Answer: a

 

Rating: 4.8 / 5 (75 votes)