IBM C2090-423 Online Practice Questions and Exam Preparation

IBM C2090-423 Online Questions & Answers

• Question 1:

  Which method would you use to connect to a directory of flat files?

  A. Flat file wizard
  B. Sequential Stage
  C. ODBC using IBM text file driver
  D. Same driver as used for the Information Server metadata repository
  C. ODBC using IBM text file driver

• Question 2:

  Where can you monitor trends in data quality over time?

  A. Data Rules
  B. Data Rule Definitions
  C. Information Analyzer Trend Viewer
  D. Information Analyzer Monitoring Add-on module
  A. Data Rules

• Question 3:

  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.
  B. You must manually create the Information Analyzer database DSN.

• Question 4:

  Which two of the following approaches can be used to manage and respond to exceptions generated by Data Rules? (Choose two.)

  A. Publish to Business Glossary
  B. Generate exception file via REST API
  C. Export exceptions from user interface
  D. Export exceptions via the DBM Metabroker
  E. Publish to Information Analyzer Exception Manager
  B. Generate exception file via REST API
  C. Export exceptions from user interface

• Question 5:

  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.
  C. Install an Information Analyzer environment (analysis server, analysis engine, analysis database) for the HR business unit.

• Question 6:

  You are working with a subject matter expert who does not have the Information Server console installed, but needs to receive a detailed value frequency distribution as a comma-delimited (csv) file. Which two of the following options can you use to deliver the required file? (Choose two.)

  A. Go to the Investigate>Table Management functions, select the frequency distribution file; export as a Delimited file; and send the file.
  B. Go to the Investigate>Publish Analysis Result functions, select the frequency distribution file; export as a Delimited file; and send the file.
  C. Go to the Reports menu, select the Data Rule Frequency Distribution report; choose the TXT output option and generate the report; and provide the URL to the report output.
  D. Use the IAAdmin command line interface (CLI); select the -getColumnOutputTable option providing the correct project and column names and the -csv format parameter; run the command and send the file.
  E. Use the IAAdmin command line interface (CLI); select the -getFrequencyDistribution option providing the correct project and column names and the -xsl format parameter to a csv-formatting stylesheet ; run the command and send the file.
  A. Go to the Investigate>Table Management functions, select the frequency distribution file; export as a Delimited file; and send the file.
  E. Use the IAAdmin command line interface (CLI); select the -getFrequencyDistribution option providing the correct project and column names and the -xsl format parameter to a csv-formatting stylesheet ; run the command and send the file.

• Question 7:

  Which two options are supported for creating Information Analyzer reports in XLS format? (Choose two.)

  A. Password protected.
  B. Include shapes in export.
  C. Keep existing word wrap.
  D. Use default full compression.
  E. Delimit fields as comma separated.
  B. Include shapes in export.
  C. Keep existing word wrap.

• Question 8:

  What is a Virtual Table?

  A. A data classification in the metadata management screen
  B. A segmentation of data from a table for analysis purposes
  C. A concatenation of data from one or more tables into one table
  D. A baseline snapshot of data for comparison purposes to other baselines
  B. A segmentation of data from a table for analysis purposes

• Question 9:

  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.
  C. Default Analysis settings can be configured at the project level.

• Question 10:

  You have run a rule set containing 20 rules, 3 of which relate to the Customer Name field, and produced 1000 exceptions. From the View Output Results tab, what steps are necessary to export a list of the records that only violated the 3 Customer Name rules?

  A. Select By Record View; Select the 3 rules; Select Export.
  B. Select By Rule View; Select the 3 rules; Select Show: Union; Select Export.
  C. Select By Pattern View; Select the Customer Name rule pattern; Select Export.
  D. Select By Rule View; Select the 3 rules; Select Show: Intersection; Select Export.
  B. Select By Rule View; Select the 3 rules; Select Show: Union; Select Export.