File Info
| Exam | IBM InfoSphere Information Server for Data Integration Fundamentals Technical Mastery Test v1 Exam |
| Number | P2090-045 |
| File Name | IBM.P2090-045.ExamCollection.2020-02-11.32q.vcex |
| Size | 18 KB |
| Posted | Feb 11, 2020 |
| Download | IBM.P2090-045.ExamCollection.2020-02-11.32q.vcex |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
Demo Questions
Question 1
Which of the following is a valid Write Mode action in the Connector Stages?
- Insert
- Update
- Delete
- All of the above
Correct answer: D
Question 2
A Job Sequence CANNOT contain ___________.
- Transformer Stages
- Sequencer Stages
- Triggers
- Job Activity Stages
Correct answer: A
Question 3
InfoSphere Data Architect is not part of the Information Server Suite. Which statement about sharing metadata with the Metadata Repository is correct?
- Metadata CANNOT be imported into the Metadata Repository from Data Architect
- Only a physical model can be exported from Data Architect to the Metadata Repository
- Only a logical model can be exported from Data Architect to the Metadata Repository
- Both, a physical model and a logical model can be exported from Data Architect to the Metadata Repository
Correct answer: D
Question 4
For the Information Server Repository, which Relational Database Management System (RDMS) CANNOT be used?
- Microsoft SQL Server
- Informix
- DB2 UDB
- Oracle
Correct answer: B
Question 5
The ODBC Connector Stage can be used to connect to _____________.
- Oracle database
- Teradata database
- DB2 database
- All of the above
Correct answer: D
Question 6
Which of the following CANNOT be defined in the DataStage configuration file?
- Degree of parallelism
- Scratch disk dedicated for sorting
- Compilation options for DataStorage jobs
- A named pool including only part(some) of the nodes
Correct answer: C
Question 7
Which of the following statements is an INVALID description of the Sort Stage Option Create Key Change Column?
- Adds a column which holds a value of 0 or 1
- 1 indicates the key value has changed
- 0 indicated the key value has not changed
- Adds a column which holds a value of true/false
Correct answer: D
Question 8
Which of the following is NOT an option for the Reject Mode setting of a Sequential File Stage?
- Continue
- Reject
- Fail
- Output
Correct answer: B
Question 9
Which Stage requires identical metadata in order to combine data?
- Lookup Stage
- Funnel Stage
- Join Stage
- Transformer Stage
Correct answer: B
Question 10
Queries in Metadata Workbench offer an easy way to investigate specific metadata in Metadata Repository. Which of the following statements is correct?
- In a query, the criteria used for filtering the desired metadata can be based on different asset types
- Queries can be saved in XML format
- You can only use existing, predefined queries
- Queries can report on objects that are not stored in the Metadata Repository
Correct answer: A
