PR000005 practice question 4 of 25

Which definition describes Column Profiling?

Full set: 140 questions
Answer options
A: Colum profiling automatically recognizes all functional and other dependencies in all tables, in particular the primary keys
B: Column profiling is the process of looking at every distinct value to determine the true minimum, maximum, data type, pattern and other important information about each attribute Correct answer
C: Column profiling identifies the attributes for referential integrity
D: Column profiling is the process of creating a normalized schema for your target system
Correct Answer:
B. Column profiling is the process of looking at every distinct value to determine the true minimum, maximum, data type, pattern and other important information about each attribute
Explanation

Column profiling is a fundamental data quality analysis technique focused on individual columns (attributes) within a data source. The process involves examining the content and structure of a single column to derive key statistical and informational metadata. This includes identifying the inferred data type, value frequencies, patterns, minimum and maximum values, and the number of null or distinct values. The primary goal is to understand the characteristics and quality of the data within that specific attribute, which is essential for data cleansing, standardization, and integration efforts.

Why Incorrect

A. This describes functional dependency analysis or primary key inference, which are types of data profiling that examine relationships between columns, not the intrinsic properties of a single column.
C. This describes foreign key or referential integrity analysis. This is a cross-table profiling task that validates relationships between columns in different tables, not a single-column analysis.
D. This describes database normalization, which is a data modeling and schema design process. While profiling results can inform normalization, it is not the definition of profiling itself.

References

1. Informatica Data Quality 10.5, Profiler Guide, Chapter 2: Profiling, Page 11.

The guide states, "A column profile analyzes the content and structure of data in a column. When you run a column profile, the Data Integration Service generates frequency counts and statistics for all the values in a column." It further details the results, which include data types, patterns, statistics (min, max), and value frequencies, directly supporting option B.

2. Informatica Data Explorer 8.6.1, User Guide, Chapter 2: Data Profiling, "Column Profiling", Page 23.

This official documentation defines column profiling as a process that "analyzes columns to understand the characteristics and content of the data." It lists outputs such as "data type, length, precision, scale, uniqueness, and frequency distribution," which aligns perfectly with the description in option B.

3. Rahm, E., & Do, H. H. (2000). Data Cleaning: Problems and Current Approaches. IEEE Data Eng. Bull., 23(4), 3-13. (A foundational academic paper on data quality).

Section 2.1 "Data Analysis" describes single-attribute analysis, which is synonymous with column profiling. It mentions analyzing data for "min, max, average, standard deviation..." and checking for "misspellings, and syntactic errors," which are determined by examining distinct values and patterns as stated in option B.

Scroll to Top