New Year Special Sale - 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: spcl70

Note! C_DS_42 has been withdrawn.

Practice Free C_DS_42 SAP Certified Application Associate - Data Integration with SAP Data Services 4.2 Exam Questions Answers With Explanation

We at Crack4sure are committed to giving students who are preparing for the SAP C_DS_42 Exam the most current and reliable questions . To help people study, we've made some of our SAP Certified Application Associate - Data Integration with SAP Data Services 4.2 exam materials available for free to everyone. You can take the Free C_DS_42 Practice Test as many times as you want. The answers to the practice questions are given, and each answer is explained.

Get Full 80 Questions Search Other SAP Exam
Question # 6

An SAP Data Services Validation transform outputs all invalid rows. If more than ten rows are invalid, the data is considered to be failed. How do you implement this?

A.

Create an auditing rule that raises an exception

B.

Raise an exception in a Conditional connected to the target table.

C.

Set a breakpoint on the line connected to the target table.

D.

Use the raise_exception function in the validation transform.

Question # 7

You developed a batch job using SAP Data Services and want yo start an execution. How can you execute the job?

2 correct answers

A.

"Execute the job manually in the Data Services Designer."

B.

Use the scheduler in the Data Services Designer

C.

Use the debug option in the Data Services Management console

D.

Use the scheduler in the Data Services Management Console

Question # 8

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

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 # 9

You are reading a Sales Order table from the source and need to add the customer region information a from a customer table. The primary key of the customer table consists of the columns CUST_ID and VALID_FROM

How would you desing the dataflow to get the region information that was valid at the ORDER_CREARTE_DATE?

A.

Perform an outer join between both tables

B.

Use a regular lookup function

C.

Join the two tables

D.

Use a lookup_ext function

Question # 10

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

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 # 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

Question # 12

Why would you use a memory datastore in your SAP Data Services dataflow design?

A.

To define a connection to SAP HANA

B.

To reduce the memory consumption in the target database.

C.

To reduce the memory consumption in the source database.

D.

To enhance processing performance of datadlows used in real time jobs.