Exam Code: P2090-045 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: IBM InfoSphere Information Server for Data Integration Fundamentals Technical Mastery Test v1 (P2090-045)
Certification Provider: IBM
Free Today! Guaranteed Training- Pass P2090-045 Exam.
2021 May P2090-045 Study Guide Questions:
Q31. Which of the following stages is NOT a file data access stage?
A. Sequential File Stage
B. Transformer Stage
C. Dataset Stage
D. FileSet Stage
Answer: B
Q32. Which statement about Metadata Workbench is incorrect?
A. It can extend data lineage to display data integration flows that are outside of Information Server
B. It relies on the repository functions in DataStage Designer for impact analysis
C. It displays data lineage reports
D. It allows Metadata Workbench administrators to associate data stewards with data objects
Answer: B
Abreast of the times P2090-045 exam question:
Q33. Which of the following statements about FastTrack is incorrect?
A. The only way to combine data in a FastTrack mapping specification is to create a lookup definition
B. When a job is generated from a FastTrack specification, it can contain connection information to access source and target database systems
C. When generating a job from a FastTrack specification, you can specify the desired stage type for the source and the target (e.g. sequentialfile, ODBC connector, DB2 connector)
D. Changes in mapping specifications are propagated to previously generated DataStage jobs as annotations
Answer: A
Q34. Which of the following is NOT possible with a Transformer Stage?
A. Generate multiple output records for each single record
B. Create and compile a custom function to be used in output link derivations
C. Define variables that can be referenced only within the Transformer Stage
D. Use system variables and job parameters within derivations
Answer: B
Tested P2090-045 training tools:
Q35. Information Services Director provides multiple binding options. Which of the following statements about bindings is correct?
A. Multiple bindings can be associated to the same service
B. The choice of binding depends on the information provider used
C. Bindings are set at the application level
D. Bindings are set at the individual operation level
Answer: A
Q36. Which of the following statements about Blueprint Director is incorrect?
A. Blueprint Director will display the time needed to perform individual tasks
B. You can browse and search Information Server metadata assets
C. You can create new blueprints from standard reference architecture templates
D. Reference architectures contain detailed method guidance for required activities
Answer: A
Q37. Which of the following CANNOT be defined in the DataStage configuration file?
A. Degree of parallelism
B. Scratch disk dedicated for sorting
C. Compilation options for DataStage jobs
D. A named pool including only part (some) of the nodes
Answer: C
Q38. Which of the following is NOT an option for the Reject Mode setting of a Sequential File Stage?
A. Continue
B. Reject
C. Fail
D. Output
Answer: B