Black Friday Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: best70

Note! SAP has retired the C_DS_42 Exam Contact us through Live Chat or email us for more information.

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

Questions 4

What application do you use to display the graphical representations of all Sap Data Services objects including their relationships and properties?

Options:

A.

Operational Dashborad

B.

Autodocumentation

C.

Impact and lineage Analysis

D.

Data quality reports

Buy Now
Questions 5

Which features are supported by the SAP Data Services interactive debugger?

3 correct answers

Options:

A.

Show sample rows of each step

B.

Set breakpoint

C.

Show the optimized execution plan

D.

Show performance-related statistics

E.

Define additional filters

Buy Now
Questions 6

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

Options:

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

Buy Now
Questions 7

You SAP Data Services job design includes an initialization script that truncates rows in the target prior to loading, the job uses automatic recovery

How would you expect the system to behave when you run the job in recovery mode?

Note: There are 2 correct answers to this question

Options:

A.

The job executes the scripts if it is part of a workflow marked as a recovery unit, but only if an error was raised

B.

The job executes the scripts if it is part of a workflow marked as a recovery unit irrespective of where the error ocurred in the job flow.

C.

the job starts with the flow that caused the error. If this flow is after the initialization script the initialization script is skipped.

D.

The job reruns all workflows and scripts. When using automatic recovery, only dataflows that ran successfully in the previous execution ^ are skipped.

Buy Now
Questions 8

You build a Data Warehouse with a date dimension in SAP Data Services. You decide to use the Date Generation transform to create this. What options are available to control the output form the transform?

Options:

A.

Julian format

B.

Increment

C.

Effective date column

D.

end date

Buy Now
Questions 9

You want to execute two dataflows in parallel in SAP Data Services. How can you achieve this?

Options:

A.

Create a workflow containing two dataflows and connect them with a line.

B.

Create a workflow containing two dataflows without connecting them with a line.

C.

Create a workflow containg two dataflows and deselect the execute Only once property of the workflow.

D.

Create a workflow containing two dataflows and set a degree of parallelism to 2.

Buy Now
Questions 10

You are instructed to calculate the maximum value in the SALARY column of an EMPLOYEE table.

How can you achieve this in SAP Data Services?

Options:

A.

Use max (SALARY) in a script.

B.

Use max(SALARY) in a conditional

C.

Call max(SALARY) from a Custom function

D.

Enter max (SALARY) in the query transform

Buy Now
Questions 11

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 12

Which feature in the SAP Data Services Management Console allows you to see the trend of the execution time for any given job?

Options:

A.

data quality reports

B.

monitor log

C.

Operational dashboard

D.

trace log

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