Summer Sale 60% Special Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: best60

Examstrust Logo
examstrust mcafee
  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

Page: 1 / 8
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

PDF + Testing Engine

  • Product Type: PDF + Testing Engine
$68  $169.99
Add to Cart

Testing Engine

  • Product Type: Testing Engine
$48  $119.99
Add to Cart

PDF Study Guide

  • Product Type: PDF Study Guide
$42  $104.99
Add to Cart
Question 1

In SAP data services what does the date generation transform allow you to generate?

Options:

A.

The rows for a given date range

B.

The current date for a column to see when each row was loaded.

C.

the valid from date based on a dataset the contains valid to information only

D.

the valid to date based on a dataset the contains valid to information only

Question 2

You execute an SAP data services job with enable recovery activated. One of the dataflows in the jobs raises an exception that interrupts the execution. You run the job again with Recover from last failed execution enabled. What happens to the data flow that raised the exception during the first execution?

Options:

A.

Is is rerun with the first failed row.

B.

It is rerun from the beginning and the partially loaded data is always handled automanticaly.

C.

It is rerun only if the dataflow is part of a recovery unit.

D.

It is rerun from the beginning and the desing of the data flow must deal with partially loaded data.

Question 3

In SAP Data Services what do you use implement a target-based delta that deals with inserts, update and deletes in the source.

Options:

A.

Table comparison transform

B.

A Map_CDC_Operation transform

C.

The auto correct load

D.

A Map_Operation transform

Question 4

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 5

A Map operation transform in SAP Data Services was used to modify the operation code of data is being processed. Why do you perform this action?

Options:

A.

To ensure compatibility with subsequent transforms

B.

To push the data down for better performance

C.

To increase the speed that the database loads

D.

To control how the data is loaded.

Question 6

You have a map operation transform immediately before the target in a data flow in Sap Data Services. What happens if all operation codes are mapped to Discard in the transform?

Options:

A.

They are flagged for later deletion

B.

They are deleted from the target

C.

They are added to the overflow file

D.

They are filtered by the transform

Question 7

You created and saved a database datastore in SAP Data Services. Which properties can you change in the Edit Datastore dialog box?

Options:

A.

database name

B.

database server name

C.

Datastore name

D.

user name and password

E.

database version

Question 8

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 9

You want to back up an SAP Data Services repository. How does the system store repositories?

Options:

A.

As tables in a relational database management system

B.

As an XML file on the Data services Access Server

C.

As an XML file on the data services job server

D.

As an binary file on the Data servives job server

Question 10

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 ||’-‘|| EXTENSION

Question 11

What does the expression SUBSTR(FIRST NAME, 1,3) return?

Options:

A.

U

B.

M

C.

FIR

D.

IRS

Question 12

Which of the following administrative tasks can you perform using the SAP Data Services Management Console?

Options:

A.

Schedule a batch job

B.

Edit the initialization script of a job

C.

edit the system configuration

D.

Configure an adapter

Load More C_DS_42 Questions
Page: 1 / 8
Total 80 questions
Get C_DS_42 Full Access Download C_DS_42 PDF