Question 220
An enterprise platform team is preparing changes that must succeed in the same environment. The two changes apply to different resources. Requirement A: analysts need interactive SQL aggregation over very large event datasets. Requirement B: object data is read about quarterly and held for several months. Which option lists the right first configuration followed by the right second configuration?
Explanation
Correct Answer
BigQuery is a managed analytical SQL warehouse. Coldline targets low-frequency access with 90-day minimum storage.
Incorrect Answers
Both requirements remain unmet: DNS is for name resolution rather than large-scale SQL analytics; A temporary filesystem is not appropriate persistent object storage.
The first action is valid: BigQuery is a managed analytical SQL warehouse. But the second fails: A temporary filesystem is not appropriate persistent object storage.
The second action is valid: Coldline targets low-frequency access with 90-day minimum storage. But the first fails: DNS is for name resolution rather than large-scale SQL analytics.