SAP C_TBW60_74 Online Practice Questions and Exam Preparation

SAP C_TBW60_74 Online Questions & Answers

• Question 31:

  How are non-cumulative Key Figures calculated? (2) A. They can utilize a virtual Key Figure to combine inflows and outflows

  B. They are designed in Business Explorer queries
  C. They can utilize two virtual Key Figures to represent inflows and outflows
  D. Their calculation is accomplished in Transformations
  E. They can utilize a virtual Key Figure to combine inflows and outflows
  C. They can utilize two virtual Key Figures to represent inflows and outflows

• Question 32:

  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
  A. 8, -8, 6

• Question 33:

  You are not able to transport newly created queries from your development SAP BW system to production. Which of the following could be a possible problem. There are 2 correct answers.

  A. The queries have not been written against a MultiProvider.
  B. The queries not have an active version.
  C. The queries are contained in the incorrect InfoArea.
  D. The queries have not been assigned to a BEx transport request.
  B. The queries not have an active version.
  D. The queries have not been assigned to a BEx transport request.

• Question 34:

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

• Question 35:

  An InfoCube has been designed with 2 user-defined Dimensions containing 1 and 3 Characteristics respectively. All InfoObjects have the same level of master data value cardinality. How can you change the design of the InfoCube to optimize performance? Select the correct answer.

  A. Put all Characteristics in a single user-defined Dimension.
  B. Distribute the InfoObjects unevenly between the Dimensions.
  C. Make the single InfoObject the one Dimension the key of the InfoCube.
  D. Create 2 more Dimensions so that each has only 1 InfoObject.
  D. Create 2 more Dimensions so that each has only 1 InfoObject.

• Question 36:

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

• Question 37:

  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
  A. Aggregates with time-dependent components are calculated for a key date

• Question 38:

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

• Question 39:

  How does an ODP DataSource become visible in the Operational Delta Queue (ODQ)? Select the correct answer

  A. The ODQ load program is run periodically.
  B. The DataSource's InfoPackage or DTP is executed.
  C. The DataSource is activated in the BI Content area of the Data Warehousing Workbench.
  D. When the SAP source system is connected to SAP BW.
  B. The DataSource's InfoPackage or DTP is executed.

• Question 40:

  You are executing a process chain to load transaction data from an SAP source system via a standard DSO into an InfoCube but NO DATA arrives in the InfoCube. What are possible reasons for this? (2)

  A. The data does NOT meet the selection criteria of the DTP
  B. The data comprises an error and the error handling setting is set to "Cancel Request, Do Not Track Records, No Update"
  C. The Data Flow object has NOT been activated
  D. The Integrity check is NOT switched on in the transformations
  A. The data does NOT meet the selection criteria of the DTP
  B. The data comprises an error and the error handling setting is set to "Cancel Request, Do Not Track Records, No Update"