SAP c-ds-42 practice test

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


Question 1

Where is an SAP Data Services job executed?

  • A. Access server
  • B. Job server
  • C. Designer application
  • D. Management console
Answer:

B

Discussions

Question 2

During development of a SAP Data Services dataflow, you find that the source system contains data
inconsistencies.
What transform allows you to define rules and monitor the conformance of the data for every load?

  • A. Validation transform
  • B. Query transform
  • C. SQL transform
  • D. Case transform
Answer:

A

Discussions

Question 3

Which SAP Data Services transforms would you use in a dataflow to load a slowly changing
dimension of type 2?

  • A. Row_Generation
  • B. Table_Comparison
  • C. Key_Generation
  • D. History_Preserving
  • E. Effective_Date
Answer:

B, C, D

Discussions

Question 4

Which syntax rules must you follow in the SAP
Data Services scripting language?

  • A. A statement ends with a dot sign (.).
  • B. A variable starts with a percent sign (%).
  • C. A comment starts with a hash (#).
  • D. A variable starts with a dollar sign ($).
Answer:

C, D

Discussions

Question 5

What are characteristics of SAP Data Services workflows?

  • A. A workflow can call other workflows.
  • B. A workflow can contain a conditional object.
  • C. A job needs to have at least one workflow.
  • D. A workflow must contain a dataflow.
Answer:

A, B

Discussions

Question 6

You are designing an SAP Data Services process.
This process must execute ONLY if a defined expression is true.
Which object allows you to accomplish this task?

  • A. Validation transform
  • B. Try/catch block
  • C. Conditional
  • D. Case transform
Answer:

C

Discussions

Question 7

You have a Salary table containing departments (DEPARTMENT column) and salaries (SALARY
column).
How do you calculate the average salaries for each department in the Query transform in SAP Data
Services?

  • A. Specify the DEPARTMENT column on the GROUP BY tab.
  • B. Enter avg(SALARY) on the Mapping tab.
  • C. Enter avg(SALARY) on the SELECT tab.
  • D. Specify the DEPARTMENT code on the WHERE tab.
Answer:

A, B

Discussions

Question 8

An SAP Data Services dataflow contains multiple transform objects. The target table contains some
unexpected results for one column.
How can you review a sample of the data as it passes through each transform?

  • A. Execute the job and review the target table in SQL.
  • B. Execute the job in debug mode with breakpoints set and enabled.
  • C. Execute the job that enables the Trace Optimized Dataflow property.
  • D. Execute the job and review the monitor during execution.
Answer:

B

Discussions

Question 9

You want to restore an older version of an object found in a shared object library.
Where do you find this version of the object in SAP Data Services?

  • A. O In the Central repository
  • B. O In the Local repository
  • C. O In the Profiler repository
  • D. O In the Auditing repository
Answer:

A

Discussions

Question 10

Your customer has rules requiring that each row in the source be tested for certain criteria in a
specific order. When a row passes one criteria, it should
NOT be tested for the next criteria.
How should this be implemented using SAP Data Services transforms?
Please choose the correct answer.

  • A. Use multiple Query transforms with one WHERE? clause per rule. Connect all queries to the source.
  • B. Use a Case transform with the Row Can Be True for One Case Only and Preserve Expression Order options enabled.
  • C. se a Case transform with the Produce Default Output with Label option enabled, and enable the Preserve Expression Order checkbox.
  • D. Use a Validation transform and add the rules in the proper order for each single column.
Answer:

B

Discussions
To page 2