Data Retention and Automatic Data Expiry Quiz Quiz

1. Basics of Data Retention Policies

   Which statement best describes the purpose of a data retention policy in data management?

   1. It defines how long data should be kept before deletion.
   2. It sets password length requirements.
   3. It determines access rights for users.
   4. It manages the network speed.
   5. It schedules email notifications for users.

2. Setting Expiry Using SQL

   Given this SQL statement, what is being set? ALTER TABLE logs ADD COLUMN expiry_date DATE;

   1. A column is added to specify when each log entry should expire.
   2. A primary key is created.
   3. User permissions are being updated.
   4. A trigger is being added to delete rows automatically.
   5. A syntax error in the SQL.

3. Automatic Deletion in NoSQL Databases

   In MongoDB, which feature can be used to automatically delete documents after a certain period?

   1. TTL index
   2. Stored procedure
   3. Aggregate pipeline
   4. LEFT JOIN
   5. Foreign key constraint

4. Scenarios: Retention Period Configuration

   A company wants to ensure that chat messages are deleted 30 days after creation. What should be configured?

   1. Set retention period to 30 days for chat messages.
   2. Increase server memory by 30%.
   3. Enable read replicas for chat messages.
   4. Set maxRetries to 30 in API requests.
   5. Add a unique index on messages.

5. Interpreting Policy Mismatches

   A user sets data expiration to 90 days but finds old records still present after 120 days. Which might be a likely cause?

   1. Automatic expiry job failed or was misconfigured.
   2. Too many concurrent users accessed the system.
   3. Data was encrypted with the wrong key.
   4. Network latency prevented deletions.
   5. The wrong port was used for the database.

6. Understanding Expiry by Attribute Value

   If your application needs to delete records when the status equals 'inactive' for 60 days, what method is most appropriate?

   1. Set a scheduled process to check 'inactive' records and delete after 60 days.
   2. Rename the 'status' field to 'active'.
   3. Compress the entire database daily.
   4. Set a firewall rule on inactive data.
   5. Change all timestamps to UTC.

7. Common Mistakes in Automatic Expiry Setup

   Which of the following is a common mistake that can prevent automatic data expiry from working?

   1. Not running the scheduled deletion process.
   2. Enabling logging for API requests.
   3. Using SSDs instead of HDDs.
   4. Backing up data weekly.
   5. Assigning user roles with 'admin' privileges.

8. Legal and Compliance Considerations

   Why is it important to adhere to data retention periods defined by regulations, like GDPR?

   1. To avoid legal penalties for keeping data longer than allowed.
   2. To lower software licensing costs.
   3. To increase the data storage billing.
   4. To improve mobile app battery usage.
   5. To allow unlimited API key generation.

9. Cross-System Expiry Challenges

   If two different systems both store copies of user data, but only one enforces data expiry, what is the risk?

   1. Expired data may persist in the second system, violating retention policies.
   2. The data will always be encrypted twice.
   3. User accounts will be locked automatically.
   4. All records will be deleted instantly.
   5. There will be a syntax error in both systems.

10. Effective Use of Expiry Metadata

    What is the advantage of storing an 'expiration_date' field on each data record?

    1. It enables easy identification and automated removal of outdated records.
    2. It increases the disk usage unnecessarily.
    3. It enforces unique values for every record.
    4. It allows unlimited read queries.
    5. It disables all write operations.