Management Console contains a collection of Web-based applications for administering the following Data Services features and objects.

A. Object relationship analysis

B. Job execution performance evaluation

C. Jobs and services executions

D. Data Processing

By which application you do Manage your production environment including batch job execution, real-time services, web services, adapter instances, server groups, central repositories, profiler repositories, and more?

A. Administrator

B. Impact and Lineage Analysis

C. Operational Dashboard

D. Data Validation Dashboard

E. Auto Documentation

F. Data Quality Reports

In the workspace for Alpha_Product_DF, How to add the product table from the Alpha datastore as the source object?

A. In the Project area, right-click the project name and, in the context menu, choose New Batch Job .

B. In the Local Object Library , choose the Datastores tab.

C. Select the product table from the Alpha datastore.

D. Drag the table to the data flow workspace and choose Make Source.

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.

A. Open the workspace for the Alpha_NACustomer_DF and Right click the connection between the source table and the Query Transform and choose Set Filter/Breakpoint

B. In the Filter window, select the Set checkbox

C. In the workspace for the Alpha_NACustomer_DF , right click the connection between the source table and the Query transform, and choose Remove Filter

D. Right click the connection between the source table and the Query transform, and choose Set Filter/ Breakpointe

E. In the Breakpoint window, select the Set checkbox

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 .

A. Drag the Alpha_AuditCustomer_DF from the Local Object Library to the

B. Alpha_AuditCustomer_Job workspace.

C. Right click the Omega project in the Project Area.

D. Choose New Batch Job

E. Name the new job Alpha_AuditCustomer_Job .

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 Modify the data flow to send customers outside North America to a second template table, Alpha_Other_customer .

A. Click in the data flow workspace to add a new template table below the Alpha_NA_customer target table.

B. Choose Execute .

C. In the Execution Properties dialog box, choose the Execution Options tab, and select the Enable auditing checkbox.

D. Name the new template table Alpha_Other_customer .

E. Create the table in datastore Delta .

F. Choose OK .

G. Add a second Query transform to the data flow

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 Save all changes and execute the job with auditing enabled and Trace Audit Data set to Yes

A. To remove the existing audit rule, choose Delete

B. Choose Add and select Custom .

C. Right-click the Alpha_AuditCustomer_Job and choose Execute .

D. In the Execution Properties dialog box, in the Execution Options tab, select the Enable auditing checkbox.

E. In the Trace tab, choose Trace Audit Data .

F. In the Value field, using the drop down list, change the value to Yes.

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?

A. Invoke sleep interval (seconds)

B. Submit sleep interval (seconds)

C. Inactive interval (minutes)

D. Active Interval (Seconds)

What are task's of data Services uses the SAP RFC Server Interface?

A. Scheduling SAP jobs

B. Reading from SAP Open Hub destinations

C. Loading SAP NetWeaver BW

D. Viewing Data Services logs from SAP NetWeaver BW

E. None of above

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.

How to Create a new batch job and data flow, called Alpha_Marketing_Offer_Job and

_Marketing_Offer_DF respectively, and a new global variable $G_Num_to_Qual.

A. In the Smart Editor, choose the Variables tab.

B. Right click Parameters and choose Insert.

C. In the project area, right click the Omega project and choose New batch job

D. Enter the name Alpha_Marketing_Offer_Job.

E. In the tool palette, select the Data Flow icon and click in the workspace.

F. Enter the name Alpha_Marketing_Offer_DF.