What task can you perform in the SAP Data Services Management Console? Note: There are 3 correct answers to this question
- A . Debug a dataflow to find data issues
- B . Display the optional Validation Transform statistics
- C . View the rows and the values being loaded
- D . Schedule a job for daily execution
- E . Display trace and monitor and error logs.
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
- A . On the view data tab
- B . In the impact and lineage analysis
- C . In the monitor log
- D . In the trace log
What is the SAP Data services Dataflow auditing feature used for? Note: There are 2 correct answers to this question.
- A . To count the number of rows processed at user defined points to collect runtime statistics
- B . To define rules based on the number of records processed overall once the dataflow is finished
- C . to define rules that each record processed by the dataflow has to comply with
- D . To view the data as it is processed by the dataflow in order to ensure its correctness
What does the expression SUBSTR(FIRST NAME, 1,3) return?
- A . U
- B . M
- C . FIR
- D . IRS
In SAP Data Services why would you select the produce default output checkbox in the Case transform?
- A . To output all rows that match the case statement
- B . to output all rows that do match exactly one case expression
- C . To output all rows to the default path regardless if the they match the case expressions.
- D . To output all rows that do not match any case expression to the default path
In SAP Data Services which basic operations can you perform with a Query transform?
- A . "Join data from several sources"
- B . "Apply functions to columns"
- C . Map Columns from an input schema to an output schema"
- D . Flag rows for update
- E . Set a global variable to a value
Which type of SAP Data Services object can a project, job, dataflow or workflow contain? 3 correct answers
- A . A Project can contain a job
- B . A job can contain a job
- C . A dataflow can contain a workflow
- D . A job can contain a workflow
- E . A workflow can contain a workflow
Why would you specify Recover as a Unit in the property of a workflow in SAP Data Services?
- A . To ensure that all objects of the workflow are executed during recovery including the steps that were executed successfully in the prior run
- B . To ensure that the workflow is skipped during recovery if the workflow was executed successfully in the prior run.
- C . To ensure that all dataflow of the workflow are executed in one single transaction during recovery
- D . To ensure that each dataflow is recovered as a separate unit during the recovery execution
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
- A . Inserted and updated rows but not delete rows
- B . Insert, updates and deletes for a specified time range.
- C . Update rows but NOT insert or deleted records.
- D . Every single change made to a row
In SAP Data Services what do you use implement a target-based delta that deals with inserts, update and deletes in the source.
- A . Table comparison transform
- B . A Map_CDC_Operation transform
- C . The auto correct load
- D . A Map_Operation transform
What transform can you use to change the operation code from UPDATE to INSERT in SAP Data
S ervices? Note: There are 2 correct answers to this question
- A . query
- B . Key generation
- C . Map operation
- D . History Preserving
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?
- A . Before the pivot transform
- B . Between the pivot transform and the query transform
- C . After the query transform
- D . Before the pivot transform and after the query transform.
How do you desing a data load that has good performance and deals with interrupted loads in SAP Data services?
- A . by setting the target table loader with Bulk Load and Auto Correct Load enabled.
- B . by setting the target table loader with bulk load enabled
- C . By using the table comparison transform
- D . By creating two dataflows and executing the Auto Correct Load version when reired
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.
- A . default value
- B . Format information
- C . field size
- D . data type
- E . comment
How do you allow a new team member to view the SAP Data Services repository in read only mode?
- A . Use the central repository in the Desinger
- B . Export the repository’s metadata to an XML file and open it in a browser.
- C . Copy the repository and view the copy in the repository manager.
- D . Use the Auto Documentation feature in the Management Console
An SAP data services job was executed in the past.
Where can you see the order that the dataflows were executed in? There are 2 correct answers to this question.
- A . In the operational dashboard
- B . In the impact and Lineage Analysis report
- C . In the job trace log.
- D . In the job server log
You SAP Data Services job design 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
- A . The job executes the scripts if it is part of a workflow marked as a recovery unit, but only if an error was raised
- B . The job executes the scripts if it is part of a workflow marked as a recovery unit irrespective of where the error ocurred in the job flow.
- C . the job starts with the flow that caused the error. If this flow is after the initialization script the initialization script is skipped.
- D . The job reruns all workflows and scripts. When using automatic recovery, only dataflows that ran successfully in the previous execution ^ are skipped.
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?
- A . Map_Operation transform
- B . Validation transform
- C . Case transform
- D . Country ID transform
What operations can be pushed down in SAP Data Services?
- A . Aggregation operations used with a group by statement
- B . join operations between a file and a database table
- C . Load operations that contain trigger
- D . Join operations between sources that are on the same database servers
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.
- A . by opening the auto documentation page in the Data Services Management Console
- B . By enabling corresponding trace options in the job execution dialog.
- C . By opening the dataflow and using the view optimized SQL feature.
- D . By starting the job in debubg mode.
What can you use a workflow for in SAP Data Services?
- A . To group data flows that belong together
- B . To group jobs that you want to monitor
- C . to allow schedulling for dataflows
- D . To transform source data into target data
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
- A . workflow
- B . subdataflow
- C . JOB
- D . Dataflow
- E . Embedded dataflow
An SAP Data Services dataflow adds the changed data (insert and update) into a target table every day.
How do you design the dataflow to ensure that a partially executed dataflow recovers automatically the next time it is executed?
2 correct answers
- A . Enable the Delete data before load target table loader option
- B . Add lookup function in the where clause to filter out existing rows.
- C . Set the autocorrect load option in the target table loader option
- D . Use the table comparison transform before the table loader
What errors can you handle in SAP Services when you use a file format target?
- A . Semantic error
- B . Data type conversion error
- C . Row- format error
- D . File type error
How do you view the data between transforms in SAP Data Services dataflow?
- A . By setting the Audit Data On job execution trace option
- B . By using the interactive debugger
- C . By setting the SQL Transforms on job execution trace option
- D . By adding audit points in the dataflow
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?
- A . Use a script with an SQL function to read from status table
- B . Use a catch block and set the variable to ‘yes1
- C . Use a dataflow to set the value via a template table
- D . Use a global variable to persist the value across job executions
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
- A . Checksum
- B . Average
- C . Count distinct
- D . sum
- E . Min
An SAP Data Services dataflow has validation error. What is the cause?
- A . The dataflow has a syntax error that has to be correct before executing it.
- B . The source data does NOT comply with the rules entered in the Validation transform
- C . The source data is incorrect and the dataflow therefore requires a validation transform.
- D . A conversion is missing
What application do you use to display the graphical representations of all Sap Data Services objects including their relationships and properties?
- A . Operational Dashborad
- B . Autodocumentation
- C . Impact and lineage Analysis
- D . Data quality reports
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
- A . Click the view enabled descriptions button on the toolbar.
- B . Enter a description in the properties of the object.
- C . right-click the object then choose enable description .
- D . Right – click on the job in the project hierarchy to enable all descriptions.
- E . disiable the hide non – executable elements setting in the difference viewer.