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.
A. Embed the first dataflow in a try-catch
B. Add a script between the dataflows using the error_number() function
C. Use a conditional for the second dataflow
D. Connect the two dataflows with line
正解:D
質問 2:
What is the SAP Data services Dataflow auditing feature used for? Note: There are 2 correct answers to this question.
A. To count the number of rows processed at user defined points to collect runtime statistics
B. To view the data as it is processed by the dataflow in order to ensure its correctness
C. To define rules based on the number of records processed overall once the dataflow is finished
D. to define rules that each record processed by the dataflow has to comply with
正解:A,D
質問 3:
What are SAP data services scripts used for? There are 2 correct answers to this question
A. To set the desired properties, for example, trace options, monitor sample rate, and the use statistics for optimization flag.
B. To execute single SQL commands using the sql() function to select a value from a status table for the variable.
C. To perform job initialization tasks to print the job variable values into the trace log using the print() function.
D. To write complex transformation logic using the flexibility of the scripting language.
正解:B,D
質問 4:
How do you allow a new team member to view the SAP Data Services repository in read only mode?
A. Use the central repository in the Desinger
B. Use the Auto Documentation feature in the Management Console
C. Export the repository's metadata to an XML file and open it in a browser.
D. Copy the repository and view the copy in the repository manager.
正解:A
質問 5:
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?
A. Case transform
B. Map_Operation transform
C. Country ID transform
D. Validation transform
正解:A
質問 6:
You define audit rules for critical data flow to confirm that you SAP Data Services batch job loaded only correct dat a. Which audit functions are available to define these rules for columns? Note: There are 3 correct answers
A. Checksum
B. sum
C. Min
D. Count distinct
E. Average
正解:A,B,E
解説: (Pass4Test メンバーにのみ表示されます)
質問 7:
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. Set the autocorrect load option in the target table loader option
B. Use the table comparison transform before the table loader
C. Enable the Delete data before load target table loader option
D. Add lookup function in the where clause to filter out existing rows.
正解:B,D
Kawai -
C_DS_43一発合格しました。Pass4Testの問題集を何個か購入しましたが、内容的には良かったと思います。