C_DS_42 Online Practice Questions and Answers

By which application you do Analyze the end-to-end impact and lineage for source and target objects used within the Data Services local repository?

A. Administrator

B. Impact and Lineage Analysis

C. Operational Dashboard

D. Data Validation Dashboard

E. Auto Documentation

F. Data Quality Reports

Contains repository names associated with the Job Server on which you run_______?

A. Batch

B. Real-Time

C. Adapters

D. Profiler

In the Omega project, How to create a new batch jobAlpha_NACustomer_Job with a new data flow called Alpha_NACustomer_DF?

A. In the Project area, right click the project name.

B. Choose New Batch Job.

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

D. In the tool palette, choose the Data Flow icon and Click the workspace where you want to add the data flow.

E. Name the data flow Alpha_NACustomer_DF and, on your keyboard, press Enter. The job should open automatically. If it does not, open it by double-clicking.

F. In the Local Object Library , select the Datastores tab

G. To save changes, choose OK

How to Save and execute the Alpha_NACustomer_Job?

A. In the main menu, choose Project Save All and To save all changes, choose OK

B. In the Project Area , right click the Alpha_NACustomer_Job and choose Execute and To accept the default execution properties, choose OK

C. To return to the Job workspace, in the tool bar, choose the Back icon and To return to the Data Flow workplace, double click the Data Flow.

D. In the Query editor, choose the WHERE tab

Execute the Alpha_NACustomer_Job in debug mode with a subset of records. In the workspace for the Alpha_NACustomer_Job , add a filter between the source and the Query transform to filter the records, so that only customers from the USA are included in the debug session?

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/ Breakpoint

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

A. Right-click the Alpha_AuditCustomer_Job and choose Execute .

B. To remove the existing audit rule, choose Delete

C. Choose Add and select Custom.

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 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.

A. In the Mapping tab, choose Functions.

B. To use the default execution properties, choose OK.

C. To return to the job workspace, on the toolbar, choose the Back icon.

D. To open the data flow workspace, double click the data flow.

E. Right click the target table and choose View Data.

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 Query transform, create a new output column TOTAL_VALUE , which will hold the new calculation.

A. To map the ORDERID column from the input schema to the same field in the output schema, select ORDERID and drag to the output schema

B. In the output schema, right click ORDERID and choose New output column.

C. Choose the Where tab or the From tab.

D. Choose Insert Below.

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.