C_DS_43 무료 덤프문제 온라인 액세스

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

• A.To perform job initialization tasks to print the job variable values into the trace log using the print() function.
• B.To execute single SQL commands using the sql() function to select a value from a status table for the variable.
• C.To set the desired properties, for example, trace options, monitor sample rate, and the use statistics for optimization flag.
• D.To write complex transformation logic using the flexibility of the scripting language.

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.Perform an outer join between both tables
• B.Use a lookup_ext function
• C.Join the two tables
• D.Use a regular lookup function

In SAP data services what does the date generation transform allow you to generate?

• A.the valid to date based on a dataset the contains valid to information only
• B.The rows for a given date range
• C.The current date for a column to see when each row was loaded.
• D.the valid from date based on a dataset the contains valid to information only

What can you use a workflow for in SAP Data Services?

• A.to allow schedulling for dataflows
• B.To group jobs that you want to monitor
• C.To group data flows that belong together
• D.To transform source data into target data

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 reruns all workflows and scripts. When using automatic recovery, only dataflows that ran successfully in the previous execution ^ are skipped.
• C.the job starts with the flow that caused the error. If this flow is after the initialization script the initialization script is skipped.
• D.The job executes the scripts if it is part of a workflow marked as a recovery unit, but only if an error was raised