C_DS_43無料問題集「SAP Certified Application Associate - Data Integration with SAP Data Services」

質問 1

A target column named ZIP4 requires the input of the source columns: POSTCODE and EXTENSION. For example:
POSTECODE:99999
EXTENSION: 9999
Desired result is ZIP4:99999-9999

（A）POSTCODE AND '-' AND EXTENSION

（B）POSTCODE ||'-'|| EXTENSION

（C）POSTCODE +'-*+ EXTENSION

（D）rpad_ext(POSTCPDE,EXTENSION)

正解：B 解答を投票する

質問 2

A SAP Data Services job contain logic to execute different dataflows depending on whether the job was successful or failed. Therefore the $NEEDS_RECOVERY variable should be set to either 'Yes' or 'No'. How do you assign the value to the $NEEDS_RECOVERY variable?

（A）Use a global variable to persist the value across job executions

（B）Use a script with an SQL function to read from status table

（C）Use a dataflow to set the value via a template table

（D）Use a catch block and set the variable to 'yes1

正解：D 解答を投票する

質問 3

An SAP Data Services dataflow must load the source table data into a target table, but the column names are different. Where do you assigg each source column to the matching target column?

（A）In a table loader

（B）In the table reader

（C）In a query transform

（D）In the Map transform

正解：C 解答を投票する

質問 4

What operation can you push down to the database using a data transfer transform in SAP Data Services? 3 answers correct

（A）Ordering

（B）XML function

（C）Custom function

（D）Distinct

（E）Join

正解：A、D、E 解答を投票する

質問 5

which transform are typically used to implement a slowly changing dimension of type 2 in SAP Data services?
3 correct answers

（A）Key_Generation

（B）Map_CDC_Operation

（C）Data_Transfer

（D）History_Preserving

（E）Table_comparison

正解：A、B、E 解答を投票する

質問 6

What operations can be pushed down in SAP Data Services?

（A）join operations between a file and a database table

（B）Load operations that contain trigger

（C）Join operations between sources that are on the same database servers

（D）Aggregation operations used with a group by statement

正解：C 解答を投票する

質問 7

You have a workflow containing two dataflows. The second dataflow should only run if the first one finished successfully.
How would you achieve this in SAP Data Services.

（A）Connect the two dataflows with line

（B）Use a conditional for the second dataflow

（C）Embed the first dataflow in a try-catch

（D）Add a script between the dataflows using the error_number() function

正解：A 解答を投票する

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

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

（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）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.

正解：A 解答を投票する

質問 9

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 twelve query transform to create the desired output. Then combine these transforms.

（B）Use the query transform with multiple IFTHENELSE() functions.

（C）Use the merge transform that is connected to the source

（D）Use the pivot transform with two pivot sets.

正解：D 解答を投票する

C_DS_43 無料問題集「SAP Certified Application Associate - Data Integration with SAP Data Services」

弊社を連絡する

関連リンク

トップ試験