nerdexam
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…

The correct answer is A. Create the bucket with the Autoclass storage class feature. Explanation/Reference: You are expecting to ingest approximately 25 GB of data a day and your billing department is worried about the increasing cost of storing old data. The current business requirements are: - The old data can be deleted anytime. - There is no predefined…

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

PROFESSIONAL-DATA-ENGINEER question #330 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

How the community answered

(45 responses)
  • A
    91% (41)
  • B
    2% (1)
  • C
    7% (3)

Explanation

Explanation/Reference: You are expecting to ingest approximately 25 GB of data a day and your billing department is worried about the increasing cost of storing old data. The current business requirements are: - The old data can be deleted anytime. - There is no predefined access pattern of the old data. - The old data should be available instantly when accessed. - There should not be any charges for data retrieval. What should you do to optimize for cost? storage class. Delete old data as needed. storage class. Delete old data as needed. storage class. Delete old data as needed. Explanation/Reference:

Topics

#BigQuery reporting#data filtering#cost optimization#vCPU filtering

Community Discussion

No community discussion yet for this question.

Full PROFESSIONAL-DATA-ENGINEER Practice