Halloween Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70percent

Certensure Logo
  1. Home
  2. SAP
  3. SAP Certified Application Associate
  4. C_DS_42 - SAP Certified Application Associate - Data Integration with SAP Data Services 4.2

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

Demo: 12 questions
Total 80 questions
Get C_DS_42 Full Access Download C_DS_42 PDF

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

Question 1

You want to set up a new SAP Data Services landscape. You must also create new repositories. Which repository types can you create?

Options:

A.

Central repository

B.

Standy repository

C.

Backup repository

D.

Local repository

E.

Profiler repository

Question 2

Where can you set up breakpoints for the SAP Data services interactive debugger?

Options:

A.

In a dataflow

B.

In a workflow

C.

In a script

D.

In a job

Question 3

You want to use on SAP data services transform to split your source vendor data into three branches, based on the country code.

Which transform do you use?

Options:

A.

Map_Operation transform

B.

Validation transform

C.

Case transform

D.

Country ID transform

Question 4

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

Options:

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.

Question 5

How do you desing a data load that has good performance and deals with interrupted loads in SAP Data services?

Options:

A.

by setting the target table loader with Bulk Load and Auto Correct Load enabled.

B.

by setting the target table loader with bulk load enabled

C.

By using the table comparison transform

D.

By creating two dataflows and executing the Auto Correct Load version when reired

Question 6

An SAP data services file format has a date column, but occasionally the file contains an invalid value in one row. This causes the dataflow to terminate with an error.

What can you do to completely load such erroneous files?

Note: There are 2 correct answer

Options:

A.

Place the dataflow between a Try/Catch block to catch all erroneous rows

B.

Use the error handling options for conversion error in the file format definition

C.

Specify a date format of'????-??-??' to indicate the value might NOT be a valid date in the file format editor

D.

Define the column as varchar and use functions in subsequent Query transform to perform the checks and conversion

Question 7

You import a table from a database into a datastore.

Which information is added into the SAP Data Services repository?

Options:

A.

The complete metadata information of the table

B.

Only the table name

C.

The whole table with all its source data

D.

The table name and all column names with their dataypes.

Question 8

In which situation is it appropriate to use a time - based CDC to capture changes in source data with SAP Data services

Options:

A.

When there are large tables with few changes

B.

when you need to capture physical deletes from source

C.

When almost all of the rows have changes

D.

When you need to capture intermediate changes

Question 9

You want to display the description of an object in the Designer workspace-Which task must you perform to accomplish this in SAP Data services?

3 correct answers

Options:

A.

Click the view enabled descriptions button on the toolbar.

B.

Enter a description in the properties of the object.

C.

right-click the object then choose enable description .

D.

Right - click on the job in the project hierarchy to enable all descriptions.

E.

disiable the hide non - executable elements setting in the difference viewer.

Question 10

What are standard component of SAP Dataservices? There are 3 correct answers

Options:

A.

Job server

B.

Design studio

C.

Secure local repository

D.

Access server

E.

Real time services

Question 11

What are advantages of using the validation transform in SAP Data services? There are 3 correct answers to this question

Options:

A.

You can see which rules were violated in one output

B.

You can set different failed paths for each rule

C.

You can have multiple rules on a single column.

D.

You can produce statistics

E.

You can call a recovery dataflow

Question 12

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

Load More C_DS_42 Questions
Demo: 12 questions
Total 80 questions
Get C_DS_42 Full Access Download C_DS_42 PDF