SAP SAP Certifications C_TBI30_74 Questions & Answers

• Question 11:

  What does this formula do?

  Month ({Orders.Order Date})

  A. Determines the month in which an order has been placed

  B. Lists the orders that have been placed in a given month

  C. Returns the total number of orders that have been placed in a given month

  D. Sorts the orders by month

  Correct Answer: A

• Question 12:

  Which of the following tasks can you perform from the Data Warehousing Workbench?(Choose two)

  A. Create new restricted key figures at InfoProvider level.

  B. Create transport packages of BW objects.

  C. Create DataStore Objects.

  D. Create variables for reporting.

  Correct Answer: BC

• Question 13:

  Which type of InfoObjects can you create in BW?(Choose three)

  A. Characteristics

  B. Units

  C. Time characteristics

  D. Key figures

  E. Technical characteristics

  Correct Answer: ABD

• Question 14:

  Which of the following Web items can you use to execute a command in a Web template?(Choose two)

  A. Text Item

  B. Dropdown Box Item

  C. Button Group Item

  D. Radio Button Group Item

  E. Checkbox Group Item

  Correct Answer: BC

• Question 15:

  What is the purpose of an "Exception" in Query Designer?

  A. To highlight data based on characteristic values

  B. To highlight data based on key figure values

  C. To hide data that does not meet threshold criteria

  D. To filter on measure values

  Correct Answer: B

• Question 16:

  In an SAP BusinessObjects Analysis, edition for Microsoft Office workbook, where can you find the active filters?(Choose two)

  A. Under Design Panel -> Information tab

  B. In the Info field

  C. Under Design Panel -> Components tab

  D. Under Design Panel -> Analysis tab

  Correct Answer: AB

• Question 17:

  Which of the following InfoProvider types always have the generated key figure 1ROWCOUNT (number of records)?(Choose two)

  A. DataStore Object

  B. InfoObject

  C. MultiProvider

  D. InfoCube

  Correct Answer: AB

• Question 18:

  What information should you provide for a SAP Business Warehouse connection in dashboards?(Choose two)

  A. The refreshing cycle, for example, every Monday morning at 8:30, or triggered on data load

  B. The mapping of the input and output parameters to the Microsoft Excel spreadsheet

  C. The query or query view used as the data source

  D. The fixed authorization user used to access the data

  Correct Answer: BC

• Question 19:

  Which task can users perform when interacting with the dashboard?

  A. Use a navigational path in Web Intelligence.

  B. Create your own navigational path.

  C. Follow a predefined navigational path.

  D. Share a navigational path with other users.

  Correct Answer: C

• Question 20:

  You define an OLAP connection to BW.

  Which of the following objects can you define as targets for this connection?

  A. MultiProvider and Favorites

  B. InfoCube and BW system

  C. Query and InfoArea

  D. Role and InfoCube

  Correct Answer: B