IBM InfoSphere Business Information Exchange Technical Mastery Test v1 (P2090-046) Free Practice Test

Question 1

DataStage Parallel Engine supports __________.

A. None of the above

B. Partition Parallelism only

C. Pipeline and Partition Parallelism

D. Pipeline Parallelism only

Correct Answer: C

Question 2

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

A. All of the above

B. Oracle database

C. Teradata database

D. DB2 database

Correct Answer: A

Question 3

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

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

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. Define specific user variables and make them available within a Job Sequence

Correct Answer: A

Question 4

In DataStage, which client can be used to set environment variables at project level?

A. DataStage Designer

B. DataStage Director

C. Information Server Web Console

D. DataStage Administrator

Correct Answer: D

Question 5

Which of the following statements about Collecting methods is correct?

A. ORDERED ensures the collected data stream being sorted

B. SORT MERGE never performs data sorting

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

D. ROUND ROBIN is the fastest algorithm

Correct Answer: B

Question 6

Which of the following is a valid Write Table action in the Connector Stages?

A. Append

B. All of the above

C. Replace

D. Truncate

Correct Answer: B

Welcome to TestSimulate