Data integrator conations "Execute only once" logic on which two objects? (Choose two)
A. Conditionals
B. Scripts
C. Work flows
D. Data flows
正解:C,D
質問 2:
Which three elements can be contained in the output schema of a query? (Choose three)
A. Nested Schemas
B. Group By
C. Order By
D. Functions
E. Columns
F. Filters
正解:A,D,E
質問 3:
You are using an oracle 10G database for the source and target tables in your data flow. In which circumstance will data integrator optimize the SQL to use the oracle "merge" command?
A. A table comparison is used to compare the source with the target
B. The "Auto Correct load" option is selected on the Target table.
C. The Map_Operation is used to map all items from " normal " to" update now operations
D. The "Use input Keys" option is selected on the target table editor
正解:B
質問 4:
Which three operations can a user configured with the "Operator" role perform?
(Choose three)
A. Manage Secured Central Object Library
B. Manage Users
C. Set Log Retention periods
D. Manage Job Schedules
E. Execute Jobs
正解:C,D,E
質問 5:
Your table contains the "sales_date" and "sales-time" fields both fields are data type archer (20). The "sales_date" format is 21-jan- 1980'. The "sales_time" format is '18-30-12'. You need to combine both fields and load the results into a single Target field of the data time data type. Which expression must you use to perform the conversion?
A. to_data(sales_date&' '& sales_time.'dd_mmmm-yyyy hh24:mi:ss')
B. to_data(sales_datell' 'll sales_time.'dd_mmm-yyyy hh24:mi:ss')
C. to_data(sales_datell' 'll sales_time.'dd_mon-yyyy hh24:mi:ss')
D. to_data(sales_date &' '& sales_time.'dd_mon-yyyy hh24:mi:ss')
正解:C
質問 6:
Which three methods can you use to create a local variable? (Choose three)
A. Select Tools | Variables | Local Variables in the Work Flow workspace
B. Select Tools | Variables | Local Variables in the Job workspace
C. Select Tools | Variables | Local Variables in the Data Flow workspace
D. Select the Variables tab in the Smart Editor of a custom function
正解:A,B,D
質問 7:
Which three combinations of input and output schemas are permitted in on embedded data flow? (Choose three)
A. 1 input and 1 outputs
B. 0 input and 1 outputs
C. 1 input and 0 outputs
D. Multiple input and multiple outputs
E. 1 input and multiple outputs
正解:A,B,C
質問 8:
Which three options are available for selecting when an audit rule fails? (Choose three)
A. Script
B. Email to List
C. Write Data to Error Table
D. Raise Exception
正解:A,B,D
Ohmura -
Pass4Testは信頼できます。間違いの選択肢についてもキチンと解説されているので、深く理解できますし、幅広く習得できる