SAP SAP Certifications C_TBW60_74 Questions & Answers

• Question 51:

  Data is loaded via a process chain to an Open Hub destination table. When this table data is then loaded into a non-SAP operational system, it is found that records are duplicated over time. What action should you take to resolve this? Select the correct answer.

  A. Configure a technical key for the destination table.

  B. Configure the destination table to be recreated on load.

  C. Configure a semantic key for the destination table.

  D. Switch the destination to a flat file in XML format.

  E. Configure a semantic key for the destination table.

  Correct Answer: C

• Question 52:

  What are the advantages of using a line-item dimension when modeling an InfoCube? (2)

  A. The primary key of the InfoCube fact table is shorter

  B. the number of joins that must be executed during query runtime is reduced

  C. Data is loading into the InfoCube without generating DIM IDs for this dimension

  D. Aggregates on this InfoCube do NOT need to be built

  Correct Answer: BC

• Question 53:

  Which of the following are true regarding BW Data Modeling? There are 3 correct answers.

  A. BW objects are created with reference to administrative needs.

  B. Reporting requirements are the necessary starting point.

  C. Different types of reporting end-users can be ignored.

  D. Reference to BW Business Content should be conducted during the development of the data model.

  E. Business Content does not need to be activated.

  F. Reporting requirements are the necessary starting point.

  Correct Answer: DE

• Question 54:

  Which of the following are true about generic DataSources? There are 3 correct answers.

  A. They can NOT be enhanced with additional fields after creation.

  B. They are can be defined with delta capability.

  C. They are can be used with real-time data extraction.

  D. They are replicated by process chain.

  E. They can be defined with filter criteria.

  Correct Answer: BCE

• Question 55:

  Which of the following initial tasks should you perform when designing an SAP BW data model? There are 2 correct answers.

  A. Evaluate the volume of data to be loaded.

  B. Derive the customer specific LSA.

  C. Analyze relationships between the characteristics and their attributes.

  D. Evaluate the format of data to be loaded.

  E. Evaluate the volume of data to be loaded.

  Correct Answer: B

• Question 56:

  Which of the following are true regarding an aggregate roll-up? (1)

  A. It is needed every time new data is loaded into the InfoCube

  B. It does not have any relationship to the availability of data for reporting in an aggregate

  C. It compresses data into the E Table of the aggregate

  D. It is the same thing as an attribute change run

  Correct Answer: A

• Question 57:

  Which of the following is a viable alternative to having more than 13 unrelated Characteristics in an InfoCube? Select the correct answer.

  A. Reduce the number of Characteristics down to 13.

  B. Create more than 13 custom-defined Dimensions.

  C. Add the extra ones as Key Figures.

  D. Associate unrelated Characteristics in a single dimension.

  E. Use more than one InfoCube in the design.

  Correct Answer: E

• Question 58:

  How does an ODP DataSource become visible in the Operational Delta Queue (ODQ)? Select the correct answer

  A. The ODQ load program is run periodically.

  B. The DataSource's InfoPackage or DTP is executed.

  C. The DataSource is activated in the BI Content area of the Data Warehousing Workbench.

  D. When the SAP source system is connected to SAP BW.

  Correct Answer: B

• Question 59:

  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

  Correct Answer: AC

• Question 60:

  What must you create to use data transfer process (DTP) error handling? Choose the correct answer.

  A. A DTP with extraction mode FULL

  B. A DTP with extraction mode INITIAL

  C. A process chain using the DTP

  D. A DTP with the transfer method Persistent Staging Area (PSA)

  Correct Answer: D