IBM InfoSphere Information Analyzer v9.1 - C2090-305 Exam Practice Test

Question 1

Which two statements are relevant to key analysis in Information Analyzer?

A. Given a primary key, performing a duplicate check of primary key values in the table

B. The functional dependencies of two columns in a table

C. The confirmation or identification of a primary key for a table

D. The discovery of data objects

E. Determining the suitability of data values found in a table

Correct Answer: A,C

Question 2

It is desired to create a data rule to determine how many rows in the master data catalog have a primary shipping location that is not found in the location_number column in the "Location" table.
What is the proper rule definition logic to achieve this requirement?

A. master_catalog_primary_shipping_location NOT match location_number

B. master_catalog_primary_shipping_Iocation <> location_number

C. master_catalog_primary_shipping_location NOT in_reference_column location_number

D. master_catalog_primary_shipping_location NOT in_reference_list location_number

Correct Answer: B

Question 3

If there is a need to run data rules on a daily basis, which two options are valid?

A. Create a bundle and run lAJob command

B. Submit lAJob command on a daily basis from Information Server Operation console

C. Schedule lAJob runs using DataStage Director

D. Run lAJob command pointing to data rule executable

E. Run lABundle command pointing to all rules to be executed

Correct Answer: D,E

Question 4

Which two are NOT valid connectors in Information Analyzer?

A. ODBC Connector

B. Oracle Connector (v11)

C. SQL Server Connector

D. Informix Connector

E. DB2 Connector

Correct Answer: C,D

Question 5

Which two techniques can be used to improve performance when processing large flat files?

A. Place an index on the file.

B. Increase the metadata repository size.

C. Change the ODBC driver from text driver to parallel driver.

D. Use virtual tables.

E. Modify the DataStage APT config file to parallel process the data.

Correct Answer: B,E

Question 6

Which of the following will allow you to run a data rule without using the Information Analyzer graphical user interface?

A. HTTP API

B. Federation Server

C. Information Services Director

D. Tivoli

Correct Answer: B

Question 7

Which statement identifies one of the actions you need to perform before you can access the DataStage Director?

A. There is no relationship between DataStage Director and Information Analyzer.

B. Nothing is required because it is done automatically at setup.

C. Perform Credential mapping.

D. Configure in Information Analyzer Home > Configure > Setup DataStage Director.

Correct Answer: C

IBM InfoSphere Information Analyzer v9.1 - C2090-305 Exam Practice Test

Latest Update

Useful Links

Contact Us