Download IBM InfoSphere Information Analyzer v9.1.C2090-305.VCEplus.2019-09-02.64q.vcex

Vendor: IBM
Exam Code: C2090-305
Exam Name: IBM InfoSphere Information Analyzer v9.1
Date: Sep 02, 2019
File Size: 37 KB
Download Exam

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: EXAM_HUB

Discount: 20%

ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator

Demo Questions

Question 1
What feature permits the addition of data from one or more columns into one column allowing column analysis on this newly formed concatenated column?
  1. Virtual table
  2. Logical table
  3. Virtual column
  4. Logical column
Correct answer: C
Explanation:
Reference: https://www.scribd.com/doc/125259952/IBM-infoSphere-information-analyzer-v8-7-User-guide (page 70)
Reference: https://www.scribd.com/doc/125259952/IBM-infoSphere-information-analyzer-v8-7-User-guide (page 70)
Question 2
When importing published analysis results into a different Information Analyzer project which two contents are included?
  1. Median value
  2. Frequency values
  3. Data Classification
  4. Cardinality Percent
  5. Uniqueness Code
Correct answer: CD
Question 3
You are searching for an employee named Kristie Jones who has accounts on various applications, in which she has used the first names Kristie, Kristin, and Kristen as her first name. 
Which is the correct rule logic for addressing this problem?
  1. name like ('KristieTKristinTKristen')[ ]'Jones'
  2. name matches (,KristieTKristinTKristen,)[]'Jones,
  3. name contains ('KristieTKristinTKristen'^rJones'
  4. name matches_regex ('Kristie'l'KristinTKristen^j'Jones'
Correct answer: D
Question 4
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 reports as in the original environment. 
  
Which parameter must be included to successfully complete the export?
  1. -includeCommonMetadata; -includeCommonReports; -includeAIIDataClasses
  2. -includeAssignedAssets; -includeProjectReports; -includeAIIDataSources
  3. -includeCommonMetadata; -includeReports; -includeAIIDataClasses
  4. -includeProjectMetadata; -includelAReports; -includeDependentClasses
Correct answer: D
Question 5
You are working with a database administrator (DBA) who would like to create a revised format for a database based on your data profiling results. The DBA wants to directly create the resulting tables from the analysis. 
What steps are necessary to provide usable output to the DBA?
  1. Select lnvestigate>Publish Analysis Results; select the relevant Table; select Generate Physical Model; select Create DDL File option; enter file location; click Submit.
  2. Select lnvestigate>Column Analysis; select the relevant Table; select Export Data Model; select Create ANSI Standard DDL option; enter file location; click Submit.
  3. 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.
  4. 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.
Correct answer: B
Question 6
If there is a need to run data rules on a daily basis, which two options are valid?
  1. Create a bundle and run lAJob command
  2. Schedule lAJob runs using DataStage Director
  3. Run lAJob command pointing to data rule executable
  4. Run lABundle command pointing to all rules to be executed
  5. Submit lAJob command on a daily basis from Information Server Operation console
Correct answer: CE
Question 7
You wish to have selected members of your team assign Terms to columns during analysis review. What steps must you take to ensure they can add Term information?
  1. In the Project Properties workspace, select Users tab; check the Information Analyzer Data Operator role.
  2. In the Project Properties workspace, select Analysis Settings tab; select the Project View; check the Enable Glossary Updates box.
  3. In the Administration web console tab. select Users and Groups, check specific users and select Add Roles to Multiple Users; check Business Glossary Author.
  4. In the Administration web console tab. select Users and Groups, check specific users and select Add Roles to Multiple Users; check Information Analyzer Project Administrator.
Correct answer: D
Question 8
Which rule definition logic will ensure that no value in a column appears more than three times in the data?
  1. testvalue EXISTS <= 3
  2. testvalue OCCURS <= 3
  3. testvalue APPEARS <= 3
  4. testvalue CONTAINS <= 3
Correct answer: D
Question 9
You need to determine whether a specific column contains either an 'X' or a T character that can occur in any order. 
Which check would allow you to evaluate this condition?  
The placeholder specfield is used in the data rule definition to represent this column.
  1. specfield CONTAINS {'X*. T}
  2. specfield MATCHES_REGEX [XY]
  3. specfield CONTAINS ucase (XT)
  4. specfield MATCHES_FORMAT X OR specfield MATCHES_FORMAT T
Correct answer: C
Question 10
The logic of a data rule has changed, producing unexpected results. What steps do you take to identify who updated the logic and when?
  1. Open Data Rule, select Overview tab > Audit trail; review the Update events
  2. Open View Output, select Overview tab, open Change log; review the Update events
  3. Open Data Rule Definition, select Overview tab > Audit trail; review the Update events
  4. Open Data Rule Definition, select Overview tab > Usage view; review the Update events
Correct answer: A
CONNECT US
HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset

HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen

ProfExam
ProfExam at a 20% markdown

You have the opportunity to purchase ProfExam at a 20% reduced price

Get Now!