Guaranteed of P2090-045 test question materials and item pool for IBM certification for IT specialist, Real Success Guaranteed with Updated P2090-045 pdf dumps vce Materials. 100% PASS IBM InfoSphere Information Server for Data Integration Fundamentals Technical Mastery Test v1 (P2090-045) exam Today!
2021 May P2090-045 Study Guide Questions:
Q1. Which of the following statements about InfoSphere Data Architect is correct?
A. You CANNOT create a logical model from a physical model
B. InfoSphere Data Architect can deploy physical data models directly to the database management system
C. Reverse engineering data models only works for DB2 databases
D. InfoSphere Data Architect is installed using the Information Server installation wizard
Answer: B
Q2. DataStage Parallel Engine supports __________.
A. Pipeline and Partition Parallelism
B. Pipeline Parallelism only
C. Partition Parallelism only
D. None of the above
Answer: A
Q3. What is a descriptor file of a Dataset created by the Dataset Stage?
A. Contains the length of the data files
B. Contains metadata, data location, but not the data itself
C. Contains the actual data in text format
D. Contains the actual data in binary format
Answer: B
Leading P2090-045 actual exam:
Q4. 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 using matches on column names III.Leverage metadata imported from other Information Server modules IV.FastTrack automatically converts data lineage reports into mapping specifications
A. I, II, III, IV
B. II, III, IV
C. I, II, IV
D. I, II, III
Answer: D
Q5. Where are Table Definitions stored?
A. Information Server metadata repository
B. In the file system as a binary file
C. In the file system as a csv file
D. None of the above
Answer: A
Q6. Which Stage requires identical metadata in order to combine data?
A. Lookup Stage
B. Funnel Stage
C. Join Stage
D. Transformer Stage
Answer: B
Tested P2090-045 interactive bootcamp:
Q7. Which of the following is a standard practice when using partition parallelism? A. Disable the pipeline parallelism for all the stages that can run in parallel
B. Setup a configuration file defining multiple CPUs for each logical node
C. Avoid repartitioning if possible
D. All of the above
Answer: C
Q8. In DataStage Sequential File Stage, how is a NULL value represented?
A. By a space character
B. By a 'NULL' string
C. A -1 for an integer field and an empty string for a VARCHAR field
D. As defined by the Developer in the extended properties of the field
Answer: D
Q9. In DataStage, Table Definitions can be imported through __________.
A. DataStage Administrator
B. Information Server Web Console
C. DataStage Designer
D. DataStage Director
Answer: C
Q10. What action will a Lookup Stage take when "Drop" is selected as the Lookup Failure Option?
A. Stage reports an error
B. Stage skips the input record
C. Stage rejects the Input record
D. Job gets aborted
Answer: B