Question 241 of 307
Single answerdataset.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?
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?
✓ACreate a view with a filter to drop rows with fewer than 8 vCPU, and use the UNNEST operator.
BCreate a materialized view with a filter to drop rows with fewer than 8 vCPU, and use the WITH common table expression.
CCreate a view with a filter to drop rows with fewer than 8 vCPU, and use the WITH common table expression.
DUse Dataflow to batch process and write the result to another BigQuery table.
✓
Correct Answer: A
Create a view with a filter to drop rows with fewer than 8 vCPU, and use the UNNEST operator.
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Google certification topics.