SAP C_TBW60_74 Exam Practice Test Instant Access

Question 1

Many of the records you have loaded into a Basic InfoCube consist of Reverse and Additive images. What could you do to reduce the size of the Fact Table? There are 2 correct answers.

ADivide those records into appropriate Aggregates.

BCompress the Fact Table.

CMove these records into a Standard DSO.

DRollup the InfoCube.

ECompress the Fact Table with zero elimination.

FCompress the Fact Table.

Answer : E

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.

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

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

CRemodel 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.

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

Answer : A, B

Question 3

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.

AUse a technical key for the Error Stack.

BPut all key figures in the Key Part of the Error Stack..

CCreate secondary indexes on the Error Stack.

DCreate a wider semantic group for the Error Stack.

Answer : D

Question 4

What is necessary for a VirtualProvider to display data? There are 3 correct answers.

AA DTP for Direct Access

BA DataSource for Direct Access

CHybridProvider

DMultiProvider

EDTP that loads data

FTransformation

Answer : A, B, F

Question 5

The Marines order 8 service members for deployment on Monday. This data is loaded to a Standard DSO. Then the office requests 2 less service members, for a total of 6. This new after image data is also loaded to the DSO. What records will be in the Change Log? Select the correct answer.

A8, -8, 6

B8, -8, 2

C8, 6

D8, 2

E8, 6, 2

Answer : A

Question 6

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

ARepeat schedules the process chain for a future date.

BRepair automatically fixes the error allowing the process chain to continue.

CRepair uses the same step instance.

DCertain steps can use either option.

ERepeat begins a new step instance.

Answer : C, D, E

Question 7

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

AConvert an InfoCube dimension to a line-item dimension

BChange the standard aggregation of the key figure

CDelete a characteristic

DChange the reference characteristic

EDelete a characteristic of an InfoCube

Answer : A, C, E

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