[Sep-2023] SAP C-DS-42 Exam Basic Questions With Answers [Q11-Q32]

Rate this post

[Sep-2023] SAP C-DS-42 Exam: Basic Questions With Answers

New 2023 Realistic Free SAP C-DS-42 Exam Dump Questions and Answer

NO.11 In SAP Data services which function delivers the same results an nested 1FTHENELSE functions?

Match_Pattern

Decode

Literal

Match_regex

NO.12 You want to display the description of an object in the Designer workspace-Which task must you perform to accomplish this in SAP Data services?
3 correct answers

Click the view enabled descriptions button on the toolbar.

Enter a description in the properties of the object.

right-click the object then choose enable description .

Right – click on the job in the project hierarchy to enable all descriptions.

disiable the hide non – executable elements setting in the difference viewer.

NO.13 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?

Validation transform

Query transform

SQL transform

Case transform

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

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

In the Query Editor , select the Group By tab.

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

Close the Editor.

NO.15 You want to restore an older version of an object found in a shared object library.
Where do you find this version of the object in SAP Data Services?

O In the Central repository

O In the Local repository

O In the Profiler repository

O In the Auditing repository

NO.16 Why would you specify Recover as a Unit in the property of a workflow in SAP Data Services?

To ensure that all objects of the workflow are executed during recovery including the steps that were executed successfully in the prior run

To ensure that the workflow is skipped during recovery if the workflow was executed successfully in the prior run.

To ensure that all dataflow of the workflow are executed in one single transaction during recovery

To ensure that each dataflow is recovered as a separate unit during the recovery execution

NO.17 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?

Invoke sleep interval (seconds)

Submit sleep interval (seconds)

Inactive interval (minutes)

Active Interval (Seconds)

NO.18 A SAP Data Services job contain logic to execute different dataflows depending on whether the job was successful or failed. Therefore the $NEEDS_RECOVERY variable should be set to either ‘Yes’ or ‘No’. How do you assign the value to the $NEEDS_RECOVERY variable?

Use a script with an SQL function to read from status table

Use a catch block and set the variable to ‘yes1

Use a dataflow to set the value via a template table

Use a global variable to persist the value across job executions

NO.19 The performance of a dataflow is slow in SAP Data Services.
How can you see which part of the operations is pushed down to the source database? Note: the are 2 correct answers to this question.

by opening the auto documentation page in the Data Services Management Console

By enabling corresponding trace options in the job execution dialog.

By opening the dataflow and using the view optimized SQL feature.

By starting the job in debubg mode.

NO.20 What errors can you handle in SAP Services when you use a file format target?

Semantic error

Data type conversion error

Row- format error

File type error

NO.21 What operation can you push down to the database using a data transfer transform in SAP Data Services? 3 answers correct

Custom function

XML function

Join

Ordering

Distinct

NO.22 In the Omega project, How to create a new batch job Alpha_Product_Job with a new data flow, Alpha_Product_DF?

In the Project menu, choose New Project

In the Project area, right-click the project name and, in the context menu, choose New Batch Job

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.

In the Alpha_Product_Job workspace, in the tool palette, choose the Data Flow icon.

Click in the workspace where you want to add the data flow, and enter the name Alpha_Product_DF.

NO.23 What does the expression SUBSTR(FIRST NAME, 1,3) return?

FIR

IRS

NO.24 You import a table from a database into a datastore.
Which information is added into the SAP Data Services repository?

The complete metadata information of the table

Only the table name

The whole table with all its source data

The table name and all column names with their dataypes.

NO.25 You developed a batch job using SAP Data Services and want yo start an execution. How can you execute the job?
2 correct answers

“Execute the job manually in the Data Services Designer.”

Use the scheduler in the Data Services Designer

Use the debug option in the Data Services Management console

Use the scheduler in the Data Services Management Console

NO.26 A dataflow contain a pivot transform followed by a query transform that performs an aggregation. The Aggregation query should by pushed down to the database in SAP Data services.
Where would you place the Data_Transfer transform to do this?

Before the pivot transform

Between the pivot transform and the query transform

After the query transform

Before the pivot transform and after the query transform.

NO.27 Which feature in the SAP Data Services Management Console allows you to see the trend of the execution time for any given job?

data quality reports

monitor log

Operational dashboard

trace log

NO.28 An SAP data services file format has a date column, but occasionally the file contains an invalid value in one row.This causes the dataflow to terminate with an error.
What can you do to completely load such erroneous files?
Note: There are 2 correct answer

Place the dataflow between a Try/Catch block to catch all erroneous rows

Use the error handling options for conversion error in the file format definition

Specify a date format of’????-??-??’ to indicate the value might NOT be a valid date in the file format editor

Define the column as varchar and use functions in subsequent Query transform to perform the checks and conversion

NO.29 You are asked to perform either the initial load or delta load based on the value of a variable that is set at job execution How do you desing this requirement in SAP Data services.

Set the job to call the initial and delta dataflow in parallel. Each dataflow should hace a filter testing for the variable value.

Use a job containing a script with the if thenelse () function to test the variable value. Connect this script to the initial and delta u dataflow.

Use a job containing a Case transform testing for the two possible conditions. Connect one case output to the initial dataflow and the other to the delta dataflow Use a job container the delta dataflow

Use a job containing a Conditional objet that test the value of the variable. In the IF part, call the initial dataflow in the ELSE part call

NO.30 Management Console is written in which language?

XML

.net

Html

Java

NO.31 In which of the following objects can you use built-in- functions in SAP Data services? Note: There are 3 correct answers to this question

Merge transform

Conditionals

Query transform

Scripts

Map CDC transform

NO.32 A SAP Data Services job contain logic to execute different dataflows depending on whether the job was successful or failed. Therefore the $NEEDS_RECOVERY variable should be set to either ‘Yes’ or ‘No’. How do you assign the value to the $NEEDS_RECOVERY variable?

Use a script with an SQL function to read from status table

Use a catch block and set the variable to ‘yes1

Use a dataflow to set the value via a template table

Use a global variable to persist the value accros job executions