SAP Certified Application Associate - Data Integration with SAP Data Services

QUESTION NO: 1
You decide to distribute the execution of a job across multiple job servers within a server group. What distribution levels are available? 3 answers correct

A. workflow B. Dataflow C. subdataflow D. Embedded dataflow E. JOB

Correct Answer: B,C,E

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 2
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?

A. end date B. Julian format C. Increment D. Effective date column

Correct Answer: A

QUESTION NO: 3
What errors can you handle in SAP Services when you use a file format target?

A. File type error B. Row- format error C. Data type conversion error D. Semantic error

Correct Answer: B

QUESTION NO: 4
A new developer joined the project team. You already created a new SAP Data Services repository for this member.
Where do you manage the security setting for this new repository?

A. Central Management console B. Repository manager C. Repository database D. Data Services Designer

Correct Answer: A

QUESTION NO: 5
An SAP Data Services dataflow has validation error.
What is the cause?

A. The dataflow has a syntax error that has to be correct before executing it. B. The source data does NOT comply with the rules entered in the Validation transform C. The source data is incorrect and the dataflow therefore requires a validation transform. D. A conversion is missing

Correct Answer: A

QUESTION NO: 6
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?

A. Type: Fixed column length:4,2 and 6 skip row headen: yes B. Type: Delimited column delimiter:; skip row headen: yes C. Type: Delimited column delimiter:; skip row headen: no D. Type: Delimited column delimiter:<blank> skip row headen: yes

Correct Answer: B

QUESTION NO: 7
You define audit rules for critical data flow to confirm that you SAP Data Services batch job loaded only correct dat a. Which audit functions are available to define these rules for columns? Note: There are 3 correct answers

A. Average B. Min C. Checksum D. Count distinct E. sum

Correct Answer: A,C,E

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 8
Why would you use a memory datastore in your SAP Data Services dataflow design?

A. To enhance processing performance of datadlows used in real time jobs. B. To define a connection to SAP HANA C. To reduce the memory consumption in the target database. D. To reduce the memory consumption in the source database.

Correct Answer: D

QUESTION NO: 9
You have a workflow containing two dataflows. The second dataflow should only run if the first one finished successfully.
How would you achieve this in SAP Data Services.

A. Connect the two dataflows with line B. Use a conditional for the second dataflow C. Add a script between the dataflows using the error_number() function D. Embed the first dataflow in a try-catch

Correct Answer: A

SAP Certified Application Associate - Data Integration with SAP Data Services - C-DS-43 Exam Questions