Answer-first summary for fast verification
Answer: Create a view on the table to present to the virtualization tool.
The correct answer is C: Create a view on the table to present to the virtualization tool. Creating a view in BigQuery allows the sales team to work with a subset of the original data that contains only the necessary columns or filtered data. This approach is cost-effective because it avoids the storage costs and maintenance overhead associated with exporting data to external tools or creating additional tables. Views ensure that the sales team is working with up-to-date data without the need for expensive queries on the full dataset. Additionally, views simplify data access for non-technical users while keeping data management efficient.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
Flowlogistic's CEO requires swift insights into their customer base to better equip the sales team, which lacks technical expertise, thereby necessitating the use of a visualization tool for generating BigQuery reports. The team is currently overwhelmed by the extensive data within the table, resulting in substantial query costs as they search for relevant information. Your objective is to provide a solution that minimizes costs effectively. What should you do?
A
Export the data into a Google Sheet for virtualization.
B
Create an additional table with only the necessary columns.
C
Create a view on the table to present to the virtualization tool.
D
Create identity and access management (IAM) roles on the appropriate columns, so only they appear in a query.