EMT Practice Test

1. Question Content...

---

Question1: Which one of the following stages requires a schema file when using Runtime Column Propagation?

Question2: 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 steps should you take to understand the job performance issues? (Choose two.)

Question3: Select the correct command to reset a password to Info1234 for user srv_etl in the Information Server internal registry, in the Unix environment.

Question4: When you read or write to a sequential file, and wish to have a value be identified with DataStage as NULL, which of the following is the correct option?

Question5: Which of the following locations will allow you to obtain a job's runtime logs? (Choose two.)

Question6: The APT_SubProcessOperator is used for what purpose?

Question7: Which Slowly Changing Dimension (SCD) stage statement is TRUE?

Question8: 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?

Question9: In your project there is a top level Sequencer job which has multiple sub sequencers and jobs. You have to move this Sequencer job to a new project. How do you determine which objects have to be exported?

Question10: 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?

Question11: When building an UPDATE statement in SQL Query builder, which of the following is TRUE?

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

Question13: Archive files can contain assets from multiple exports of multiple tools. When importing into a project from an archive file with the istool command, which order of asset types below would yield the best performance?

Question14: Which of the following environment variables can help in verifying whether data is evenly partitioned across all nodes?

Question15: Which of the following will determine the running row number within a group?

Question16: For very large records, you may need to set the following environment variable with an appropriate value in order to allow the job to run successfully:

Question17: Which of the following is an FTP Collection method?

Question18: Which of the following statements about checkpoint/restart is TRUE?

Question19: How do you create a shared table definition from the DataStage client?

Question20: By default, how much internal memory does the Sort use per partition?

Question21: Record Count property is set to zero in Connector stage. How many rows are written out?

Question22: Which of the following is the default data type for the Aggregator stage during calculation?

Question23: Which of the following statements about real time job design is TRUE?

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

Question25: You want to retain the record with the largest value in the TotalAmount column for each CustID and ProductType using a Remove Duplicates stage. How can this be accomplished?

Question26: Which statement is TRUE?

Question27: In order to collect operational metadata, you must do which of the following?

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

Question29: A Parameter Set is a named object that can contain which of the following?

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

Question31: In order to use Cognos TM1 Connector, which statement is TRUE?

Question32: 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.)

Question33: Which of the following is NOT a valid use of stage variables?

Question34: Which of the following is the correct schema format for a Time column?

Question35: Which of the following is TRUE about working with assets and artifacts?

Question36: 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.)

Question37: Which Connector Stage doesn't support reject Link

Question38: Which one of the following is NOT an XML Pack stage?

Question39: Your job consists of a DB2 Connector stage followed by a Sort stage followed by a Transformer stage followed by another DB2 Connector stage.
The following two Balanced Optimizer options have been selected:
Push processing to data sources

Push processing to data targets

The following two Balanced Optimizer options have NOT been selected:
Push data reduction processing to data targets

Push all processing into the (target) data server

Assuming the job design allows for maximum optimization, what does the optimized job design look like?

Question40: What COBOL data type is defined by Decimal data within the Complex Flat File stage?

Question41: Which partitioning method requires a key?

Question42: A job is designed with 3 Join stages in sequence.
Join_1 keys are "Account", "Customer" and "PO_Date"
Join_2 keys are "Account", "Customer" and "Txn"
Join_3 keys are "Account", "Product_CD" and "Txn"
Which of the following will lead to the best run time performance?

Question43: Which statement about the ISD input stage is NOT TRUE?

Question44: Parallel job column definitions have an SQL type associated with them. Which of the following is TRUE?

Question45: 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?

Question46: Which statement about restartable sequence jobs is TRUE?

Question47: Which statement about shared containers is TRUE?

Question48: Which is NOT a valid native operator for OSH?

Question49: Given this configuration file:

Which of the following describes the resulting behavior for a job consisting of Row Generator -> data set?

Question50: Which of the following is TRUE about Transformer Stage when
$APT_TRANSFORM_COMPILE_OLD_NULL_HANDLING is set?

Question51: The encrypt.sh or the encrypt.bat script can be used to do which of the following?

Question52: Which statement about looping in sequences is TRUE?

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

Question54: Which client Tool is used to export environment variables from a Project?

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

Question56: A job consist of Sequential File Stage -> Copy Stage using auto partitioning -> Sequential File stage. 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?

Question57: Which statement is TRUE about Balanced Optimization?

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

Question59: Given this score:

It runs 3 processes on 2 nodes.
How does the job run?

Question60: Your job aggregates data before writing the results out to a DB2 table. You have since learned that this job will be required to aggregate very large amounts of data. To ensure high performance you create a new, non-default configuration file for the job that defines a node pool named "highperfnodes" 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 data using the "highperfnodes" pool? (Choose two.)

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

Question62: Which of the following is NOT TRUE about the DataStage job score?

Question63: Which restructure stage has a single reject link?

Question64: Which of the following is TRUE?