SAP Certified Application Associate - Modeling and Data Management with SAP BW 7.4 (C_TBW60_74) Free Practice Test

Question 1

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 generic DataSource with a numeric pointer for the delta service.

B. Use a DSO for Real Time Data Acquisition.

C. Use a DB Connect based DataSource.

D. Use a DataSource based on SAP Data Services to restore the detail.

Correct Answer: C

Question 2

Which of the following are true about generic DataSources? There are 3 correct answers.

A. They can be defined with filter criteria.

B. They are replicated by process chain.

C. They can NOT be enhanced with additional fields after creation.

D. They are can be used with real-time data extraction.

E. They are can be defined with delta capability.

Correct Answer: A,D,E

Question 3

You want to increase the overall performance of a designed standard DSO. The DSO has contains 100 InfoObjects in its definition, 5 of which are in the Key Part. Which of the following possible actions should you take? There are 3 correct answers.

A. Set up the automatic movement of Active Table records to a subsequent InfoProvider.

B. Decrease the size of the Key Part.

C. Create secondary indexes.

D. Set the Settings option for Unique records.

E. Set up automatic deletion of Change Log data.

Correct Answer: C,D,E

Question 4

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 three InfoCubes; one each for Planned, Budgeted and Forecasted key figure values.

B. Create a new Dimension table containing a Characteristic to distinguish the key figure types.

C. Create Key Figures Amount and Quantity as non-cumulatives with virtual key figures to calculate the different types.

D. Use the Select option "Unique for Every Cell" in the distinguishing Characteristic.

Correct Answer: B,D

Question 5

Which setting increases the performance of the Activation job for a Standard DSO? Select the correct answer.

A. Unique Data Records.

B. Automatically Repeat Red Requests in Process Chain.

C. SID Generation During Activation

D. Parallel Activation of Requests in Activation Queue.

Correct Answer: A

Question 6

Which of the following are true regarding navigational attributes? There are 3 correct answers.

A. They are directly linked to the InfoCube Dimension tables.

B. Behave like Characteristics in a Dimension table.

C. They must be switched on for specific InfoProviders.

D. They do not generate additional tables outside the InfoProvider.

E. Must be part of the definition of the Characteristic InfoObject definition.

Correct Answer: B,C,E

Question 7

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. DB Connect with a Microsoft Access database.

B. Flat files.

C. UD Connect with JDBC connectors to SQL Server.

D. SAP Data Services with the Service API.

E. BI Content with the Service API.

Correct Answer: D,E

Question 8

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

A. Aggregates reduce the number of key figures

B. Aggregates can be created on dimension characteristics and navigational attributes

C. Several dimension characteristics used in an aggregate always have the same aggregation level

D. Aggregates can only be created for Basic Cubes

E. Aggregates are stored as a single transparent table, which houses the aggregated data

Correct Answer: B,D

Question 9

You want postable nodes in a hierarchy to appear in multiple hierarchy branches.
What action could you take to accomplish this? (2)

A. Configure the hierarchy as time-dependent

B. Enter the postable nodes as Link Nodes

C. Create multiple similar hierarchies

D. Configure the hierarchy with a time-dependent structure

Correct Answer: D

Question 10

You have created a new Data Flow object in the graphical sAP BW data Flow tool by copying a Data Flow template. What must you do to use the new Data Flow? (1)

A. Copy non-persistent SAP BW Objects

B. Validate non-persistent SAP BW Objects

C. Activate non-persistent SAP BW Objects

D. Replace non-persistent SAP BW objects with active SAP BW objects

Correct Answer: D

Welcome to TestSimulate

SAP Certified Application Associate - Modeling and Data Management with SAP BW 7.4 (C_TBW60_74) Free Practice Test