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

A. When defining Output from the data rule, select ODBC DSN from drop down list for the target database for the results, name your table, and select "Overwrite" for update method.

B. When defining Output from the data rule, select System Table Only on the output tab, name your table, and select "Overwrite" for update method.

C. Export system generated table from Information Analyzer Database, load the export into the Information Server repository, and select "Import" for the update method.

D. When defining Output from the data rule, select Simple User-Named table on the output tab, name your table, and select "Overwrite" for update method.

A. Select lnvestigate>Publish Analysis Results; select the relevant Table; choose the Generate Database DDL option; select the database-specific DDL type; enter file location; click Submit.

B. Select lnvestigate>Column Analysis; select the relevant Table; select Export Data Model; select Create ANSI Standard DDL option; enter file location; click Submit.

C. Select lnvestigate>Publish Analysis Results; select the relevant Table; select Generate Physical Model; select Create DDL File option; enter file location; click Submit.

D. Select lnvestigate>Publish Analysis Results; select the relevant Table; choose the InfoSphere Metadata Asset Manager option; click Submit; create New Import Area; select the InfoSphere Data Architect Metabroker; select the created PDR model; select generate ANSI standard DDL; click Submit.

A. specfield CONTAINS {'X*. T}

B. specfield MATCHES_REGEX [XY]

C. specfield MATCHES_FORMAT X OR specfield MATCHES_FORMAT T

D. specfield CONTAINS ucase (XT)

A. Variable names can be the same and can be bound to different input columns.

B. Variable names can be the same but must be bound to the same input column.

C. A rule set can not contain more than one data rule.

D. Variable names must be unique.

A. Select the data class or sub-class indicating the type of information for each field containing personal information.

B. Update the 'Personal' attribute for each data field containing personal information.

C. Update the 'Priority' attribute for each data field containing personal information.

D. Select the 'Personal' status on the Domain & Completeness workspace.

A. Precision

B. Cardinality

C. Format

D. Classification

A. Data rules can be tested interactively during data rule creation.

B. Each data rule has a defined status.

C. You cannot transfer data rules to another environment.

D. Data rule definitions are explicit to one data source.

E. Data rules only produce exception data.