SAP C_TBW60_74 Exam Practice Test Instant Access

Question 1

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

AUnion

BUnbalanced

CTemporal

DInner

ELeft Outer

FTemporal

Answer : D, E

Question 2

You need to transport your BW objects and your ECC DataSources. Which is the right order to do so? Select the correct answer.

ATransport your DataSources, Transport your BW objects, Replicate your DataSources

BTransport your BW Objects, Replicate your DataSources, Transport your DataSources

CTransport your DataSources, Replicate your DataSources, Transport your BW Objects.

Answer : C

Question 3

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

Question 4

What can you use to accelerate an SAP BW implementation project? (1)

ASAP BW Data Warehousing Workbench

BSAP BI Content

CSAP BW Accelerator (BWA)

DSAP BW Statistics

Answer : C

Question 5

What are the differences between the Reporting and Operational Data Store (ODS) layers in LSA if both are reportable? (2)

AThey can use different InfoProvider types

BThe ODS layer is typically used for archiving

CThey differ in data refresh requirements

DThey differ in the granularity of data

EThey can use different InfoProvider types

Answer : D

Question 6

What can you do to have two or more hierarchies with the same technical name? (2)

AConfigure the hierarch as version-dependent

BConfigure the hierarchy to have a time-dependent structure

CConfigure the hierarchy with link nodes

DConfigure the hierarchy as time-dependent

EConfigure the hierarch as version-dependent

Answer : D

Question 7

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

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