Google Cloud Professional Data Engineer PDE — Topic 1 Question 248

Question

dataset.inventory_vm sample records: You have an inventory of VM data stored in the BigQuery table. You want to prepare the data for regular reporting in the most cost-effective way. You need to exclude VM rows with fewer than 8 vCPU in your report. What should you do?

Accepted Answer

Correct answer: A. The correct answer is A. Option A: Create a view with a filter to drop rows with fewer than 8 vCPU, and use the UNNEST operator. This option delivers the requirement at the lowest cost.

Google Cloud Professional Data Engineer PDE — Question 248