Online Access Free C-DS-43 Practice Test

You import a table from a database into a datastore.
Which information is added into the SAP Data Services repository?

• A.The complete metadata information of the table
• B.Only the table name
• C.The table name and all column names with their dataypes.
• D.The whole table with all its source data

What requirement must you meet when mapping an output column on the SAP Data Services query transform mapping tab?

• A.Primary keys in the input schema must be mapped to only one column in the output schema
• B.All columns of the input schema must be mapped to the output schema
• C.Each column in the output schema must be mapped to one or more columns in the input schema
• D.Every column of the output schema must have a mapping

You source table has a revenue column and a quantity column for each month. You want to transform this data to get a table containing twelve rows whit two columns.
What is the best way to achieve this in SAP Data services?

• A.Use the merge transform that is connected to the source
• B.Use twelve query transform to create the desired output. Then combine these transforms.
• C.Use the pivot transform with two pivot sets.
• D.Use the query transform with multiple IFTHENELSE() functions.

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

• A.To execute single SQL commands using the sql() function to select a value from a status table for the variable.
• B.To perform job initialization tasks to print the job variable values into the trace log using the print() function.
• 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.

An SAP Data Services dataflow must load the source table data into a target table, but the column names are different. Where do you assigg each source column to the matching target column?

• A.In the Map transform
• B.In a table loader
• C.In a query transform
• D.In the table reader