Online Access Free C_TBW60_74 Practice Test

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 PSA entries need to be reactivated.
• B.The Transformation connecting the DataSource needs reactivation.
• C.The PSA entries should have been deleted prior to the DataSource reactivation.
• D.The InfoProvider data should have been first deleted.

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

• A.SAP BW Statistics
• B.SAP BW Data Warehousing Workbench
• C.SAP BI Content
• D.SAP BW Accelerator (BWA)

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

• A.Data is loaded into the InfoCube without generating DIM Ids for this dimension
• B.The number of joins that must be executed during query runtime is reduced
• C.Aggregates on this InfoCube do NOT need to be built
• D.The primary key of the InfoCube fact table is shorter
• E.The number of joins that must be executed during query runtime is reduced

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.There is no delta data in the PSA table.
• B.The InfoPackage has been set to "Full" update.
• C.The DataSource has been configured with interim storage.
• D.The DataSource extraction type has been set to "Full."
• E.The subsequent Transformation has rules set to "Addition."

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 Key Figures Amount and Quantity as non-cumulatives with virtual key figures to calculate the different types.
• B.Use the Select option "Unique for Every Cell" in the distinguishing Characteristic.
• C.Create three InfoCubes; one each for Planned, Budgeted and Forecasted key figure values.
• D.Create a new Dimension table containing a Characteristic to distinguish the key figure types.