SAP Certified Application Associate - Modeling and Data Management with SAP BW 7.4: C_TBW60_74

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%.

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

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.