C_TBW60_74 Online Practice Questions and Answers

What other layer of the EDW layer can be used in place of the Corporate Memory? (1)

A. The Business Transformation Layer

B. The Reporting Layer

C. The Data Acquisition Layer

D. The Data Propagation Layer

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

A. Ability to extract once and deploy many times

B. Fast load of mass data

C. A single version of the truth

D. Homogenized data

Which of the following are features of DSOs? (3)

A. They store unconverted OLTP data

B. They enable drilldown in reporting from InfoCube to the DSO

C. They enable overwrite functions for key figures and non-key figure characteristics

D. They are integrated with the Business Explorer (BEx)

You have created a new Data Flow object in the graphical sAP BW data Flow tool by copying a Data Flow template. What must you do to use the new Data Flow? (1)

A. Copy non-persistent SAP BW Objects

B. Validate non-persistent SAP BW Objects

C. Activate non-persistent SAP BW Objects

D. Replace non-persistent SAP BW objects with active SAP BW objects

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.

When should you use the Generic Data Extractor tools to create a data source? There are 3 correct answers.

A. When Business Content does not contain a data source for your application.

B. When you use customer written programs in R/3 to populate your tables.

C. When the data to be extracted is highly granular.

D. When the application does not feature its own data extraction method.

E. If you want to extract data without delta extractions.

Which of the following is a viable alternative to having more than 13 unrelated Characteristics in an InfoCube? Select the correct answer.

A. Reduce the number of Characteristics down to 13.

B. Create more than 13 custom-defined Dimensions.

C. Add the extra ones as Key Figures.

D. Associate unrelated Characteristics in a single dimension.

E. Use more than one InfoCube in the design.

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

A. Evaluate the volume of data to be loaded.

B. Derive the customer specific LSA.

C. Analyze relationships between the characteristics and their attributes.

D. Evaluate the format of data to be loaded.

E. Evaluate the volume of data to be loaded.

Which of the following are true regarding BW Data Modeling? There are 3 correct answers.

A. BW objects are created with reference to administrative needs.

B. Reporting requirements are the necessary starting point.

C. Different types of reporting end-users can be ignored.

D. Reference to BW Business Content should be conducted during the development of the data model.

E. Business Content does not need to be activated.

F. Reporting requirements are the necessary starting point.

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

A. Transient Provider

B. InfoSet

C. Open Hub Destination

D. InfoSource

E. InfoSet

Configure a technical key for the destination table A Flat interface DataSource is used to extract file data into the PS

A. The DTP, however, is having trouble loading the data into an InfoCube. What could be the possible solution? Select the correct answer.

B. The BW DTP is set to Full extraction.

C. The Transformation does not have rules for all destination fields.

D. The DataSource has a delta process of FIL0.

E. The BW DTP is set to Full extraction.

What can you use to accelerate an SAP BW implementation project? (1)

A. SAP BW Data Warehousing Workbench

B. SAP BI Content

C. SAP BW Accelerator (BWA)

D. SAP BW Statistics

Which of the following statements about aggregates is true? (2)

A. Aggregates can only be created for Basic Cubes

B. Aggregates are stored as a single transparent table, which houses the aggregated data

C. Aggregates can be created on dimension characteristics and navigational attributes

D. Several dimension characteristics used in an aggregate always have the same aggregation level

E. Aggregates reduce the number of key figures

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.

A. The Transformation should be set to overwrite.

B. The DTP should be set to Full update.

C. The after image needs to first be loaded in a DSO.

D. The InfoPackage should be assigned to a daemon.

what does SAP recommend you do to improve the overall reporting performance of a standard InfoCube in SAP BW 7.4? (3)

A. Create aggregates

B. Replace the InfoCube by a SPO

C. Use the process type "Fill OLAP cache" in a process chain

D. Use navigation attributes instead of dimension characteristics

E. Use several InfoCubes as PartProviders of a MultiProvider instead of a single standard InfoCube