Online Access Free C_DS_42 Practice Test

In SAP Data Services why would you select the produce default output checkbox in the Case transform?

• A.to output all rows that do match exactly one case expression
• B.To output all rows that do not match any case expression to the default path
• C.To output all rows to the default path regardless if the they match the case expressions.
• D.To output all rows that match the case statement

You created and saved a database datastore in SAP Data Services. Which properties can you change in the Edit Datastore dialog box? There are 2 correct answers

• A.user name and password
• B.database version
• C.Datastore name
• D.database name
• E.database server name

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.Join the two tables
• B.Perform an outer join between both tables
• C.Use a lookup_ext function
• D.Use a regular lookup function

What are standard component of SAP Dataservices? There are 3 correct answers

• A.Real time services
• B.Access server
• C.Job server
• D.Secure local repository
• E.Design studio

You build a Data Warehouse with a date dimension in SAP Data Services. You decide to use the Date Generation transform to create this. What options are available to control the output form the transform?

• A.Julian format
• B.end date
• C.Effective date column
• D.Increment