[2026] SAP Certified Application Associate - Data Integration with SAP Data Services

문제1

You want to load data from an input table to an output table using the SAP Data Services Query transform. How do you define the mapping of the columns within a Query transform?

A. Drag one column from the input schema to the output schema

B. Select an output column and enter the mapping manually.

C. Drag one column from the output schema to the input schema

D. Select one input column and enter the mapping manually

정답: D

문제2

You decide to distribute the execution of a job across multiple job servers within a server group. What distribution levels are available? 3 answers correct

A. JOB

B. workflow

C. subdataflow

D. Embedded dataflow

E. Dataflow

정답: A,C,E

설명: (Fast2test 회원만 볼 수 있음)

문제3

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 design this requirement in SAP Data services.

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

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

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

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

정답: C

문제4

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

A. History Preserving

B. Map operation

C. query

D. Key generation

정답: A,B

문제5

A target column named ZIP4 requires the input of the source columns: POSTCODE and EXTENSION. For example:
POSTECODE:99999
EXTENSION: 9999
Desired result is ZIP4:99999-9999

A. POSTCODE ||'-'|| EXTENSION

B. POSTCODE AND '-' AND EXTENSION

C. POSTCODE +'-*+ EXTENSION

D. rpad_ext(POSTCPDE,EXTENSION)

정답: A

문제6

You have to load a file that contains the following first three lines:
YEAR; MONTH; PLAN_AMOUNT
2014;01;100.00
2014;02;110.00
What setting do you use when you created a file format for this?

A. Type: Delimited column delimiter:; skip row headen: no

B. Type: Delimited column delimiter:; skip row headen: yes

C. Type: Fixed column length:4,2 and 6 skip row headen: yes

D. Type: Delimited column delimiter:<blank> skip row headen: yes

정답: B

문제7

In which situation is it appropriate to use a time - based CDC to capture changes in source data with SAP Data services

A. When almost all of the rows have changes

B. when you need to capture physical deletes from source

C. When there are large tables with few changes

D. When you need to capture intermediate changes

정답: C

문제8

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

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

B. Set the autocorrect load option in the target table loader option

C. Use the table comparison transform before the table loader

D. Enable the Delete data before load target table loader option

정답: A,C

문제9

What operations can be pushed down in SAP Data Services?

A. Load operations that contain trigger

B. Aggregation operations used with a group by statement

C. join operations between a file and a database table

D. Join operations between sources that are on the same database servers

정답: D

SAP Certified Application Associate - Data Integration with SAP Data Services - C-DS-43무료 덤프문제 풀어보기

우리와 연락하기

유용한 링크

최신 업데이트