C_TBW60_74 Online Practice Questions and Answers

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.

A. Modify a BI Content DataSource to include the Teradata fields in the extraction.

B. Use the File interface to extract manageable files of no more than 20,000 records each.

C. Use a WebService DataSource to stream the records into the PSA of the DataSource.

D. Use DB Connect for the ETL process.

E. Use UD Connect for the ETL process.

What are the features of using the Operational Data Provisioning (ODP) Infrastructure in BW 7.4? There are 3 correct answers.

A. Extract once and deploy many times.

B. Relies on the proven Delta Queue technology.

C. High compression rate up to 90% of extracted data.

D. Single point of monitoring.

E. Makes complete use of mandatory PSA's.

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

A. The ODQ load program is run periodically.

B. The DataSource's InfoPackage or DTP is executed.

C. The DataSource is activated in the BI Content area of the Data Warehousing Workbench.

D. When the SAP source system is connected to SAP BW.

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.

What are the advantages of using a line-item dimension when modeling an InfoCube? (2)

A. The primary key of the InfoCube fact table is shorter

B. the number of joins that must be executed during query runtime is reduced

C. Data is loading into the InfoCube without generating DIM IDs for this dimension

D. Aggregates on this InfoCube do NOT need to be built

The Materials department has created several new products (0PRODUCT) and transactional data for them in the source system. Neither the new products nor the transactional data are visible in SAP BW reporting. Which of the following helps you analyze the issue? There are 3 correct answers.

A. Check for the new data in the DataSource PSA.

B. Check that the InfoCube compression is up to date.

C. Check that the InfoCube contains the new master data.

D. Check that the InfoCube contains the new transaction data.

E. Check the Attribute Change Run.

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.

A. The DataSource extraction type has been set to "Full."

B. The InfoPackage has been set to "Full" update.

C. The subsequent Transformation has rules set to "Addition."

D. There is no delta data in the PSA table.

E. The DataSource has been configured with interim storage.

Partitioning can be used to either aid query response time or manage large amounts of InfoCube data.

Which of the following statements are true about InfoCube partitioning? There are 2 correct answers.

A. Logical and table partitioning cannot be combined.

B. The Analytic Engine can do partition pruning.

C. Table partitions are based either on 0CALMONTH or 0FISCPER.

D. The Repartitioning toolbox can be used with logical partitioning.

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

A. Analyze relationships between the characteristics and their attributes.

B. Evaluate the volume of data to be loaded.

C. Evaluate the number and types of users.

D. Evaluate the format of the data to be loaded.

End-users want to see the Material Group assigned to a Material at the time of the transaction. How should you model there InfoObjects to accomplish this? (1)

A. Model Material Group as a time-dependent navigation attribute of Material

B. Model Material Group as a time-dependent hierarchy of Material

C. Model Material and Group in the same InfoCube Dimension Table

D. Model Material Group as a time-independent navigation attribute of Material