C_TBW60_74 Exam Training Practice Tests (SAP Certified Application Associate - Modeling and Data Management with SAP BW 7.4)]

Question 1

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

A. The request is contained in a subsequent InfoProvider. B. The request is contained in an Aggregate. C. The request has been compressed. D. The request must be deleted selectively.

Correct Answer: A

Question 2

You want to increase the overall performance of a designed standard DSO. The DSO has contains 100 InfoObjects in its definition, 5 of which are in the Key Part. Which of the following possible actions should you take? There are 3 correct answers.

A. Create secondary indexes. B. Set up the automatic movement of Active Table records to a subsequent InfoProvider. C. Set up automatic deletion of Change Log data. D. Decrease the size of the Key Part. E. Set the Settings option for Unique records.

Correct Answer: A,C,E

Question 3

The UD Connect extraction of document level data from a SQL Server database results in a loss of document detail in BW. What possible action could you take to resolve this? Select the correct answer.

A. Use a DB Connect based DataSource. B. Use a DSO for Real Time Data Acquisition. C. Use a generic DataSource with a numeric pointer for the delta service. D. Use a DataSource based on SAP Data Services to restore the detail.

Correct Answer: A

Question 4

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

A. The DataSource's InfoPackage or DTP is executed. B. The ODQ load program is run periodically. C. When the SAP source system is connected to SAP BW. D. The DataSource is activated in the BI Content area of the Data Warehousing Workbench.

Correct Answer: A

Question 5

Which of the following are true in designing aggregates?
There are 3 correct answers.

A. Time-dependent aggregates can be adjusted upon changes of the key date only through process chains. B. Aggregates containing navigational attributes can be larger than aggregates based on dimensional characteristics. C. Aggregates are evaluated by the BW system based on usage and number of records. D. Multiple aggregates should be designed to fit into a rollup hierarchy. E. Aggregates can share dimension tables with the InfoCube.

Correct Answer: B,C,E

Question 6

How can BI Content be used in a SAP BW implementation? (2)

A. Eliminate the need for requirements analysis B. Replaces analysis and data modeling C. Enable Business Blueprint and Realization D. Continuous improvement after go-live

Correct Answer: C,D

Question 7

Which of the following are true regarding DB and UD Connect technologies? There are 2 correct answers.

A. UD Connect contains an inherent "Group By" clause. B. UD Connect requires ABAP connectors. C. DB Connect requires the potential use of a Database Shared Library. D. DB Connect normally reduces the granularity of the data.

Correct Answer: A,C

Question 8

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

A. Transformation B. MultiProvider C. A DataSource for Direct Access D. A DTP for Direct Access E. DTP that loads data F. HybridProvider

Correct Answer: A,C,D

Question 9

You design a Standard DSO with a semantic key consisting of controlling area and cost center number in the Key Part. What should you do to prevent valid records from being written to the Error Stack during load?
Select the correct answer.

A. Use a technical key for the Error Stack. B. Create a wider semantic group for the Error Stack. C. Put all key figures in the Key Part of the Error Stack.. D. Create secondary indexes on the Error Stack.

Correct Answer: B

Question 10

Your InfoCube contains the following Key Figures: Planned Amount, Budgeted Amount, Forecasted Amount, Planned Quantity, Budgeted Quantity and Forecasted Quantity. You want to reduce the number of Key Figures to only Amount and Quantity and still retain the uniqueness of key figure values? How can you accomplish this? There are 2 correct answers.

A. Create a new Dimension table containing a Characteristic to distinguish the key figure types. B. Create Key Figures Amount and Quantity as non-cumulatives with virtual key figures to calculate the different types. C. Create three InfoCubes; one each for Planned, Budgeted and Forecasted key figure values. D. Use the Select option "Unique for Every Cell" in the distinguishing Characteristic.

Correct Answer: A,D

SAP Certified Application Associate - Modeling and Data Management with SAP BW 7.4 - C_TBW60_74 Exam Practice Test