SAP SAP Certifications C_TBW60_74 Questions & Answers

• Question 1:

  Your reporting end-users request reporting on year-to-date data.Which of the following would enable this capability? There are 3 correct answers.

  A. Use a combination of an InfoCube query with current data directly extracted from the source system.

  B. Use a HybridProvider based on a Virtual Provider.

  C. Use TransientProviders.

  D. Use a DSO with Real-time Data Acquisition.

  E. Use a MultiProvider with a Write-Optimized DSO and an InfoCube as components.

  Correct Answer: BD

• Question 2:

  End-users want to see the Material Group assigned to a Material at the time of the transaction. How should you model there InfoObjects to accomplish this? (1)

  A. Model Material Group as a time-dependent navigation attribute of Material

  B. Model Material Group as a time-dependent hierarchy of Material

  C. Model Material and Group in the same InfoCube Dimension Table

  D. Model Material Group as a time-independent navigation attribute of Material

  Correct Answer: C

• Question 3:

  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

  Correct Answer: BD

• Question 4:

  What is necessary for a VirtualProvider to display data? There are 3 correct answers.

  A. A DTP for Direct Access

  B. A DataSource for Direct Access

  C. HybridProvider

  D. MultiProvider

  E. DTP that loads data

  F. Transformation

  Correct Answer: ABF

• Question 5:

  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

  Correct Answer: ABE

• Question 6:

  Many of the records you have loaded into a Basic InfoCube consist of Reverse and Additive images. What could you do to reduce the size of the Fact Table? There are 2 correct answers.

  A. Divide those records into appropriate Aggregates.

  B. Compress the Fact Table.

  C. Move these records into a Standard DSO.

  D. Rollup the InfoCube.

  E. Compress the Fact Table with zero elimination.

  F. Compress the Fact Table.

  Correct Answer: E

• Question 7:

  The Air Force orders 10 F-14's for deployment on Monday. This data is loaded to an InfoCube. Then the office requests 2 more fighters, for a total of 12. The new after image data is also to be loaded to the InfoCube. However, you receive an error on the InfoCube update. What could be the issue? Select the correct answer.

  A. The Transformation should be set to overwrite.

  B. The DTP should be set to Full update.

  C. The after image needs to first be loaded in a DSO.

  D. The InfoPackage should be assigned to a daemon.

  Correct Answer: C

• Question 8:

  You are not able to delete a request from a DSO. What best describes the situation? Select the correct answer

  A. The request has been compressed.

  B. The request is contained in an Aggregate.

  C. The request is contained in a subsequent InfoProvider.

  D. The request must be deleted selectively.

  Correct Answer: C

• Question 9:

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

  A. Reporting access to granular data using standard dimensions is faster.

  B. The use of Surrogate IDs (SIDs) to replace master data values in tables.

  C. Dimension tables can be read independently.

  D. Navigational attributes can be used.

  E. The use of Surrogate IDs (SIDs) to replace master data values in tables.

  Correct Answer: C

• Question 10:

  Which is the best way to model the object "Price?" There are 2 correct answers.

  A. If the price of an object changes slowly, model it as a navigational attribute.

  B. If the desired result is the price paid by a customer at the time of the Transaction, model price as a calculated Key Figure.

  C. Leave it out of the data model.

  D. If the price of an object changes slowly, model it as a display attribute.

  Correct Answer: AB