SAP C_TBW60_74 Online Practice Questions and Exam Preparation

SAP C_TBW60_74 Online Questions & Answers

• Question 41:

  Partitioning can be used to either aid query response time or manage large amounts of InfoCube data. Which of the following statements are true about InfoCube partitioning? There are 2 correct answers.

  A. Logical and table partitioning cannot be combined.
  B. The Analytic Engine can do partition pruning.
  C. Table partitions are based either on 0CALMONTH or 0FISCPER.
  D. The Repartitioning toolbox can be used with logical partitioning.
  B. The Analytic Engine can do partition pruning.
  C. Table partitions are based either on 0CALMONTH or 0FISCPER.
  D. The Repartitioning toolbox can be used with logical partitioning.

• Question 42:

  Which of the following are true regarding DB and UD Connect technologies? There are 2 correct answers.

  A. UD Connect contains an inherent "Group By" clause.
  B. UD Connect requires ABAP connectors.
  C. DB Connect normally reduces the granularity of the data.
  D. DB Connect requires the potential use of a Database Shared Library.
  A. UD Connect contains an inherent "Group By" clause.
  D. DB Connect requires the potential use of a Database Shared Library.

• Question 43:

  Which of the following process chain collector steps prevent multiple executions of a successor process? There are 2 correct answers.

  A. The Start process step triggered by a Meta Chain.
  B. The Exclusive OR process step.
  C. The OR process step.
  D. The Attribute Change Run process step.
  E. The AND process step.
  B. The Exclusive OR process step.
  E. The AND process step.

• Question 44:

  What is necessary for a VirtualProvider to display data? There are 3 correct answers.

  A. A DTP for Direct Access
  B. A DataSource for Direct Access
  C. HybridProvider
  D. MultiProvider
  E. DTP that loads data
  F. Transformation
  A. A DTP for Direct Access
  B. A DataSource for Direct Access
  F. Transformation

• Question 45:

  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 be active and connected.
  B. All target InfoProviders must have their table space increased.
  C. All fields of 0CUSTOMER_ATTR have been mapped.
  D. All active customer ABAP enhancements of 0CUSTOMER_ATTR are active
  D. All active customer ABAP enhancements of 0CUSTOMER_ATTR are active

• Question 46:

  What pre-requisites must be fulfilled to use a generic DataSource for real time data acquisition (RDA)? There are 2 correct answers.

  A. A Generic Delta Service must be part of the definition.
  B. The delta field must be a selection criteria.
  C. The Delta Service must be marked for RDA.
  D. The delta field must be a numeric pointer.
  E. The DataSource must be based on a function module.
  A. A Generic Delta Service must be part of the definition.
  C. The Delta Service must be marked for RDA.

• Question 47:

  Which of the following are standard aggregation types for Key Figures? (2)

  A. Summation
  B. Average
  C. Last Value
  D. Minimum
  A. Summation
  D. Minimum

• Question 48:

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

  A. You can inspect the contents of the fact table only
  B. Repair and rebuild indices
  C. Gain an overview of SID values
  D. Roll-up requests into aggregates regardless of the activation status of the aggregate
  E. Repair and rebuild indices
  D. Roll-up requests into aggregates regardless of the activation status of the aggregate

• Question 49:

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

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

• Question 50:

  What other layer of the EDW layer can be used in place of the Corporate Memory? (1)

  A. The Business Transformation Layer
  B. The Reporting Layer
  C. The Data Acquisition Layer
  D. The Data Propagation Layer
  D. The Data Propagation Layer