C_DS_42 Online Practice Questions and Answers

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

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

How to Open the target table editor to view the Schema In and Schema Out?

A. Double click the target table.

B. Click the View Data icon (magnifying glass) for the target table in the workspace.

C. Close both view data windows.

D. Double click the target table

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

To ensure that your job is processing the data correctly, you wan to run the job in debug mode. To minimize the data you have to review in the interactive debugger, you set the debug option process to show only records from an individual CountryID field value. In the Cloud/WTS environment, the Designer will not allow multiple users to share the interactive debugger port. Change the interactive debugger port in Designer options.

A. From the main menu, choose Tools Options

B. From the Designer options, choose Environment

C. In the Interactive Debugger field, enter port number 60XX . A dialog box with the message "Overwrite job server option parameters (BODI1260099)" opens. To continue, choose Yes and click ok

D. In the Filter window, select the Set checkbox

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 In the Alpha_NACustomer_DF workspace, delete an existing expression for the Country column in

the Query transform.

A. In the Mapping tab, choose Functions.

B. In the Select Function dialog box, choose Lookup Functions.

C. the Alpha_NACustomer_DF workspace, to open the transform editor, double click the Query transform.

D. In the Query Editor, in the output schema, choose the field Country.

E. In the Mapping tab for the Country field, delete the existing expression.

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 Now that the expression can calculate the total of the order values, make it possible for the Query to begin at the first order through the end of the records in the table by using the Group By tab.

A. On the Mapping tab of the TOTAL_VALUE column, enter the expression:

B. In the Query Editor , select the Group By tab.

C. In the Schema In column, select the ORDERID field from the ORDER_DETAILS table and drag it to the Group By tab.

D. Close the Editor.

Where is an SAP Data Services job executed?

A. Access server

B. Job server

C. Designer application

D. Management console