An organization processes 10 million records for GDPR compliance audits nightly. Which database strategy best reduces processing time while maintaining data minimization principles?
-
A
Index all columns for maximum query speed
-
B
Partition tables by processing date and index only audit-relevant columns
-
C
Store all data in a single denormalized table for faster reads
-
D
Replicate the entire dataset to an in-memory database