Online Access Free C-DS-42 Practice Test

What operation can you push down to the database using a data transfer transform in SAP Data Services? 3 answers correct

• A.XML function
• B.Ordering
• C.Custom function
• D.Distinct
• E.Join

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.Table_comparison
• C.Data_Transfer
• D.History_Preserving
• E.Key_Generation

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

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

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

What application do you use to display the graphical representations of all Sap Data Services objects including their relationships and properties?

• A.Autodocumentation
• B.Operational Dashborad
• C.Data quality reports
• D.Impact and lineage Analysis