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