Free Download C2090-424 Examp Dump: IBM.C2090-424.RealExams.2019-02-28.64q.vcex

Question 1

Assume you have before and after data sets and want to identify and process all of the changes between the two data sets. Assuming data is properly partitioned and sorted, which of the following should be used?

Difference
Change Apply
Change Capture
Change Capture and Change Apply

Correct answer: C

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_Change_Capture_Stage.html

Question 2

In the Masking Policy Editor in the Data Masking stage of your job, you have specified for a column containing credit card numbers the Random Replacement masking policy. For the Copy option you have specified “(1,2)(3,4)”.

What changes will be made to a credit card number, such as 6327664369, to mask it?

Digits 1 through 2 and digits 3 through 4 will be randomly changed. The rest of the digits will remain the same.
Digits 1 through 2 and digits 3 through 4 will remain the same. The rest of the digits will be randomly changed.
The 2 digits starting at digit 1 and the 4 digits starting at digit 3 will remain the same. The rest of the digits will be randomly changed.
The 2 digits starting at digit 1 and the 4 digits starting at digit 3 will be randomly changed. The rest of the digits will remain the same.

Correct answer: D

Question 3

What is the primary advantage of creating data rules within Information Analyzer as opposed to creating them within the Data Rules stage?

Data rules cannot be created within the Data Rules stage. They must first be created in Information Analyzer before they can be used in the Data Rules stage.
Rules created within Information Analyzer can be tested and debugged on non-operational data in a testing environment before they are put into production.
Rules created in the DataStage Data Rules stage have to be compiled into an executable form before they can be used.
The variables in rules created in DataStage Data Rules stage must first be bound to data columns or literals before they can be run.

Correct answer: B

Question 4

Which stages will require a schema file when runtime column propagation (RCP) is enabled? (Choose two.)

Data Set
Column Import
Internal Source
External Target
Make Subrecord

Correct answer: BD

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_using_rcp_with_sequential_stages.html

Question 5

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

Abort Job
Demote to warning
Promote to warning
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

Question 6

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

Question 7

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

Question 8

Consider a customer with multiple environments, Development, Test and Production. Which statement is TRUE?

Each environment must have a C++ compiler.
QualityStage rule sets are not a type of deployable asset.
It is not possible to revert to a previous version of a package.
A package can contain an improved version of a job which will replace the old one.

Correct answer: B

Question 9

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 10

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

Exam	InfoSphere DataStage v11.3
Number	C2090-424
File Name	IBM.C2090-424.RealExams.2019-02-28.64q.vcex
Size	179 KB
Posted	Feb 28, 2019
Download	IBM.C2090-424.RealExams.2019-02-28.64q.vcex

Download IBM.C2090-424.RealExams.2019-02-28.64q.vcex

File Info

How to open VCEX & EXAM Files?

Demo Questions