QuestionQ102

VerifiedEnsuring solution and operations excellence

Your company has a Google Cloud project that uses BigQuery for data warehousing with pay-per-use pricing. You need to monitor queries in real time to identify the most expensive queries and the users who spend the most. What should you do?

Explanation

BigQuery audit logs record user activity, including jobs and queries. Exporting the relevant BigQuery Data Access logs to a BigQuery dataset through a Cloud Logging sink makes the log data available for SQL analysis by submitting user and billed query volume. Cloud Billing exports are intended for billing analysis and have variable reporting and export latency, so they do not provide the required real-time, per-user query monitoring.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!