North Carolina Data Migration Specialist Exam
Question and correct answers (verified
answers 100%) Q&A 2026/2027 INSTANT
DOWNLOAD PDF
1. What is the primary goal of a data migration project?
A. To permanently delete old systems
B. To move data from one system to another while maintaining integrity
C. To reduce employee access
D. To replace all databases
Correct Answer: B
Rationale: Data migration focuses on transferring data between systems while
preserving accuracy, completeness, security, and usability.
2. Which activity should occur first in a data migration project?
A. Data loading
B. Data validation
C. Migration planning and assessment
D. System retirement
Correct Answer: C
Rationale: Planning identifies requirements, risks, data sources, scope, and
migration strategies before execution begins.
3. What does ETL stand for?
,A. Extract, Transform, Load
B. Evaluate, Transfer, Link
C. Export, Translate, Launch
D. Extract, Test, Locate
Correct Answer: A
Rationale: ETL is the process of extracting data from sources, transforming it into
the required format, and loading it into the target system.
4. Which phase of migration involves removing duplicate records?
A. Data extraction
B. Data cleansing
C. Data archiving
D. Data loading
Correct Answer: B
Rationale: Data cleansing improves data quality by correcting errors, removing
duplicates, and standardizing information.
5. A data migration specialist should perform a data inventory to:
A. Increase database size
B. Identify available data assets and sources
C. Disable security controls
D. Remove metadata
Correct Answer: B
Rationale: Data inventories document existing data sources, formats, owners, and
dependencies.
6. Which data quality dimension measures whether data is correct?
,A. Completeness
B. Accuracy
C. Timeliness
D. Consistency
Correct Answer: B
Rationale: Accuracy evaluates whether data correctly represents real-world
values.
7. What is a major risk during data migration?
A. Improved reporting
B. Data loss or corruption
C. Better performance
D. Increased availability
Correct Answer: B
Rationale: Poor migration processes can result in missing, corrupted, or inaccurate
data.
8. What is the purpose of a migration mapping document?
A. To define employee schedules
B. To show how source fields map to target fields
C. To eliminate testing
D. To replace security policies
Correct Answer: B
Rationale: Mapping documents define relationships between source and
destination data structures.
9. Which migration approach moves all data at once?
, A. Incremental migration
B. Big bang migration
C. Hybrid migration
D. Parallel migration
Correct Answer: B
Rationale: Big bang migration transfers all data in a single migration event.
10. What is incremental migration?
A. Moving data in smaller batches over time
B. Deleting unused records
C. Copying only metadata
D. Avoiding testing
Correct Answer: A
Rationale: Incremental migration reduces risk by transferring data gradually.
11. What is data profiling used for?
A. Designing user interfaces
B. Examining data characteristics and quality
C. Encrypting applications
D. Managing employees
Correct Answer: B
Rationale: Data profiling analyzes patterns, values, completeness, and anomalies
in datasets.
12. Which technology is commonly used for large-scale data migration?
Question and correct answers (verified
answers 100%) Q&A 2026/2027 INSTANT
DOWNLOAD PDF
1. What is the primary goal of a data migration project?
A. To permanently delete old systems
B. To move data from one system to another while maintaining integrity
C. To reduce employee access
D. To replace all databases
Correct Answer: B
Rationale: Data migration focuses on transferring data between systems while
preserving accuracy, completeness, security, and usability.
2. Which activity should occur first in a data migration project?
A. Data loading
B. Data validation
C. Migration planning and assessment
D. System retirement
Correct Answer: C
Rationale: Planning identifies requirements, risks, data sources, scope, and
migration strategies before execution begins.
3. What does ETL stand for?
,A. Extract, Transform, Load
B. Evaluate, Transfer, Link
C. Export, Translate, Launch
D. Extract, Test, Locate
Correct Answer: A
Rationale: ETL is the process of extracting data from sources, transforming it into
the required format, and loading it into the target system.
4. Which phase of migration involves removing duplicate records?
A. Data extraction
B. Data cleansing
C. Data archiving
D. Data loading
Correct Answer: B
Rationale: Data cleansing improves data quality by correcting errors, removing
duplicates, and standardizing information.
5. A data migration specialist should perform a data inventory to:
A. Increase database size
B. Identify available data assets and sources
C. Disable security controls
D. Remove metadata
Correct Answer: B
Rationale: Data inventories document existing data sources, formats, owners, and
dependencies.
6. Which data quality dimension measures whether data is correct?
,A. Completeness
B. Accuracy
C. Timeliness
D. Consistency
Correct Answer: B
Rationale: Accuracy evaluates whether data correctly represents real-world
values.
7. What is a major risk during data migration?
A. Improved reporting
B. Data loss or corruption
C. Better performance
D. Increased availability
Correct Answer: B
Rationale: Poor migration processes can result in missing, corrupted, or inaccurate
data.
8. What is the purpose of a migration mapping document?
A. To define employee schedules
B. To show how source fields map to target fields
C. To eliminate testing
D. To replace security policies
Correct Answer: B
Rationale: Mapping documents define relationships between source and
destination data structures.
9. Which migration approach moves all data at once?
, A. Incremental migration
B. Big bang migration
C. Hybrid migration
D. Parallel migration
Correct Answer: B
Rationale: Big bang migration transfers all data in a single migration event.
10. What is incremental migration?
A. Moving data in smaller batches over time
B. Deleting unused records
C. Copying only metadata
D. Avoiding testing
Correct Answer: A
Rationale: Incremental migration reduces risk by transferring data gradually.
11. What is data profiling used for?
A. Designing user interfaces
B. Examining data characteristics and quality
C. Encrypting applications
D. Managing employees
Correct Answer: B
Rationale: Data profiling analyzes patterns, values, completeness, and anomalies
in datasets.
12. Which technology is commonly used for large-scale data migration?
