Free SAP Certified Application Associate – SAP BusinessObjects Web Intelligence 4.3 Exam C_BOWI_4302 Exam Practice Test

How do you access the Format Table option?

• Right click the footer of the table
• Right click the column header of the table
• Right click the border of the table
• Right click the data of the table

You are creating a report to summarize the number of cars sold by region. Which object should you use to aggregate the number of cars sold? Please choose the correct answer. Response:

• Sum
• Detail
• Measure
• Dimension

What is the output of the following expression when the CurrentDate is January 31, 2014? If (MonthNumberOfYear(CurrentDate())=1; Year(CurrentDate())-1; Year(CurrentDateQ))

• 2014
• 01/31/2014
• 01/31/2013
• 2013

How do you duplicate a query? Please choose the correct answer. Response:

• Choose Duplicate Query in the Tools Menu
• Select Duplicate Query in Properties in the Query Panel
• Right-click Query in the Report Manager and select Duplicate Query
• Right-click the Query Tab in the Query Panel and select Duplicate Query

What are the benefits of using SAP Business Objects Web Intelligence? (2 correct answers)

• you can centrally manage, control, and configure your BI deployment
• you can centrally manage, control, and configure your BI deployment
• you can dynamically refresh and update information directly in your MS Office documents
• you can drill, slice-and-dice, and format information based on your business needs
• you can use simple drag-and-drop features to create interactive reports

Which wildcards can you use in a query filter? There are 2 correct answers to this question. Response:

• ?
• %
• -
• *

Why would you use the FormatDate() function? There are 2 correct answers to this question. Response:

• To modify the format of a string object into a non-standard date format.
• To convert a string object into a date object.
• To convert a date object into a string object.
• To format a date so that it is displayed as a string when it is concatenated with another string.

How does rearranging the objects in the Result pane after the query has run affect the block display? Please choose the correct answer. Response:

• The objects are rearranged in the block based on the order in the Results Objects pane.
• The reordered objects are removed from the block.
• The block is sorted in ascending order based on the first object in the Results Objects pane.
• The block remains unchanged.

Identify from the following options which ensure that the data displays on the page in a way that is easy to view and interpret? Please choose the correct answer. Response:

• The Padding options at single level of your document
• The Format options at various levels of your document
• The Page break options at various levels of your document
• The Format options at single level of your document

Which Report Manager tab should you use to change report formatting? Please choose the correct answer. Response:

• Map
• Data
• Properties
• Templates