SAP C_TBW60_74 Exam Questions Instant Access

Question 1

You want to load data from an SAP ERP source system in SAP BW. Which of the following ETL technologies could you use? There are 2 correct answers.

AFlat files.

BSAP Data Services with the Service API.

CUD Connect with JDBC connectors to SQL Server.

DDB Connect with a Microsoft Access database.

EBI Content with the Service API.

Answer : B, E

Question 2

Which of the following types of join are possible with an InfoSet? (3)

AUnion

BUnbalanced

CTemporal

DInner

ELeft Outer

FTemporal

Answer : D, E

Question 3

You want postable nodes in a hierarchy to appear in multiple hierarchy branches.

What action could you take to accomplish this? (2)

AEnter the postable nodes as Link Nodes

BConfigure the hierarchy as time-dependent

CCreate multiple similar hierarchies

DConfigure the hierarchy with a time-dependent structure

Answer : D

Question 4

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 5

Which of the following are features of the Write-Optimized DSO? (2)

AThey utilize the single Active Data Table

BThey are intended to contain aggregated data

CThey enable mass data loads

DThey utilize a semantic (business) key for record uniqueness

Answer : A, C

Question 6

You want to increase the overall performance of a designed standard DSO. The DSO has contains 100 InfoObjects in its definition, 5 of which are in the Key Part. Which of the following possible actions should you take? There are 3 correct answers.

ACreate secondary indexes.

BDecrease the size of the Key Part.

CSet up automatic deletion of Change Log data.

DSet the Settings option for Unique records.

ESet up the automatic movement of Active Table records to a subsequent InfoProvider.

Answer : A, C, D

Question 7

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

ATo ensure vertical consistency of the data flow

BTo provide a layer where data can be overwritten to reflect the current status of business transactions

CTo provide an enterprise wide repository of business data at a summary level

DTo ensure that data is only extracted once from source systems

Answer : A, D

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