C_TBW60_74 Exam Dumps – Our Features

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

• UD Connect contains an inherent 'Group By' clause.
• UD Connect requires ABAP connectors.
• DB Connect normally reduces the granularity of the data.
• DB Connect requires the potential use of a Database Shared Library.

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

Your reporting end-users request reporting on year-to-date data.Which of the following would enable this capability? There are 3 correct answers.

• Use a combination of an InfoCube query with current data directly extracted from the source system.
• Use a HybridProvider based on a Virtual Provider.
• Use TransientProviders.
• Use a DSO with Real-time Data Acquisition.
• Use a MultiProvider with a Write-Optimized DSO and an InfoCube as components.

Which setting increases the performance of the Activation job for a Standard DSO? Select the correct answer.

• Unique Data Records.
• Automatically Repeat Red Requests in Process Chain.
• Parallel Activation of Requests in Activation Queue.
• SID Generation During Activation

There is a need to extract millions of records from an Oracle database into BW for analysis. Which of the following represents the best ETL strategy? Select the correct answer.

• Modify a BI Content DataSource to include the Teradata fields in the extraction.
• Use the File interface to extract manageable files of no more than 20,000 records each.
• Use a WebService DataSource to stream the records into the PSA of the DataSource.
• Use DB Connect for the ETL process.
• Use UD Connect for the ETL process.

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 statements about aggregates is true? (2)

• Aggregates can only be created for Basic Cubes
• Aggregates are stored as a single transparent table, which houses the aggregated data
• Aggregates can be created on dimension characteristics and navigational attributes
• Several dimension characteristics used in an aggregate always have the same aggregation level
• Aggregates reduce the number of key figures

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

• Model disjunct transaction and master data domains for application-specific reporting.
• Implement the entire corporate information factory enterprise data warehouse architecture.
• Define specific scenarios for data logistics shaped by the customer environment.
• Determine which LSA layers are relevant based on the customer's requirement and objectives.

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

What is the purpose of the Enterprise Data Warehouse (EDW) Layer? (2)

• To ensure vertical consistency of the data flow
• To provide a layer where data can be overwritten to reflect the current status of business transactions
• To provide an enterprise wide repository of business data at a summary level
• To ensure that data is only extracted once from source systems