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

By which application you do View dashboards that provide at-aglance statistics, status, and performance of your job executions for one or more repositories over a given time period?

A. Administrator

B. Impact and Lineage Analysis

C. Operational Dashboard

D. Data Validation Dashboard

E. Auto Documentation

F. Data Quality Reports

Contains the repository name associated with the ________ Server?

A. Batch

B. Real-Time

C. Adapters

D. Profiler

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

A. For the source

B. For the Target

C. For the staging databases

D. None of the above

In addition to the main databases for source information, records for orders are stored in flat files. You

need to extract data from these flat files, and so must create the appropriate file format for the extraction.

Adjust the data types for the columns proposed by the Designer based on their content.

(Validate the correct statement).

A. In the Local Objects Library, choose Formats tab.

B. Right click the Flat Files node and choose New.

C. Enter Orders_Format as the format name.

D. In the Column Attributes pane, change the field datatypes to the datatypes in the Column Attributes Values table.

E. In the ORDERDATE field, to change the format of the date, enter dd-mon-yyyy .

F. Choose Save and close .

In the Omega project, How to create a new batch job Alpha_Product_Job with a new data flow, Alpha_Product_DF?

A. In the Project menu, choose New Project

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

C. Enter the job name, Alpha_Product_Job and, on your keyboard, press the Enter key. The job should open automatically. If it does not, open it by double-clicking.

D. In the Alpha_Product_Job workspace, in the tool palette, choose the Data Flow icon.

E. Click in the workspace where you want to add the data flow, and enter the name Alpha_Product_DF.

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 Replicate the Audit_NACustomer_DF data flow.

A. In the Local Object Library Data Flow tab right click the Alpha_NACustomer_DF data flow and choose Replicate

B. Rename the copied data flow Alpha_AuditCustomer_DF.

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 calculate the total value of all orders, including their discounts, for reporting purposes. Currently

these details are found in different tables. Use the sum function to calculate the total value of orders in the

Order_Details table.

How to In the transform editor for the Query transform, propose a join between the two source tables.

A. To open the Query Editor double click the Query .

B. To connect the Query Transform, select the Query Transform , hold down the mouse button, drag it to the order_sum table, and release the mouse button.

C. Choose the Where tab or the From tab.

D. the Propose Join button.

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)