Black Friday Special Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: scxmas70

Note! Following C_DS_42 Exam is Retired now. Please select the alternative replacement for your Exam Certification.

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

Question # 4

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

A.

POSTCODE AND '-' AND EXTENSION

B.

rpad_ext(POSTCPDE,EXTENSION)

C.

POSTCODE +'-*+ EXTENSION

D.

POSTCODE ||’-‘|| EXTENSION

Full Access
Question # 5

What task can you perform in the SAP Data Services Management Console? Note: There are 3 correct answers to this question

A.

Debug a dataflow to find data issues

B.

Display the optional Validation Transform statistics

C.

View the rows and the values being loaded

D.

Schedule a job for daily execution

E.

Display trace and monitor and error logs.

Full Access
Question # 6

You decide to distribute the execution of a job across multiple job servers within a server group. What distribution levels are available? 3 answers correct

A.

workflow

B.

subdataflow

C.

JOB

D.

Dataflow

E.

Embedded dataflow

Full Access
Question # 7

In SAP Data Services which basic operations can you perform with a Query transform?

A.

"Join data from several sources"

B.

"Apply functions to columns"

C.

Map Columns from an input schema to an output schema"

D.

Flag rows for update

E.

Set a global variable to a value

Full Access
Question # 8

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.

A.

default value

B.

Format information

C.

field size

D.

data type

E.

comment

Full Access
Question # 9

How do you allow a new team member to view the SAP Data Services repository in read only mode?

A.

Use the central repository in the Desinger

B.

Export the repository's metadata to an XML file and open it in a browser.

C.

Copy the repository and view the copy in the repository manager.

D.

Use the Auto Documentation feature in the Management Console

Full Access
Question # 10

In SAP Data Services why would you select the produce default output checkbox in the Case transform?

A.

To output all rows that match the case statement

B.

to output all rows that do match exactly one case expression

C.

To output all rows to the default path regardless if the they match the case expressions.

D.

To output all rows that do not match any case expression to the default path

Full Access
Question # 11

which transform are typically used to implement a slowly changing dimension of type 2 in SAP Data services?

3 correct answers

A.

Data_Transfer

B.

History_Preserving

C.

Map_CDC_Operation

D.

Key_Generation

E.

Table_comparison

Full Access
Question # 12

A new developer joined the project team. You already created a new SAP Data Services repository for this member.

Where do you manage the security setting for this new repository?

A.

Data Services Designer

B.

Central Management console

C.

Repository manager

D.

Repository database

Full Access