Which statement is TRUE about Balanced Optimization?
A. Balanced Optimization is installed with InfoSphere DataStage. B. Balanced Optimization creates a parameter set called BalOpJAQLParams in the underlying project if it does not exist. C. Balanced Optimization will change or optimize machine configurations, InfoSphere DataStage configurations, database configurations, or HDFS configurations. D. Balanced optimizations are performed in a priority order. When there is ambiguity (for example, some processing could be performed either in a source or target database) processing is pushed into database sources.
D. Balanced optimizations are performed in a priority order. When there is ambiguity (for example, some processing could be performed either in a source or target database) processing is pushed into database sources.
A Parameter Set is a named object that can contain which of the following?
A. Multiple parameters and only one value file B. Only one parameter and only one value file C. Multiple parameters and multiple value files D. Only one parameter and multiple value files
D. Only one parameter and multiple value files
Question 36:
Which Connector Stage doesn't support reject Link
A. DB2 Connector B. ODBC Connector C. Oracle Connector D. Netezza Connector
B. ODBC Connector
Reject links are not supported by any connectivity source stage. This includes the Px Sybase, Px ODBC, Px DB2Z, Px Classic Federation stages,Px DB2 and Px Oracle stages.
Question 37:
You are experiencing performance issues for a given job. You are assigned the task of understanding what is happening at run time for that job. What steps should you take to understand the job performance issues? (Choose two.)
A. Use the resource estimation tool B. Use the performance analysis tool C. Replace Join stages by Lookup stages D. Run the job with $APT_TRACE_RUN set to true E. Run the job with $APT_DUMP_SCORE set to true
B. Use the performance analysis tool E. Run the job with $APT_DUMP_SCORE set to true
Question 38:
Which statement about looping in sequences is TRUE?
A. The Start Loop stage only supports numeric loops B. Numeric loops must increment by one unless you supply a parameter C. The current loop counter value can be passed to the stages in the loop D. The compiler will insert an End Loop as the last stage in the sequence if one is omitted
C. The current loop counter value can be passed to the stages in the loop
Question 39:
Your job aggregates data before writing the results out to a DB2 table. You have since learned that this job will be required to aggregate very large amounts of data. To ensure high performance you create a new, non-default configuration file for the job that defines a node pool named "highperfnodes" that includes only nodes with very high processing power.
What additional design changes do you need to make to the job to ensure that it aggregates the data using the "highperfnodes" pool? (Choose two.)
A. Select the "highperfnodes" pool in the Execution tab of the Job Properties window B. Add the $APT_CONFIG_FILE environment variable as an additional job parameter C. Add a Sort stage before the Aggregator stage to sort the data before the data is aggregated D. Change properties in the Aggregator stage to force it to use the nodes in the appropriate pool E. Change properties in the Aggregator stage to force it to use the new non-default configuration file
A. Select the "highperfnodes" pool in the Execution tab of the Job Properties window D. Change properties in the Aggregator stage to force it to use the nodes in the appropriate pool
Question 40:
Which statement about shared containers is TRUE?
A. A shared container is an independently compiled unit B. A local container can be converted to a shared container C. A shared container can be converted to a local container D. A container cannot be created by selecting a group of stages and links in a job
B. A local container can be converted to a shared container
Nowadays, the certification exams become more and more important and required by more and more
enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare
for the exam in a short time with less efforts? How to get a ideal result and how to find the
most reliable resources? Here on Vcedump.com, you will find all the answers.
Vcedump.com provide not only IBM exam questions,
answers and explanations but also complete assistance on your exam preparation and certification
application. If you are confused on your C2090-424 exam preparations
and IBM certification application, do not hesitate to visit our
Vcedump.com to find your solutions here.