C-DS-42 by SAP Actual Free Exam Questions And Answers

Question 1

What are advantages of using the validation transform in SAP Data services? There are 3 correct answers to this question

A. You can produce statistics

B. You can see which rules were violated in one output

C. You can set different failed paths for each rule

D. You can have multiple rules on a single column.

E. You can call a recovery dataflow

Discussion 0

Correct Answer: B,C,D 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

In which of the following objects can you use built-in- functions in SAP Data services? Note: There are 3 correct answers to this question

A. Conditionals

B. Map CDC transform

C. Merge transform

D. Query transform

E. Scripts

Discussion 0

Correct Answer: C,D,E Vote an answer

Question 4

In SAP Data Services why would you select the produce default output checkbox in the Case transform?

A. To output all rows that do not match any case expression to the default path

B. To output all rows to the default path regardless if the they match the case expressions.

C. To output all rows that match the case statement

D. to output all rows that do match exactly one case expression

Discussion 0

Correct Answer: A Vote an answer

Question 5

You are reading a Sales Order table from the source and need to add the customer region information a from a customer table. The primary key of the customer table consists of the columns CUST_ID and VALID_FROM How would you desing the dataflow to get the region information that was valid at the ORDER_CREARTE_DATE?

A. Perform an outer join between both tables

B. Use a regular lookup function

C. Use a lookup_ext function

D. Join the two tables

Discussion 0

Correct Answer: B Vote an answer

Question 6

How would you use the View Optimized SQL feature to optimize the SQL feature to optimize the performance of the dataflow?

A. View and modify the SQL to improve performance

B. View and modify the SQL and adjust the dataflow to maximize push-down operations.

C. View and modify the overall optimization plan of a data services engine

D. View and modify the database execution plan within the Data Services Designer

Discussion 0

Correct Answer: B Vote an answer

Question 7

The value of the DEPT ID is null

What is the output of this SAP Data Services function?

A. IS

B. ?

C. null

D. CA

Discussion 0

Correct Answer: B Vote an answer

Question 8

You are joining tables using the query transform of SAP Data Services.

A. Only equal conditions

B. Maximum of two tables

C. Left outer joins and inner joins

D. Only inner joins

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