File Info
| Exam | IBM InfoSphere Information Server for Data Integration Fundamentals Technical Mastery Test v1 Exam |
| Number | P2090-045 |
| File Name | IBM.P2090-045.TestKing.2019-02-22.55q.vcex |
| Size | 25 KB |
| Posted | Feb 22, 2019 |
| Download | IBM.P2090-045.TestKing.2019-02-22.55q.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
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 2
Where are Table Definitions stored?
- Information Server metadata repository
- In the file system as a binary file
- In the file system as a csv file
- None of the above
Correct answer: A
Question 3
Which of the following is a valid Write Table action in the Connector Stages?
- Append
- Replace
- Truncate
- All of the above
Correct answer: D
Question 4
Which type of Join would you select for the Join Stage to output unmatched records from both input data sources?
- Inner join
- Left outer join
- Right outer join
- Full outer join
Correct answer: D
Question 5
In a Job Sequence, what is the purpose for the use of Checkpoints?
- Monitor performance and failure for each stage
- Automatically restart a job
- Record the log information for each trigger
- Restart a job from the latest Checkpoint in case of job failures
Correct answer: D
Question 6
Using a Job Sequence, which of the following tasks CANNOT be performed?
- Define specific user variables and make them available within a Job Sequence
- Drop a database table using a script, then start two different parallel jobs in sequence when a file appears in a specific directory
- Run two different parallel jobs in sequence and use job parameters to pass different $APT_CONFIG _FILE values for each of them
- Create multiple Exception Handlers stages to handle different types of failures
Correct answer: D
Question 7
Which statement about Metadata Workbench is incorrect?
- It can extend data lineage to display data integration flows that are outside of Information Server
- It relies on the repository functions in DataStage Designer for impact analysis
- It displays data lineage reports
- It allows Metadata Workbench administrators to associate data stewards with data objects
Correct answer: B
Question 8
A Job Sequence CANNOT contain __________.
- Transformer Stages
- Sequencer Stages
- Triggers
- Job Activity Stages
Correct answer: A
Question 9
In DataStage, which client can be used to set environment variables at project level?
- DataStage Designer
- DataStage Administrator
- DataStage Director
- Information Server Web Console
Correct answer: B
Question 10
What action will a Lookup Stage take when "Drop" is selected as the Lookup Failure Option?
- Stage reports an error
- Stage skips the input record
- Stage rejects the Input record
- Job gets aborted
Correct answer: B
