Google Professional Data Engineer

Google Professional Data Engineer

Get started today

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?