ExamTopics Logo
Mail Us[email protected]
Menu
Google Discussions
exam questions

Exam Associate Data Practitioner All Questions

View all questions & answers for the Associate Data Practitioner exam
Go to Exam

Exam Associate Data Practitioner topic 1 question 15 discussion

Actual exam question from Google's Associate Data Practitioner
Question #: 15
Topic #: 1
[All Associate Data Practitioner Questions]

You have a BigQuery dataset containing sales data. This data is actively queried for the first 6 months. After that, the data is not queried but needs to be retained for 3 years for compliance reasons. You need to implement a data management strategy that meets access and compliance requirements, while keeping cost and administrative overhead to a minimum. What should you do?

  • A. Use BigQuery long-term storage for the entire dataset. Set up a Cloud Run function to delete the data from BigQuery after 3 years.
  • B. Partition a BigQuery table by month. After 6 months, export the data to Coldline storage. Implement a lifecycle policy to delete the data from Cloud Storage after 3 years.
  • C. Set up a scheduled query to export the data to Cloud Storage after 6 months. Write a stored procedure to delete the data from BigQuery after 3 years.
  • D. Store all data in a single BigQuery table without partitioning or lifecycle policies.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by n2183712847 at Feb. 27, 2025, 6:42 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
n2183712847
2 months ago
Selected Answer: B
The best option is B. Partition a BigQuery table by month. After 6 months, export the data to Coldline storage. Implement a lifecycle policy to delete the data from Cloud Storage after 3 years. Option B provides the optimal balance of meeting the 3-year data retention requirement, achieving excellent cost optimization by tiering data to Coldline, and maintaining reasonable administrative overhead. Option C is more complex and less clear on overall retention and cost due to data duplication. Option D is the simplest administratively but provides the worst cost optimization. Option A is not cost-optimized and has moderate overhead. Therefore, Option B is the most practical and well-rounded solution for this data management scenario.
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago