Exam Questions and Answers for C-BOWI-43 Study Guide Questions and Answers!
SAP Certified Application Associate - SAP BusinessObjects Web Intelligence 4.3 Certification Sample Questions and Practice Exam
NEW QUESTION 18
What does the RefValue() function return if there is no reference data?
- A. A blank
- B. An error
- C. A null
- D. A zero
Answer: C
NEW QUESTION 19
When using the ranking feature on a table, which expression allows you to display the total of all values (both ranked and unranked) in the footer of the block?
- A. NoFilter(Sum([measure]))
- B. RefValue(Sum([measure]))
- C. Sum([measure] ForEach [dimension])
- D. Sum([measure]) In Block
Answer: D
NEW QUESTION 20
How can you combine Microsoft Excel spreadsheet data with universe query data?
- A. Combine the data using a minus query.
- B. Filter the universe query using subqueries.
- C. Extend the universe query using a scope of analysis.
- D. Merge dimensions from the two data sources.
Answer: D
NEW QUESTION 21
How do you remove a custom sort that has been applied to an object?
- A. Choose the Remove button in the Manage Sorts dialog.
- B. Right click the object, select Sort, and then select None.
- C. Delete the column containing the object.
- D. Choose the Reset button in the Manage Sorts dialog.
Answer: D
NEW QUESTION 22
What does the ranking calculation mode Cumulative Percentage keep in the block?
- A. The top/bottom values until the sum reaches a specified percentage of the total
- B. The top/bottom values until the sum reaches a specified value
- C. The top/bottom percentage of the number of rows based on the dimension
- D. The top/bottom number of rows based on the measure
Answer: A
NEW QUESTION 23
What happens if an optional prompt is blank when you execute a query?
- A. The query is filtered by the default value of the prompt.
- B. The query is filtered by the last value selected.
- C. The query filter is ignored.
- D. The query returns an empty record set.
Answer: C
NEW QUESTION 24
Which of the following filter components are used to restrict data? Note: There are 3 correct Answers to this question.
- A. An operand
- B. A SELECT statement
- C. An object
- D. A universe connection
- E. An operator
Answer: A,C,E
NEW QUESTION 25
What is a Web Intelligence variable?
- A. A function that merges multiple queries.
- B. A property that allows the user to change the application mode.
- C. An option that enhances performance when a query is refreshed.
- D. A formula that is saved with a name.
Answer: D
NEW QUESTION 26
In which of the following can you use the If( ) function in Web Intelligence?
- A. Drill filters
- B. Variables
- C. Input control
- D. Prompts
Answer: B
NEW QUESTION 27
To what can you apply a conditional formatting rule? Note: There are 2 correct Answers to this question.
- A. Data in a section header cell
- B. Data in a query filter
- C. Data in a chart
- D. Data in a table
Answer: A,D
NEW QUESTION 28
What chart elements can use a formula? Note: There are 2 correct Answers to this question.
- A. Axis titles
- B. Chart title
- C. Legend labels
- D. Data labels
Answer: A,C
NEW QUESTION 29
What is the required argument of the UserResponse( ) function?
- A. prompt_string
- B. report name
- C. dimension
- D. measure
Answer: A
NEW QUESTION 30
Which analysis function adds a column to a vertical table?
- A. Default aggregation
- B. Sum
- C. Percentage
- D. Count
Answer: A
NEW QUESTION 31
Your data source has the following values: SMITH, SMYTH, SMALL, SMOOTH, SMART, SMILEY. What syntax do you use to show only the names SMITH and SMYTH?
- A. SM&
- B. SM*TH
- C. SM%TH
- D. SM_TH
Answer: B
NEW QUESTION 32
How do you make changes to a document that has been published in the BI launch pad? Note: There are
2 correct Answers to this question.
- A. Select the document, select More Actions and select Modify.
- B. Right click the document and select Document Link.
- C. Double click the document and select Design Mode.
- D. Right click the document and select Properties.
Answer: A,C
NEW QUESTION 33
How does the ForEach operator affect the default calculation context?
- A. Removes dimension(s).
- B. Replaces dimension(s).
- C. Filters dimension(s).
- D. Adds dimension(s).
Answer: D
NEW QUESTION 34
What operator do you select to use a wildcard character in a Web Intelligence query?
- A. In list
- B. Matches pattern
- C. Except
- D. Equal to
Answer: B
NEW QUESTION 35
Where is a variable saved?
- A. In a query
- B. In the universe
- C. In a category
- D. In the document
Answer: D
NEW QUESTION 36
Which operator allows you to select exactly one value as the operand for a query filter?
- A. Is null
- B. Between
- C. Equal to
- D. Different from pattern
Answer: C
NEW QUESTION 37
You want to subtotal the data by year in a table but you do not have a location for the subtotal in the table. What must you do to create the location for the subtotal in the table?
- A. Insert a blank cell.
- B. Section the report.
- C. Apply a break.
- D. Format the table.
Answer: C
NEW QUESTION 38
Why is the subtotal missing from the bottom of each break in the attached diagram?
- A. The report is NOT sectioned by year.
- B. The break footers display option is NOT selected.
- C. The calculation was applied to the table before the break.
- D. The default aggregation on the measure is delegated.
Answer: B
NEW QUESTION 39
What actions can you perform in the Web Intelligence query panel? Note: There are 3 correct Answers to this question.
- A. Change table to chart.
- B. Publish as a web service.
- C. Rearrange objects in the query.
- D. Remove objects from the query.
- E. Change custom filters.
Answer: C,D,E
NEW QUESTION 40
How do you allow a user to type a value for a prompt? Note: There are 2 correct Answers to this question.
- A. Deselect the "Set default values" property.
- B. Deselect the "Select only from list" property.
- C. Deselect the "Prompt with list of values" property.
- D. Select the "Optional prompt" property.
Answer: C,D
NEW QUESTION 41
What are the benefits of using SAP BusinessObjects Web Intelligence? Note: There are 2 correct Answers to this question.
- A. You can use simple drag-and-drop features to create interactive reports.
- B. You can dynamically refresh and update information directly in your MS Office documents.
- C. You can drill, slice-and-dice, and format information based on your business needs.
- D. You can centrally manage, control, and configure your BI deployment.
Answer: A,C
NEW QUESTION 42
What tasks can you perform in the data application mode? Note: There are 2 correct Answers to this question.
- A. Assign chart series data
- B. Add a report filter
- C. Merge objects
- D. Create a new data provider
Answer: C,D
NEW QUESTION 43
......
C-BOWI-43 certification dumps - SAP Certified Application Associate C-BOWI-43 guides - 100% valid: https://www.passcollection.com/C-BOWI-43_real-exams.html
100% Pass Your C-BOWI-43 at First Attempt with PassCollection: https://drive.google.com/open?id=14EvyOQVWCnZer4Spw3KBeHAaPHD3HLK0
