C_TBW60_74 by SAP Actual Free Exam Q&As

Question 1

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

A. Reverse Image B. After Image C. Before Image and After Image D. Additive Image E. Delete Image

Discussion 0

Correct Answer: A,C,D Vote an answer

Question 2

What can you do in the remodeling toolbox? (3)

A. Change the standard aggregation of the key figure B. Convert an InfoCube dimension to a line-item dimension C. Change the reference characteristic D. Delete a characteristic of an InfoCube E. Delete a characteristic

Discussion 0

Correct Answer: B,D,E Vote an answer

Question 3

Which of the following are true regarding BW Data Modeling? There are 3 correct answers.

A. Different types of reporting end-users can be ignored. B. Reporting requirements are the necessary starting point. C. BW objects are created with reference to administrative needs. D. Reference to BW Business Content should be conducted during the development of the data model. E. Business Content does not need to be activated. F. Reporting requirements are the necessary starting point.

Discussion 0

Correct Answer: D,E Vote an answer

Question 4

what does SAP recommend you do to improve the overall reporting performance of a standard InfoCube in SAP BW 7.4? (3)

A. Replace the InfoCube by a SPO B. Use navigation attributes instead of dimension characteristics C. Use the process type "Fill OLAP cache" in a process chain D. Create aggregates E. Use several InfoCubes as PartProviders of a MultiProvider instead of a single standard InfoCube

Discussion 0

Correct Answer: A,D,E Vote an answer

Question 5

Your customer wants to model their SAP BW system according to best practices. You propose using a layered scalable architecture (LSA). Which of the following steps must you perform? There are 2 correct answers.

A. Define specific scenarios for data logistics shaped by the customer environment. B. Implement the entire corporate information factory enterprise data warehouse architecture. C. Determine which LSA layers are relevant based on the customer's requirement and objectives. D. Model disjunct transaction and master data domains for application-specific reporting.

Discussion 0

Correct Answer: A,C Vote an answer

Question 6

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 DTP should be set to Full update. C. The InfoPackage should be assigned to a daemon. D. The after image needs to first be loaded in a DSO.

Discussion 0

Correct Answer: D Vote an answer

Question 7

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

A. When changes are made to texts from Characteristics used in an Aggregate. B. When changes are made to attributes or hierarchies from Characteristics used in an Aggregate. C. When changes are made to the structure of the InfoCube. D. When changes are made to attributes, hierarchies or texts from Characteristics used in an Aggregate.

Discussion 0

Correct Answer: B Vote an answer

Question 8

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

A. It is the same thing as an attribute change run B. It compresses data into the E Table of the aggregate C. It does not have any relationship to the availability of data for reporting in an aggregate D. It is needed every time new data is loaded into the InfoCube

Discussion 0

Correct Answer: D Vote an answer

Question 9

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

A. Repair uses the same step instance. B. Certain steps can use either option. C. Repair automatically fixes the error allowing the process chain to continue. D. Repeat begins a new step instance. E. Repeat schedules the process chain for a future date.

Discussion 0

Correct Answer: A,B,D Vote an answer

Question 10

What are the advantages of using a line-item dimension when modeling an InfoCube? (2)

A. The primary key of the InfoCube fact table is shorter B. The number of joins that must be executed during query runtime is reduced C. Data is loaded into the InfoCube without generating DIM Ids for this dimension D. The number of joins that must be executed during query runtime is reduced E. Aggregates on this InfoCube do NOT need to be built

Discussion 0

Correct Answer: C Vote an answer

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