Month End Sale Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70special

SAP C_DS_42 SAP Certified Application Associate - Data Integration with SAP Data Services 4.2 Exam Practice Test

Page: 1 / 8
Total 80 questions

SAP Certified Application Associate - Data Integration with SAP Data Services 4.2 Questions and Answers

Testing Engine

  • Product Type: Testing Engine
$36  $119.99

PDF Study Guide

  • Product Type: PDF Study Guide
$31.5  $104.99
Question 1

You create a file format in SAP Data Services

What properties can you set for a column?

Note: There are 3 correct answers to this question.

Options:

A.

default value

B.

Format information

C.

field size

D.

data type

E.

comment

Question 2

What is the SAP Data services Dataflow auditing feature used for? Note: There are 2 correct answers to this question.

Options:

A.

To count the number of rows processed at user defined points to collect runtime statistics

B.

To define rules based on the number of records processed overall once the dataflow is finished

C.

to define rules that each record processed by the dataflow has to comply with

D.

To view the data as it is processed by the dataflow in order to ensure its correctness

Question 3

You modified an existing SAP data Services job. You notice that the run time is now longer then expected. Where in SAP Data Services can you observe the progress of row counts to determine the location of a bottleneck

Options:

A.

On the view data tab

B.

In the impact and lineage analysis

C.

In the monitor log

D.

In the trace log

Question 4

The SAP Data services merge transform is used to combine two datasets; the first has 3000 rows and the second has 2000 rows. What are characteristics of the Merge transform? Note: there are 2 correct answers to this question

Options:

A.

The merge transform combines the dataset into 5000 or less output rows.

B.

The merge transform combines the dataset into 5000 output rows

C.

The merge transform joins the datasets using a full outer join

D.

The merge transform require both dataset to have the same structure.

Question 5

Which type of SAP Data Services object can a project, job, dataflow or workflow contain? 3 correct answers

Options:

A.

A Project can contain a job

B.

A job can contain a job

C.

A dataflow can contain a workflow

D.

A job can contain a workflow

E.

A workflow can contain a workflow

Question 6

You built a delta load dataflow in SAP Data Services. This Dataflow is executed every night. The source table contains a CHANGE_DATE column

which is populated by the database when the row is saved.

What can a timestamp based CDC aproach identify in the source based on this CHANGE_DATE column

Options:

A.

Inserted and updated rows but not delete rows

B.

Insert, updates and deletes for a specified time range.

C.

Update rows but NOT insert or deleted records.

D.

Every single change made to a row

Question 7

Which features are supported by the SAP Data Services interactive debugger?

3 correct answers

Options:

A.

Show sample rows of each step

B.

Set breakpoint

C.

Show the optimized execution plan

D.

Show performance-related statistics

E.

Define additional filters

Question 8

A target column named ZIP4 requires the input of the source columns: POSTCODE and EXTENSION. For example:

POSTECODE:99999

EXTENSION: 9999

Desired result is ZIP4:99999-9999

Options:

A.

POSTCODE AND '-' AND EXTENSION

B.

rpad_ext(POSTCPDE,EXTENSION)

C.

POSTCODE +'-*+ EXTENSION

D.

POSTCODE ir-'ll EXTENSION

Question 9

From the account table you want to know how many accounts you have per account type. The ACCOUNT_TYPE is output along with an additional column COUNTER. The group by tab of the query transform is used with ACCOUNT_TYPE. Which mapping would you use for the COUNTER column in SAP Data Services?

Options:

A.

count_distinct(Account_TYPE)

B.

Count(*)

C.

Sum(Account_type)

D.

Gen_Row_Num()

Question 10

You are joining tables using the query transform of SAP Data Services.

Options:

A.

Maximum of two tables

B.

Left outer joins and inner joins

C.

Only equal conditions

D.

Only inner joins

Question 11

An SAP Data Services dataflow adds the changed data (insert and update) into a target table every day.

How do you design the dataflow to ensure that a partially executed dataflow recovers automatically the next time it is executed?

2 correct answers

Options:

A.

Enable the Delete data before load target table loader option

B.

Add lookup function in the where clause to filter out existing rows.

C.

Set the autocorrect load option in the target table loader option

D.

Use the table comparison transform before the table loader

Question 12

What is the relationship between local variables and parameters in SAP Data Services? 2 correct answers

Options:

A.

a local variable in a workflow sets the value of an a parameter in a dataflow.

B.

3 local variable in a job sets the value of an a parameter in a workflow

C.

a parameter in a workflow sets the value of a local variable in a dataflow

D.

a parameter in a job set the value of a local variable in a dataflow

Page: 1 / 8
Total 80 questions