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

出題：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 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 解答を投票する

出題：2

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.

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

出題：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 Map transform

C. In a query transform

D. In the table reader

正解：C 解答を投票する

出題：4

Why would you specify Recover as a Unit in the property of a workflow in SAP Data Services?

A. To ensure that all objects of the workflow are executed during recovery including the steps that were executed successfully in the prior run

B. To ensure that the workflow is skipped during recovery if the workflow was executed successfully in the prior run.

C. To ensure that all dataflow of the workflow are executed in one single transaction during recovery

D. To ensure that each dataflow is recovered as a separate unit during the recovery execution

正解：A 解答を投票する

出題：5

You are reading a Sales Order table from the source and need to add the customer region information a from a customer table. The primary key of the customer table consists of the columns CUST_ID and VALID_FROM How would you desing the dataflow to get the region information that was valid at the ORDER_CREARTE_DATE?

A. Use a regular lookup function

B. Join the two tables

C. Use a lookup_ext function

D. Perform an outer join between both tables

正解：A 解答を投票する

出題：6

In SAP Data Services why would you select the produce default output checkbox in the Case transform?

A. To output all rows to the default path regardless if the they match the case expressions.

B. To output all rows that match the case statement

C. To output all rows that do not match any case expression to the default path

D. to output all rows that do match exactly one case expression

正解：C 解答を投票する

出題：7

A Map operation transform in SAP Data Services was used to modify the operation code of data is being processed. Why do you perform this action?

A. To control how the data is loaded.

B. To push the data down for better performance

C. To ensure compatibility with subsequent transforms

D. To increase the speed that the database loads

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

出題：8

In which situation is it appropriate to use a time - based CDC to capture changes in source data with SAP Data services

A. when you need to capture physical deletes from source

B. When there are large tables with few changes

C. When almost all of the rows have changes

D. When you need to capture intermediate changes

正解：B 解答を投票する

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