C_DS_42 by SAP Actual Free Exam Questions And Answers

Question 1

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 script with the if then else () function to test the variable value. Connect this script to the initial and delta u dataflow.

C. Set the job to call the initial and delta dataflow in parallel. Each dataflow should have a filter testing for the variable value.

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

Discussion 0

Correct Answer: A Vote an answer

Question 2

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

B. Average

C. Min

D. Checksum

E. Count distinct

Discussion 0

Correct Answer: A,B,D Vote an answer

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

Question 3

What does the data services repository of SAP Data services contain?
There are 2 correct answers to this question

A. Transformation rules

B. User security

C. in flight data

D. Target metadata

Discussion 0

Correct Answer: A,D Vote an answer

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

Question 4

What requirement must you meet when mapping an output column on the SAP Data Services query transform mapping tab?

A. Primary keys in the input schema must be mapped to only one column in the output schema

B. All columns of the input schema must be mapped to the output schema

C. Every column of the output schema must have a mapping

D. Each column in the output schema must be mapped to one or more columns in the input schema

Discussion 0

Correct Answer: D Vote an answer

Question 5

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?

A. Use a dataflow to set the value via a template table

B. Use a catch block and set the variable to 'yes1

C. Use a global variable to persist the value across job executions

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

Discussion 0

Correct Answer: B Vote an answer

Question 6

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?

A. To push the data down for better performance

B. To increase the speed that the database loads

C. To ensure compatibility with subsequent transforms

D. To control how the data is loaded.

Discussion 0

Correct Answer: C,D Vote an answer

Question 7

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.

A. default value

B. Format information

C. comment

D. field size

E. data type

Discussion 0

Correct Answer: A,B,D Vote an answer

Question 8

In SAP Data services which function delivers the same results an nested 1FTHENELSE functions?

A. Literal

B. Match_regex

C. Decode

D. Match_Pattern

Discussion 0

Correct Answer: C Vote an answer

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

Contact Us

Useful Links

Latest Updated