You are analyzing a historical data source with 500 million records with approximately 15
million added per year. You wish to analyze only records from the year 2000. The table
contains a numeric field called YearAdded. What steps will allow you to minimize the data
analyzed?

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 (100=Germany, 101=France. 102=ltaly, and so on). Which rule logic would address
a requirement to find all French customers that have a phone number made up often digits?

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?