An e-commerce company stores customer order records in a relational database that feeds analytics dashboards and the customer-service portal. Over time, stale shipping addresses and duplicate customer accounts have begun to cause reporting errors and slow queries. The security manager is updating the data-maintenance plan. Which action will BEST ensure the ongoing accuracy and relevance of operational data while still supporting business use?
Schedule periodic data cleansing and validation to remove duplicates and correct outdated values
Apply read-only permissions to all production tables
Rotate the database encryption keys every six months
Move order records older than one year to cold storage
Scheduling regular data-cleansing and validation routines identifies duplicates, inconsistent formats, and obsolete fields so they can be corrected or removed. This proactive process maintains data integrity and keeps information reliable for day-to-day operations. Rotating encryption keys improves confidentiality but does not address data quality. Moving old records to cold storage is an archival control that does nothing for the accuracy of active data. Applying read-only permissions protects against unauthorized changes but will not fix existing errors or outdated information.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
Why are regular audits important for maintaining data quality?
Open an interactive chat with Bash
What is the difference between proactive and retrospective data management?
Open an interactive chat with Bash
How do access controls and retention periods differ from regular audits in data lifecycle management?
Open an interactive chat with Bash
ISC2 CISSP
Asset Security
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .