C-DS-42問題集、SAP実際の試験問題

質問 1

You built a delta load dataflow in SAP Data Services. This Dataflow is executed every night. The source table contains a CHANGE_DATE column which is populated by the database when the row is saved.
What can a timestamp based CDC aproach identify in the source based on this CHANGE_DATE column

A. Insert, updates and deletes for a specified time range.

B. Inserted and updated rows but not delete rows

C. Every single change made to a row

D. Update rows but NOT insert or deleted records.

正解: B

質問 2

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 push the data down for better performance

B. To ensure compatibility with subsequent transforms

C. To increase the speed that the database loads

D. To control how the data is loaded.

正解: B,D

質問 3

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

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

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

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

正解: C

質問 4

A dataflow contain a pivot transform followed by a query transform that performs an aggregation. The Aggregation query should by pushed down to the database in SAP Data services.
Where would you place the Data_Transfer transform to do this?

A. Between the pivot transform and the query transform

B. After the query transform

C. Before the pivot transform and after the query transform.

D. Before the pivot transform

正解: A

質問 5

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

A. Ordering

B. Distinct

C. Custom function

D. XML function

E. Join

正解: A,B,E

質問 6

What are SAP data services scripts used for? There are 2 correct answers to this question

A. To set the desired properties, for example, trace options, monitor sample rate, and the use statistics for optimization flag.

B. To execute single SQL commands using the sql() function to select a value from a status table for the variable.

C. To perform job initialization tasks to print the job variable values into the trace log using the print() function.

D. To write complex transformation logic using the flexibility of the scripting language.

正解: B,D

質問 7

You execute an SAP data services job with enable recovery activated. One of the dataflows in the jobs raises an exception that interrupts the execution. You run the job again with Recover from last failed execution enabled. What happens to the data flow that raised the exception during the first execution?

A. It is rerun from the beginning and the desing of the data flow must deal with partially loaded data.

B. Is is rerun with the first failed row.

C. It is rerun only if the dataflow is part of a recovery unit.

D. It is rerun from the beginning and the partially loaded data is always handled automanticaly.

正解: B

質問 8

In SAP Data Services which basic operations can you perform with a Query transform?

A. Flag rows for update

B. Set a global variable to a value

C. "Join data from several sources"

D. Map Columns from an input schema to an output schema"

E. "Apply functions to columns"

正解: E

SAP Certified Application Associate - Data Integration with SAP Data Services 4.2 - C-DS-42 模擬練習