EMT Practice Test

1. Question Content...

---

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

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

Question3: 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 an Audit label for the new target table and create a custom audit rule to verify the sum of the count of the two target tables is equal to the count of the source table.

Question4: Contains repository names that are associated with the Job Server on which you run your jobs. Which is the actual option to see jobs status?

Question5: You executed a job in development environment and it raised primary key violation error in SAP Data Services. Which feature do you enable to identify which primary key values caused the errors?

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

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

Question8: The value of the DEPT ID is null

What is the output of this SAP Data Services function?

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

Question10: Management Console is written in which language?

Question11: You import a table from a database into a datastore.
Which information is added into the SAP Data Services repository?

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

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

Question14: During development of a SAP Data Services dataflow, you find that the source system contains data inconsistencies.
What transform allows you to define rules and monitor the conformance of the data for every load?

Question15: _________through which SAP Data Services connects to this
SAP application server. Use the same user name used to create the SAP BW Source datastore.

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

Question17: In SAP Data Services which basic operations can you perform with a Query transform?

Question18: What requirement must you meet when mapping an output column on the SAP Data Services query transform mapping tab?

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

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

Question21: How to Connect the source table to the target table?

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

Question23: Which syntax rules must you follow in the SAP
Data Services scripting language?

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

Question25: ___________in the SAP RFC destination to which this RFC
Server will connect?

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

Question27: In which parameter the number of seconds to sleep before the Data Profiler checks for completion of an invoked task. Invoked tasks run synchronously, and the Data Profiler must check for their completion?

Question28: You SAP Data Services job desing includes an initialization script that truncates rows in the target prior to loading, the job uses automatic recovery How would you expect the system to behave when you run the job in recovery mode?
Note: There are 2 correct answers to this question

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

Question30: In which parameter the number of seconds to sleep before the
Data Profiler attempts to start pending tasks. Pending tasks have not yet started because the maximum number of concurrent tasks was reached?

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

Question32: You are joining tables using the query transform of SAP Data Services.

Question33: How to Save and execute the Alpha_NACustomer_Job?

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

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

Question36: How to Open the target table editor to view the Schema In and Schema Out?

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

Question38: When evaluating the customer data for Alpha Acquisitions, you discover a data entry error. The contact title of
"Account Manager" has been entered as "Accounting Manager". You must correct these entries before it is moved to the data warehouse. How to Execute the Alpha_NACustomer_Job with the default execution properties after saving all of the objects that you have created.

Question39: How do you desing a data load that has good performance and deals with interrupted loads in SAP Data services?

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

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

Question42: You have a Salary table containing departments (DEPARTMENT column) and salaries (SALARY column).
How do you calculate the average salaries for each department in the Query transform in SAP Data Services?

Question43: A SAP Data Services job contain logic to execute different dataflows depending on whether the job was successful or failed. Therefore the $NEEDS_RECOVERY variable should be set to either 'Yes' or 'No'. How do you assign the value to the $NEEDS_RECOVERY variable?

Question44: Which SAP Data Services transforms would you use in a dataflow to load a slowly changing dimension of type 2?

Question45: How to Use a WHERE clause to select only customers in North America
(North American countries are United States, Canada, and Mexico which have COUNTRYID values of 1, 2,and 11)?

Question46: You have a map operation transform immediately before the target in a data flow in Sap Data Services. What happens if all operation codes are mapped to Discard in the transform?

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

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

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

Question50: You are loading a database table using SAP Data Services. Which loading options are valid? Note: There are 3 correct answers to this question.

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

Question52: Which features are supported by the SAP Data Services interactive dubbuger?
3 correct answers

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

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

Question55: An SAP Data Services dataflow adds the changed data (insert and update) into a target table every day.
How do you desing the dataflow to ensure that a partially executed dataflow recovers automatically the next time it is executed?
2 correct answers

Question56: In the Alpha Acquisitions database, the country for a customer is stored in a separate table and referenced with a code. To speed up access to information in the data warehouse, this lookup should be eliminated.
Use the lookup_ext function to exchange the ID for the country name in the customers table for Alpha with the actual value from the country table.
How to Execute the Alpha_NACustomer_Job with the default execution properties after saving all objects you have created.

Question57: What do you call for that particular link of Clicking to Click to open the Documentation Map, which lists the SAP Data Services technical documentation available to end users or administrators, and a link to the customer portal where you can find the latest versions of the documentation?

Question58: Contains the repository name associated with the ________ Server?

Question59: An SAP data services file format has a date column, but occasionally the file contains an invalid value in one row. This causes the dataflow to terminate with an error.
What can you do to completely load such erroneous files?
Note: There are 2 correct answer

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

Question61: You have to load a file that contains the following first three lines:
YEAR; MONTH; PLAN_AMOUNT
2014;01;100.00
2014;02;110.00
What setting do you use when you created a file format for this?

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

Question63: The Marketing department would like to send special offers to customers who have placed a specified number of orders. This can be done by creating a custom function that must be called when a customer order is placed.
You want to create a custom function to accept the input parameters of the Customer ID, and the number of orders required to receive a special order, check the Orders table, and then create an initial list of eligible customers.

Question64: Install the Management Console on a separate computer from other Data Services components. Where does management Console runs?