P2090-045 Online Practice Questions and Answers

Using a Job Sequence, which of the following tasks CANNOT be performed?

A. Define specific user variables and make them available within a Job Sequence

B. Drop a database table using a script, then start two different parallel jobs in sequence when a file appears in a specific directory

C. Run two different parallel jobs in sequence and use job parameters to pass different $APT_CONFIG _FILE values for each of them

D. Create multiple Exception Handlers stages to handle different types of failures

The ODBC Connector Stage can be used to connect to __________.

A. Oracle database

B. Teradata database

C. DB2 database

D. All of the above

Which of the following statements is an INVALID description of the Sort Stage Option Create Key Change Column?

A. Adds a column which holds a value of 0 or 1

B. 1 indicates the key value has changed

C. 0 indicates the key value has not changed

D. Adds a column which holds a value of true/false

A file contains a very large number of records with unique groups based on a key. Which Grouping Method would you prefer to use in the Aggregate Stage for aggregating the data?

A. Hash

B. Sort

C. Random

D. Round Robin

With Information Services Director, you can deploy services that package the following information provider types:

I.DataStage and QualityStage jobs II.SOAP over HTTP III.DB2 and Oracle SQL statements IV.Federation Server queries

A. I, II, IV

B. II, III, IV

C. I, II, III

D. I, III, IV

Which of the following statements about Collecting methods is correct?

A. ROUND ROBIN is the fastest algorithm

B. SORT MERGE never performs data sorting

C. ORDERED ensures the collected data stream being sorted

D. AUTO chooses the best method between ROUND ROBIN, SORT MERGE, and ORDERED

What is a supported function of the Dataset Management Utility?

A. Repartitions datasets

B. Stores datasets

C. Copies, views and deletes the dataset

D. Saves the table definition for the dataset

In which situation below can you use the Metadata Asset Manager with the MetaBrokers and Bridges (Import/Export Manager) to import metadata into the Metadata Repository?

A. To bring runtime information about DataStage jobs into the Metadata Repository

B. To bring FastTrack mapping specifications into the Metadata Repository

C. To bring Cognos BI reports and queries into the Metadata Repository

D. To bring a blueprint from Blueprint Director into the Metadata Repository

DataStage Parallel Engine supports __________.

A. Pipeline and Partition Parallelism

B. Pipeline Parallelism only

C. Partition Parallelism only

D. None of the above

Which of the following statements is not a supported matching option of the Lookup Stage?

A. Equality match

B. Caseless match

C. Range on the Target Link

D. Range on the Reference Link