Free SAP C_TBW60_74 Exam Dumps Questions & 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.Use the Select option "Unique for Every Cell" in the distinguishing Characteristic.
• 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.Create a new Dimension table containing a Characteristic to distinguish the key figure types.

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 compresses data into the E Table of the aggregate
• C.It does not have any relationship to the availability of data for reporting in an aggregate
• D.It is the same thing as an attribute change run

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

• A.Aggregates reduce the number of key figures
• B.Aggregates can be created on dimension characteristics and navigational attributes
• C.Aggregates can only be created for Basic Cubes
• D.Several dimension characteristics used in an aggregate always have the same aggregation level
• E.Aggregates are stored as a single transparent table, which houses the aggregated data

A Business Content transactional Datasource that uses delta queue processing was converted to Real Time Data Acquisition. An analysis reveals that no new deltas are being transferred into SAP BW 7.x, even though documents are regularly created in the SAP source system delta queue. What tools could you use? There are 2 correct answers.

• A.Process Chain Monitor
• B.Data Load Monitor
• C.Extractor Checker in SAP ECC
• D.SAP BW Delta Queue

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 display 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 navigational attribute.