CRM CRM Data Management 1 — Questions and Answers

Question 1: What is 'data deduplication' in CRM systems?

Backing up CRM data twice
The process of identifying and merging duplicate records to maintain data quality (Correct answer)
Encrypting sensitive customer data
Archiving old customer records

Correct answer: The process of identifying and merging duplicate records to maintain data quality

Data deduplication finds and merges duplicate records (same contact entered twice) to maintain clean, accurate CRM data.

Data deduplication in CRM identifies records representing the same real-world entity that exist multiple times. Duplicates cause problems including: customers receiving multiple communications, inaccurate reporting, split interaction history, and wasted sales effort. Deduplication tools use fuzzy matching algorithms comparing name, email, phone, and company fields to identify likely duplicates. Most enterprise CRMs have built-in deduplication during import and ongoing duplicate detection. The process involves flagging, reviewing, and merging duplicate records while preserving all related activities and history.

Question 2: What is a 'mandatory field' (required field) in CRM data entry?

A field that auto-populates from external sources
A field that must be filled in before a record can be saved (Correct answer)
A field visible only to administrators
A field calculated from other fields

Correct answer: A field that must be filled in before a record can be saved

Mandatory fields must be populated before a record can be saved, ensuring critical data is always captured.

Mandatory (required) fields in CRM enforce data completeness by preventing records from being saved unless specific fields contain values. For example, a Contact record might require Last Name and Email. Deal records might require Deal Name, Close Date, and Pipeline Stage. Setting the right fields as mandatory balances data quality against user friction — too many required fields can discourage adoption, while too few leads to incomplete records. CRM platforms allow administrators to configure which fields are required and often allow context-specific requirements (field required only in certain pipeline stages).

Question 3: What is CRM data 'normalization'?

Converting all data to normal distribution
Standardizing data formats for consistency, such as phone number formatting (Correct answer)
Backing up data to multiple locations
Reducing database size by compressing data

Correct answer: Standardizing data formats for consistency, such as phone number formatting

Data normalization standardizes formats and values across CRM records for consistency, such as ensuring all phone numbers follow the same format.

Data normalization in CRM refers to standardizing data formats, values, and structures for consistency. Examples include: standardizing phone numbers to +1 (555) 123-4567 format, normalizing state names to two-letter codes (CA instead of California), standardizing company names (IBM vs. I.B.M. vs. International Business Machines), and enforcing consistent job title naming. Normalized data improves: search accuracy, deduplication effectiveness, reporting reliability, and system integrations. Many CRMs have built-in normalization tools, and ETL processes apply normalization during data imports.

Question 4: What does 'CRM data enrichment' involve?

Making the CRM interface more visually appealing
Automatically appending additional information to existing CRM records from external data sources (Correct answer)
Encrypting sensitive customer data
Removing outdated data from the CRM

Correct answer: Automatically appending additional information to existing CRM records from external data sources

Data enrichment supplements existing CRM records with additional information from external sources like LinkedIn, Clearbit, or ZoomInfo.

CRM data enrichment involves automatically or manually adding missing or supplementary data to CRM records from external sources. Examples: a contact's LinkedIn profile data (job title, company size, industry), company financials and employee count from Dun & Bradstreet, technographic data (what software a company uses) from BuiltWith or HG Insights, intent data (who's researching your solutions) from Bombora. Enrichment tools like Clearbit, ZoomInfo, and LinkedIn Sales Navigator integrate with major CRMs to continuously append and update data.

Question 5: What is 'data governance' in the context of CRM management?

Government regulations for customer data
A framework of policies, roles, and procedures ensuring CRM data quality, security, and appropriate use (Correct answer)
The process of archiving old CRM records
Software tools for CRM administration

Correct answer: A framework of policies, roles, and procedures ensuring CRM data quality, security, and appropriate use

Data governance establishes policies, ownership, and processes to ensure CRM data remains accurate, secure, consistent, and compliant.

CRM data governance is a comprehensive framework addressing: Data ownership (who is responsible for which data), Data quality standards (what constitutes acceptable data), Data entry policies (mandatory fields, format standards), Access controls (who can see/edit sensitive data), Retention policies (how long to keep different data types), Compliance requirements (GDPR, CCPA handling), Data stewardship (who monitors and maintains data quality), and Audit trails (tracking who changed what). Without governance, CRM data quality degrades over time as different users enter data inconsistently.

Question 6: What is 'GDPR' and how does it impact CRM data management?

A CRM software standard
The General Data Protection Regulation requiring explicit consent and data rights for EU citizens' personal data (Correct answer)
A global database performance rating
A customer relationship scoring system

Correct answer: The General Data Protection Regulation requiring explicit consent and data rights for EU citizens' personal data

GDPR is an EU regulation requiring organizations to obtain consent, protect personal data, and honor data subject rights like deletion and portability.

The General Data Protection Regulation (GDPR), effective May 2018, significantly impacts CRM data management for organizations handling EU residents' data. Key requirements include: Lawful basis for storing personal data (consent, legitimate interest, contract), Consent records (when and how consent was obtained), Right to be forgotten (ability to delete all personal data for an individual), Data portability (providing personal data in machine-readable format on request), Data breach notification (72-hour reporting requirement), Data minimization (only storing necessary data). CRMs must have features to record consent, process deletion requests, and export individual records to comply.

CRM CRM Data Management 1

What is 'data deduplication' in CRM systems?