Online Access Free C-DS-42 Exam Questions

How would you use the View Optimized SQL feature to optimize the SQL feature to optimize the performance of the dataflow?

• A.View and modify the overall optimization plan of a data services engine
• B.View and modify the SQL to improve performance
• C.View and modify the SQL and adjust the dataflow to maximize push-down operations.
• D.View and modify the database execution plan within the Data Services Designer

You developed a batch job using SAP Data Services and want yo start an execution. How can you execute the job?
2 correct answers

• A."Execute the job manually in the Data Services Designer."
• B.Use the scheduler in the Data Services Management Console
• C.Use the debug option in the Data Services Management console
• D.Use the scheduler in the Data Services Designer

which transform are typically used to implement a slowly changing dimension of type 2 in SAP Data services?
3 correct answers

• A.Map_CDC_Operation
• B.Data_Transfer
• C.Key_Generation
• D.History_Preserving
• E.Table_comparison

How do you allow a new team member to view the SAP Data Services repository in read only mode?

• A.Export the repository's metadata to an XML file and open it in a browser.
• B.Use the Auto Documentation feature in the Management Console
• C.Copy the repository and view the copy in the repository manager.
• D.Use the central repository in the Desinger

You decide to distribute the execution of a job across multiple job servers within a server group. What distribution levels are available? 3 answers correct

• A.Dataflow
• B.Embedded dataflow
• C.workflow
• D.subdataflow
• E.JOB