SAP SAP Certifications C_TBI30_73 Questions & Answers

• Question 71:

  You want to create a query in BEx Query Designer that produces a table as shown in the attached screenshot.

  

  What do you have to use to accomplish this?

  A. Filters

  B. Structures

  C. Exceptions

  D. Restricted key figures

  Correct Answer: B

• Question 72:

  Which InfoObjects can you use when creating BEx Queries? (Choose two)

  A. Hierarchies

  B. Structures

  C. Filters

  D. Characteristics

  E. Key figures

  Correct Answer: DE

• Question 73:

  You open the Cost Center dimension in BEx Query Designer (see the attached graphic).

  

  What information about the Cost Center characteristic can you determine? (Choose two)

  A. The Cost Center is compounded to the Controlling area.

  B. The Cost Center has display attributes.

  C. The Cost Center has navigational attributes.

  D. The Controlling area is compounded to the Cost Center.

  Correct Answer: AB

• Question 74:

  Which of the following functions is included in SAP BusinessObjects Analysis, edition for Microsoft Office?

  A. Migrate a BEx Analyzer Workbook.

  B. Create a Report-Report-Interface.

  C. Define a filter by measure.

  D. Save a variant to the BW server.

  Correct Answer: C

• Question 75:

  Which of the following statements regarding refreshing mode in BEx Analyzer is correct?

  A. The "pause automatic refresh" option should only be used when you perform ad hoc analysis directly against an InfoProvider.

  B. The "pause automatic refresh" option is the best practice option. You only use the "automatic refresh" option for special scenarios to optimize the use of the OLAP processor.

  C. The "automatic refresh" option is the best practice option. You only use the "pause automatic refresh" if you want to define more than one filter and send them all to the OLAP processor.

  D. The "pause automatic refresh" option prevents automatic data refreshes when you report against VirtualProviders with real-time data access.

  Correct Answer: C

• Question 76:

  What can you define when using the formula mode in BEx Analyzer?

  A. Excel formulas to read data out of a data source defined in your workbook

  B. Excel formulas to change the filter settings directly in the BEx Query definition

  C. Excel formulas to change the navigation state of a data source defined in your workbook

  D. Excel formulas to read data directly out of a PSA table

  Correct Answer: A

• Question 77:

  Which hierarchies are available when you use a BEx Query in SAP BusinessObjects Analysis, edition for Microsoft Office?

  A. All hierarchies of the characteristics that you use in the query

  B. The hierarchies that you activated in the query for the characteristics

  C. All hierarchies of the InfoProvider that you use in the query

  D. The hierarchies that you selected when inserting the query into Analysis

  Correct Answer: A

• Question 78:

  Where can you save workbooks created with SAP BusinessObjects Analysis, edition for Microsoft Office? (Choose two)

  A. In an Analysis iView in the Enterprise Portal

  B. On your local PC

  C. On the BI platform

  D. On the BW server

  Correct Answer: BC

• Question 79:

  For which purposes can you use the tabs in the Design panel of SAP BusinessObjects Analysis, edition for Microsoft Office? (Choose two)

  A. The Components tab, to retrieve information such as filters assigned to single components

  B. The Components tab, to add components such as charts or dropdown boxes to the workbook

  C. The Information tab, to add text information to the workbook by using drag and drop

  D. The Information tab, to display the structure of used elements

  E. The Analysis tab, to define the data that is displayed in the crosstab

  Correct Answer: CE

• Question 80:

  What is a capability in SAP BusinessObjects Analysis, edition for Microsoft Office, PowerPoint?

  A. You can use the same filter options as in Analysis for Excel.

  B. You can split long tables across multiple slides.

  C. You can provide a design panel for conditional formatting.

  D. You can perform calculations and axes swapping.

  Correct Answer: B