C_TBI30_74 Online Practice Questions and Answers

How could you optimize the performance of a BEx query?(Choose two)

A. Create aggregates.

B. Use excludes in the filter settings.

C. Update the database statistics.

D. Create virtual key figures.

Your BW customer wants to access BEx queries in Web Intelligence, Dashboards, and Crystal Reports for Enterprise using BICS connectivity.

How do you explain the interaction between the BW and BI authorizations?

A. Authorizations for the required reporting tools and data access must be defined on the BI platform.

B. Authorizations for BI users must be imported in BW to access data.

C. Authorizations for the required reporting tools and data access must be defined in BW.

D. Authorizations for the required reporting tools must be defined on the BI platform and for the data access in BW.

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.

Your customer requests a new dashboard. You suggest creating a prototype first, as advised by best practices.

What are the benefits of this recommendation?(Choose two)

A. You can simulate the data flow.

B. You can simulate the design and development process.

C. You can streamline the production time.

D. You can simulate how users will interact with the dashboard.

What is the result of setting the "constant selection" property in the Extended tab of a restricted key figure?

A. Navigation and filters will affect the restricted key figure.

B. Navigation will affect the result of the restricted key figure, filters will have no effect.

C. Filters will change the result of the restricted key figure, navigation will have no effect.

D. Navigation and filters will not affect the restricted key figure.

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

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

You want to connect a number of different DataSources to a target. The DataSources have the same business rules.

Which object do you use to connect the DataSources to the target?

A. InfoArea

B. InfoSource

C. InfoPackage

D. InfoProvider

Which of the following tasks can you perform from the Data Warehousing Workbench?(Choose two)

A. Create new restricted key figures at InfoProvider level.

B. Create transport packages of BW objects.

C. Create DataStore Objects.

D. Create variables for reporting.

What is the purpose of design mode in BEx Analyzer?

A. To change the query design

B. To design query views

C. To design and embed charts in the workbook

D. To define the layout of the workbook using design items