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:
Q21. Which of the following statements about Collecting methods is correct?
A. ROUND ROBIN is the fastest algorithm
B. SORT MERGE never performs data sorting
C. ORDERED ensures the collected data stream being sorted
D. AUTO chooses the best method between ROUND ROBIN, SORT MERGE, and
ORDERED
Answer: B
Q22. A Transformer Stage can have __________.
A. One input link, one or more reject links, one otherwise link, one or more output links
B. One or more input links, one or more reject links, one otherwise link, one or more output links
C. One input link, one reject link, one otherwise link, one or more output links
D. One or more input links, one reject link, one otherwise link, one or more output links
Answer: C
Q23. Which of the following is a valid Write Mode action in the Connector Stages?
A. Insert
B. Update
C. Delete
D. All of the above
Answer: D
Rebirth P2090-045 free exam questions:
Q24. In Blueprint Director, how do you easily recognize that an element contains a subdiagram?
A. There is a little ?icon associated with the elementThere is a little ??icon associated with the element
B. There is a little green arrow associated to the element
C. There is a little ??icon associated with the element
D. Double clicking the element is the only way to find out
Answer: C
Q25. What objects below will you NOT be able to view with the Repository window in DataStage Designer Client?
A. Parallel Jobs
B. Table Definitions
C. Logs
D. Sequence Jobs
Answer: C
Q26. Which type of jobs can be compiled into Orchestrate Scripting Language (OSH)?
A. Server jobs
B. Parallel jobs
C. Sequence Jobs
D. Mainframe Jobs
Answer: B
Exact P2090-045 tutorials:
Q27. In which situation below can you use the Metadata Asset Manager with the MetaBrokers and Bridges (Import/Export Manager) to import metadata into the Metadata Repository?
A. To bring runtime information about DataStage jobs into the Metadata Repository
B. To bring FastTrack mapping specifications into the Metadata Repository
C. To bring Cognos BI reports and queries into the Metadata Repository
D. To bring a blueprint from Blueprint Director into the Metadata Repository
Answer: C
Q28. Which functionalities are supported by InfoSphere Discovery? I.Discover primary / foreign key relationships between tables II.Discover statistics about usage of data by users III.Discover matching source and target columns IV.Discover suggested transformations that, when applied, will transform the data from the source columns to match the data in the target columns
A. I, II, IV
B. I, III, IV
C. I, II, III
D. II, III, IV
Answer: B
Q29. Which of the following is a valid Write Table action in the Connector Stages?
A. Append
B. Replace
C. Truncate
D. All of the above
Answer: D
Q30. Which of the following statements is not a supported matching option of the Lookup Stage?
A. Equality match
B. Caseless match
C. Range on the Target Link
D. Range on the Reference Link
Answer: C