QUESTION 46
You are working as an ETL developer using SAP Data Services Designer. To whom You will create Datastores?

QUESTION 47
What is the SAP Data services Dataflow auditing feature used for?

QUESTION 48
What operation can you push down to the database using a data transfer transform in SAP Data Services? 3 answers correct

QUESTION 49
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

QUESTION 50
You must ensure that all records from the Customer table in the Alpha database are being moved to the Delta staging database using the audit logs.
In the Local Object Library, replicate the Alpha_NACustomer_DF data flow. Name the replicated data flow Alpha_AuditCustomer_DF . Add the replicated data flow to a new job, Alpha_AuditCustomer_Job . Set up auditing on the data flow Alpha_AuditCustomer_DF by adding an audit rule to compare the total number of records in the source and target tables.
How to Add the Alpha_AuditCustomer_DF to the Alpha_AuditCustomer_Job .

QUESTION 51
What is the relationship between local variables and parameters in SAP Data Services? 2 correct answers

QUESTION 52
How to Save and execute the job, Alpha_Product_Job?

QUESTION 53
Why would you use a memory datastore in your SAP Data Services dataflow design?

QUESTION 54
What are advantages of using the validation transform in SAP Data services? There are 3 correct answers to this question

QUESTION 55
In which parameter the number of minutes a profiling task can be inactive before the Data Profiler cancels it?

QUESTION 56
What can you use a workflow for in SAP Data Services?

QUESTION 57
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?

QUESTION 58
You must calculate the total value of all orders, including their discounts, for reporting purposes. Currently these details are found in different tables.
Use the sum function to calculate the total value of orders in the Order_Details table.
How to in the Query transform, create a new output column
TOTAL_VALUE , which will hold the new calculation.

QUESTION 59
What task can you perform in the SAP Data Services Management Console? Note: There are 3 correct answers to this question

QUESTION 60
Once you have confirmed that the structure appears correct, you execute another debug session with all records, breaking after every row. Execute the Alpha_NACustomer_Job again in debug mode using a breakpoint to stop the debug process after a number of rows.

QUESTION 61
What transform can you use to change the operation code from UPDATE to INSERT in SAP Data Services?
Note: There are 2 correct answers to this question

QUESTION 62
Which type of SAP Data Services object can a project, job, dataflow or workflow contain? 3 correct answers

QUESTION 63
You developed a batch job using SAP Data Services and want yo start an execution. How can you execute the job?
2 correct answers

QUESTION 64
Where can you set up breakpoints for the SAP Data services interactive debugger?

QUESTION 65
In which of the following objects can you use built-in- functions in SAP Data services? Note: There are 3 correct answers to this question