For the Information Server Repository, which Relational Database Management System (RDMS) CANNOT be used?
A. Microsoft SQL Server
B. Informix
C. DB2 UDB
D. Oracle
Which of the following is a valid Write Table action in the Connector Stages?
A. Append
B. Replace
C. Truncate
D. All of the above
Which of the following is NOT an option for the Reject Mode setting of a Sequential File Stage?
A. Continue
B. Reject
C. Fail
D. Output
Which of the following statements about Blueprint Director is incorrect?
A. Blueprint Director will display the time needed to perform individual tasks
B. You can browse and search Information Server metadata assets
C. You can create new blueprints from standard reference architecture templates
D. Reference architectures contain detailed method guidance for required activities
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 the Lookup Stage is correct?
A. It is a Real-Time Stage
B. It combines data horizontally
C. It can have only one input link defined
D. The default partition method for Lookup is Hash
With DataStage Designer you CANNOT __________.
A. Design jobs that extract, integrate, and transform the data for data warehouse
B. Create and reuse Table Definitions
C. Compile and execute the DataStage jobs
D. Configure the deployment model
Where can Job Parameters be used for DataStage parallel job development?
A. In directory and file names
B. In constraints and file names
C. In constraints and derivations
D. All of the above
DataStage Parallel Engine supports __________.
A. Pipeline and Partition Parallelism
B. Pipeline Parallelism only
C. Partition Parallelism only
D. None of the above
What is a descriptor file of a Dataset created by the Dataset Stage?
A. Contains the length of the data files
B. Contains metadata, data location, but not the data itself
C. Contains the actual data in text format
D. Contains the actual data in binary format
