Explanation:
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.
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.