HOTSPOT
You are developing a SQL Server Integration Services (SSIS) package.
You use a Data Profiling task to examine the data from a source system. You need to
establish:
The minimum and maximum dates for the datetime columns in the source data
The minimum, maximum, and average values for numeric columns in the source data
You need to use the appropriate profile type in the Data Profiling task.
Which profile type should you use? (To answer, select the appropriate profile type in the
answer area.)
Answer: 
Explanation:
Column Statistics Profile Request: This gives you the minimum, maximum, average, and standard deviation for numeric columns; and the minimum and maximum for datetime columns.
You can use the SSIS Data Profiling task for profiling the following:
**Column Length Distribution: To find strings of unexpected length.
**Column Null Ratio: To find the percentage of NULLs in a column.
**Column Pattern: A very powerful profiler that expresses ‘patterns within strings as
regular expressions’ and then calculates the distribution of these regular expressions.
**Column Value Distribution: Gives the distribution of values for discrete columns.
**Candidate Key: Gives the percentage of unique values in columns, thus helping to identify likely key-candidate columns.
**Functional Dependency: This profile reports how much the values in a dependent
column depend on the values in a set of determinant columns.
**Value Inclusion: Finds the extent to which column values from one table
have corresponding values in a set of column values of another table, thus helping find potential foreign keys.