Google Cloud Associate Cloud Engineer — Question 265

You use Cloud Logging to capture application logs. You now need to use SQL to analyze the application logs in Cloud Logging, and you want to follow Google-recommended practices. What should you do?

Answer options

• A. Develop SQL queries by using Gemini for Google Cloud.
• B. Enable Log Analytics for the log bucket and create a linked dataset in BigQuery.
• C. Create a schema for the storage bucket and run SQL queries for the data in the bucket.
• D. Export logs to a storage bucket and create an external view in BigQuery.

Correct answer: B

Explanation

The correct answer is B because enabling Log Analytics allows for efficient analysis of logs by creating a linked dataset in BigQuery, which is the recommended practice by Google. Options A, C, and D do not align with Google's best practices for analyzing Cloud Logging data using SQL as effectively as option B does.