C-DS-42 by SAP Valid Free Exam Practice Test

Question 1

What errors can you handle in SAP Services when you use a file format target?

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

Correct Answer: A

Question 2

Which repository types are used in SAP Data Services? 2 correct

A. Data repository B. Profiler repository C. Remote Repository D. Central Repository

Correct Answer: B,D

Question 3

What application do you use to display the graphical representations of all Sap Data Services objects including their relationships and properties?

A. Autodocumentation B. Operational Dashborad C. Impact and lineage Analysis D. Data quality reports

Correct Answer: A

Question 4

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: Delimited column delimiter:; skip row headen: yes B. Type: Delimited column delimiter:; skip row headen: no C. Type: Delimited column delimiter:<blank> skip row headen: yes D. Type: Fixed column length:4,2 and 6 skip row headen: yes

Correct Answer: A

Question 5

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. Data Services Designer B. Central Management console C. Repository manager D. Repository database

Correct Answer: B

Question 6

You executed a job in development environment and it raised primary key violation error in SAP Data Services. Which feature do you enable to identify which primary key values caused the errors?

A. Auto correct load B. delete data before loading C. Drop and re-created target table D. Use overflow file

Correct Answer: D

Question 7

The performance of a dataflow is slow in SAP Data Services.
How can you see which part of the operations is pushed down to the source database? Note: the are 2 correct answers to this question.

A. By opening the dataflow and using the view optimized SQL feature. B. By starting the job in debubg mode. C. By enabling corresponding trace options in the job execution dialog. D. by opening the auto documentation page in the Data Services Management Console

Correct Answer: A,C

Question 8

An SAP data services job was executed in the past.
Where can you see the order that the dataflows were executed in?
There are 2 correct answers to this question.

A. In the operational dashboard B. In the impact and Lineage Analysis report C. In the job trace log. D. In the job server log

Correct Answer: C

SAP Certified Application Associate - Data Integration with SAP Data Services 4.2 - C-DS-42 Exam Practice Test