SAP SAP Certifications C_TBW60_74 Questions & Answers

• Question 71:

  What can you use to accelerate an SAP BW implementation project? Choose the correct answer.

  A. SAP BW Data Warehousing Workbench

  B. SAP BI Content

  C. SAP BW Accelerator (BWA)

  D. SAP BW Statistics

  Correct Answer: B

• Question 72:

  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

  Correct Answer: BC

• Question 73:

  What are the indications of a missing or inappropriate aggregate? There are 3 correct answers.

  A. Percentage of total query time spent on the database exceeds 30%.

  B. Ratio of number of rows selected to total query run time exceeds 10%.

  C. Database time less than 2 seconds.

  D. Ratio of number of rows transferred to the number of rows selected is greater than 10%.

  Correct Answer: ACD

• Question 74:

  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

  Correct Answer: D

• Question 75:

  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.

  Correct Answer: B

• Question 76:

  You are not able to transport newly created queries from your development SAP BW system to production. Which of the following could be a possible problem. There are 2 correct answers.

  A. The queries have not been written against a MultiProvider.

  B. The queries not have an active version.

  C. The queries are contained in the incorrect InfoArea.

  D. The queries have not been assigned to a BEx transport request.

  Correct Answer: BD

• Question 77:

  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

  Correct Answer: ACE

• Question 78:

  Which of the following are standard aggregation types for Key Figures? (2)

  A. Summation

  B. Average

  C. Last Value

  D. Minimum

  Correct Answer: AD

• Question 79:

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

  A. Model disjoint 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 requirements and objectives

  Correct Answer: CD

• Question 80:

  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.

  Correct Answer: AB