C_DS_42 Online Practice Questions and Answers

By which application you do Evaluate the reliability of your target data based on the validation rules you created in your batch jobs. Quickly review, assess, and identify potential inconsistencies or errors in source data?

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

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

What do you call for that particular link of Clicking to Click to open the Documentation Map, which lists the SAP Data Services technical documentation available to end users or administrators, and a link to the customer portal where you can find the latest versions of the documentation?

A. Settings

B. Home

C. Logout

D. Question mark icon

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

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

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

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 Using the Function wizard, create a new expression for the column using the search_replace function found under the category of "String" functions.

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

B. In the Query Editor , in the Mapping tab, choose Functions.

C. In the Select Function dialog box, choose String Functions .

D. From the list of function names, select search_replace and choose Next .

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.

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.

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)

Your customer has rules requiring that each row in the source be tested for certain criteria in a specific

order. When a row passes one criteria, it should NOT be tested for the next criteria.

How should this be implemented using SAP Data Services transforms? Please choose the correct answer.

A. Use multiple Query transforms with one WHERE? clause per rule. Connect all queries to the source.

B. Use a Case transform with the Row Can Be True for One Case Only and Preserve Expression Order options enabled.

C. se a Case transform with the Produce Default Output with Label option enabled, and enable the Preserve Expression Order checkbox.

D. Use a Validation transform and add the rules in the proper order for each single column.

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.

Which syntax rules must you follow in the SAP Data Services scripting language?

A. A statement ends with a dot sign (.).

B. A variable starts with a percent sign (%).

C. A comment starts with a hash (#).

D. A variable starts with a dollar sign ($).