Topic 1 Question 248
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?
Create a view with a filter to drop rows with fewer than 8 vCPU, and use the UNNEST operator.
Create a materialized view with a filter to drop rows with fewer than 8 vCPU, and use the WITH common table expression.
Create a view with a filter to drop rows with fewer than 8 vCPU, and use the WITH common table expression.
Use Dataflow to batch process and write the result to another BigQuery table.
ユーザの投票
コメント(2)
- 正解だと思う選択肢: A
A. Create a view with a filter to drop rows with fewer than 8 vCPU, and use the UNNEST operator.
👍 2scaenruy2024/01/03 - 正解だと思う選択肢: A
- The table structure shows that the vCPU data is stored in a nested field within the components column.
- Using the UNNEST operator to flatten the nested field and apply the filter.
👍 2raaad2024/01/04
シャッフルモード