EMT Practice Test

1. Question Content...

---

Question1: How do you view the data between transforms in SAP Data Services dataflow?

Question2: An SAP Data Services dataflow has validation error.
What is the cause?

Question3: In which situation is it appropriate to use a time - based CDC to capture changes in source data with SAP Data services

Question4: You execute an SAP data services job with enable recovery activated. One of the dataflows in the jobs raises an exception that interrupts the execution. You run the job again with Recover from last failed execution enabled. What happens to the data flow that raised the exception during the first execution?

Question5: In SAP Data Services you have a Validation Transform with the following two rules Rule #1: Action on Failure is 'Send to Pas' Rules#2: Action on Failure is 'Send to Fail.
Where are the records that fail both rule #1 and rule #2 sent?

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

Question7: You want to set up a new SAP Data Services landscape. You must also create new repositories. Which repository types can you create?

Question8: 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

Question9: Which features are supported by the SAP Data Services interactive debugger?
3 correct answers

Question10: 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?

Question11: What does the data services repository of SAP Data services contain?
There are 2 correct answers to this question

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

Question13: 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?

Question14: 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

Question15: You want to execute two dataflows in parallel in SAP Data Services. How can you achieve this?

Question16: What errors can you handle in SAP Services when you use a file format target?

Question17: A Map operation transform in SAP Data Services was used to modify the operation code of data is being processed. Why do you perform this action?

Question18: What is the SAP Data services Dataflow auditing feature used for? Note: There are 2 correct answers to this question.

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

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

Question21: 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

Question22: a do you use implement a target-based delta that deals with inserts, update and deletes in the source.

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

Question24: 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

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

Question26: 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

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

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

Question29: You create a file format in SAP Data Services
What properties can you set for a column?
Note: There are 3 correct answers to this question.

Question30: You want to display the description of an object in the Designer workspace-Which task must you perform to accomplish this in SAP Data services?
3 correct answers

Question31: The value of the DEPT ID is null

What is the output of this SAP Data Services function?

Question32: Which feature in the SAP Data Services Management Console allows you to see the trend of the execution time for any given job?

Question33: The performance of a dataflow is slow in SAP Data Services.
How can you see which part of the operations is pushed down to the source database? Note: the are 2 correct answers to this question.

Question34: You want to load data from an input table to an output table using the SAP Data Services Query transform. How do you define the mapping of the columns within a Query transform? There are 2 correct answers

Question35: Where can you set up breakpoints for the SAP Data services interactive debugger?

Question36: A dataflow contain a pivot transform followed by a query transform that performs an aggregation. The Aggregation query should by pushed down to the database in SAP Data services.
Where would you place the Data_Transfer transform to do this?

Question37: What does the expression SUBSTR(FIRST NAME, 1,3) return?