C2090-421Real Exam Questions

Free Download New Updated IBM C2090-421Real Exam Questions and Answers 171-180

By on October 12, 2014
EnsurepassQUESTION 171 Which three of the following actions are available when editing a message handler? (Select three)   A. Abort Job B. Demote to warning C. Promote to warning D. Suppress from job log E. Demote to informational   Correct Answer: CDE Explanation: Reference:http://pic.dhe.ibm.com/infocenter/iisinfsv/v8r7/index.jsp?topic=%2Fcom.ibm.swg .im.iis.ds.direct.doc%2Ftopics%2Ft_ddirref_Managing_Message_Handlers.html     QUESTION 172 What is the correct Read more [...]

Continue Reading

C2090-421Real Exam Questions

Free Download New Updated IBM C2090-421Real Exam Questions and Answers 161-170

By on
EnsurepassQUESTION 161 Refer to the exhibit. You submit a job from DataStage Director and then log onto your DataStage Linux server to issue the command "ps-ef | grepds" and receive the following screen:     Which process is the section leader for node2?   A. 7216 B. 7219 C. 7220 D. 7221   Correct Answer: D     QUESTION 162 You are responsible for managing job changes for you project team. You must update the source code repository through Eclipse Team Read more [...]

Continue Reading

C2090-421Real Exam Questions

Free Download New Updated IBM C2090-421Real Exam Questions and Answers 151-160

By on
EnsurepassQUESTION 151 You would like to invoke a job sequence from a web service. How can this be done?   A. Invoke the job sequence using the dsjob command. B. Select the job sequence when creating the web service operation, C. Check the use job sequence checkbox when creating the web service. D. Create a DataStage routine that invokes the job sequence and invoke the routine from a DataStage job. Then use this job when creating the web service operation.   Correct Answer: Read more [...]

Continue Reading

C2090-421Real Exam Questions

Free Download New Updated IBM C2090-421Real Exam Questions and Answers 141-150

By on
EnsurepassQUESTION 141 Which three environment variables are used for reporting on DataStage jobs? (Select three)   A. $APT_DISABLE_ROOT_FORKJOIN B. $APT_DUMP_SCORE C. $OSH_PRINT_SCHEMAS D. $APT_PM_PLAYER_MEMORY E. $APT_PM_STARTUP_CONCURRENCY   Correct Answer: BCD     QUESTION 142 What three statements are true with regards to restartable mode for an FTP Enterprise stage? (Select three)   A. Specify the-restartable_transfer option. B. Optionally specify Read more [...]

Continue Reading

C2090-421Real Exam Questions

Free Download New Updated IBM C2090-421Real Exam Questions and Answers 141-150

By on
EnsurepassQUESTION 141 Which three environment variables are used for reporting on DataStage jobs? (Select three)   A. $APT_DISABLE_ROOT_FORKJOIN B. $APT_DUMP_SCORE C. $OSH_PRINT_SCHEMAS D. $APT_PM_PLAYER_MEMORY E. $APT_PM_STARTUP_CONCURRENCY   Correct Answer: BCD     QUESTION 142 What three statements are true with regards to restartable mode for an FTP Enterprise stage? (Select three)   A. Specify the-restartable_transfer option. B. Optionally specify Read more [...]

Continue Reading

C2090-421Real Exam Questions

Free Download New Updated IBM C2090-421Real Exam Questions and Answers 131-140

By on
EnsurepassQUESTION 131 How are Host Systems added to the Shared Metadata repository? (Select two)   A. Use the Import/Export Manager when importing shared metadata. B. Use the DataStage Administrator application to import new Host Systems. C. Use the shared table creation wizard from the DataStage client to add a new Host System. D. Select Repository > Metadata Sharing > Management from the main menu to open the Shared Metadata Management tool   Correct Answer: D   Read more [...]

Continue Reading

C2090-421Real Exam Questions

Free Download New Updated IBM C2090-421Real Exam Questions and Answers 111-120

By on
EnsurepassQUESTION 111 A job contains a Sort stage that sorts a large volume of data across a cluster of servers. Due to new requirements, the customer has requested that this sorting be done on a subset of servers identified in the configuration file to minimize impact on database nodes. The $APT_CONFIG_FILE shows no sort disk pool for any node. Which two steps will accomplish this? (Choose two.)   A. Assign a separate config file just for the Sort stage. B. Have an appropriate node Read more [...]

Continue Reading

C2090-421Real Exam Questions

Free Download New Updated IBM C2090-421Real Exam Questions and Answers 101-110

By on
EnsurepassQUESTION 101 Which three data types can the ODBC Enterprise stage handle? (Choose three.)   A. SQL_CLOB B. SQL_BIGINT C. SQL_TIMESTAMP D. SQL_VARBINARY E. SQL_SMALLDATETIME   Correct Answer: BCD     QUESTION 102 Which two steps are required to change from a normal lookup to a sparse lookup in an ODBC Enterprise stage? (Choose two.)   A. Sort the data on the reference link. B. Change the lookup option in the stage properties to "Sparse". Read more [...]

Continue Reading

