C2090-305 Exam Questions

Which rule definition logic will ensure that no value in a column appears more than three times in the data?

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 pla...

The logic of a data rule has changed, producing unexpected results. What steps do you take to identify who updated the logic and when?

What steps are required to start working with data rules?

You are experiencing a problem which occurs primarily or exclusively when you import metadata. Which two logs would you use to collect diagnostic data, diagnose, and resolve the pr...

Which is NOT a defined metadata workspace within Information Analyzer?

The results of a column analysis can be further utilized in additional InfoSphere Information Server tools. Which item can be used to enforce domain requirements and completeness r...

Which statement is NOT true for installation of information Analyzer?

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

Which steps are required to import published analysis results into an Information Analyzer project?

A customer table contains a country code column representing the customer's country. There is a corresponding lookup table that captures which country code represents each country...

Given that a rule set contains two data rules that use the same variables, which statement is true?

Which of the following will allow you to run a data rule without using the Information Analyzer graphical user interface?

You suspect that data in a table contains inconsistent structure/formatting. Which Information Analyzer Column Analysis screen would be used to determine this?

At which levels can Information Analyzer analysis settings be set?

You need to check multiple columns for duplicates. How does changing the column sequence in Run Duplicate Analysis affect the duplicate check analysis results?

Which two steps are necessary to set up data rule monitoring?

Which two can be used to identify exception descriptors of interest in the Data Quality Console?

Which type of analysis provides the benefit of monitoring your data over time so that you can determine whether the content and structure of your data has changed?

You are configuring security for a user who will be testing Information Analyzer rules on an ad hoc basis. What steps are necessary to ensure the user can test the rules?

Which two steps are necessary to display exceptions in the Data Quality Console?

A new business group, working in a separate and distinct Information Analyzer environment, is starting to assess their data quality, but wishes to reuse existing data quality valid...

When creating a data rule definition through the HTTP API, which two can be included as attributes of the <DataRuleDefinition> element?

Which two can be scheduled using the API options?

What are the three domain analysis methods?

You need to check multiple columns for duplicates. How does changing the column sequence in run duplicate analysis affect the duplicate check analysis results?

How many Information Analyzer databases can a single installation have?

You are evaluating a Date of Birth field in a customer table. What are the three key steps in analyzing this field?

In which two screens can you see the output results of the data quality rules?

What feature allows you to mark issues for further investigation and add information to highlight problems to other data analysts for both columns and tables?

You have a Quantity field with the precision of two and it cannot have a negative or zero value. What steps can be taken to identify the Invalid values?

What feature permits the addition of data from one or more columns into one column allowing column analysis on this newly formed concatenated column?

When importing published analysis results into a different Information Analyzer project which two contents are included?

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 nam...

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 t...

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...

If there is a need to run data rules on a daily basis, which two options are valid?

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?

Which two techniques can be used to improve performance when processing large flat files?

You are analyzing a known table with a five column primary key. You wish to confirm its uniqueness with minimal processing time. Which steps should you take?

Which statement identifies one of the actions you need to perform before you can access the DataStage Director?

What column analysis process will infer a data class for each column in your data making it easier to compare domains of data?

Where can the Confidence Benchmark be set?

To import metadata into Information Analyzer, a user requires which Information Server role as a minimum?

Which two are valid connectors in Information Analyzer? (Choose two.)

Which two components must you identify when building a data connection? (Choose two.)

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 thi...

You need to analyze data in columns labeled "city", "state", and "zip_code". What Information Analyzer capability would you use to view distinct values across all three columns as...

You need to capture the results of a data rules execution so it can be used in subsequent data rules. Which approach will work?

When working with Information Analyzer reports, which two functions require use of the reporting functionality in the Information Server Web Console?