SAP Certified Application Associate - Modeling and Data Management with SAP BW 7.4 - C_TBW60

Question 1

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

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

Discussion 0

Correct Answer: C Vote an answer

Question 2

What are performance advantages when using an InfoCube instead of a DataStore Object? There are 2 correct answers.

A. Navigational attributes can be used. B. Surrogate IDs (SIDs) replace master data values in dimension tables. C. Reporting access to granular data using standard dimensions is faster. D. Surrogate ID (SID) keys and DIM_ID keys are generated automatically.

Discussion 0

Correct Answer: B,D Vote an answer

Question 3

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

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

Discussion 0

Correct Answer: A,D Vote an answer

Question 4

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 Repartitioning toolbox can be used with logical partitioning. C. The Analytic Engine can do partition pruning. D. Table partitions are based either on 0CALMONTH or 0FISCPER.

Discussion 0

Correct Answer: B,C,D Vote an answer

Question 5

The Materials department has created several new products (0PRODUCT) and transactional data for them in the source system. Neither the new products nor the transactional data are visible in SAP BW reporting. Which of the following helps you analyze the issue? There are 3 correct answers.

A. Check that the InfoCube contains the new transaction data. B. Check that the InfoCube compression is up to date. C. Check the Attribute Change Run. D. Check that the InfoCube contains the new master data. E. Check for the new data in the DataSource PSA.

Discussion 0

Correct Answer: C,D,E Vote an answer

Question 6

You want to load data from an SAP ERP source system in SAP BW. Which of the following ETL technologies could you use? There are 2 correct answers.

A. BI Content with the Service API. B. Flat files. C. SAP Data Services with the Service API. D. DB Connect with a Microsoft Access database. E. UD Connect with JDBC connectors to SQL Server.

Discussion 0

Correct Answer: A,C Vote an answer

Question 7

Your customer wants to model their SAP BW system according to the best practices. You propose using a layered scalable architecture (LSA). Which of the following steps must you perform? (2)

A. Define specific scenarios for data logistics shaped by the customer environment B. Model disjoint transaction and master data domains for application-specific reporting C. Determine which LSA layers are relevant based on the customer's requirements and objectives D. Implement the entire corporate information factory enterprise data warehouse architecture

Discussion 0

Correct Answer: A,C Vote an answer

Question 8

The UD Connect extraction of document level data from a SQL Server database results in a loss of document detail in BW. What possible action could you take to resolve this? Select the correct answer.

A. Use a DSO for Real Time Data Acquisition. B. Use a DataSource based on SAP Data Services to restore the detail. C. Use a generic DataSource with a numeric pointer for the delta service. D. Use a DB Connect based DataSource.

Discussion 0

Correct Answer: D Vote an answer

Question 9

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

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

Discussion 0

Correct Answer: D Vote an answer

Question 10

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

Discussion 0

Correct Answer: A Vote an answer

SAP Certified Application Associate - Modeling and Data Management with SAP BW 7.4 - C_TBW60_74 FREE EXAM DUMPS QUESTIONS & ANSWERS