As a data engineer at a large ecommerce company, your customer order data is stored in Bigtable. The current garbage collection policy deletes data after 30 days, and the number of versions is set to 1. However, data analysts occasionally encounter customer data that is older than 30 days when running queries to report total customer spending. Your task is to ensure that analysts see only customer data that is no older than 30 days, while also minimizing both cost and overhead. How would you achieve this?

Exam-Like

Set the expiring values of the column families to 29 days and keep the number of versions to 1.

17.1%

Use a timestamp range filter in the query to fetch the customer's data for a specific range.

57.1%

Schedule a job daily to scan the data in the table and delete data older than 30 days.

11.4%

Set the expiring values of the column families to 30 days and set the number of versions to 2.

14.3%

Google Professional Data Engineer