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

What errors can you handle in SAP Services when you use a file format target?

• A.  File type error
• B.  Row- format error
• C.  Data type conversion error
• D.  Semantic error

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 write complex transformation logic using the flexibility of the scripting language.
• C.  To perform job initialization tasks to print the job variable values into the trace log using the print() function.
• D.  To set the desired properties, for example, trace options, monitor sample rate, and the use statistics for optimization flag.

You are reading a Sales Order table from the source and need to add the customer region information a from a customer table. The primary key of the customer table consists of the columns CUST_ID and VALID_FROM How would you desing the dataflow to get the region information that was valid at the ORDER_CREARTE_DATE?

• A.  Use a regular lookup function
• B.  Perform an outer join between both tables
• C.  Use a lookup_ext function
• D.  Join the two tables

A dataflow contain a pivot transform followed by a query transform that performs an aggregation. The Aggregation query should by pushed down to the database in SAP Data services.
Where would you place the Data_Transfer transform to do this?

• A.  Before the pivot transform
• B.  After the query transform
• C.  Before the pivot transform and after the query transform.
• D.  Between the pivot transform and the query transform

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

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