SAP C_BOWI_42 SAP Certified Application Associate - SAP BusinessObjects Web Intelligence 4.2 Online Training

Exam4Training is providing valid preparation material for SAP C_BOWI_42 exam. Their SAP C_BOWI_42 SAP Certified Application Associate – SAP BusinessObjects Web Intelligence 4.2 Online Training contain all the topics and the questions that will be asked in the real SAP Certified Application Associate C_BOWI_42 exam. The SAP C_BOWI_42 SAP Certified Application Associate – SAP BusinessObjects Web Intelligence 4.2 Online Training guarantee 100% success in an exam as it consists of quality questions and answers related to C_BOWI_42 SAP Certified Application Associate – SAP BusinessObjects Web Intelligence 4.2 exam. In short, you can get all in one product from Exam4Training.

Page 1 of 5

1. 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.

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

2. Which tasks can you accomplish using breaks? There are 2 correct answers to this question.

Generate a running sum in multiple table blocks.

Remove repeated values in one table block.

Break the table into multiple table blocks.

Generate subtotals in one table block.

3. How much impact does data tracking have on the data size of a Web Intelligence document (WID) Compared to the same document without data tracking? Please choose the correct answer.

It will stay the same size.

It will increase two times.

It will increase three times.

It will increase by 50% on each refresh.

4. What are the ways of adding breaks In the Web Intelligence Desktop application? There are 2 correct answers to this question

Click on the origin where you want to insert a break

In the Analysis toolbox, on the Display tab, by clicking Break

The row or column where you want to add the break and selecting Break>Add Break

In the text, on the Design tab, by clicking Break

5. What is the procedure to Display the data in the table as an image that maintains the original formatting? Please choose the correct answer.

Right-click the table and, from the contextual menu, select Copy

Drag data in a table in the target application and you can add the data contained in the table, click copy and paste

Drag and drop the table from Web Intelligence to the target application

Right- click the table to the target application and maintain the formatting from Web Intelligence

6. Which reporting tool should you use to create a Web Intelligence document (WID) directly from an Excel data source? Please choose the correct answer.

Crystal Reports

Desktop Intelligence

Web Intelligence in InfoView

Web Intelligence Rich Client

7. Which three statements are true about alerters? There are 3 correct answers to this question.

You can apply alerters to charts.

You can apply multiple alerters to one block.

You can apply the same alerter to multiple blocks.

You can control the order in which alerters are applied.

8. Which two Web Intelligence Rich Client authentication methods enable you to export Web Intelligence documents (WID) to the Central Management Server (CMS)? There are 2 correct answers to this question.

LTM

LDAP

Offline

Enterprise

Standalone

9. What are the two relational operators that can be used with wildcard Characters, in a query filter? There are 2 correct answers to this question

Design pattern: to find values that match the design you specify

Matches pattern: to find values that match the pattern you specify

Different from pattern: to find values different than the pattern you specify

Defined pattern: to find values that match the defined pattern you specify

10. Which two statements are true of contexts? There are 2 correct answers to this question.

You can combine objects in different contexts.

You cannot combine objects in different contexts.

You can combine any object within the same context to create a query.

You can combine only measures within the same context to create a query.

Page 2 of 5

11. Which three statements are true of calculation contexts? There are 3 correct answers to this question.

If no context is defined the default context is assumed.

You can use NoFilter() as an extended syntax keyword when using contexts.

The ForEach context operator automatically takes the dimensions in the block into account.

You must place parentheses around the values listed after the Where keyword when using the Where operator.

12. Where can you set the priority options for saving a Web Intelligence document (WID) to Microsoft Excel? Please choose the correct answer.

Web Intelligence

InfoView Preferences

Microsoft Excel File Options

Web Intelligence Rich Client

13. Where in a Web Intelligence report do you view merged objects in BusinessObjects Web Intelligence XI 4.x? Please choose the correct answer.

Report Properties tab

Data tab

Navigation tab

Object Properties tab

14. Which two statements are true about Page Layout of a report? There are 2 correct answers to this question.

It displays the definition of the block.

It displays the report page by default.

It defines what the report will look like when printed.

It defines what the report will look like in PDF mode.

15. Which three methods can you use to combine queries using the Web Intelligence Rich Client? There are 3 correct answers to this question.

UNION

MINUS

UNION ALL

