P2090-045 Exam Questions
52 real P2090-045 exam questions with expert-verified answers and explanations. Page 1 of 2.
- Question #1
Which tool below can be used to assign permissions to users for each DataStage project?
- Question #2
In DataStage, which client can be used to set environment variables at project level?
- Question #4
DataStage Parallel Engine supports __________.
- Question #5
Where are Table Definitions stored?
- Question #6
Information Services Director provides multiple binding options. Which of the following statements about bindings is correct?
- Question #7
A file contains a very large number of records with unique groups based on a key. Which Grouping Method would you prefer to use in the Aggregate Stage for aggregating the data?
- Question #8
Which of the following statements about FastTrack is incorrect?
- Question #9
In Blueprint Director, how do you easily recognize that an element contains a subdiagram?
- Question #10
With DataStage Designer you CANNOT __________.
- Question #11
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?
- Question #12
Which of the following statements about the Lookup Stage is correct?
- Question #14
Which of the following is NOT a valid File Update Mode property setting of a Sequential File Stage?
- Question #15
A DataStage job can be executed from_______________
- Question #16
Which of the following is NOT possible with a Transformer Stage?
- Question #17
Under which scenario may a user benefit from using InfoSphere Discovery?
- Question #18
Which of the following statements about Blueprint Director is incorrect?
- Question #19
Using a Job Sequence, which of the following tasks CANNOT be performed?
- Question #20
Which of the following stages is NOT a file data access stage?
- Question #21
What are the file format types when you use DataStage Designer to export objects?
- Question #22
Which of the following is NOT an option for the Reject Mode setting of a Sequential File Stage?
- Question #23
Where can Job Parameters be used for DataStage parallel job development?
- Question #24
Which description below about the Sort Stage is invalid?
- Question #25
Which of the following statements is an INVALID description of the Sort Stage Option Create Key Change Column?
- Question #26
The ODBC Connector Stage can be used to connect to __________.
- Question #27
Which type of jobs can be compiled into Orchestrate Scripting Language (OSH)?
- Question #28
What action will a Lookup Stage take when "Drop" is selected as the Lookup Failure Option?
- Question #29
What is a descriptor file of a Dataset created by the Dataset Stage?
- Question #30
A Transformer Stage can have __________.
- Question #31
Queries in Metadata Workbench offer an easy way to investigate specific metadata in Metadata Repository. Which of the following statements is correct?
- Question #32
Which of the following statements is not a supported matching option of the Lookup Stage?
- Question #34
A customer has set up a survey using layout templates but, after activating the survey, notices that graphics and templates are not appearing. What component of Data Collection Web...
- Question #37
Which of the following components need to be up and running in order to use InfoSphere Discovery Studio?
- Question #38
Which of the following is a valid Write Table action in the Connector Stages?
- Question #39
Which of the following CANNOT be defined in the DataStage configuration file?
- Question #40
How can FastTrack speed up the process of creating new source-to-target mapping specifications? I.Reverse engineer existing DataStage jobs II.Automatically discover column mappings...
- Question #41
What is a supported function of the Dataset Management Utility?
- Question #42
What objects below will you NOT be able to view with the Repository window in DataStage Designer Client?
- Question #45
Which of the following statements about InfoSphere Data Architect is correct?
- Question #46
With Information Services Director, you can deploy services that package the following information provider types: I.DataStage and QualityStage jobs II.SOAP over HTTP III.DB2 and O...
- Question #47
Which of the following statements about Collecting methods is correct?
- Question #48
A Job Sequence CANNOT contain __________.
- Question #49
In DataStage, Table Definitions can be imported through __________.
- Question #50
In DataStage Sequential File Stage, how is a NULL value represented?
- Question #51
Which Stage requires identical metadata in order to combine data?
- Question #52
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.D...
- Question #54
Which of the following is NOT a function provided by the DB2 Connector Stage?
- Question #55
Consider a Parallel Job including a Join Stage with HASH partitioning algorithm followed by an Aggregator stage. Which of the following statements about the Aggregator stage partit...
- Question #56
Which of the following statements about partitioning algorithms is correct?
- Question #57
Which of the following is a valid Write Mode action in the Connector Stages?
- Question #58
Which statement about Metadata Workbench is incorrect?