100% Guarantee of C2090-303 exam cost materials and practice exam for IBM certification for consumer, Real Success Guaranteed with Updated C2090-303 pdf dumps vce Materials. 100% PASS IBM InfoSphere DataStage v9.1 exam Today!
2021 May C2090-303 Study Guide Questions:
Q41. - (Topic 2)
Which DB2 to InfoSphere DataStage data type conversion is correct when reading data with the DB2 Connector stage?
A. XML to SQL_WVARCHAR
B. BIGINT to SQL_BIGINT (INT32)
C. VARCHAR, 32768 to SQL_VARCHAR
D. CHAR FOR BIT DATA to SQL_VARBINARY
Answer: A
Q42. - (Topic 2)
What two computer system resources on the DataStage engine are monitored in the Operations Console? (Choose two.)
A. Disk
B. CPU
C. Memory
D. Scratch disk
E. XMETA database
Answer: B,C
Q43. - (Topic 1)
Which method is used to specify when to stop a job because of too many rejected rowswith an ODBC Connector?
A. In the Abort when field, select Max
B. In the Abort when field, select Rows
C. In the Abort when field, select Count
D. In the Abort when field, select Amount
Answer: B
Update C2090-303 exam cram:
Q44. - (Topic 2)
Identify two areas that DataStage can integrate with a Hadoop environment. (Choose two.)
A. Use the Pig Activity stage in a sequencer to invoke a Pig MapReduce program.
B. Use the HiveActivity stage in a sequences to invoke a Hive MapReduce program.
C. Use the Big Data File stage to access files on the Hadoop Distributed File System.
D. Use the Oozie Workflow Activity stage in a sequencer job to invoke Oozie work flows.
E. Use the MapReduce Transformer stage to convert Hadoop Distributed File System data.
Answer: C,D
Q45. - (Topic 1)
A customer must compare a date column with a job parameter date to determine which output links the row belongs on. What stage should be used for this requirement?
A. Filter stage
B. Switch stage
C. Compare stage
D. Transformer stage
Answer: D
Q46. - (Topic 1)
In your ETL application design you have found several areas of common processing requirementsin the mapping specifications. These common logic areas found include: code validation lookups and name formatting. The common logic areas have the same logic, but the jobs using them would have different column metadata. Choose the action that gives you the best reusability design to effectively implement these common logic areas in your ETL application?
A. Create parallel routines for each of the common logic areas and for each of the unique column metadata formats.
B. Create separate jobs for each layout and choose the appropriate job to run within a job sequencer.
C. Create parallel shared containers and define columns combining all data formats.
D. Create parallel shared containers with Runtime Column Propagation (RCP) ON and define only necessary common columns needed for the logic.
Answer: D
Precise C2090-303 torrent:
Q47. - (Topic 1)
Which option is required to identify a particular job player processes?Which option is required to identify a particularjob? player processes?
A. Set $APT_DUMP_SCORE to true.
B. Set $APT_PM_SHOW_PIDS to true.
C. Log onto the server and issue the command "ps -ef | grep ds".
D. Use the DataStage Director Job administration screen to display active player processes.
Answer: B
Q48. - (Topic 1)
The Score is divided into which two sections? (Choose two.)
A. Stages
B. File sets
C. Schemas
D. Data sets
E. Operators
Answer: D,E
Q49. - (Topic 2)
You have created three parallel jobs (Job A, B and C) in which the output of one job is the input to the other job. You are required to create processing that manages this data relationship of the jobs and provide job level restart-ability. What two tasks will accomplish these objectives? (Choose two.)
A. Enable runtime column propagation for the job sequence running the jobs.
B. Set the 'Add checkpoints so sequence is restartable' option in the Sequencer job.
C. Enable the 'Add checkpoints so container is restartable' option for each of the parallel shared containers.
D. Create two parallel shared containers that has the logic of Job B and Job C and include those shared containers in the correct flow order within the design of Job A.
E. Create a Sequencer job that has triggered events configured allowing Job A to run first, then Job B to run when A completes successfully, and then Job C to run when Job Bcompletes successfully.
Answer: B,E
Q50. - (Topic 1)
You are responsible for deploying objects into your customers production environment. To ensure the stability of the production systemthe customer does not permit compilers on production machines. They have also protected the project and only development machines have the required compiler. What option will enable jobs with a parallel transformer to execute in the customers production machines?
A. Add $APT_COMPILE_OPT=-portable
B. Set $APT_COPY_TRANSFORM_OPERATOR
C. Use protected projects in the production environment.
D. Create a package with Information Server Manager and select the option to include executables.
Answer: D