Exit demo C2090-423 Information Analyzer v8.5 PDF format · free preview

IBM C2090-423 - Questions & Answers

Free preview · every answer includes a full explanation

Product page: https://prepkeys.com/c2090-423.html

Question 1
Single choice

You are trying to identify a multi-column primary key in a table of 50 million records.

What steps can you take to minimize performance impact?

A.

None, you must always assess full volume of data.

B.

Use a data sample; apply regression analysis to identify statistically likely candidates; apply duplicate
check.

C.

Use a data sample; limit the test to specific columns at one time; incrementally increase the number of
possible column combinations.

D.

Use a data sample; apply functional dependency analysis to remove dependent columns; incrementally
increase the number of possible column combinations.

Question 2
Single choice

You submitted a column analysis job with the "Retain Scripts" set to no. The column analysis job finished with an "error encountered" final message. You have access to the DataStage Director client.

Which option would allow you to find the source of the error?

A.

Create a log view in Information Analyzer and rerun the job. Examine the log to determine the error.

B.

Rerun the job with the "Retain Scripts" turned on. The error message will be returned to the Information Analyzer status window.

C.

Submit the job from Information Analyzer. After it finishes log onto DataStage Director and examine the

job log to determine the source of the error.

D.

Submit the job from Information Analyzer and place it on hold. Log onto DataStage Director, release the job and examine the job log to determine the source of the error.

Question 3
Single choice

While reviewing the results of a data rule test you find a logic error.

Which option will allow you to troubleshoot this error?

A.

Set the debug option when submitting the test job, then review the log.

B.

Open a command window on the client, submit the job and view the log.

C.

Set Retain Scripts to on and use DataStage Director to review the job log.

D.

Create a log view to capture the CAS log. Rerun the rule and review the log.

Question 4
Single choice

Which statement is true about analysis settings?

A.

Default Analysis settings can be created for individual users.

B.

Default Analysis settings cannot be configured for all projects.

C.

Default Analysis settings can be configured at the project level.

D.

Default Analysis settings are controlled by the DataStage Analysis project.

Question 5
Single choice

In a large enterprise, the human resource business unit wants to ensure the restriction of the analysis and analysis results to a set of HR managers.

Which configuration will support this requirement?

A.

Use operating system IDs and database IDs to restrict access.

B.

Use Information Server roles and security to restrict access to analysis and results.

C.

Install an Information Analyzer environment (analysis server, analysis engine, analysis database) for the HR business unit.

D.

Install an analysis engine for each business unit and one analysis database using Information server security to restrict access.

Question 6
Single choice

Which of the following is true about ODBC DSN's (data source names)?

A.

No ODBC DSN's are required.

B.

You must manually create the Information Analyzer database DSN.

C.

You must create a DSN for the data sources on both the client and server.

D.

The Information Analyzer database DSN is automatically created at installation time.

Question 7
Single choice

You are installing Information Analyzer and plan to use Oracle as the Information Analyzer analysis database.

Which statement is true?

A.

The metadata database must also be Oracle.

B.

The metadata database does not have to be Oracle.

C.

Only Oracle RAC (Real Application Clusters) is supported.

D.

The Information Analyzer analysis database can not be Oracle.

Question 8
Multiple choice

When analyzing large volumes of source data in column analysis, which two statements identify ways you can improve processing performance? (Choose two.)

A.

Use data sampling in Information Analyzer.

B.

Add more space to the Metadata repository.

C.

Modify the project Analysis settings to increase the buffer pools.

D.

Modify the DataStage apt config file to use multiple nodes and parallel process the data.

E.

Modify the Information Analyzer Analysis database config file to parallel process the data.

Question 9
Multiple choice

When analyzing large number of columns in Information Analyzer, which two components may require capacity planning review? (Choose two.)

A.

Disk space on the Engine layer.

B.

Disk space on the Application Server.

C.

Buffer pools on the Application Server.

D.

Information Server Metadata repository.

E.

Information Analyzer Analysis database.

Question 10
Multiple choice

When creating a Scheduling View, which two of the following options can be configured? (Choose two.)

A.

Status > Schedule > Pending

B.

Status > Task Run > Abnormally Ended

C.

Status > Task Run > Successfully Ended

D.

Origins > Information Analyzer > IA Export Project

E.

Origins > Information Analyzer > IA Report Execution

Showing 10 of 118 questions · Unlock the full set