SAP C_TBW45_70 Online Practice Questions and Exam Preparation

SAP C_TBW45_70 Online Questions & Answers

• Question 31:

  A Key Figure InfoObject ... (Choose two)

  A. ... can carry master data when used as an attribute of a characteristic.
  B. ... can have, amongst others, the data type Amount, Quantity or Number.
  C. ... can have an exception aggregation. This field sets how the key figure is aggregated in the Business Explorer in relation to a given reference characteristic. Example: AVG (average).
  D. ... can be used as a key field of a DataStore Object.
  B. ... can have, amongst others, the data type Amount, Quantity or Number.
  C. ... can have an exception aggregation. This field sets how the key figure is aggregated in the Business Explorer in relation to a given reference characteristic. Example: AVG (average).

• Question 32:

  A BEx Analyzer workbook can be based on which of the following? (Choose three)

  A. A Query
  B. A Query view created with the BEx Analyzer
  C. An InfoProvider
  D. A BEx Report created with the Report Designer
  A. A Query
  B. A Query view created with the BEx Analyzer
  C. An InfoProvider

• Question 33:

  What should you do to ensure that an attribute can be used as a navigation attribute in reporting? (Choose two)

  A. In the InfoObject maintenance for a characteristic, define the attribute as a navigation attribute.
  B. Activate the attribute for navigation in the Aggregate maintenance.
  C. Activate the attribute for navigation at InfoProvider level.
  D. Activate the attribute for navigation at DataSource level.
  A. In the InfoObject maintenance for a characteristic, define the attribute as a navigation attribute.
  C. Activate the attribute for navigation at InfoProvider level.

• Question 34:

  Which of the following statements regarding BEx Query Designer are correct? (Choose three)

  A. Before defining a formula, you must ensure you have already created any restricted key figures that will be referenced in the formula.
  B. You can only drag and drop multiple characteristics into the query definition if they come from the same dimension.
  C. You can save a query that contains errors.
  D. If a query contains errors, the system provides information to help you correct them, including menu options that may be suitable.
  E. You can maintain many of the properties of multiple characteristics or key figures simultaneously.
  C. You can save a query that contains errors.
  D. If a query contains errors, the system provides information to help you correct them, including menu options that may be suitable.
  E. You can maintain many of the properties of multiple characteristics or key figures simultaneously.

• Question 35:

  Which of the following are supported document classes in SAP NetWeaver BI? (Choose three)

  A. InfoProvider (transaction data)
  B. Master Data
  C. Meta Data
  D. Object Data
  A. InfoProvider (transaction data)
  B. Master Data
  C. Meta Data

• Question 36:

  Which of the following statements is true of the star schema of InfoCubes in SAP NetWeaver BI? (Choose three)

  A. Characteristic values are stored hierarchically in dimension tables.
  B. Master data information is stored outside the dimension tables.
  C. The SID table represents the connection between the master data and dimension tables.
  D. SID technology simplifies the sharing of master data.
  E. Characteristic InfoObject master data must always be stored in dimension tables.
  B. Master data information is stored outside the dimension tables.
  C. The SID table represents the connection between the master data and dimension tables.
  D. SID technology simplifies the sharing of master data.

• Question 37:

  Which of the following statements are true regarding sections in the Report Designer? (Choose two)

  A. A static section is based on a data provider that has an underlying query containing two structures.
  B. A dynamic section is based on a data provider that has an underlying query containing one structure.
  C. A dynamic section is based on a data provider that has an underlying query containing two structures.
  D. Dynamic sections offer fewer navigation options than static sections.
  A. A static section is based on a data provider that has an underlying query containing two structures.
  B. A dynamic section is based on a data provider that has an underlying query containing one structure.

• Question 38:

  Which of the following statements are true regarding display and navigational attributes? (Choose two)

  A. You can subtotal a query result based on navigational attributes.
  B. You can subtotal a query result based on display attributes.
  C. You can sort the query result on both display and navigational attributes.
  D. Only display attributes can appear in the "columns" or "rows" section of the BEx Query Designer.
  A. You can subtotal a query result based on navigational attributes.
  C. You can sort the query result on both display and navigational attributes.

• Question 39:

  In your planning project you have a basic InfoCube containing the actual data and a Real Time InfoCube containing the plan data. You want to use actual and plan data at the same time in your Integrated Planning scenario. Which of the following statements are correct? (Choose two)

  A. You can create an aggregation level on the Real Time InfoCube and combine it with the actual InfoCube in a MultiProvider. On the MultiProvider you can create a planning function that copies the actual data to the plan InfoCube.
  B. You can include the actual InfoCube and the plan InfoCube in a MultiProvider, create an aggregation level on the MultiProvider, and create a distribution function that distributes plan data according to the actual data.
  C. You can create an aggregation level on the Real Time InfoCube and combine it with the actual InfoCube in a MultiProvider. On the MultiProvider you can create a plan query that shows actual and plan data.
  D. Since only Real Time InfoCubes can be used in Integrated Planning, you must use a Data Transfer Process to move your actual data to the Real Time InfoCube. Then you plan on the Real Time InfoCube.
  B. You can include the actual InfoCube and the plan InfoCube in a MultiProvider, create an aggregation level on the MultiProvider, and create a distribution function that distributes plan data according to the actual data.
  C. You can create an aggregation level on the Real Time InfoCube and combine it with the actual InfoCube in a MultiProvider. On the MultiProvider you can create a plan query that shows actual and plan data.

• Question 40:

  What are the options available when choosing types of master data (attributes, texts, hierarchies) in the definition of characteristic InfoObjects? (Choose three) A. A characteristic InfoObject contains either all types of master data or no master data at all.

  B. Each individual master data type can be defined separately for each characteristic InfoObject.
  C. You can define a characteristic InfoObject that contains time-dependent texts and timeindependent attributes.
  D. If an attribute is time-dependent, it follows that the texts and all other attributes are timedependent as well.
  E. There are characteristic InfoObjects for which no text tables exist, but which contain attributes nevertheless.
  B. Each individual master data type can be defined separately for each characteristic InfoObject.
  C. You can define a characteristic InfoObject that contains time-dependent texts and timeindependent attributes.
  E. There are characteristic InfoObjects for which no text tables exist, but which contain attributes nevertheless.