SAP Certified Application Associate - Business Intelligence with SAP BW 7.3 and SAP BI 4.0 Set 2

1.

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

Migrate a BEx Analyzer Workbook. Create a Report-Report-Interface. Define a filter by measure. Save a variant to the BW server.

2.

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

The "pause automatic refresh" option should only be used when you perform ad hoc analysis directly
against an InfoProvider. 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. The "automatic refresh" option is the best practice option. You only use the "pause automatic refresh" ifyou want to define more than one filter and send them all to the OLAP processor. The "pause automatic refresh" option prevents automatic data refreshes when you report againstVirtualProviders with real-time data access.

3.

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

Excel formulas to read data out of a data source defined in your workbook Excel formulas to change the filter settings directly in the BEx Query definition Excel formulas to change the navigation state of a data source defined in your workbook Excel formulas to read data directly out of a PSA table

4.

You create a workbook with exceptions in BEx Analyzer. Your customer does not like the standard colors for Bad 1 and Good 2 exceptions.
What do you use to change the color settings in BEx Analyzer?

The theme The portal theme The XML file The CSS file

5.

What is the purpose of design mode in BEx Analyzer?

To change the query design To design query views To design and embed charts in the workbook To define the layout of the workbook using design items

6.

Which of the following actions can you perform in SAP BusinessObjects Explorer?

Create a new chart type. Change the chart type used for data visualization. Import data directly from a dashboard. Design a layout template.

7.

Which of the following is a tool for ad hoc analysis and reporting to be used by business users/end users?

Dashboard Design Crystal Reports Web Intelligence Web Application Designer

8.

You are using the LifeCycle Manager to promote BI objects.
How do you undo a change to an object in the target system?

Roll back either a complete or a partial promotion. Change the object directly in the production environment. Delete the promotion job in the source system. Reset the system time to a time before the transport.

9.

What is the objective of the semantic layer?

To validate data loaded into BW To create transformations from various ERP systems to a BW system To provide business users access to data without them needing to be familiar with the structure of thedata sources To enable database administrators to create a data warehouse from multiple data sources

10.

Which components make up a data flow in BW?

PSA table, Start Routine, and DataSource DataSource, Transformation, and InfoProvider Start Routine, Transformation, and End Routine InfoSource, DataSource, and PSA table

SAP Certified Application Associate - Business Intelligence with SAP BW 7.3 and SAP BI 4.0 Set 2

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner

SAP Certified Application Associate - Business Intelligence with SAP BW 7.3 and SAP BI 4.0 Set 2

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

Detail Form

COMPANY

Products

OTHERS

Partner