SAP C_DS_42 問題集

質問 1：
The SAP Data services merge transform is used to combine two datasets; the first has 3000 rows and the second has 2000 rows. What are characteristics of the Merge transform? Note: there are 2 correct answers to this question There are 2 correct answers
A. The merge transform joins the datasets using a full outer join
B. The merge transform combines the dataset into 5000 or less output rows.
C. The merge transform require both dataset to have the same structure.
D. The merge transform combines the dataset into 5000 output rows
正解：A,C

質問 2：
What are advantages of using the validation transform in SAP Data services? There are 3 correct answers to this question
A. You can call a recovery dataflow
B. You can set different failed paths for each rule
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.
正解：B,C,E

質問 3：
A SAP Data Services job contain logic to execute different dataflows depending on whether the job was successful or failed. Therefore the $NEEDS_RECOVERY variable should be set to either 'Yes' or 'No'. How do you assign the value to the $NEEDS_RECOVERY variable?
A. Use a catch block and set the variable to 'yes1
B. Use a global variable to persist the value across job executions
C. Use a dataflow to set the value via a template table
D. Use a script with an SQL function to read from status table
正解：A

質問 4：
What application do you use to display the graphical representations of all Sap Data Services objects including their relationships and properties?
A. Autodocumentation
B. Operational Dashborad
C. Data quality reports
D. Impact and lineage Analysis
正解：A

質問 5：
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?
A. Enter max (SALARY) in the query transform
B. Use max (SALARY) in a script.
C. Use max(SALARY) in a conditional
D. Call max(SALARY) from a Custom function
正解：A

質問 6：
You are joining tables using the query transform of SAP Data Services.
A. Left outer joins and inner joins
B. Maximum of two tables
C. Only equal conditions
D. Only inner joins
正解：A

質問 7：
You build a Data Warehouse with a date dimension in SAP Data Services. You decide to use the Date Generation transform to create this. What options are available to control the output form the transform?
A. end date
B. Increment
C. Effective date column
D. Julian format
正解：A