Answer-first summary for fast verification
Answer: Create a view of the frequently queried data.
Feedback: A. Incorrect. This is not a recommended approach, because there will be redundant data. B. Correct. Creating a view will rerun the complex query automatically. Meanwhile, the analysts need only reference the name of the view, which makes it easier for them. C. Incorrect. This is not a recommended approach, because there will be redundant data. D. Incorrect. It requires more effort and cost to duplicate the data in another database.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Your analysts repeatedly run the same complex queries that combine and filter through a lot of data on BigQuery. The data changes frequently. You need to reduce the effort for the analysts.
A
Create a dataset with the data that is frequently queried.
B
Create a view of the frequently queried data.
C
Export the frequently queried data into a new table.
D
Export the frequently queried data into Cloud SQL
No comments yet.