SAP C_TBW60_74 Online Practice Questions and Exam Preparation

SAP C_TBW60_74 Online Questions & Answers

• Question 21:

  Which of the following initial tasks should you perform when designing an SAP BW data model? (2)

  A. Analyze relationships between the characteristics and their attributes
  B. Evaluate the volume of data to be loaded
  C. Evaluation of the number and types of users
  D. Evaluate the format of data to be loaded
  B. Evaluate the volume of data to be loaded
  C. Evaluation of the number and types of users

• Question 22:

  What are performance advantages when using an InfoCube instead of a DataStore Object? There are 2 correct answers.

  A. Navigational attributes can be used.
  B. Surrogate ID (SID) keys and DIM_ID keys are generated automatically.
  C. Surrogate IDs (SIDs) replace master data values in dimension tables.
  D. Reporting access to granular data using standard dimensions is faster.
  B. Surrogate ID (SID) keys and DIM_ID keys are generated automatically.
  C. Surrogate IDs (SIDs) replace master data values in dimension tables.

• Question 23:

  Your reporting end-users have noticed that several Basic InfoCube queries are staring to run more slowly. After examination of the InfoCube, you notice that 2 out of 7 user-defined Dimensions are approaching 50% the size of the Fact Table. What action should you take to resolve this? There are 2 correct answers.

  A. Remodel the Cube by restructuring these 2 Dimensions as Line-Item Dimensions and rearrange their remaining Characteristics among the other Dimensions.
  B. Remodel the Cube by restructuring these 2 Dimensions as Line-Item Dimensions and rearrange their remaining Characteristics in additional new Dimensions.
  C. Remodel the Cube by moving the high-cardinality Characteristics from these Dimensions into one of these 2 Dimensions and the other Characteristics in the other Dimension.
  D. Remodel the Cube by creating more Dimensions making as many of them as possible into Line-Item Dimensions and eliminate the remaining Characteristics.
  A. Remodel the Cube by restructuring these 2 Dimensions as Line-Item Dimensions and rearrange their remaining Characteristics among the other Dimensions.
  B. Remodel the Cube by restructuring these 2 Dimensions as Line-Item Dimensions and rearrange their remaining Characteristics in additional new Dimensions.

• Question 24:

  A Business Content transactional Datasource that uses delta queue processing was converted to Real Time Data Acquisition. An analysis reveals that no new deltas are being transferred into SAP BW 7.x, even though documents are regularly created in the SAP source system delta queue. What tools could you use? There are 2 correct answers.

  A. Process Chain Monitor
  B. Extractor Checker in SAP ECC
  C. SAP BW Delta Queue
  D. Data Load Monitor
  B. Extractor Checker in SAP ECC
  D. Data Load Monitor

• Question 25:

  Which of the following objects can you use as a source objects for a Transformation object? (2)

  A. Transient Provider
  B. InfoSet
  C. Open Hub Destination
  D. InfoSource
  E. InfoSet
  D. InfoSource

• Question 26:

  You want to report on a MultiProvider containing a Standard DSO and an InfoCube. Data in the InfoCube has been archived to a SAP IQ near line storage system. Queries written for the MultiProvider do not display the archived data.What setting should you check? Select the correct answer.

  A. Release OLE DB for OLAP
  B. Read Mode
  C. NLS Usage
  D. Data Integrity
  C. NLS Usage

• Question 27:

  Your customer wants to migrate SAP BW 3.x Data Flows to SAP BW 7.x data flows. What can they do to mitigate the risks of the migration? Please choose the correct answer.

  A. Use emulation first to model the Data Flow with transformations and a data transfer process.
  B. Create the Data Flow manually to create update rules and a data transfer process.
  C. Use emulation first to model the Data Flow with update rules and a data transfer process.
  D. Create the Data Flow manually to create transformations and a data transfer process.
  A. Use emulation first to model the Data Flow with transformations and a data transfer process.

• Question 28:

  Which of the following are features of the Write-Optimized DSO? (2)

  A. They utilize the single Active Data Table
  B. They are intended to contain aggregated data
  C. They enable mass data loads
  D. They utilize a semantic (business) key for record uniqueness
  A. They utilize the single Active Data Table
  C. They enable mass data loads

• Question 29:

  Which of the following are features of DSOs? (3)

  A. They store unconverted OLTP data
  B. They enable drilldown in reporting from InfoCube to the DSO
  C. They enable overwrite functions for key figures and non-key figure characteristics
  D. They are integrated with the Business Explorer (BEx)
  B. They enable drilldown in reporting from InfoCube to the DSO
  C. They enable overwrite functions for key figures and non-key figure characteristics
  D. They are integrated with the Business Explorer (BEx)

• Question 30:

  Which of the following is a valid sequence for modeling objects in the BW data flow? (1)

  A. From DataSource to InfoSource to InfoCube without a Transformation
  B. From DataSource to Transformation to InfoSource to InfoCube
  C. From DataSource to Transformation to InfoSource to Transformation to InfoCube
  D. From DataSource to InfoSource then directly to another InfoSource to Transformation to InfoCube
  E. From InfoSource to DataSource to InfoCube
  C. From DataSource to Transformation to InfoSource to Transformation to InfoCube