SAP SAP Certifications C_TBW60_74 Questions & Answers

• Question 61:

  Your business is using a variety of queries. You plan on upgrading your SAP BW 7.4 system to the latest support package. You want to ensure that the query results are correct with various navigation steps. What tool would you use to accomplish this? Select the correct answer.

  A. The BEx Web Analyzer.

  B. The BW Administration Cockpit.

  C. The BW Metadata Repository.

  D. The BEx Analyzer.

  E. The BW Trace Tool.

  Correct Answer: E

• Question 62:

  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

  Correct Answer: D

• Question 63:

  You need to transport your BW objects and your ECC DataSources. Which is the right order to do so? Select the correct answer.

  A. Transport your DataSources, Transport your BW objects, Replicate your DataSources

  B. Transport your BW Objects, Replicate your DataSources, Transport your DataSources

  C. Transport your DataSources, Replicate your DataSources, Transport your BW Objects.

  Correct Answer: C

• Question 64:

  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.

  Correct Answer: AD

• Question 65:

  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

  Correct Answer: D

• Question 66:

  You want to report on a MultiProvider containing a Standard DSO and an InfoCube. Data in the InfoCube has been archived to a SAP IQ near line storage system. Queries written for the MultiProvider do not display the archived data.What setting should you check? Select the correct answer.

  A. Release OLE DB for OLAP

  B. Read Mode

  C. NLS Usage

  D. Data Integrity

  Correct Answer: C

• Question 67:

  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

  Correct Answer: A

• Question 68:

  Which of the following definitions of a DSO is true? (1)

  A. DSO Objects are subsets of an InfoCube's data

  B. DSO Objects are equivalent to aggregates

  C. DSO Objects contain consolidated data at the atomic level

  D. DSO Objects are unique to OLTP Systems

  Correct Answer: C

• Question 69:

  When should you use the Generic Data Extractor tools to create a data source? There are 3 correct answers.

  A. When Business Content does not contain a data source for your application.

  B. When you use customer written programs in R/3 to populate your tables.

  C. When the data to be extracted is highly granular.

  D. When the application does not feature its own data extraction method.

  E. If you want to extract data without delta extractions.

  Correct Answer: ABD

• Question 70:

  A newly designed important query has less than desirable performance. Which of the following should you check? There are 3 correct answers.

  A. Too many key figures in the Columns area of the query default view.

  B. Too many characteristics in the Rows area of the query definition.

  C. Overlapping filters.

  D. Too many characteristics in the Free Characteristics of the query definition.

  E. Overuse of filter exclusions on the Filter tab of the query definition.

  Correct Answer: BCE