Download IBM.C2090-424.TestKing.2019-01-19.35q.vcex

Download Exam

File Info

Exam InfoSphere DataStage v11.3
Number C2090-424
File Name IBM.C2090-424.TestKing.2019-01-19.35q.vcex
Size 123 KB
Posted Jan 19, 2019
Download IBM.C2090-424.TestKing.2019-01-19.35q.vcex


How to open VCEX & EXAM Files?

Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.

Purchase

Coupon: MASTEREXAM
With discount: 20%






Demo Questions

Question 1

Which of the following actions are available when editing a message handler? 


  1. Abort Job
  2. Demote to warning
  3. Promote to warning
  4. Promote to informational
Correct answer: C
Explanation:
Reference: http://www-01.ibm.com/support/knowledgecenter/SSZJPZ_8.5.0/com.ibm.swg.im.iis.ds.design.help.doc/topics/editmessagehandlerswindow.html
Reference: http://www-01.ibm.com/support/knowledgecenter/SSZJPZ_8.5.0/com.ibm.swg.im.iis.ds.design.help.doc/topics/editmessagehandlerswindow.html



Question 2

The Lookup stage is one of three stages that join records based on the values of key columns. What are the other stages? (Choose two.)


  1. Join
  2. Merge
  3. Modify
  4. Funnel
  5. Difference
Correct answer: AB
Explanation:
Reference: https://www-01.ibm.com/support/knowledgecenter/SSZJPZ_11.3.0/com.ibm.swg.im.iis.ds.parjob.dev.doc/topics/c_deeref_Lookup_Stage.html 
Reference: https://www-01.ibm.com/support/knowledgecenter/SSZJPZ_11.3.0/com.ibm.swg.im.iis.ds.parjob.dev.doc/topics/c_deeref_Lookup_Stage.html 



Question 3

Which type of data can be extracted using the Unstructured Data stage?


  1. XML data
  2. Microsoft Word data
  3. Microsoft Excel data
  4. BigInsights HDFS file data
Correct answer: C
Explanation:
Reference: https://www-01.ibm.com/support/knowledgecenter/SSZJPZ_11.3.0/com.ibm.swg.im.iis.ds.unstructureddatastage.usage.doc/topics/uds_extract_data.html
Reference: https://www-01.ibm.com/support/knowledgecenter/SSZJPZ_11.3.0/com.ibm.swg.im.iis.ds.unstructureddatastage.usage.doc/topics/uds_extract_data.html



Question 4

Which of the following is TRUE when using a data set created with a 4 node config file?


  1. Data sets are operating system files
  2. Data is stored in a non-persistent form
  3. The data set control file holds all your data
  4. A Data Set stage can have 1 input link and multiple output links
Correct answer: B



Question 5

Which statement about restartable sequence jobs is TRUE?


  1. If a restartable sequence aborts, it can be restarted from Director.
  2. Choosing “Reset job” from Director will start the job where it left off.
  3. Checkpoints are always added to every eligible Job Activity stage in the sequence.
  4. There is no way to force a Job Activity stage to return if the sequence got beyond it. 
Correct answer: A
Explanation:
Reference: http://www-01.ibm.com/support/docview.wss?uid=swg1JR46534
Reference: http://www-01.ibm.com/support/docview.wss?uid=swg1JR46534



Question 6

Given this configuration file:
  
Which of the following describes the resulting behavior for a job consisting of Row Generator -> data set?


  1. Conductor, section leader and player processes are executed on the server is1 and is2.
  2. Conductor process is executed on the server is1. Section leader and Player processes are executed on the server is2.
  3. Conductor and section leader processes are executed on the server is1. Player processes are executed on the server is2. 
  4. Conductor process and player processes are executed on the server is1. Section leader process is executed on the server is2.
Correct answer: C



Question 7

Given this score:
  
It runs 3 processes on 2 nodes. 
How does the job run? 


  1. On two physical nodes and two logical nodes
  2. On two physical nodes and single logical node
  3. On a single physical node and two logical nodes
  4. On a single physical node and single logical node
Correct answer: D



Question 8

Which one of the following is an implicit data type conversion? 


  1. date -> char
  2. char -> date
  3. varchar -> char
  4. char -> timestamp
Correct answer: D



Question 9

Which of the following are valid stage options for a parallel DataStage job which uses a configuration file with multiple nodes and a File Connector as a source running in parallel mode? (Choose two.)


  1. Provide a specific file name in the file name property. 
  2. In the file name property, provide a file name with a wildcard that matches the existing file names.
  3. Provide a specific file name in the file name property and select the option “Number of Readers Per Node” to be greater than 1.
  4. Set the read method with specific file(s), set the Read From Multiple Nodes = yes, and provide the specific file in the file property.
  5. Set the read method with a file pattern and provide a file name with a wildcard that matches the existing file names in the file pattern property.
Correct answer: CD



Question 10

To run multiple copies of the same job within Director, which of the following must be supplied?


  1. Job name
  2. Invocation ID
  3. Parameter values
  4. Username and password
Correct answer: C









PROFEXAM WITH A 20% DISCOUNT

You can buy ProfExam with a 20% discount!



HOW TO OPEN VCEX FILES

Use ProfExam Simulator to open VCEX files