C_DS_42 Online Practice Questions and Answers

By which application you do View and export reports for batch and realtime jobs, such as job summaries and data quality transform reports?

A. Administrator

B. Impact and Lineage Analysis

C. Operational Dashboard

D. Data Validation Dashboard

E. Auto Documentation

F. Data Quality Reports

What do you call for that particular link of Clicking to open a dialog box for changing a variety of options depending on the selected application?

A. Settings

B. Home

C. Logout

D. Question mark icon

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

A. Batch

B. Real-Time

C. Adapters

D. Profiler

You are an ETL developer working on a data warehousing project. You need to load data from the product

table and create a table for North American customers.

How to Create a new project called Omega?

A. In the Project menu, choose New Project.

B. In the Project New dialog box, in the Project name field, enter Omega.

C. Choose Create .The new project appears in the Project area.

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

How to Add the Query transform to the workspace between the source and target?

A. To open the Query Editor , in the data flow workspace, double click the Query transform.

B. To add a new Query template to the data flow, in the tool palette, choose the Query Transform icon, and click the workspace.

C. To connect the source table to the Query transform, select the source table, hold down the left mouse button, drag the cursor to the Query transform, and release the mouse button.

D. To connect the Query transform to the target template table, select the Query transform, hold down the left mouse button, drag the cursor to the target table, and release the mouse button.

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)?

A. In the Query editor, choose the WHERE tab

B. Enter the where clause, customer.COUNTRYID in (1,2,11)

C. To save all changes, choose OK

D. Confirm that 22 records were loaded

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 Enable auditing for the execution of the Alpha_AuditCustomer_Job .

A. Right-click the Alpha_AuditCustomer_Job .

B. Choose Execute .

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

D. Choose the Trace tab and choose Trace Audit Data .

E. Under Action on failure, select the Raise exception checkbox.

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 create a new batch job called Alpha_Order_Sum_Job with a data flow Alpha_Order_Sum_DF .

A. Choose the Where tab or the From tab.

B. Choose the Propose Join button.

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

D. Enter the job name Alpha_Order_Sum_Job .

E. In the Alpha_Order_Sum_Job workspace, from the toolbar, choose the Data Flow icon.

In which parameter the number of minutes a profiling task can be inactive before the Data Profiler cancels it?

A. Invoke sleep interval (seconds)

B. Submit sleep interval (seconds)

C. Inactive interval (minutes)

D. Active Interval (Seconds)