C_DS_43 Exam Training Practice Tests (SAP Certified Application Associate - Data Integration with SAP Data Services)]

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 script with the if then else () function to test the variable value. Connect this script to the initial and delta u dataflow. 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. 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 Conditional objet that test the value of the variable. In the IF part, call the initial dataflow in the ELSE part call

Correct Answer: D

Question 2

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

Correct Answer: D

Question 3

You want to load data from an input table to an output table using the SAP Data Services Query transform. How do you define the mapping of the columns within a Query transform?

A. Drag one column from the input schema to the output schema B. Drag one column from the output schema to the input schema C. Select one input column and enter the mapping manually D. Select an output column and enter the mapping manually.

Correct Answer: C

Question 4

You want to execute two dataflows in parallel in SAP Data Services. How can you achieve this?

A. Create a workflow containing two dataflows and set a degree of parallelism to 2. B. Create a workflow containing two dataflows without connecting them with a line. C. Create a workflow containg two dataflows and deselect the execute Only once property of the workflow. D. Create a workflow containing two dataflows and connect them with a line.

Correct Answer: B

Question 5

You modified an existing SAP data Services job. You notice that the run time is now longer then expected. Where in SAP Data Services can you observe the progress of row counts to determine the location of a bottleneck

A. In the monitor log B. In the trace log C. In the impact and lineage analysis D. On the view data tab

Correct Answer: A

Question 6

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. Query transform C. Map CDC transform D. Merge transform E. Scripts

Correct Answer: B,D,E

Question 7

What are standard component of SAP Dataservices? There are 3 correct answers

A. Real time services B. Job server C. Secure local repository D. Access server E. Design studio

Correct Answer: B,C,D

Question 8

You import a table from a database into a datastore.
Which information is added into the SAP Data Services repository?

A. The table name and all column names with their dataypes. B. Only the table name C. The whole table with all its source data D. The complete metadata information of the table

Correct Answer: D

Question 9

You SAP Data Services job design includes an initialization script that truncates rows in the target prior to loading, the job uses automatic recovery How would you expect the system to behave when you run the job in recovery mode?
Note: There are 2 correct answers to this question

A. The job executes the scripts if it is part of a workflow marked as a recovery unit irrespective of where the error ocurred in the job flow. B. the job starts with the flow that caused the error. If this flow is after the initialization script the initialization script is skipped. C. The job executes the scripts if it is part of a workflow marked as a recovery unit, but only if an error was raised D. The job reruns all workflows and scripts. When using automatic recovery, only dataflows that ran successfully in the previous execution ^ are skipped.

Correct Answer: B,C

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