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

出題：1

What task can you perform in the SAP Data Services Management Console? Note: There are 3 correct answers to this question

A. Debug a dataflow to find data issues

B. View the rows and the values being loaded

C. Display trace and monitor and error logs.

D. Display the optional Validation Transform statistics

E. Schedule a job for daily execution

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

出題：2

In SAP Data Services you have a Validation Transform with the following two rules Rule #1: Action on Failure is 'Send to Pas' Rules#2: Action on Failure is 'Send to Fail.
Where are the records that fail both rule #1 and rule #2 sent?

A. To both the Pass and Fail output

B. Only to the Fail output

C. Only to the Pass output

D. Only to the Rule Violation output

正解：B 解答を投票する

出題：3

An SAP data services file format has a date column, but occasionally the file contains an invalid value in one row. This causes the dataflow to terminate with an error.
What can you do to completely load such erroneous files?
Note: There are 2 correct answer

A. Specify a date format of'????-??-??' to indicate the value might NOT be a valid date in the file format editor

B. Define the column as varchar and use functions in subsequent Query transform to perform the checks and conversion

C. Place the dataflow between a Try/Catch block to catch all erroneous rows

D. Use the error handling options for conversion error in the file format definition

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

出題：4

From the account table you want to know how many accounts you have per account type. The ACCOUNT_TYPE is output along with an additional column COUNTER. The group by tab of the query transform is used with ACCOUNT_TYPE. Which mapping would you use for the COUNTER column in SAP Data Services?

A. Gen_Row_Num()

B. Count(*)

C. count_distinct(Account_TYPE)

D. count(Account_type)

正解：D 解答を投票する

出題：5

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

出題：6

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. Add a script between the dataflows using the error_number() function

C. Use a conditional for the second dataflow

D. Embed the first dataflow in a try-catch

正解：A 解答を投票する

出題：7

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

出題：8

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

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