C_TBW60_74 Online Practice Questions and Answers

What are the differences between the Reporting and Operational Data Store (ODS) layers in LSA if both are reportable? (2)

A. They can use different InfoProvider types

B. The ODS layer is typically used for archiving

C. They differ in data refresh requirements

D. They differ in the granularity of data

E. They can use different InfoProvider types

What are the indications of a missing or inappropriate aggregate? There are 3 correct answers.

A. Percentage of total query time spent on the database exceeds 30%.

B. Ratio of number of rows selected to total query run time exceeds 10%.

C. Database time less than 2 seconds.

D. Ratio of number of rows transferred to the number of rows selected is greater than 10%.

What can you use to accelerate an SAP BW implementation project? Choose the correct answer.

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 with time-dependent components is true? (1)

A. Aggregates with time-dependent components are calculated for a key date

B. The key date for an aggregate with a time-dependent component is always a fixed date

C. When aggregates with a time-dependent component are filled the key date is retrieved

D. For a query to use data in an aggregate with a time-dependent component, the query's key date does not have to match the key date of the aggregated

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.

A BW 7.4 data flow has been working successfully for a while. Today the data flow resulted in an error after the DataSource has been changed and reactivateD. What could be the possible problem? Select the correct answer.

A. The Transformation connecting the DataSource needs reactivation.

B. The PSA entries need to be reactivated.

C. The PSA entries should have been deleted prior to the DataSource reactivation.

D. The InfoProvider data should have been first deleted.

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.

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.

A. Model disjunct transaction and master data domains for application-specific reporting.

B. Implement the entire corporate information factory enterprise data warehouse architecture.

C. Define specific scenarios for data logistics shaped by the customer environment.

D. Determine which LSA layers are relevant based on the customer's requirement and objectives.

Standard DSO Objects consist of which of the following tables? (1)

A. Activation Queue, Active Data and PSA

B. Active Data, Change Log and PSA

C. Change Log, Activation Queue, PSA

D. Change Log, Activation Queue, Active Data

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.

A. Use a technical key for the Error Stack.

B. Put all key figures in the Key Part of the Error Stack..

C. Create secondary indexes on the Error Stack.

D. Create a wider semantic group for the Error Stack.