SAP C_TBW60_74 Online Practice Questions and Exam Preparation

SAP C_TBW60_74 Online Questions & Answers

• Question 1:

  Which of the following statements about the compression of an InfoCube are true? (1)

  A. Compression leads to a reduction in storage space and an increase in read performance
  B. During compression the Request ID in the Data Packet Dimension is ignored
  C. Once compression takes place it is still possible to manage individual request separately
  D. The compressed data is retained in the F Table of the InfoCube
  A. Compression leads to a reduction in storage space and an increase in read performance

• Question 2:

  Which of the following does the data propagation layers of your SAP BW system offer? There are 2 correct answers.

  A. Ability to extract once and deploy many times
  B. Fast load of mass data
  C. A single version of the truth
  D. Homogenized data
  A. Ability to extract once and deploy many times
  C. A single version of the truth

• Question 3:

  The hierarchy framework allows the DataSource to read the hierarchy structure based on which setting? Select the correct answer.

  A. The hierarchy is version-dependent.
  B. The hierarchy is sorted.
  C. The hierarchy reverses +/- nodes.
  D. The hierarchy is flexible.
  D. The hierarchy is flexible.

• Question 4:

  Which of the following actions must you perform to design the dimensions of an InfoCube when you want to accelerate query performance? (3)

  A. Assign two characteristics that have an N:M relationship to different dimensions
  B. Each dimension should have the same number of characteristics
  C. Place the most selective characteristics first in the dimensions
  D. Use the line item dimensions for characteristics with high cardinality
  E. Assign two compounded characteristics to different dimensions
  A. Assign two characteristics that have an N:M relationship to different dimensions
  C. Place the most selective characteristics first in the dimensions
  D. Use the line item dimensions for characteristics with high cardinality

• Question 5:

  Which of the following does the data propagation layer of your SAP BW system offer? There are 2 correct answers.

  A. Complete data history.
  B. Fast load of mass data.
  C. A single version of the truth.
  D. Ability to extract once and deploy many times.
  E. A single version of the truth.
  D. Ability to extract once and deploy many times.

• Question 6:

  What can you do in the remodeling toolbox? (3) A. Convert an InfoCube dimension to a line-item dimension

  B. Change the standard aggregation of the key figure
  C. Delete a characteristic
  D. Change the reference characteristic
  E. Delete a characteristic of an InfoCube
  C. Delete a characteristic
  E. Delete a characteristic of an InfoCube

• Question 7:

  Your customer wants to model their SAP BW system according to best practices. You propose using a layered scalable architecture (LSA). Which of the following steps must you perform? There are 2 correct answers.

  A. Model disjunct transaction and master data domains for application-specific reporting.
  B. Implement the entire corporate information factory enterprise data warehouse architecture.
  C. Define specific scenarios for data logistics shaped by the customer environment.
  D. Determine which LSA layers are relevant based on the customer's requirement and objectives.
  C. Define specific scenarios for data logistics shaped by the customer environment.
  D. Determine which LSA layers are relevant based on the customer's requirement and objectives.

• Question 8:

  You want to update the 3.x version of an SAP BW DataSource to a 7.x version with the capability to restore the original version. What should you do during the migration to achieve this? Please choose the correct answer.

  A. Replace the 3.x SAP BW InfoSource with a 7.x version SAP BW InfoSource.
  B. Migrate the 3.x DataSource version with export.
  C. Delete all entries from the Persistent Staging Area (PSA)
  D. Create a transformation to replace the transfer rules.
  B. Migrate the 3.x DataSource version with export.

• Question 9:

  what does SAP recommend you do to improve the overall reporting performance of a standard InfoCube in SAP BW 7.4? (3)

  A. Create aggregates
  B. Replace the InfoCube by a SPO
  C. Use the process type "Fill OLAP cache" in a process chain
  D. Use navigation attributes instead of dimension characteristics
  E. Use several InfoCubes as PartProviders of a MultiProvider instead of a single standard InfoCube
  A. Create aggregates
  B. Replace the InfoCube by a SPO
  E. Use several InfoCubes as PartProviders of a MultiProvider instead of a single standard InfoCube

• Question 10:

  You want postable nodes in a hierarchy to appear in multiple hierarchy branches.

  What action could you take to accomplish this? (2)

  A. Enter the postable nodes as Link Nodes
  B. Configure the hierarchy as time-dependent
  C. Create multiple similar hierarchies
  D. Configure the hierarchy with a time-dependent structure
  D. Configure the hierarchy with a time-dependent structure