File Info
| Exam | InfoSphere DataStage v11.3 |
| Number | C2090-424 |
| File Name | IBM.C2090-424.PracticeTest.2019-02-13.34q.vcex |
| Size | 123 KB |
| Posted | Feb 13, 2019 |
| Download | IBM.C2090-424.PracticeTest.2019-02-13.34q.vcex |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
Demo Questions
Question 1
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.)
- Join
- Merge
- Modify
- Funnel
- 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 2
Which type of data can be extracted using the Unstructured Data stage?
- XML data
- Microsoft Word data
- Microsoft Excel data
- 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 3
Which of the following is TRUE when using a data set created with a 4 node config file?
- Data sets are operating system files
- Data is stored in a non-persistent form
- The data set control file holds all your data
- A Data Set stage can have 1 input link and multiple output links
Correct answer: B
Question 4
Which statement about restartable sequence jobs is TRUE?
- If a restartable sequence aborts, it can be restarted from Director.
- Choosing “Reset job” from Director will start the job where it left off.
- Checkpoints are always added to every eligible Job Activity stage in the sequence.
- 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 5
Given this configuration file:
Which of the following describes the resulting behavior for a job consisting of Row Generator -> data set?
- Conductor, section leader and player processes are executed on the server is1 and is2.
- Conductor process is executed on the server is1. Section leader and Player processes are executed on the server is2.
- Conductor and section leader processes are executed on the server is1. Player processes are executed on the server is2.
- Conductor process and player processes are executed on the server is1. Section leader process is executed on the server is2.
Correct answer: C
Question 6
Given this score:
It runs 3 processes on 2 nodes.
How does the job run?
- On two physical nodes and two logical nodes
- On two physical nodes and single logical node
- On a single physical node and two logical nodes
- On a single physical node and single logical node
Correct answer: D
Question 7
Which one of the following is an implicit data type conversion?
- date -> char
- char -> date
- varchar -> char
- char -> timestamp
Correct answer: D
Question 8
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.)
- Provide a specific file name in the file name property.
- In the file name property, provide a file name with a wildcard that matches the existing file names.
- Provide a specific file name in the file name property and select the option “Number of Readers Per Node” to be greater than 1.
- Set the read method with specific file(s), set the Read From Multiple Nodes = yes, and provide the specific file in the file property.
- 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 9
To run multiple copies of the same job within Director, which of the following must be supplied?
- Job name
- Invocation ID
- Parameter values
- Username and password
Correct answer: C
Question 10
Which statement about looping in sequences is TRUE?
- The Start Loop stage only supports numeric loops
- Numeric loops must increment by one unless you supply a parameter
- The current loop counter value can be passed to the stages in the loop
- The compiler will insert an End Loop as the last stage in the sequence if one is omitted
Correct answer: C
Explanation:
