C_TBW60_74 Online Practice Questions and Answers

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

A. A Generic Delta Service must be part of the definition.

B. The delta field must be a selection criteria.

C. The Delta Service must be marked for RDA.

D. The delta field must be a numeric pointer.

E. The DataSource must be based on a function module.

Which of the following initial tasks should you perform when designing an SAP BW data model? (2)

A. Analyze relationships between the characteristics and their attributes

B. Evaluate the volume of data to be loaded

C. Evaluation of the number and types of users

D. Evaluate the format of data to be loaded

Which of the following are true regarding an aggregate roll-up? (1)

A. It is needed every time new data is loaded into the InfoCube

B. It does not have any relationship to the availability of data for reporting in an aggregate

C. It compresses data into the E Table of the aggregate

D. It is the same thing as an attribute change run

Which of the following is a valid sequence for modeling objects in the BW data flow? (1)

A. From DataSource to InfoSource to InfoCube without a Transformation

B. From DataSource to Transformation to InfoSource to InfoCube

C. From DataSource to Transformation to InfoSource to Transformation to InfoCube

D. From DataSource to InfoSource then directly to another InfoSource to Transformation to InfoCube

E. From InfoSource to DataSource to InfoCube

Which of the following are true regarding ODP/ODQ data extraction into BW? There are 2 correct answers.

A. PSA tables continue to be mandatory.

B. DTPs continue to be mandatory.

C. DataSources continue to be mandatory.

D. Transformation are no longer necessary.

E. The Delta Queue in BW is necessary.

Configure a technical key for the destination table A Flat interface DataSource is used to extract file data into the PS

A. The DTP, however, is having trouble loading the data into an InfoCube. What could be the possible solution? Select the correct answer.

B. The BW DTP is set to Full extraction.

C. The Transformation does not have rules for all destination fields.

D. The DataSource has a delta process of FIL0.

E. The BW DTP is set to Full extraction.

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.

You have configured an extraction of master data from an SAP ERP source system. After the first extraction, all of the previously extracted data is being loaded. What could be the possible cause? There is one correct answer.

A. The DataSource extraction type has been set to "Full."

B. The InfoPackage has been set to "Full" update.

C. The subsequent Transformation has rules set to "Addition."

D. There is no delta data in the PSA table.

E. The DataSource has been configured with interim storage.

A MultiProvider has four InfoCubes as components. One InfoCube is a VirtualProvider and two of the others have aggregates. The total execution time of the MultiProvider query is 29 sec when you expect 10 sec. What can account for this scenario? There are 3 correct answers.

A. The shadow aggregates are being used because of the roll up job.

B. The query is running in a batch process.

C. There are non-cumulative key figures in the InfoCubes.

D. The query is configured for nonparallel processing.

E. There are insufficient background processes at execution time.

Which is the best way to model the object "Price?" There are 2 correct answers.

A. If the price of an object changes slowly, model it as a navigational attribute.

B. If the desired result is the price paid by a customer at the time of the Transaction, model price as a calculated Key Figure.

C. Leave it out of the data model.

D. If the price of an object changes slowly, model it as a display attribute.