SAP C_BOWI_42 Online Practice Questions and Exam Preparation

SAP C_BOWI_42 Online Questions & Answers

• Question 1:

  Which of the following query types can you use for combined queries? (3 answers)

  A. Minus
  B. Union
  C. Where
  D. Intersection
  E. Subquery
  A. Minus
  B. Union
  D. Intersection

• Question 2:

  How does SAP recommend you print a Web Intelligence document to ensure the document layout is preserved?

  A. Use the Print Screen button on your keyboard
  B. Export data to a CSV file and print the CSV file.
  C. Use the print option in the browser
  D. Export the document to a PDF file and print the PDF file.
  D. Export the document to a PDF file and print the PDF file.

• Question 3:

  Why purge data in a document before saving to the BI platform? (2 answers)

  A. To ensure that data security restrictions are applied when the document is viewed.
  B. To enable data tracking on a subsequent refresh.
  C. To reduce document file size.
  D. To allow other users to view the document in their preferred viewing locale.
  A. To ensure that data security restrictions are applied when the document is viewed.
  B. To enable data tracking on a subsequent refresh.

• Question 4:

  Why do you use the "Turn into" functionality?

  A. To change the data source of a document
  B. To change the data type of an object
  C. To change the object of a section
  D. To change the table into a chart
  D. To change the table into a chart

• Question 5:

  You add a new object to a query and run the query. How do you display the new object in the document?

  A. Select "Insert a table in the current report" option.
  B. Choose "Refresh All" in the report
  C. Select "Insert a table in a new report" option.
  D. Drag the new object from the Available Objects pane onto the report.
  D. Drag the new object from the Available Objects pane onto the report.

• Question 6:

  How does the ForEach operator affect the default calculation context?

  A. Filters dimension(s).
  B. Add dimension(s).
  C. Replaces dimension(s).
  D. Removes dimension(s).
  B. Add dimension(s).

• Question 7:

  When scheduling Web Intelligence document, what output formats are available? (2 answers)

  A. Adobe Acrobat (PDF)
  B. Microsoft PowerPoint (PPT)
  C. HyperText Markup Language (HTML)
  D. Plain Text (TXT)
  A. Adobe Acrobat (PDF)
  D. Plain Text (TXT)

• Question 8:

  Which operator allows you to enter more than one operand value?

  A. In list
  B. Less than
  C. Except
  D. Equal to
  A. In list

• Question 9:

  What property prevents free-form entry in response of a prompt?

  A. Keep last value selected
  B. Optional prompt
  C. Select only from list
  D. Set default values
  C. Select only from list

• Question 10:

  How can you combine Microsoft Excel spreadsheet data with universe query data?

  A. Merge dimensions from two data sources.
  B. Extend the universe query using a scope of analysis
  C. Combine the data using a minus query.
  D. Filter the universe query using subqueries.
  A. Merge dimensions from two data sources.