C_DS_42問題集、SAP実際の試験問題

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

質問 2

You build a Data Warehouse with a date dimension in SAP Data Services. You decide to use the Date Generation transform to create this. What options are available to control the output form the transform?

A. Effective date column

B. Julian format

C. Increment

D. end date

正解: D

質問 3

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 +'-*+ EXTENSION

B. POSTCODE AND '-' AND EXTENSION

C. POSTCODE ||'-'|| EXTENSION

D. rpad_ext(POSTCPDE,EXTENSION)

正解: C

質問 4

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

質問 5

The performance of a dataflow is slow in SAP Data Services.
How can you see which part of the operations is pushed down to the source database? Note: the are 2 correct answers to this question.

A. By starting the job in debubg mode.

B. By enabling corresponding trace options in the job execution dialog.

C. by opening the auto documentation page in the Data Services Management Console

D. By opening the dataflow and using the view optimized SQL feature.

正解: B,D

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

Which repository types are used in SAP Data Services? 2 correct

A. Central Repository

B. Data repository

C. Profiler repository

D. Remote Repository

正解: A,C

質問 8

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 pivot transform with two pivot sets.

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

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

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

正解: A

SAP Certified Application Associate - Data Integration with SAP Data Services 4.2 - C_DS_42 模擬練習