INTERSECT

16. Build a query using the eFashion universe, and select the following options to create a section? There are 3 correct answers to this question

Year

Quarter

Half-Year

Sales revenue

Monthly Sales revenue

17. Select the correct sequence To Format a Bar Chart? Please choose the correct answer.

Report Element>Chart>Insert Column Chart

Chart> Report Element >Insert Column Chart

Chart> Insert Column Chart >Report Element

Insert Column Chart>Chart>Report Element

18. Which two are calculation context types? There are 2 correct answers to this question.

Input

Output

Logical

Conditional

19. Which scenarios should you use breaks for? There are 2 correct answers to this question.

Generating subtotals in one table block

Breaking the table into multiple table blocks

Grouping repeated values in one table block

Generating running sum in multiple table blocks

20. Which three options appear in the Scope of Analysis pane in the Query panel? There are 3 correct answers to this question.

None

Default

Custom

One Level

Page 3 of 5

21. Where do you view merged dimensions? Please choose the correct answer.

In the Report Map pane

In the Available Objects pane

In the Document Structure and Filters pane

In the Query panel

22. Which method can you use to build a custom sort? Please choose the correct answer.

Right-click the table, select "Custom Sort"

Right-click the table, select "Sort" and select "Custom Sort"

Select a column; on the toolbar, click the "Custom Sort" button

Select a column; on the toolbar, click the "Apply Sort" button and select "Custom Sort"

23. Which two are benefits of using breaks? There are 2 correct answers to this question.

Creates a navigation map

Makes the table block easier to read

Splits the block into smaller table blocks

Enables the use of subtotals in one block

24. Which three data sources can you synchronize in a Web Intelligence 4.0 document (WID)? There are 3 correct answers to this question.

Personal data files

Stored procedure data source

Queries from the same universe

Queries from different universes

25. What is the default behavior when creating a report from two queries from the same universe? Please choose the correct answer.

Result produces two table blocks.

Dimension objects are automatically merged.

Results are shown on two different report tabs.

Dimension objects are not automatically merged.

26. Which two are running aggregate functions in Web Intelligence? There are 2 correct answers to this question.

RunningMax()

RunningSum()

RunningTotal()

RunningMean()

27. Discuss all the advantages link to organizing a report in the section. There are 2 correct answers to this question

You can have multiple blocks projected from the same microcube within a single report, all sub-grouped to the sectioned level

You can have single block projected from the same microcube within a single report, all grouped to the sectioned level

You can insert subtotal cells, repeated in each section, which are created by the simple process of drag and drop

You can insert tables, different in each section, which are created by the simple process of drag and drop

28. Which of the following is not a step of demonstration, to display an aggregate within a sectioned report. Please choose the correct answer.

Click a detail row in the Sales revenue column

Click the Table, Chart or Others tab

Click the Analysis Toolbox

Click the Functions Tab

29. Which three calculations can you use in a measure object in Web Intelligence? There are 3 correct answers to this question.

Min

Max

Count

Count All

30. Which three statements are true of contexts? There are 3 correct answers to this question.

Contexts are defined in a report.

Contexts are defined in a universe.

You can combine objects in different contexts.

You can combine any objects within the same context to create a query.

Page 4 of 5

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

Map

Data

Properties

Templates

32. You set the drill option "Prompt when drill requires additional data". Now you drill outside the scope of analysis on your report.

How does Web Intelligence respond? Please choose the correct answer.

It prompts you to choose a hierarchy level and waits for your response before retrieving the data.

It notifies you that it needs to retrieve additional data to complete the drill and retrieves the data.

It inserts a prompted query filter in the query and reruns the query.

It inserts a prompted report filter on the report and refreshes the report view.

33. Which method should you use to store a Web Intelligence Rich Client document in an enterprise secured location? Please choose the correct answer.

Save the document to the Enterprise directories

Save the document to the Enterprise documents.

Export the document to the Central Management Server (CMS).

Export the document to the Central Configuration Manager (CCM).

34. Which two data sources can you directly access from a Web Intelligence document (WID) using the Web Intelligence Rich Client? There are 2 correct answers to this question.

Universe

Text File

Web Service

OLAP Cube

35. Which two methods can you use to define document properties? There are 2 correct answers to this question.

Click the report tab, select "Document Properties" and enter the required information.