C2090-421Real Exam Questions

Free Download New Updated IBM C2090-421Real Exam Questions and Answers 91-100

By on
EnsurepassQUESTION 91 You need to find the differences between the jobs in the Test project and theit older version in the Production project. You discover that the Production project is on another domain. What feature would find the differences in a job that is in a project on a different domain?   A. Cross Domain Compare B. Cross Project Compare C. DataStage Version Control D. Export from the other domain and import into a project in the same domain as the one you are working Read more [...]

Continue Reading

C2090-421Real Exam Questions

Free Download New Updated IBM C2090-421Real Exam Questions and Answers 81-90

By on
EnsurepassQUESTION 81 Configuring the weighting column of an Aggregator stage affects which three options. (Choose three.)   A. Sum B. Maximum Value C. Sum of Weights D. Corrected Sum of Squares E. Percent Coefficient of Variation   Correct Answer: ACE     QUESTION 82 In which two situations would you use the Web Services Client stage? (Choose two.)   A. You need to create a WSDL. B. You want to deploy a service. C. You do not need both input and Read more [...]

Continue Reading

C2090-421Real Exam Questions

Free Download New Updated IBM C2090-421Real Exam Questions and Answers 71-80

By on
EnsurepassQUESTION 71 In a Transformer Stage you have a nullable input column that is mapped to a non-nullable output column. What two techniques can be used to handle NULL values? (Choose two.)   A. NullToValue(input_column,'unknown'). B. IF input_column = '' THEN 'unknown' ELSE input_column. C. IF input_column = NULL THEN 'unknown' ELSE input_column. D. IF IsNULL(input_column) THEN 'unknown' ELSE input_column.   Correct Answer: AD     QUESTION 72 Which three statements Read more [...]

Continue Reading

C2090-421Real Exam Questions

Free Download New Updated IBM C2090-421Real Exam Questions and Answers 51-60

By on
EnsurepassQUESTION 51 How does the Complex Flat File stage (CFF) support the use of "OCCURS DEPENDING ON" clause?   A. CFF does not support this clause. B. The related elements are output as arrays. C. The related elements are output as subrecords. D. The related elements are output as denormalized fields.   Correct Answer: B     QUESTION 52 What two stages are required to place Header and Detail records, which have different formats, into a single format? (Choose Read more [...]

Continue Reading

C2090-421Real Exam Questions

Free Download New Updated IBM C2090-421Real Exam Questions and Answers 41-50

By on
EnsurepassQUESTION 41 You have run ten instances of the same job the previous evening. You want to examine the job logs for all instances but can only find five of them. How can you avoid this in the future for this job?   A. Change the Auto-purge settings in Administrator. B. Change the Auto-purge settings for the job in Director. C. Set the $APT_AUTOPURGE_LOG environment variable to False. D. Set the $APT_AUTOLOG_PURGE environment variable to False.   Correct Answer: B   Read more [...]

Continue Reading

C2090-421Real Exam Questions

Free Download New Updated IBM C2090-421Real Exam Questions and Answers 31-40

By on
EnsurepassQUESTION 31 How must the input data set be organized for input into the join stage? (Choose two.)   A. Unsorted B. Key partitioned C. Hash partitioned D. Entire partitioned E. Sorted in ascending order   Correct Answer: BE     QUESTION 32 Which three methods can be used to import metadata from a Web Services Description Language (WSDL) document? (Choose three.)   A. XML Table Definitions B. Web Services WSDL Definitions C. Orchestrate Read more [...]

Continue Reading

C2090-421Real Exam Questions

Free Download New Updated IBM C2090-421Real Exam Questions and Answers 21-30

By on
EnsurepassQUESTION 21 Which of the following is not an ODBC connector property?   A. Username B. Password C. Data source D. Remote server   Correct Answer: D     QUESTION 22 You have a job that reads in Sequential File followed by a Transformer stage. When you run this job, which partitioning method will be used by default?   A. Hash B. Same C. Random D. Round Robin   Correct Answer: D     QUESTION 23 A job reads from a sequential Read more [...]

Continue Reading

C2090-421Real Exam Questions

Free Download New Updated IBM C2090-421Real Exam Questions and Answers 11-20

By on
EnsurepassQUESTION 11 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 are the first two steps you should take to understand the job performance issues? (Choose two.)   A. Review the objectives of the job. B. Run job with $APT_TRACE_RUN set to true. C. Run job with $APT_DUMP_SCORE set to true. D. Replace Transformer stages with custom operators.   Correct Answer: AC     Read more [...]

Continue Reading

C2090-421Real Exam Questions

Free Download New Updated IBM C2090-421Real Exam Questions and Answers 1-10

By on
EnsurepassQUESTION 1 You are responsible for deploying objects into your customers production environment. To ensure the stability of the production system the customer does not permit compilers on production machines. They have also protected the project and only development machines have the required compiler. What two options will allow jobs with a parallel transformer to execute in the customers production machines? (Choose two.)   A. Add $APT_COMPILE_OPT=-portable B. Set $APT_COPY_TRANSFORM_OPERATOR Read more [...]

Continue Reading