Online Access Free C_DS_43 Practice Test

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.Increment
• B.Effective date column
• C.Julian format
• D.end date

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 enabling corresponding trace options in the job execution dialog.
• B.By opening the dataflow and using the view optimized SQL feature.
• C.by opening the auto documentation page in the Data Services Management Console
• D.By starting the job in debubg mode.

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 intermediate changes
• B.when you need to capture physical deletes from source
• C.When there are large tables with few changes
• D.When almost all of the rows have changes

How do you view the data between transforms in SAP Data Services dataflow?

• A.By setting the Audit Data On job execution trace option
• B.By setting the SQL Transforms on job execution trace option
• C.By adding audit points in the dataflow
• D.By using the interactive debugger

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 starts with the flow that caused the error. If this flow is after the initialization script the initialization script is skipped.
• 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 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 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.