SAP C_DS_43 Exam Questions Instant Access

Question 1

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

ATo write complex transformation logic using the flexibility of the scripting language.

BTo perform job initialization tasks to print the job variable values into the trace log using the print() function.

CTo set the desired properties, for example, trace options, monitor sample rate, and the use statistics for optimization flag.

DTo execute single SQL commands using the sql() function to select a value from a status table for the variable.

Answer : A, D

Question 2

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

AOperational Dashborad

BAutodocumentation

CImpact and lineage Analysis

DData quality reports

Answer : B

Question 3

You want to back up an SAP Data Services repository. How does the system store repositories?

AAs tables in a relational database management system

BAs an XML file on the Data services Access Server

CAs an XML file on the data services job server

DAs an binary file on the Data servives job server

Answer : A

Question 4

Which features are supported by the SAP Data Services interactive debugger?

3 correct answers

AShow sample rows of each step

BSet breakpoint

CShow the optimized execution plan

DShow performance-related statistics

EDefine additional filters

Answer : A, B, E

Question 5

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

Question 6

You modified an existing SAP data Services job. You notice that the run time is now longer then expected. Where in SAP Data Services can you observe the progress of row counts to determine the location of a bottleneck

AOn the view data tab

BIn the impact and lineage analysis

CIn the monitor log

DIn the trace log

Answer : C

Question 7

Why would you specify Recover as a Unit in the property of a workflow in SAP Data Services?

ATo ensure that all objects of the workflow are executed during recovery including the steps that were executed successfully in the prior run

BTo ensure that the workflow is skipped during recovery if the workflow was executed successfully in the prior run.

CTo ensure that all dataflow of the workflow are executed in one single transaction during recovery

DTo ensure that each dataflow is recovered as a separate unit during the recovery execution

Answer : A

SAP Certified Application Associate - Data Integration with SAP Data Services C_DS_43 Exam Questions