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

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 .

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.

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 the SAP RFC destination to which this RFC Server will connect?

A. RFC program ID

B. SAP application server name

C. Client number

D. System number

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

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.

You are designing an SAP Data Services process.

This process must execute ONLY if a defined expression is true.

Which object allows you to accomplish this task?

A. Validation transform

B. Try/catch block

C. Conditional

D. Case transform

What are characteristics of SAP Data Services workflows?

A. A workflow can call other workflows.

B. A workflow can contain a conditional object.

C. A job needs to have at least one workflow.

D. A workflow must contain a dataflow.