Google Cloud Professional Data Engineer — Question 268
Your new customer has requested daily reports that show their net consumption of Google Cloud compute resources and who used the resources. You need to quickly and efficiently generate these daily reports. What should you do?
Answer options
- A. Do daily exports of Cloud Logging data to BigQuery. Create views filtering by project, log type, resource, and user.
- B. Filter data in Cloud Logging by project, resource, and user; then export the data in CSV format.
- C. Filter data in Cloud Logging by project, log type, resource, and user, then import the data into BigQuery.
- D. Export Cloud Logging data to Cloud Storage in CSV format. Cleanse the data using Dataprep, filtering by project, resource, and user.
Correct answer: A
Explanation
The correct answer is A, as exporting Cloud Logging data to BigQuery allows for efficient querying and analysis, enabling the creation of views that can dynamically filter the data by the required parameters. Option B does not utilize BigQuery, which limits the ability to efficiently analyze large datasets. Option C requires an additional step of importing data into BigQuery, which is less efficient than directly exporting it. Option D involves unnecessary data cleansing steps that can be avoided by using BigQuery's capabilities.