SAP Certified Application Associate - Data Integration with SAP Data Services 4.2

QUESTION NO: 1
What operation can you push down to the database using a data transfer transform in SAP Data Services? 3 answers correct

A. Distinct B. Custom function C. Ordering D. XML function E. Join

Correct Answer: A,C,E

QUESTION NO: 2
What is the relationship between local variables and parameters in SAP Data Services? 2 correct answers

A. a local variable in a workflow sets the value of an a parameter in a dataflow. B. 3 local variable in a job sets the value of an a parameter in a workflow C. a parameter in a workflow sets the value of a local variable in a dataflow D. a parameter in a job set the value of a local variable in a dataflow

Correct Answer: A,B

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

A. When there are large tables with few changes B. When you need to capture intermediate changes C. when you need to capture physical deletes from source D. When almost all of the rows have changes

Correct Answer: A

QUESTION NO: 4
Which type of SAP Data Services object can a project, job, dataflow or workflow contain? 3 correct answers

A. A Project can contain a job B. A dataflow can contain a workflow C. A job can contain a workflow D. A job can contain a job E. A workflow can contain a workflow

Correct Answer: A,B,D

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

A. Map_Operation transform B. Validation transform C. Country ID transform D. Case transform

Correct Answer: D

QUESTION NO: 7
You are asked to perform either the initial load or delta load based on the value of a variable that is set at job execution How do you design this requirement in SAP Data services.

A. Use a job containing a Conditional objet that test the value of the variable. In the IF part, call the initial dataflow in the ELSE part call B. Use a job containing a Case transform testing for the two possible conditions. Connect one case output to the initial dataflow and the other to the delta dataflow Use a job container the delta dataflow C. Use a job containing a script with the if then else () function to test the variable value. Connect this script to the initial and delta u dataflow. D. Set the job to call the initial and delta dataflow in parallel. Each dataflow should have a filter testing for the variable value.

Correct Answer: A

QUESTION NO: 8
You are joining tables using the query transform of SAP Data Services.

A. Maximum of two tables B. Left outer joins and inner joins C. Only inner joins D. Only equal conditions

Correct Answer: B

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