What is the function of the Case transform?
A. To select a Job path based on conditional logic.
B. To split data sets based on conditional logic into separate streams.
C. To join data sets from separate streams based on conditional logic.
D. To map a column value based on multiple conditions.
正解:B
質問 2:
You need to merge two tables from heterogeneous data sources and apply multiple join conditions. The tables contain very large data volumes. What is the recommended method to maximize performance and reduce system resources?
A. Use the Data_Transfer transform to stage the tables in the same database before applying the join conditions
B. Use Multiple Flat Files to stage the tables, then join the flat files using a Query transform.
C. Use the Query transform to join the two tables by applying the join conditions.
D. Use the Merge transform to merge the data into a single Table before applying the join conditions
正解:A
質問 3:
You need to use an extremely web service within data integrator. What information will you need to configure data integrator to use this web service?
A. Document Type definition (DTD)
B. Web Service Definition Language (WSDL)
C. Web service URL
D. XML schema definition (XSD)
正解:B
質問 4:
You have two structurally equivalent data sets which you want to append into a single target. How would you connect the input data sets?
A. Merge transform
B. Map_Operation transform
C. Into a single target table
D. Query transform
正解:A
質問 5:
Which lookup function returns multiple columns?
A. Lookup_Ext
B. Lookup
C. Lookup _Adv
D. Lookup_Seq
正解:A
質問 6:
Which two options must you set to capture your audit information to the Trace Logs? (Choose two)
A. Set Trace Audit Data to "Yes"
B. Select "Edit Job Server Config" I "Enable Auditing" in the Server Manager
C. Select Tools I Options I Designer I General I Capture Audit Data
D. Select "Enable Auditing" in the Job parameters.
正解:A,D
1225 お客様のコメント





朝比** -
Pass4Testサイト、いい本を書いていただきありがとうございました。無事合格できました。