C-DS-43試験無料問題集（82題）「SAP Certified Application Associate - Data Integration with SAP Data Services 認定」

出題：1

The SAP Data services merge transform is used to combine two datasets; the first has 3000 rows and the second has 2000 rows. What are characteristics of the Merge transform? Note: there are 2 correct answers to this question

A. The merge transform combines the dataset into 5000 output rows

B. The merge transform combines the dataset into 5000 or less output rows.

C. The merge transform require both dataset to have the same structure.

D. The merge transform joins the datasets using a full outer join

正解：C 解答を投票する

出題：2

What can you use a workflow for in SAP Data Services?

A. To transform source data into target data

B. To group data flows that belong together

C. To group jobs that you want to monitor

D. to allow schedulling for dataflows

正解：B 解答を投票する

出題：3

What operations can be pushed down in SAP Data Services?

A. Aggregation operations used with a group by statement

B. Load operations that contain trigger

C. join operations between a file and a database table

D. Join operations between sources that are on the same database servers

正解：D 解答を投票する

出題：4

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

A. Match_Pattern

B. Decode

C. Match_regex

D. Literal

正解：B 解答を投票する

出題：5

You source table has a revenue column and a quantity column for each month. You want to transform this data to get a table containing twelve rows whit two columns.
What is the best way to achieve this in SAP Data services?

A. Use the merge transform that is connected to the source

B. Use twelve query transform to create the desired output. Then combine these transforms.

C. Use the pivot transform with two pivot sets.

D. Use the query transform with multiple IFTHENELSE() functions.

正解：C 解答を投票する

出題：6

An SAP Data Services job contains a lot of dataflows and runs for several hours every night. If a job execution fails, you want to skip all successful dataflows and start with the failed dataflow. How do you accomplish this?
There are 2 correct answer

A. Run the nightly job with the enable recovery flag turned on.

B. add a try block before each dataflow and a Catch block after each dataflow

C. Design the dataflow to ensure a second run does not result in duplicate

D. Merge the dataflows from the job and rerun it.

正解：B,C 解答を投票する

出題：7

What does the expression SUBSTR(FIRST NAME, 1,3) return?

A. U

B. IRS

C. M

D. FIR

正解：D 解答を投票する

出題：8

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 Conditional objet that test the value of the variable. In the IF part, call the initial dataflow in the ELSE part call

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

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

正解：B 解答を投票する

出題：9

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

A. Data type conversion error

B. File type error

C. Row- format error

D. Semantic error

正解：C 解答を投票する

C-DS-43試験無料問題集「SAP Certified Application Associate - Data Integration with SAP Data Services 認定」