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

Which of the following does the data propagation layer of your SAP BW system offer? (2)

• Ability to extract once and deploy many times
• Fast load of mass data
• A single version of the truth
• Homogenized data

You have configured an extraction of master data from an SAP ERP source system. After the first extraction, all of the previously extracted data is being loaded. What could be the possible cause? There is one correct answer.

• The DataSource extraction type has been set to 'Full.'
• The InfoPackage has been set to 'Full' update.
• The subsequent Transformation has rules set to 'Addition.'
• There is no delta data in the PSA table.
• The DataSource has been configured with interim storage.

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.

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

You want to load data from an SAP ERP source system in SAP BW. Which of the following ETL technologies could you use? There are 2 correct answers.

• Flat files.
• SAP Data Services with the Service API.
• UD Connect with JDBC connectors to SQL Server.
• DB Connect with a Microsoft Access database.
• BI Content with the Service API.

You are executing a process chain to load transaction data from an SAP source system via a standard DSO into an InfoCube but NO DATA arrives in the InfoCube. What are possible reasons for this? (2)

• The data does NOT meet the selection criteria of the DTP
• The data comprises an error and the error handling setting is set to 'Cancel Request, Do Not Track Records, No Update'
• The Data Flow object has NOT been activated
• The Integrity check is NOT switched on in the transformations

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

• Transient Provider
• InfoSet
• Open Hub Destination
• InfoSource
• InfoSet

Which of the following are true regarding Aggregates? There are 3 correct answers.

• They are intended to increase query performance.
• They can be created for DataStore Objects.
• They can be created with reference to a time-dependent navigational attribute.
• They are flat when containing 15 or less user-defined Characteristics.
• Flat aggregates have no effect on query performance.

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.

• The Transformation should be set to overwrite.
• The DTP should be set to Full update.
• The after image needs to first be loaded in a DSO.
• The InfoPackage should be assigned to a daemon.

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

• Evaluate the volume of data to be loaded.
• Derive the customer specific LSA.
• Analyze relationships between the characteristics and their attributes.
• Evaluate the format of data to be loaded.
• Evaluate the volume of data to be loaded.

Which of the following actions must you perform to design the dimensions of an InfoCube when you want to accelerate query performance? (3)

• Assign two characteristics that have an N:M relationship to different dimensions
• Each dimension should have the same number of characteristics
• Place the most selective characteristics first in the dimensions
• Use the line item dimensions for characteristics with high cardinality
• Assign two compounded characteristics to different dimensions