C-DS-43 試験問題を無料オンラインアクセス

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_distinct(Account_TYPE)
• B.Gen_Row_Num()
• C.Count(*)
• D.count(Account_type)

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

• A.You can set different failed paths for each rule
• B.You can call a recovery dataflow
• C.You can see which rules were violated in one output
• D.You can produce statistics
• E.You can have multiple rules on a single column.

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

• A.Ordering
• B.XML function
• C.Custom function
• D.Join
• E.Distinct

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

• A.By using the table comparison transform
• B.By creating two dataflows and executing the Auto Correct Load version when reired
• C.by setting the target table loader with bulk load enabled
• D.by setting the target table loader with Bulk Load and Auto Correct Load enabled.

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?

• A.Use the query transform with multiple IFTHENELSE() functions.
• B.Use the merge transform that is connected to the source
• C.Use twelve query transform to create the desired output. Then combine these transforms.
• D.Use the pivot transform with two pivot sets.