LeetQuiz Logo
Privacy Policy•contact@leetquiz.com
© 2025 LeetQuiz All rights reserved.
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?

Exam-Like



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.

Powered ByGPT-5