SAP C_DS_43 Exam Practice Test Instant Access

Question 1

The SAP Data services merge transform is used to combine two datasets; the first has 3000 rows and the second has 2000 rows. What are characteristics of the Merge transform? Note: there are 2 correct answers to this question

AThe merge transform combines the dataset into 5000 or less output rows.

BThe merge transform combines the dataset into 5000 output rows

CThe merge transform joins the datasets using a full outer join

DThe merge transform require both dataset to have the same structure.

Answer : D

Question 2

How would you use the View Optimized SQL feature to optimize the SQL feature to optimize the performance of the dataflow?

AView and modify the overall optimization plan of a data services engine

BView and modify the SQL to improve performance

CView and modify the SQL and adjust the dataflow to maximize push-down operations.

DView and modify the database execution plan within the Data Services Designer

Answer : C

Question 3

Which repository types are used in SAP Data Services? 2 correct

ACentral Repository

BData repository

CProfiler repository

DRemote Repository

Answer : A, C

Question 4

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?

AUse twelve query transform to create the desired output. Then combine these transforms.

BUse the query transform with multiple IFTHENELSE() functions.

CUse the merge transform that is connected to the source

DUse the pivot transform with two pivot sets.

Answer : D

Question 5

A new developer joined the project team. You already created a new SAP Data Services repository for this member.

Where do you manage the security setting for this new repository?

AData Services Designer

BCentral Management console

CRepository manager

DRepository database

Answer : B

Question 6

You are asked to perform either the initial load or delta load based on the value of a variable that is set at job execution

How do you design this requirement in SAP Data services.

ASet the job to call the initial and delta dataflow in parallel. Each dataflow should have a filter testing for the variable value.

BUse a job containing a script with the if then else () function to test the variable value. Connect this script to the initial and delta u dataflow.

CUse a job containing a Case transform testing for the two possible conditions. Connect one case output to the initial dataflow and the other to the delta dataflow Use a job container the delta dataflow

DUse a job containing a Conditional objet that test the value of the variable. In the IF part, call the initial dataflow in the ELSE part call

Answer : D

Question 7

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?

APerform an outer join between both tables

BUse a regular lookup function

CJoin the two tables

DUse a lookup_ext function

Answer : B

SAP C_DS_43 SAP Certified Application Associate - Data Integration with SAP Data Services Exam Practice Test