C_DS_43 Premium Exam Engine - Download Free PDF Questions [Q49-Q68] : Free valid test braindumps : http://free.validbraindumps.com

QUESTION 49
Which of the following administrative tasks can you perform using the SAP Data Services Management Console?

Schedule a batch job

Edit the initialization script of a job

edit the system configuration

Configure an adapter

QUESTION 50
An SAP Data Services dataflow adds the changed data (insert and update) into a target table every day.
How do you design the dataflow to ensure that a partially executed dataflow recovers automatically the next time it is executed?
2 correct answers

Enable the Delete data before load target table loader option

Add lookup function in the where clause to filter out existing rows.

Set the autocorrect load option in the target table loader option

Use the table comparison transform before the table loader

QUESTION 51
What transform can you use to change the operation code from UPDATE to INSERT in SAP Data Services? Note: There are 2 correct answers to this question

query

Key generation

Map operation

History Preserving

QUESTION 52
What is the relationship between local variables and parameters in SAP Data Services? 2 correct answers

a local variable in a workflow sets the value of an a parameter in a dataflow.

3 local variable in a job sets the value of an a parameter in a workflow

a parameter in a workflow sets the value of a local variable in a dataflow

a parameter in a job set the value of a local variable in a dataflow

QUESTION 53
You want to use on SAP data services transform to split your source vendor data into three branches, based on the country code.
Which transform do you use?

Map_Operation transform

Validation transform

Case transform

Country ID transform

QUESTION 54
You source table has a revenue column and a quantity column for each month. You want to transform this data to get a table containing twelve rows whit two columns.
What is the best way to achieve this in SAP Data services?

Use twelve query transform to create the desired output. Then combine these transforms.

Use the query transform with multiple IFTHENELSE() functions.

Use the merge transform that is connected to the source

Use the pivot transform with two pivot sets.

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

QUESTION 56
You are joining tables using the query transform of SAP Data Services.

Maximum of two tables

Left outer joins and inner joins

Only equal conditions

Only inner joins

QUESTION 57
What are advantages of using the validation transform in SAP Data services? There are 3 correct answers to this question

You can see which rules were violated in one output

You can set different failed paths for each rule

You can have multiple rules on a single column.

You can produce statistics

You can call a recovery dataflow

QUESTION 58
You create a file format in SAP Data Services
What properties can you set for a column?
Note: There are 3 correct answers to this question.

default value

Format information

field size

data type

comment

QUESTION 59
What does the data services repository of SAP Data services contain?
There are 2 correct answers to this question

in flight data

Target metadata

Transformation rules

User security

QUESTION 60
You are instructed to calculate the maximum value in the SALARY column of an EMPLOYEE table.
How can you achieve this in SAP Data Services?

Use max (SALARY) in a script.

Use max(SALARY) in a conditional

Call max(SALARY) from a Custom function

Enter max (SALARY) in the query transform

QUESTION 61
You have a workflow containing two dataflows. The second dataflow should only run if the first one finished successfully.
How would you achieve this in SAP Data Services.

Use a conditional for the second dataflow

Embed the first dataflow in a try-catch

Add a script between the dataflows using the error_number() function

Connect the two dataflows with line

QUESTION 62
How would you use the View Optimized SQL feature to optimize the SQL feature to optimize the performance of the dataflow?

View and modify the overall optimization plan of a data services engine

View and modify the SQL to improve performance

View and modify the SQL and adjust the dataflow to maximize push-down operations.

View and modify the database execution plan within the Data Services Designer

QUESTION 63
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

QUESTION 64
You are loading a database table using SAP Data Services. Which loading options are valid? Note: There are 3 correct answers to this question.

Abap execution option

Number of loader

Rows per commit

Data transfer method

Include in transaction

QUESTION 65
You executed a job in development environment and it raised primary key violation error in SAP Data Services. Which feature do you enable to identify which primary key values caused the errors?

Drop and re-created target table

Use overflow file

delete data before loading

Auto correct load

QUESTION 66
What application do you use to display the graphical representations of all Sap Data Services objects including their relationships and properties?

Operational Dashborad

Autodocumentation

Impact and lineage Analysis

Data quality reports

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

QUESTION 68
What requirement must you meet when mapping an output column on the SAP Data Services query transform mapping tab?

Primary keys in the input schema must be mapped to only one column in the output schema

Each column in the output schema must be mapped to one or more columns in the input schema

All columns of the input schema must be mapped to the output schema

Every column of the output schema must have a mapping

C_DS_43 Premium Exam Engine - Download Free PDF Questions [Q49-Q68]

SAP C_DS_43 Exam Syllabus Topics: