Google
PROFESSIONAL-DATA-ENGINEER · Question #330
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 exclu
Sign in or unlock PROFESSIONAL-DATA-ENGINEER to reveal the answer and full explanation for question #330. The question stem and answer options stay visible for context.
Submitted by miguelv· Mar 30, 2026Building and operationalizing data processing systems
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?
Exhibit
Options
- ACreate the bucket with the Autoclass storage class feature.
- BCreate an Object Lifecycle Management policy to modify the storage class for data older than 30 days to nearline, 90 days to coldline, and 365 days to archive
- CCreate an Object Lifecycle Management policy to modify the storage class for data older than 30 days to coldline, 90 days to nearline, and 365 days to archive
- DCreate an Object Lifecycle Management policy to modify the storage class for data older than 30 days to nearline, 45 days to coldline, and 60 days to archive
Unlock PROFESSIONAL-DATA-ENGINEER to see the answer
You've previewed enough free PROFESSIONAL-DATA-ENGINEER questions. Unlock PROFESSIONAL-DATA-ENGINEER for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#BigQuery reporting#data filtering#cost optimization#vCPU filtering