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

Question 1

What is the purpose of the Enterprise Data Warehouse (EDW) Layer? (2)

A. To ensure that data is only extracted once from source systems

B. To ensure vertical consistency of the data flow

C. To provide a layer where data can be overwritten to reflect the current status of business transactions

D. To provide an enterprise wide repository of business data at a summary level

Correct Answer: A,B

Question 2

Your reporting end-users have noticed that several Basic InfoCube queries are staring to run more slowly.
After examination of the InfoCube, you notice that 2 out of 7 user-defined Dimensions are approaching 50% the size of the Fact Table. What action should you take to resolve this? There are 2 correct answers.

A. Remodel the Cube by moving the high-cardinality Characteristics from these Dimensions into one of these 2 Dimensions and the other Characteristics in the other Dimension.

B. Remodel the Cube by restructuring these 2 Dimensions as Line-Item Dimensions and rearrange their remaining Characteristics in additional new Dimensions.

C. Remodel the Cube by creating more Dimensions making as many of them as possible into Line-Item Dimensions and eliminate the remaining Characteristics.

D. Remodel the Cube by restructuring these 2 Dimensions as Line-Item Dimensions and rearrange their remaining Characteristics among the other Dimensions.

Correct Answer: B,D

Question 3

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 Key Figures Amount and Quantity as non-cumulatives with virtual key figures to calculate the different types.

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

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

Correct Answer: C,D

Question 4

Which of the following types of join are possible with an InfoSet? (3)

A. Unbalanced

B. Left Outer

C. Temporal

D. Temporal

E. Union

F. Inner

Correct Answer: B,F

Question 5

When is the Change Run required after successful completion of a master data load? Select the best answer.

A. When changes are made to attributes, hierarchies or texts from Characteristics used in an Aggregate.

B. When changes are made to texts from Characteristics used in an Aggregate.

C. When changes are made to the structure of the InfoCube.

D. When changes are made to attributes or hierarchies from Characteristics used in an Aggregate.

Correct Answer: D

Question 6

Which of the following are true about the process step options Repair and Repeat? There are 3 correct answers.

A. Repeat schedules the process chain for a future date.

B. Repair automatically fixes the error allowing the process chain to continue.

C. Repair uses the same step instance.

D. Certain steps can use either option.

E. Repeat begins a new step instance.

Correct Answer: C,D,E

Question 7

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

A. Surrogate IDs (SIDs) replace master data values in dimension tables.

B. Navigational attributes can be used.

C. Surrogate ID (SID) keys and DIM_ID keys are generated automatically.

D. Reporting access to granular data using standard dimensions is faster.

Correct Answer: A,C

Question 8

You want to update the 3.x version of an SAP BW DataSource to a 7.x version with the capability to restore the original version. What should you do during the migration to achieve this? Please choose the correct answer.

A. Migrate the 3.x DataSource version with export.

B. Create a transformation to replace the transfer rules.

C. Delete all entries from the Persistent Staging Area (PSA)

D. Replace the 3.x SAP BW InfoSource with a 7.x version SAP BW InfoSource. -

Correct Answer: A

Question 9

After transporting BEx workbooks to production from development, users state that they cannot find the workbooks. What would be the most logical reason? Select the correct answer.

A. The BEx workbooks are not active in production.

B. The users' roles have to be updated in production.

C. The BEx workbooks have not been authorized.

D. The users' roles have to be re-transported.

Correct Answer: D

Question 10

Which of the following is a viable alternative to having more than 13 unrelated Characteristics in an InfoCube? Select the correct answer.

A. Create more than 13 custom-defined Dimensions.

B. Associate unrelated Characteristics in a single dimension.

C. Reduce the number of Characteristics down to 13.

D. Use more than one InfoCube in the design.

E. Add the extra ones as Key Figures.

Correct Answer: D

SAP Certified Application Associate - Modeling and Data Management with SAP BW 7.4 - C_TBW60_74 Exam Practice Test

Latest Update

Useful Links

Contact Us