C_TBW60_74 Online Practice Questions and Answers

Your InfoCube contains the following Key Figures: Planned Amount, Budgeted Amount, Forecasted Amount, Planned Quantity, Budgeted Quantity and Forecasted Quantity. You want to reduce the number of Key Figures to only Amount and Quantity and still retain the uniqueness of key figure values? How can you accomplish this? There are 2 correct answers.

A. Create a new Dimension table containing a Characteristic to distinguish the key figure types.

B. Create three InfoCubes; one each for Planned, Budgeted and Forecasted key figure values.

C. Create Key Figures Amount and Quantity as non-cumulatives with virtual key figures to calculate the different types.

D. Use the Select option "Unique for Every Cell" in the distinguishing Characteristic.

Your business is using a variety of queries. You plan on upgrading your SAP BW 7.4 system to the latest support package. You want to ensure that the query results are correct with various navigation steps. What tool would you use to accomplish this? Select the correct answer.

A. The BEx Web Analyzer.

B. The BW Administration Cockpit.

C. The BW Metadata Repository.

D. The BEx Analyzer.

E. The BW Trace Tool.

Which of the following are true regarding an aggregate roll-up? (1)

A. It is needed every time new data is loaded into the InfoCube

B. It does not have any relationship to the availability of data for reporting in an aggregate

C. It compresses data into the E Table of the aggregate

D. It is the same thing as an attribute change run

Which of the following are true regarding ODP/ODQ data extraction into BW? There are 2 correct answers.

A. PSA tables continue to be mandatory.

B. DTPs continue to be mandatory.

C. DataSources continue to be mandatory.

D. Transformation are no longer necessary.

E. The Delta Queue in BW is necessary.

The Marines order 8 service members for deployment on Monday. This data is loaded to a Standard DSO. Then the office requests 2 less service members, for a total of 6. This new after image data is also loaded to the DSO. What records will be in the Change Log? Select the correct answer.

A. 8, -8, 6

B. 8, -8, 2

C. 8, 6

D. 8, 2

E. 8, 6, 2

Which of the following statements about the compression of an InfoCube are true? (1) A. Compression leads to a reduction in storage space and an increase in read performance

B. During compression the Request ID in the Data Packet Dimension is ignored

C. Once compression takes place it is still possible to manage individual request separately

D. The compressed data is retained in the F Table of the InfoCube

Which of the following are true regarding Aggregates? There are 3 correct answers.

A. They are intended to increase query performance.

B. They can be created for DataStore Objects.

C. They can be created with reference to a time-dependent navigational attribute.

D. They are flat when containing 15 or less user-defined Characteristics.

E. Flat aggregates have no effect on query performance.

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

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.

Which is the best way to model the object "Price?" There are 2 correct answers.

A. If the price of an object changes slowly, model it as a navigational attribute.

B. If the desired result is the price paid by a customer at the time of the Transaction, model price as a calculated Key Figure.

C. Leave it out of the data model.

D. If the price of an object changes slowly, model it as a display attribute.