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

Question 1

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 field must be a numeric pointer.

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 Service must be marked for RDA.

Correct Answer: D,E

Question 2

You have added the fields "ZCOUNTRY" and "ZLOCALITY" to the DataSource, 0CUSTOMER_ATTR .
Which of the following is necessary to ensure that the new fields can be extracted from the source system into PSA of the DataSource in SAP BW. Select the correct answer.

A. All target InfoProviders must be active and connected.

B. All fields of 0CUSTOMER_ATTR have been mapped.

C. All active customer ABAP enhancements of 0CUSTOMER_ATTR are active

D. All target InfoProviders must have their table space increased.

Correct Answer: C

Question 3

A Flat interface DataSource is used to extract file data into the PS

A. The BW DTP is set to Full extraction.

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

C. The InfoPackage is not active.

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

E. The DataSource has a delta process of FIL0.

F. The BW Delta Queue is empty.

Correct Answer: A

Question 4

Which of the following record modes delivered by a DataSource can you directly upload to an InfoCube?
There are 3 correct answers.

A. Before Image and After Image

B. After Image

C. Reverse Image

D. Additive Image

E. Delete Image

Correct Answer: A,C,D

Question 5

What does SAP recommend you do to improve the overall reporting performance of an InfoCube in SAP BW
7.4? There are 3 correct answers.

A. Create one or more line item dimensions.

B. Create aggregates.

C. Include the InfoCube into a semantically partitioned object (SPO).

D. Execute a pre-load OLAP cache process in a process chain.

Correct Answer: A,B,C

Question 6

Which of the following does the data propagation layers of your SAP BW system offer? There are 2 correct answers.

A. Ability to extract once and deploy many times

B. Fast load of mass data

C. A single version of the truth

D. Homogenized data

Correct Answer: A,C

Question 7

The Air Force orders 10 F-14's for deployment on Monday. This data is loaded to an InfoCube. Then the office requests 2 more fighters, for a total of 12. The new after image data is also to be loaded to the InfoCube.
However, you receive an error on the InfoCube update. What could be the issue? Select the correct answer.

A. The Transformation should be set to overwrite.

B. The after image needs to first be loaded in a DSO.

C. The DTP should be set to Full update.

D. The InfoPackage should be assigned to a daemon.

Correct Answer: B

Question 8

Which of the following are true in designing aggregates?
There are 3 correct answers.

A. Aggregates can share dimension tables with the InfoCube.

B. Multiple aggregates should be designed to fit into a rollup hierarchy.

C. Aggregates containing navigational attributes can be larger than aggregates based on dimensional characteristics.

D. Aggregates are evaluated by the BW system based on usage and number of records.

E. Time-dependent aggregates can be adjusted upon changes of the key date only through process chains.

Correct Answer: A,C,D

Question 9

Your business is using a variety of queries. You plan on upgrading your SAP BW 7.4 system to the latest support package. You want to ensure that the query results are correct with various navigation steps. What tool would you use to accomplish this? Select the correct answer.

A. The BW Administration Cockpit.

B. The BW Trace Tool.

C. The BW Metadata Repository.

D. The BEx Analyzer.

E. The BEx Web Analyzer.

Correct Answer: B

Question 10

When should you use the Generic Data Extractor tools to create a data source? There are 3 correct answers.

A. When the data to be extracted is highly granular.

B. When you use customer written programs in R/3 to populate your tables.

C. If you want to extract data without delta extractions.

D. When Business Content does not contain a data source for your application.

E. When the application does not feature its own data extraction method.

Correct Answer: B,D,E

Welcome to TestSimulate

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