IBM C2090-423 Online Practice Questions and Exam Preparation

IBM C2090-423 Online Questions & Answers

• Question 31:

  Which of the following represents the minimum post-installation configuration steps to verify Information Analyzer is ready for analysis work?

  A. Information Analyzer is automatically configured during installation and no post-installation configuration is required.
  B. Create a user and assign Information Server Suite Access, Configure server DSN to Analysis database, validate Analysis Engine, verify connectivity to the Analysis database.
  C. Create a user and assign the role of Information Analyzer Project Administrator, configure server DSN to Analysis database, validate Analysis Engine, verify connectivity to the Analysis database.
  D. Create a user and assign the role of Information Analyzer Data Administrator with DataStage credentials, configure server DSN to Analysis database, validate Analysis Engine, verify connectivity to the Analysis database.
  D. Create a user and assign the role of Information Analyzer Data Administrator with DataStage credentials, configure server DSN to Analysis database, validate Analysis Engine, verify connectivity to the Analysis database.

• Question 32:

  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
  B. Status > Task Run > Abnormally Ended
  D. Origins > Information Analyzer > IA Export Project

• Question 33:

  You need to analyze new data that has been added to a table that you previously analyzed in Information Analyzer. Which Information Analyzer process would be used to accomplish this?

  A. column analysis
  B. baseline analysis
  C. publishing analysis results
  D. importing analysis data metadata
  A. column analysis

• Question 34:

  Which two of the following methods supports loading analysis results into the Information Server? (Choose two.)

  A. Analysis Metabroker
  B. DBM File Metabroker
  C. DataStage Exchange File
  D. Categories and Terms Metabroker
  E. InfoSphere Data Architect Metabroker
  B. DBM File Metabroker
  E. InfoSphere Data Architect Metabroker

• Question 35:

  Which statement is NOT true about data rule building?

  A. Rule definitions are built with a rule builder or free form editor.
  B. Rule logic can be linked with Boolean operators in the Condition field of rule builder.
  C. Information Analyzer will parse all expressions from free form builder into rule builder.
  D. Switching is allowed between the rule builder and free form builder while constructing rule definitions.
  C. Information Analyzer will parse all expressions from free form builder into rule builder.

• Question 36:

  You are working with a System Administrator who must move an Information Analyzer project to a new Information Server environment using the command line tools. You need to ensure that the project is established with the same metadata and users as in the original environment. Which of the following parameters must be included to successfully complete the export?

  A. -includeCommonMetadata; -includeProjectRoles; -includeAllDataClasses
  B. -includeAssignedAssets; -includeProjectRoleAssignments; -includeAllDataSources
  C. -includeCommonMetadata; -includeProjectRoleAssignments; -includeAllDataClasses
  D. -includeProjectMetadata; -includeProjectRoleAssignments; -includeDependentClasses
  C. -includeCommonMetadata; -includeProjectRoleAssignments; -includeAllDataClasses

• Question 37:

  You need to restrict access to source data in your project. What steps do you need to take to ensure that users can only view the analysis results?

  A. In the Project Properties workspace, select Details tab; check Enable Drilldown Security setting; Save All.
  B. In the Project Properties workspace, select Analysis Settings tab; check Restrict Drilldown setting; Save All.
  C. In the Project Properties workspace, select Users tab; select all users; uncheck the Drilldown user role; Save All.
  D. In the Project Properties workspace, select Data Sources tab; select all sources; click Apply Drilldown Security button; Save All.
  A. In the Project Properties workspace, select Details tab; check Enable Drilldown Security setting; Save All.

• Question 38:

  You have run a rule set over 3 time periods. What steps are necessary to determine if the overall information quality within the records has met the established thresholds?

  A. View Output Results; Select Overview tab; confirm that the number of exception records has declined.
  B. View Output Results; Select Overview tab; confirm that the number of exception records has met the Validity benchmark.
  C. View Output Results; Select Overview tab; confirm that the number of actual records over limit is below the Confidence benchmark.
  D. View Output Results; Select Overview tab; confirm that the number of exception patterns has met the Baseline Comparison benchmark.
  C. View Output Results; Select Overview tab; confirm that the number of actual records over limit is below the Confidence benchmark.

• Question 39:

  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.
  A. Use data sampling in Information Analyzer.
  D. Modify the DataStage apt config file to use multiple nodes and parallel process the data.

• Question 40:

  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.
  C. Use a data sample; limit the test to specific columns at one time; incrementally increase the number of possible column combinations.