Exam Code: C2090-305 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: IBM InfoSphere Information Analyzer v9.1
Certification Provider: IBM
Free Today! Guaranteed Training- Pass C2090-305 Exam.
2021 May C2090-305 Study Guide Questions:
Q31. What are two characteristics of data rules?
A. Each data rule has a defined state.
B. Data rules only produce exception data.
C. Data rule definitions are explicit to one data source.
D. You cannot transfer data rules to another environment.
E. Data rules can be tested interactively during data rule creation.
Answer: A,E
Reference:https://www.scribd.com/doc/125259952/IBM-infoSphere-information-analyzer-v8-7-User-guide(page 130)
Q32. Which can be done in the Data Rule Stage?
A. Create a metric
B. Unpublish a rule
C. Delete a published rule
D. Create an unpublished rule
Answer: A
Q33. What feature permits the addition of data from one or more columns into one column allowing column analysis on this newly formed concatenated column?
A. Virtual table
B. Logical table
C. Virtual column
D. Logical column
Answer: C
Reference:https://www.scribd.com/doc/125259952/IBM-infoSphere-information-analyzer-v8-7-User-guide(page 70)
Up to the minute C2090-305 torrent:
Q34. Which two steps are necessary to set up data rule monitoring?
A. Create Metric.
B. Create Data Rule Definition.
C. Create Data Source connection.
D. Create batch script to run data rule.
E. Create and configure dashboard environment to see run results.
Answer: A,C
Q35. When importing published analysis results into a different Information Analyzer project which two contents are included?
A. Median value
B. Frequency values
C. Data Classification
D. Cardinality Percent
E. Uniqueness Code
Answer: C,D
Q36. 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?
A. name like ('KristieTKristinTKristen')[ ]'Jones'
B. name matches (,KristieTKristinTKristen,)[]'Jones,
C. name contains ('KristieTKristinTKristen'^rJones'
D. name matches_regex ('Kristie'l'KristinTKristen^j'Jones'
Answer: D
Exact C2090-305 pack:
Q37. Which two can be scheduled using the API options?
A. Data Rules
B. Policy Monitors
C. Domain Analysis
D. Task Sequences
E. Baseline Analysis
Answer: A,E
Q38. Which rule definition logic will ensure that no value in a column appears more than three times in the data?
A. testvalue EXISTS <= 3
B. testvalue OCCURS <= 3
C. testvalue APPEARS <= 3
D. testvalue CONTAINS <= 3
Answer: D
Q39. It is desired to create a data rule to determine how many rows in the master data catalog have a primary shipping location that is not found in the location_number column in the "Location" table.
What is the proper rule definition logic to achieve this requirement?
A. master_catalog_primary_shipping_location <> location_number
B. master_catalog_primary_shipping_location NOT match location_number
C. master_catalog_primary_shipping_location NOT in_reference_list location_number
D. master_catalog_primary_shipping_location NOT in_reference_column location_number
Answer: D
Reference:https://www.scribd.com/doc/125259952/IBM-infoSphere-information-analyzer-v8-7-User-guide(page 145)
Q40. You are reviewing the summary of a data rule on the Information Analyzer Home Page dashboard and see a red exclamation mark.
What does it signify?
A. The data rule was run via an external scheduler.
B. The job for the data rule failed to run successfully.
C. The data rule result was not delivered to the Data Quality Console.
D. The data rule failed to meet the target benchmark for two or more instances.
Answer: B
Reference:https://www.scribd.com/doc/125259952/IBM-infoSphere-information-analyzer-v8-7-User-guide(p. 190, last para of the page)