C_DS_42 Online Practice Questions and Answers

Contains repository names that are associated with the Job Server on which you run your jobs. Which is the actual option to see jobs status?

A. Batch

B. Real-Time

C. Adapters

D. Profiler

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. Create a file format Orders_Format for an orders flat file so that you can use it as a source object for extraction. (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. Right click your new file format Orders_Format and choose View Data .

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

When evaluating the customer data for Alpha Acquisitions, you discover a data entry error. The contact title of "Account Manager" has been entered as "Accounting Manager". You must correct these entries before it is moved to the data warehouse. How to In the Alpha_NACustomer_DF workspace, delete an existing expression for the Title column in the Query transform.

A. In the Alpha_NACustomer_DF workspace, to open the Query Editor, double click the Query transform.

B. In the Query Editor, in the output schema, choose the field CONTACTTITLE .

C. To delete existing expression, in the Mapping tab highlight the expression and press the Delete button on your keyboard.

D. In the Search_replace Select Parameters dialog box, select the drop down arrow next to the field Input expression.

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.

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)

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.