Search
Home
Saved
0
267 views
Sign In
Upload
Join
RELATED TITLES
0
Q&A Uploaded by Raf Portael
Bestsellers
Books
Audiobooks
C2090-424 Possible questions for certification
Save
Embed
Share
Print
Download
Magazines
News
Documents
Data Stage Scenario
1
of 6
Plan Analyzer Zos Product Brief Us
Latest IBM C2090-424
Search document
QUESTION 1
Sheet Music
Assume Ass ume you have have before before and after data sets and want to identify and process all of the c hange between the two data sets. Assuming data is properly partitioned and sorted, which of the followin should be used? C. Change Capture QUESTION 2
In the Masking Policy Editor Edit or in the Data Mask ing stage of your job, you hav have e specified for a colum containing credit card numbers numbers the Random Random Replacement masking policy. For the Copy Copy option yo have specified "(1,2) (3,4)". D. The The 2 digits starting st arting at digit 1 and the 4 digits starting at digit 3 will be randomly randomly chang The rest of the digits will remain the same. QUESTION 3
What is the primary advantage advantage of creating creati ng data rules within Information Information Analyzer Analy zer as opposed opposed to creating them within the Data Rules stage? B. Rules created withi n Information Information Analyzer Analy zer can be tested test ed and debugged on non-operati non -operati data in a testing tes ting environment environment before they t hey are put into production producti on QUESTION 4
Which Whic h stages will will require require a schema file when runtime runtime c olumn propagation propagation (RCP) (RCP) is enabled? enabled? (Ch two.) B. Column Import D. External Target QUESTION 5
Which Whi ch of the following actions ac tions are available available when editing editi ng a mess age handler? C. Promote to warning 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.) A. Join Join B. Merge M erge QUESTION 7
Which type of data can be extracted using the Unstructured Data stage? C. Microsoft Excel data QUESTION 8
Consider Consider a customer cust omer with with multiple environmen environments, ts, Development, Development, Test Test and Production. W hich Master your semester with Scribd statement is TRUE? Read Free Foron 30this Days Sign up to vote title B. QualityStage rule sets are not a type of deployable asset. & The New York Times Useful Not useful Cancel anytime.
Special offer forQUESTION students: Only 9 $4.99/month. Which of the following is TRUE when using a data set created with a 4 node config file?
Home
Saved
Bestsellers
Books
Audiobooks
Magazines
News
Documents
Sheet Music
Master your semester with Scribd & The New York Times Special offer for students: Only $4.99/month.
Upload
Sign In
Read Free For 30 Days Cancel anytime.
Join
Search
Home
Saved
267 views
0
Upload
Sign In
Join
RELATED TITLES
0
Q&A Uploaded by Raf Portael
Bestsellers
Books
Audiobooks
C2090-424 Possible questions for certification
Save
Embed
Share
Print
Download
Magazines
News
Documents
Data Stage Scenario
1
of 6
Plan Analyzer Zos Product Brief Us
Latest IBM C2090-424
Search document
QUESTION 12
Sheet Music
Given this configuration file: Which of the following describes the resulting behavior for a job consistin g of Row Generator -> d set? C. Conductor and section leader processes are executed on the server is1. Player pro are executed on the server is2. QUESTION 13
Given this score: It runs 3 processes on 2 nodes. How does the job run? C. On a single physical node and single logical node QUESTION 14
Which one of the following is an implicit data type conversion? D. char -> timestamp QUESTION 15
Which of the following are valid stage options for a parallel DataStage job which uses a configura file with multiple nodes and a File Connector as a source running in parallel mode? (Choose two. C. Provide a specific file name in the file name property and select the option "Number of Readers Per Node" to be greater than1. D. Set the read method with specific file(s), set the Read From Multiple Nodes = yes , a provide the specific file in the file property. QUESTION 16
Which statement about the ISD input stage is NOT TRUE? E. Text over JMS binding is only available if you are using Network Deployment QUESTION 17
You're Reading a Preview
In order to collect operational metadata, youfullmust dowith which the following? Unlock access a freeoftrial. C. Enable "Record job performance data" in the General tab of the project properties using Administrator client
Download With Free Trial
QUESTION 18
Which statement is TRUE about Balanced Optimization? 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) proces is pushed into database sources. QUESTION 19
Master your semester with Scribd To run multiple c opies of the same job within Director, which of the following must be supplied? Read Free Foron 30this Days Sign up to vote title C. Parameter values & The New York Times Useful Not useful QUESTION 20
Special offer for students: Only $4.99/month. Which statement about looping in sequences is TRUE? A. The Start Loop s tage only supports numeric loops
Cancel anytime.
Home
Saved
Bestsellers
Books
Audiobooks
Magazines
News
Documents
Sheet Music
Master your semester with Scribd & The New York Times Special offer for students: Only $4.99/month.
Upload
Sign In
Read Free For 30 Days Cancel anytime.
Join
Search
Home
Saved
0
267 views
Upload
Sign In
Join
RELATED TITLES
0
Q&A Uploaded by Raf Portael
Bestsellers
Books
Audiobooks
C2090-424 Possible questions for certification
Save
Embed
Share
Print
Download
Magazines
News
Documents
Data Stage Scenario
1
of 6
Plan Analyzer Zos Product Brief Us
Latest IBM C2090-424
Search document
QUESTION 23
Sheet Music
Which of the following is the default data type for the Aggregator stage during calculation? B. Double QUESTION 24
Which of the following is TRUE about working with assets and artifacts? D. You must import the source control project into your own source control workspace in Information Server Manager before you can submit assets QUESTION 25
Which is NOT a valid native operator for OSH? A. Sort QUESTION 26
A job consist of Sequential File Stage -> Copy Stage using auto partitioning -> Sequential File s We need the target Sequential File stage rows to be in the same order as the source file. Which collection algorithm should be chosen in the target Sequential File stage? D. Sorted merge QUESTION 27
Which restructure stage has a single reject link? D. Combine Records QUESTION 28
Which of the following will run the DataStage job in the Unix environment for the domain is1:9445 server is1 for the user srv_etl? B. dsjob domain is1:9445 server is1 userid srv_etl password {iisenc}infosphere run dst jTest101 You're Reading a Preview QUESTION 29
Unlock full access with a free trial.
How do you create a shared table definition from the DataStage client?
Download Free Trialwindow B. Use the shared table creation wizard from With the repository QUESTION 30
When building an UPDATE statement in SQL Query builder, which of the following is TRUE? D. Columns to update must be selected individually from the column selection grid
QUESTION 31
You are experiencing performance iss ues for a given job. You are assigned the task of underst what is happening at run time for that job. Read Free For 30this Days Signissues? up to vote on title What steps should you take to understand the job performance (Choose two.) Useful Not useful Cancel anytime. B. Use the performance analysis tool Special offer for students: Only $4.99/month. E. Run the job with $APT_DUMP_SCORE set to true
Master your semester with Scribd & The New York Times
Home
Saved
Bestsellers
Books
Audiobooks
Magazines
News
Documents
Sheet Music
Master your semester with Scribd & The New York Times Special offer for students: Only $4.99/month.
Upload
Sign In
Read Free For 30 Days Cancel anytime.
Join
Search
Home
Saved
267 views
0
Sign In
Upload
Join
RELATED TITLES
0
Q&A Uploaded by Raf Portael
Bestsellers
Books
Audiobooks
C2090-424 Possible questions for certification
Save
Embed
Share
Print
Download
Magazines
News
Documents
Data Stage Scenario
1
of 6
Plan Analyzer Zos Product Brief Us
Latest IBM C2090-424
Search document
QUESTION 33
Sheet Music
Which of the following is an FTP Collection method? D. Sort Merge
QUESTION 34
Which of the following will determine the running row number within a group? D. Use a Sort stage prior to the Transformer stage based on the key break column. Then, the LastRowinGroup() function to determine the last row in a group
QUESTION 35
Which of the following statements about checkpoint/restart is TRUE? A. The parallel framework does not support checkpoints inside jobs QUESTION 36
When you read or write to a sequential file, and wish to have a value be identified with DataStage NULL, which of the following is the option? B. Set string type default option using the value QUESTION 37
Which partitioning method requires a key? B. Same QUESTION 38
Record Count property is set to zero in Connector stage. How many rows are written out? A. All Rows QUESTION 39
You're Reading a Preview
Which statement is TRUE? Unlock full access with a free trial. D. The configuration file only needs to be copied to the conductor nodes from which paralle engine applications are started
Download With Free Trial
QUESTION 40
Which of the following is the schema format for a Time column? C. record (tField:time[s econds];) QUESTION 41
Which statement about shared containers is TRUE? B. A local container can be converted to a shared container
Master your semester with Scribd QUESTION 42 A job isYork designed with 3 Join stages in sequence. & The New Times
Join_1 keys are "Account", "Customer" and "PO_Date" Special offer for students: Only $4.99/month. Join_2 keys are "Account", "Customer" and "Txn" Join_3 keys are "Account", "Product_CD" and "Txn"
Read Free Foron 30this Days Sign up to vote title
Useful
Not useful
Cancel anytime.
Home
Saved
Bestsellers
Books
Audiobooks
Magazines
News
Documents
Sheet Music
Master your semester with Scribd & The New York Times Special offer for students: Only $4.99/month.
Upload
Sign In
Read Free For 30 Days Cancel anytime.
Join
Search
Home
Saved
0
267 views
Upload
Sign In
Join
RELATED TITLES
0
Q&A Uploaded by Raf Portael
Bestsellers
Books
Audiobooks
C2090-424 Possible questions for certification
Save
Embed
Share
Print
Download
Magazines
News
Documents
Sheet Music
Data Stage Scenario
1
of 6
Plan Analyzer Zos Product Brief Us
Latest IBM C2090-424
Search document
QUESTION 46
Which of the following locations will allow you to obtain a job's runtime logs? (Choose two.) C. Workload Manager E. Performance Monitor QUESTION 47
In order to use Cognos TM1 Connector, which statement is TRUE? D. Install theCognos TM1 API component and import the IBM Cognos TM1 certificate and a property file that stores truststore password QUESTION 48
Your job aggregates data before writing the results out to a DB2 table. You have sinc e learned t this job will be required to aggregate very large amounts of data. To ensure high performance create a new, nondefault configuration file for the job that defines a node pool named "highperfn 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 d using the "highperfnodes" pool? (Choose two.) 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 QUESTION 49
Parallel job column definitions have an SQL type associated with them. Which of the following is TRUE? C. Use the Parallel tab of the Edit Column Meta Data dialog box to view the SQL type QUESTION 50
You're Reading a Preview
A Parameter Set is a named object that can contain which of the following? D.Only one parameter and multipleUnlock valuefullfiles access with a free trial. QUESTION 51
Download With Free Trial
Which Slowly Changing Dimension (SCD) stage statement is TRUE? B. Each SCD stage processes multiple dimensions and performs lookups by using an equ matching QUESTION 52
Which of the following is NOT a valid use of stage variables? D. Storing the result on an expression to be used in multiple output columns
Master your semester with Scribd QUESTION 53 Free Foron 30this Days Sign up to vote title By default, how much internal memory does the Sort use perRead partition? 20MB Times & The NewB. York Useful Not useful Special offer for students: Only $4.99/month.
Cancel anytime.
QUESTION 54
The encrypt.sh or the encrypt.bat sc ript can be used to do which of the following?
Home
Saved
Bestsellers
Books
Audiobooks
Magazines
News
Documents
Sheet Music
Master your semester with Scribd & The New York Times Special offer for students: Only $4.99/month.
Upload
Sign In
Read Free For 30 Days Cancel anytime.
Join
Search
Home
Saved
0
267 views
Sign In
Upload
Join
RELATED TITLES
0
Q&A Uploaded by Raf Portael
Bestsellers
Books
Audiobooks
C2090-424 Possible questions for certification
Save
Embed
Share
Print
Download
Magazines
News
Documents
Sheet Music
Data Stage Scenario
1
of 6
Plan Analyzer Zos Product Brief Us
Latest IBM C2090-424
Search document
QUESTION 58
Archive files can contain assets from multiple exports of multiple tools. When importing into a pro from an archive file with the istool command, which order of asset ty pes below would yield the be performance? A. Users and groups, Common metadata, InfoSphere DataStage and QualityStage assets, Reports, Custom attributes for InfoSphere Information Covernance Catalog QUESTION 59
In your project there is a top level Sequencer job which has multiple sub sequencers and jobs. Yo have to move this Sequencer job to a new project. How do you determine which objec ts have exported? D. Select top level sequencer job and click on "Edit->Job Properties -> Dependencies" QUESTION 60
For very large records, you may need to set the following environment variable with an appropriat value in order to allow the job to run successfully: D. $APT_DEFAULT_TRANSPORT_BLOCK_SIZE
QUESTION 61
Which of the following is TRUE? D. When runtime column propagation is enabled, you can use output mapping on a stage You're Reading a Preview rename or drop QUESTION 62
Unlock full access with a free trial.
Which Connector Stage doesn't support reject Link Download With Free Trial B. ODBC Connector QUESTION 63
Select the command to reset a password to Info1234 for user srv_etl in the Information Server registry, in the Unix environment. C. SessionAdmin.sh user userid srv_etl password Info1234 QUESTION 64
Which of the following statements about real time job design is TRUE? D. The Information Services Director server starts job instances on one or more DataStag servers for load balancing and scalability. Read Free Foron 30this Days Sign up to vote title
Master your semester with Scribd & The New York Times Special offer for students: Only $4.99/month.
Useful
Not useful
Cancel anytime.
Home
Saved
Bestsellers
Books
Audiobooks
Magazines
News
Documents
Sheet Music
Master your semester with Scribd & The New York Times Special offer for students: Only $4.99/month.
Upload
Sign In
Read Free For 30 Days Cancel anytime.
Join