Right-click the report tab, select "Document Properties" and enter the required information.

Right-click a blank space on the report page, select "Document Properties" and enter the required information.

In the Properties tab of the Report Manager, select "Document Properties" and enter the required information.

36. Which method can you use to hide data using an alerter? Please choose the correct answer.

Build an alerter that removes the column.

Build an alerter that applies a formula that changes the block value.

Build an alerter with a formula that changes the font color to the background color.

Click anywhere in the document. On the toolbar, click the "Data" button and select "Hide Data".

37. A variable in your report contains the statement:

=If[State] = "California" Then [Sales revenue] * 1.05 Else If[State] = "Colorado" Then [Sales revenue] *1.1 Else If[State] InList ("DC";"Texas ") Then [Sales revenue] * 1.15 Else If[State] =

"Massachusetts" Then [Sales revenue] * 1.18 Else [Sales revenue]

Sales revenue for Florida is $1,879,159.

Which rate is applied to the Florida revenue by the formula? Please choose the correct answer.

1.00

1.05

1.10

1.15

1.18

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

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

39. Which three types of local data files can you use to create a BusinessObjects Web Intelligence 4.0 document (WID)? There are 3 correct answers to this question.

TXT

XML

CSV

XLS

40. Which type of relationship links sub-queries by default? Please choose the correct answer.

AND

NOR

NAND

Page 5 of 5

41. Which two settings can you configure for the Sample option in the Properties tab of the Web Intelligence Query panel? There are 2 correct answers to this question.

You can enable the "Fixed" option.

You can set the "Max retrieval time".

You can set the "Max rows retrieved".

You can specify a "Sample Result" set.

42. Which three output context expressions are valid extended syntax expressions? There are 3 correct answers to this question.

Where ([State] = "CA")

Where Section In [State]

In Block Where Section = [State]

In Section Where ([State] = "CA")

Where ([State]="CA" And [Year] ="2006")

43. In the Web Intelligence Desktop, when you save a document as an Excel file, you can specify which reports saving; Following are the options available to save and export data? There are 2 correct answers to this question

Prioritize data analysis in the Excel document

Prioritize the format of reports in the Excel document

Prioritize easy data processing in the Excel document

Prioritize the selection of best solution in the Excel document

44. Which function would you use to extract the word "casual" from the product name "casual pants" of the Product Name field? Please choose the correct answer.

Left(5; [Product Name])

Left([Product Name]; 5)

Right((Product Name), 5)

Right(5, [Product Name])

45. Your report contains a table.

What happens when you drop a dimension object into a blank part of this report? Please choose the correct answer.

A new group is created.

A new block is created.

A new free-standing cell is created.

A new section is created.

46. You have a regional sales report with State, City and Sales Revenue dimensions. You want to create a variable that excludes State from the output context.

Which output statement should you use? Please choose the correct answer.

In([State])

Out([State])

ForAll([State])

ForEach([State])

47. For what purposes can you use the Page Layout of a report? There are 2 correct answers to this question.

To display the definition of the block.

To define how the report will look like in PDF mode.

To define how the report will look like when printed.

To display the report page by default.

48. Which method should you use to group query filters together to form one AND statement? Please choose the correct answer.

Drag the queries together

Drag the query filters to the Group panel

Select the filters, right-click and select Group

Select the filters, then click the Group Filters button on the toolbar

49. You want to compare the sales revenue performance of the top 20% of your customers to the average of all of your customers.

You decide to apply a rank on the table that shows customers and revenue and create a variable to show the average revenue for all customers.

Which function should you use in the variable?

NoFilter()

NoRank()

AverageAll()

IgnoreFilter()

50. From the following identify which of the option is not a method to copy a chart from Web Intelligence to a target application? Please choose the correct answer.

Right-click the chart, and, from the contextual menu, select Copy.

In the target document, right-click the section cell and, from the contextual menu, click Copy

In the target document, right-click the area where you want the table to appear and, from the contextual menu, select Paste

Drag and drop the table from Web Intelligence to the target application

Latest C_BOWI_42 Dumps Valid Version with 175 Q&As

Latest And Valid Q&A | 90 Days Free Update | Once Fail, Full Refund

Get Valid C_BOWI_42 Exam

Latest C_BOWI_42 Dumps Valid Version with 175 Q&As

Leave a Reply Cancel reply