Ultimate access to all questions.
You have an inventory of virtual machines (VMs) data stored in the BigQuery table named 'dataset.inventory_vm.' This data will be used for generating regular reports, and it is crucial to ensure cost-effectiveness in the process. Your goal is to prepare the report by excluding any VM entries that have fewer than 8 virtual CPUs (vCPU). How should you proceed to achieve this?
Explanation:
Option A is correct because it involves creating a view with a filter to drop rows with fewer than 8 vCPU and using the UNNEST operator to handle nested fields. This approach avoids the additional costs and complexities associated with creating a materialized view or using Dataflow. A simple view is sufficient for regular reporting needs, especially when the vCPU data is stored in a nested field.