[Q10-Q26] Free C-DS-42 Exam Files Downloaded Instantly UPDATED [2024] : Testking Free Dumps : http://blog.testkingfree.com

NO.10 You want to set up a new SAP Data Services landscape. You must also create new repositories. Which repository types can you create?

Central repository

Standy repository

Backup repository

Local repository

Profiler repository

NO.11 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.12 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 create a new batch job called Alpha_Order_Sum_Job with a data flow Alpha_Order_Sum_DF .

Choose the Where tab or the From tab.

Choose the Propose Join button.

the Project area , right click your Omega project and choose New batch job.

Enter the job name Alpha_Order_Sum_Job .

In the Alpha_Order_Sum_Job workspace, from the toolbar, choose the Data Flow icon.

NO.13 In SAP Data Services what do you use implement a target-based delta that deals with inserts, update and deletes in the source.

Table comparison transform

A Map_CDC_Operation transform

The auto correct load

A Map_Operation transform

NO.14 Which type of SAP Data Services object can a project, job, dataflow or workflow contain? 3 correct answers

A Project can contain a job

A job can contain a job

A dataflow can contain a workflow

A job can contain a workflow

A workflow can contain a workflow

NO.15 A new developer joined the project team. You already created a new SAP Data Services repository for this member.
Where do you manage the security setting for this new repository?

Data Services Designer

Central Management console

Repository manager

Repository database

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

U

M

FIR

IRS

NO.17 Management Console is written in which language?

XML

.net

Html

Java

NO.18 You modified an existing SAP data Services job. You notice that the run time is now longer then expected. Where in SAP Data Services can you observe the progress of row counts to determine the location of a bottleneck

On the view data tab

In the impact and lineage analysis

In the monitor log

In the trace log

NO.19 How do you allow a new team member to view the SAP Data Services repository in read only mode?

Use the central repository in the Desinger

Export the repository’s metadata to an XML file and open it in a browser.

Copy the repository and view the copy in the repository manager.

Use the Auto Documentation feature in the Management Console

NO.20 You want to execute two dataflows in parallel in SAP Data Services. How can you achieve this?

Create a workflow containing two dataflows and connect them with a line.

Create a workflow containing two dataflows without connecting them with a line.

Create a workflow containg two dataflows and deselect the execute Only once property of the workflow.

Create a workflow containing two dataflows and set a degree of parallelism to 2.

NO.21 An SAP Data Services dataflow contains multiple transform objects. The target table contains some unexpected results for one column.
How can you review a sample of the data as it passes through each transform?

Execute the job and review the target table in SQL.

Execute the job in debug mode with breakpoints set and enabled.

Execute the job that enables the Trace Optimized Dataflow property.

Execute the job and review the monitor during execution.

NO.22 What task can you perform in the SAP Data Services Management Console? Note: There are 3 correct answers to this question

Debug a dataflow to find data issues

Display the optional Validation Transform statistics

View the rows and the values being loaded

Schedule a job for daily execution

Display trace and monitor and error logs.

NO.23 You have a map operation transform immediately before the target in a data flow in Sap Data Services. What happens if all operation codes are mapped to Discard in the transform?

They are flagged for later deletion

They are deleted from the target

They are added to the overflow file

They are filtered by the transform

NO.24 which transform are typically used to implement a slowly changing dimension of type 2 in SAP Data services?
3 correct answers

Data_Transfer

History_Preserving

Map_CDC_Operation

Key_Generation

Table_comparison

NO.25 You must ensure that all records from the Customer table in the Alpha database are being moved to the Delta staging database using the audit logs.
In the Local Object Library, replicate the Alpha_NACustomer_DF data flow.
Name the replicated data flow Alpha_AuditCustomer_DF . Add the replicated data flow to a new job, Alpha_AuditCustomer_Job . Set up auditing on the data flow Alpha_AuditCustomer_DF by adding an audit rule to compare the total number of records in the source and target tables.
How to Save all changes and execute the job with auditing enabled and Trace Audit Data set to Yes

To remove the existing audit rule, choose Delete

Choose Add and select Custom .

Right-click the Alpha_AuditCustomer_Job and choose Execute .

In the Execution Properties dialog box, in the Execution Options tab, select the Enable auditing checkbox.

In the Trace tab, choose Trace Audit Data .

In the Value field, using the drop down list, change the value to Yes.

NO.26 You define audit rules for critical data flow to confirm that you SAP Data Services batch job loaded only correct dat a. Which audit functions are available to define these rules for columns? Note: There are 3 correct answers

Checksum

Average

Count distinct

sum

Min