C-TBW60-74 by SAP Valid Free Exam Practice Test

Question 1

You have been asked to delete a request from an InfoCube. What best describes the situation? Select the correct answer.

A. You must change the request status to green before you can delete. B. You have to create Aggregates before you delete the request. C. You cannot delete the request since it is compressed. D. You cannot delete the request if it has a red status.

Correct Answer: C

Question 2

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 users' roles have to be updated in production. B. The users' roles have to be re-transported. C. The BEx workbooks are not active in production. D. The BEx workbooks have not been authorized.

Correct Answer: B

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 a new Dimension table containing a Characteristic to distinguish the key figure types. B. Create Key Figures Amount and Quantity as non-cumulatives with virtual key figures to calculate the different types. C. Use the Select option "Unique for Every Cell" in the distinguishing Characteristic. D. Create three InfoCubes; one each for Planned, Budgeted and Forecasted key figure values.

Correct Answer: A,C

Question 4

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

A. To provide a layer where data can be overwritten to reflect the current status of business transactions B. To provide an enterprise wide repository of business data at a summary level C. To ensure vertical consistency of the data flow D. To ensure that data is only extracted once from source systems

Correct Answer: C,D

Question 5

Your customer wants to migrate SAP BW 3.x Data Flows to SAP BW 7.x data flows. What can they do to mitigate the risks of the migration? Please choose the correct answer.

A. Create the Data Flow manually to create transformations and a data transfer process. B. Use emulation first to model the Data Flow with update rules and a data transfer process. C. Create the Data Flow manually to create update rules and a data transfer process. D. Use emulation first to model the Data Flow with transformations and a data transfer process.

Correct Answer: D

Question 6

You design a Standard DSO with a semantic key consisting of controlling area and cost center number in the Key Part. What should you do to prevent valid records from being written to the Error Stack during load?
Select the correct answer.

A. Put all key figures in the Key Part of the Error Stack.. B. Create secondary indexes on the Error Stack. C. Create a wider semantic group for the Error Stack. D. Use a technical key for the Error Stack.

Correct Answer: C

Question 7

Which of the following initial tasks should you perform when designing an SAP BW data model? There are 2 correct answers.

A. Evaluate the volume of data to be loaded. B. Evaluate the format of data to be loaded. C. Derive the customer specific LSA. D. Evaluate the volume of data to be loaded. E. Analyze relationships between the characteristics and their attributes.

Correct Answer: C

Question 8

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. Replace non-persistent SAP BW objects with active SAP BW objects D. Activate non-persistent SAP BW Objects

Correct Answer: C

Question 9

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

A. Behave like Characteristics in a Dimension table. B. They do not generate additional tables outside the InfoProvider. C. They must be switched on for specific InfoProviders. D. Must be part of the definition of the Characteristic InfoObject definition. E. They are directly linked to the InfoCube Dimension tables.

Correct Answer: A,C,D

Question 10

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

SAP Certified Application Associate - Modeling and Data Management with SAP BW 7.4 - C-TBW60-74 Exam Practice Test