最新的SAP Certified Application Associate認證 C_DS_43考試題庫

問題1

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. Enable the Delete data before load target table loader option

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

C. Use the table comparison transform before the table loader

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

正確答案: B,C

問題2

From the account table you want to know how many accounts you have per account type. The ACCOUNT_TYPE is output along with an additional column COUNTER. The group by tab of the query transform is used with ACCOUNT_TYPE. Which mapping would you use for the COUNTER column in SAP Data Services?

A. count(Account_type)

B. count_distinct(Account_TYPE)

C. Count(*)

D. Gen_Row_Num()

正確答案: A

問題3

How do you desing a data load that has good performance and deals with interrupted loads in SAP Data services?

A. by setting the target table loader with Bulk Load and Auto Correct Load enabled.

B. by setting the target table loader with bulk load enabled

C. By creating two dataflows and executing the Auto Correct Load version when reired

D. By using the table comparison transform

正確答案: C

問題4

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?

A. After the query transform

B. Before the pivot transform

C. Before the pivot transform and after the query transform.

D. Between the pivot transform and the query transform

正確答案: D

問題5

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

A. when you need to capture physical deletes from source

B. When you need to capture intermediate changes

C. When there are large tables with few changes

D. When almost all of the rows have changes

正確答案: C

問題6

You execute an SAP data services job with enable recovery activated. One of the dataflows in the jobs raises an exception that interrupts the execution. You run the job again with Recover from last failed execution enabled. What happens to the data flow that raised the exception during the first execution?

A. It is rerun from the beginning and the partially loaded data is always handled automanticaly.

B. It is rerun only if the dataflow is part of a recovery unit.

C. Is is rerun with the first failed row.

D. It is rerun from the beginning and the desing of the data flow must deal with partially loaded data.

正確答案: C

問題7

An SAP Data Services job contains a lot of dataflows and runs for several hours every night. If a job execution fails, you want to skip all successful dataflows and start with the failed dataflow. How do you accomplish this?
There are 2 correct answer

A. Design the dataflow to ensure a second run does not result in duplicate

B. Merge the dataflows from the job and rerun it.

C. Run the nightly job with the enable recovery flag turned on.

D. add a try block before each dataflow and a Catch block after each dataflow

正確答案: A,D

問題8

In SAP data services what does the date generation transform allow you to generate?

A. The rows for a given date range

B. The current date for a column to see when each row was loaded.

C. the valid from date based on a dataset the contains valid to information only

D. the valid to date based on a dataset the contains valid to information only

正確答案: A

問題9

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

A. Impact and lineage Analysis

B. Operational Dashborad

C. Autodocumentation

D. Data quality reports

正確答案: C

最新的SAP Certified Application Associate - Data Integration with SAP Data Services - C_DS_43免費考試真題

最新更新

站內鏈接

聯系我們