Free SAP C-TBW60-74 Exam Dumps Questions & Answers

Configure a technical key for the destination table A Flat interface DataSource is used to extract file data into the PS

• A.  The BW DTP is set to Full extraction.
• B.  The DataSource has a delta process of FIL0.
• C.  The Transformation does not have rules for all destination fields.
• D.  The BW DTP is set to Full extraction.
• E.  The DTP, however, is having trouble loading the data into an InfoCube. What could be the possible solution? Select the correct answer.

You have added the fields "ZCOUNTRY" and "ZLOCALITY" to the DataSource, 0CUSTOMER_ATTR .
Which of the following is necessary to ensure that the new fields can be extracted from the source system into PSA of the DataSource in SAP BW. Select the correct answer.

• A.  All target InfoProviders must have their table space increased.
• B.  All active customer ABAP enhancements of 0CUSTOMER_ATTR are active
• C.  All fields of 0CUSTOMER_ATTR have been mapped.
• D.  All target InfoProviders must be active and connected.

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

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.  They can use different InfoProvider types
• C.  The ODS layer is typically used for archiving
• D.  They differ in the granularity of data
• E.  They differ in data refresh requirements

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

• A.  Database time less than 2 seconds.
• B.  Ratio of number of rows transferred to the number of rows selected is greater than 10%.
• C.  Ratio of number of rows selected to total query run time exceeds 10%.
• D.  Percentage of total query time spent on the database exceeds 30%.