Summer Limited Time 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: takeit60

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

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

Questions 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.

Buy Now
Questions 5

You have to load a file that contains the following first three lines:

YEAR; MONTH; PLAN_AMOUNT

2014;01;100.00

2014;02;110.00

What setting do you use when you created a file format for this?

Options:

A.

Type: Delimited column delimiter:; skip row headen: no

B.

Type: Fixed column length:4,2 and 6 skip row headen: yes

C.

Type: Delimited column delimiter:; skip row headen: yes

D.

Type: Delimited column delimiter: skip row headen: yes

Buy Now
Questions 6

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.

Buy Now
Questions 7

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

Buy Now
Questions 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.

Options:

A.

default value

B.

Format information

C.

field size

D.

data type

E.

comment

Buy Now
Questions 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.

Buy Now
Questions 10

A SAP Data Services job contain logic to execute different dataflows depending on whether the job was successful or failed. Therefore the $NEEDS_RECOVERY variable should be set to either 'Yes' or 'No'. How do you assign the value to the $NEEDS_RECOVERY variable?

Options:

A.

Use a script with an SQL function to read from status table

B.

Use a catch block and set the variable to 'yes1

C.

Use a dataflow to set the value via a template table

D.

Use a global variable to persist the value across job executions

Buy Now
Questions 11

A dataflow contain a pivot transform followed by a query transform that performs an aggregation. The Aggregation query should by pushed down to the database in SAP Data services.

Where would you place the Data_Transfer transform to do this?

Options:

A.

Before the pivot transform

B.

Between the pivot transform and the query transform

C.

After the query transform

D.

Before the pivot transform and after the query transform.

Buy Now
Questions 12

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

Options:

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.

Buy Now
Exam Code: C_DS_42
Exam Name: SAP Certified Application Associate - Data Integration with SAP Data Services 4.2
Last Update: Mar 29, 2024
Questions: 80