C_DS_42 Online Practice Questions and Answers

By which application you do View, analyze, and print graphical representations of all objects as depicted in the Designer including their relationships, properties, and more?

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

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.

In the transform editor for the Query transform, How to map all columns from the Schema In to the Schema Out?

A. In the Query editor, choose the WHERE tab.

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

C. To select all columns in the Schema In , choose the CUSTOMERID column, hold the shift key, and choose the PHONE column

D. Drag all columns to the Schema Out

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

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

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.