Answer-first summary for fast verification
Answer: Create a view on the table to present to the visualization tool.
The correct answer is C. Creating a logical view with only the required columns for visualization is the most efficient and cost-effective solution. Option B is not ideal because creating a separate table would make the data static, and updates to the original data would not reflect in this new table, leading to outdated information. A view ensures that the visualization tool always accesses the most current data without the need for additional tables or data exports.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Flowlogistic, a leading logistics and supply chain provider, is facing challenges in managing and tracking orders due to outdated infrastructure. They aim to leverage cloud technology for real-time inventory tracking and analytics to optimize resource deployment and predict shipment delays. Given their non-technical sales team's struggle with BigQuery reports due to overwhelming data, what is the most cost-effective solution to simplify data visualization for them?
A
Export the data into a Google Sheet for visualization.
B
Create an additional table with only the necessary columns.
C
Create a view on the table to present to the visualization tool.
D
Create identity and access management (IAM) roles on the appropriate columns, so only they appear in a query.
No comments yet.