File Info
| Exam | IBM InfoSphere Information Server for Data Integration Fundamentals Technical Mastery Test v1 Exam |
| Number | P2090-045 |
| File Name | IBM.P2090-045.SelfTestEngine.2018-09-05.28q.vcex |
| Size | 17 KB |
| Posted | Sep 05, 2018 |
| Download | IBM.P2090-045.SelfTestEngine.2018-09-05.28q.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
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 2
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 3
A Job Sequence CANNOT contain __________.
- Transformer Stages
- Sequencer Stages
- Triggers
- Job Activity Stages
Correct answer: A
Question 4
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 5
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
Question 6
Which of the following components need to be up and running in order to use InfoSphere Discovery Studio?
- WAS (WebSphere Application Server)
- The ASB agent
- The database holding the Information Server Metadata Repository
- All of the above
- None of the above
Correct answer: E
Question 7
Which of the following CANNOT be defined in the DataStage configuration file?
- Degree of parallelism
- Scratch disk dedicated for sorting
- Compilation options for DataStage jobs
- A named pool including only part (some) of the nodes
Correct answer: C
Question 8
In DataStage Sequential File Stage, how is a NULL value represented?
- By a space character
- By a 'NULL' string
- A -1 for an integer field and an empty string for a VARCHAR field
- As defined by the Developer in the extended properties of the field
Correct answer: D
Question 9
Under which scenario may a user benefit from using InfoSphere Discovery?
- Automate data relationship discovery
- Prototype a data model for the first time
- Automate transformation rule discovery
- Automate business object identification
- All of the above
Correct answer: E
Question 10
Which of the following statements about Blueprint Director is incorrect?
- Blueprint Director will display the time needed to perform individual tasks
- You can browse and search Information Server metadata assets
- You can create new blueprints from standard reference architecture templates
- Reference architectures contain detailed method guidance for required activities
Correct answer: A
