C_DS_42 Online Practice Questions and Answers

By which application you do View dashboards that provide at-aglance statistics, status, and performance of your job executions for one or more repositories over a given time period?

A. Administrator

B. Impact and Lineage Analysis

C. Operational Dashboard

D. Data Validation Dashboard

E. Auto Documentation

F. Data Quality Reports

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

Where does An administrator sets user permissions?

A. Central Management Server (CMS)

B. Management Console

C. Data Services Management Console

D. Management Console navigation

Contains Access Server names associated with the which type of service. Which is the actual option to see jobs status?

A. Batch

B. Real-Time

C. Adapters

D. Profiler

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

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

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

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 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 transform editor for the Query transform, propose a join between the two source tables.

A. To open the Query Editor double click the Query .

B. To connect the Query Transform, select the Query Transform , hold down the mouse button, drag it to the order_sum table, and release the mouse button.

C. Choose the Where tab or the From tab.

D. the Propose Join button.

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.

_________through which SAP Data Services connects to this SAP application server. Use the same user name used to create the SAP BW Source datastore.

A. RFC program ID

B. SAP application server name

C. Client number

D. User Name

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 In the Local Object Library, create a new customer function called CF_MarketingOffer.

A. In the Local Object Library, choose the Custom Functions tab.

B. Enter the name Alpha_Marketing_Offer_Job.

C. In the tool palette, select the Data Flow icon and click in the workspace.

D. Enter the name CF_MarketingOffer, and choose Next.

E. the Smart Editor, choose the Variables tab.

You have a Salary table containing departments (DEPARTMENT column) and salaries (SALARY column). How do you calculate the average salaries for each department in the Query transform in SAP Data Services?

A. Specify the DEPARTMENT column on the GROUP BY tab.

B. Enter avg(SALARY) on the Mapping tab.

C. Enter avg(SALARY) on the SELECT tab.

D. Specify the DEPARTMENT code on the WHERE tab.

During development of a SAP Data Services dataflow, you find that the source system contains data

inconsistencies.

What transform allows you to define rules and monitor the conformance of the data for every load?

A. Validation transform

B. Query transform

C. SQL transform

D. Case transform