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

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.

• Process Chain Monitor
• Extractor Checker in SAP ECC
• SAP BW Delta Queue
• Data Load Monitor

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

• Analyze relationships between the characteristics and their attributes.
• Evaluate the volume of data to be loaded.
• Evaluate the number and types of users.
• Evaluate the format of the data to be loaded.

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.

• Configure a technical key for the destination table.
• Configure the destination table to be recreated on load.
• Configure a semantic key for the destination table.
• Switch the destination to a flat file in XML format.
• Configure a semantic key for the destination table.

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

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

Which of the following does the data propagation layers of your SAP BW system offer? There are 2 correct answers.

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

Which of the following are features of the Write-Optimized DSO? (2)

• They utilize the single Active Data Table
• They are intended to contain aggregated data
• They enable mass data loads
• They utilize a semantic (business) key for record uniqueness

A HybridProvider based on a RDA DSO is duplicating data in the standard InfoCube.What could be the cause of this scenario? Select the correct answer.

• Disable all unnecessary aggregates.
• The associated process chain does not delete the DSO data.
• The associated process chain does not delete the InfoCube data.
• The Daemon schedule must be less frequent.

Your business is using a variety of queries. You plan on upgrading your SAP BW 7.4 system to the latest support package. You want to ensure that the query results are correct with various navigation steps. What tool would you use to accomplish this? Select the correct answer.

• The BEx Web Analyzer.
• The BW Administration Cockpit.
• The BW Metadata Repository.
• The BEx Analyzer.
• The BW Trace Tool.

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

• It is needed every time new data is loaded into the InfoCube
• It does not have any relationship to the availability of data for reporting in an aggregate
• It compresses data into the E Table of the aggregate
• It is the same thing as an attribute change run

When is the Change Run required after successful completion of a master data load? Select the best answer.

• When changes are made to texts from Characteristics used in an Aggregate.
• When changes are made to attributes or hierarchies from Characteristics used in an Aggregate.
• When changes are made to attributes, hierarchies or texts from Characteristics used in an Aggregate.
• When changes are made to the structure of the InfoCube.