Free SAP C-DS-42 Exam Dumps Questions & Answers

You want to load data from an input table to an output table using the SAP Data Services Query transform. How do you define the mapping of the columns within a Query transform? There are 2 correct answers

• A.Select one input column and enter the mapping manually
• B.Drag one column from the output schema to the input schema
• C.Drag one column from the input schema to the output schema
• D.Select an output column and enter the mapping manually.

You want to display the description of an object in the Designer workspace-Which task must you perform to accomplish this in SAP Data services?
3 correct answers

• A.right-click the object then choose enable description .
• B.Enter a description in the properties of the object.
• C.Click the view enabled descriptions button on the toolbar.
• D.disiable the hide non - executable elements setting in the difference viewer.
• E.Right - click on the job in the project hierarchy to enable all descriptions.

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 and adjust the dataflow to maximize push-down operations.
• C.View and modify the database execution plan within the Data Services Designer
• D.View and modify the SQL to improve performance

Where can you set up breakpoints for the SAP Data services interactive debugger?

• A.In a dataflow
• B.In a job
• C.In a script
• D.In a workflow

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

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