QUESTION 22
You built a delta load dataflow in SAP Data Services. This Dataflow is executed every night. The source table contains a CHANGE_DATE column which is populated by the database when the row is saved.
What can a timestamp based CDC aproach identify in the source based on this CHANGE_DATE column

QUESTION 23
You have a workflow containing two dataflows. The second dataflow should only run if the first one finished successfully.
How would you achieve this in SAP Data Services.

QUESTION 24
You decide to distribute the execution of a job across multiple job servers within a server group. What distribution levels are available? 3 answers correct

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

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

QUESTION 27
An SAP Data Services job contains a lot of dataflows and runs for several hours every night. If a job execution fails, you want to skip all successful dataflows and start with the failed dataflow. How do you accomplish this?
There are 2 correct answer

QUESTION 28
The value of the DEPT ID is null

What is the output of this SAP Data Services function?

QUESTION 29
What does the expression SUBSTR(FIRST NAME, 1,3) return?

QUESTION 30
You created and saved a database datastore in SAP Data Services. Which properties can you change in the Edit Datastore dialog box?

QUESTION 31
In SAP Data Services which basic operations can you perform with a Query transform?

QUESTION 32
You want to use on SAP data services transform to split your source vendor data into three branches, based on the country code.
Which transform do you use?

QUESTION 33
You define audit rules for critical data flow to confirm that you SAP Data Services batch job loaded only correct dat a. Which audit functions are available to define these rules for columns? Note: There are 3 correct answers

QUESTION 34
which transform are typically used to implement a slowly changing dimension of type 2 in SAP Data services?
3 correct answers

QUESTION 35
From the account table you want to know how many accounts you have per account type. The ACCOUNT_TYPE is output along with an additional column COUNTER. The group by tab of the query transform is used with ACCOUNT_TYPE. Which mapping would you use for the COUNTER column in SAP Data Services?

QUESTION 36
An SAP Data Services dataflow must load the source table data into a target table, but the column names are different. Where do you assigg each source column to the matching target column?

QUESTION 37
A target column named ZIP4 requires the input of the source columns: POSTCODE and EXTENSION. For example:
POSTECODE:99999
EXTENSION: 9999
Desired result is ZIP4:99999-9999

QUESTION 38
An SAP Data Services Validation transform outputs all invalid rows. If more than ten rows are invalid, the data is considered to be failed. How do you implement this?