Google Cloud Professional Cloud Developer PCD — Topic 1 Question 65

Question

Your analytics system executes queries against a BigQuery dataset. The SQL query is executed in batch and passes the contents of a SQL file to the BigQuery CLI. Then it redirects the BigQuery CLI output to another process. However, you are getting a permission error from the BigQuery CLI when the queries are executed. You want to resolve the issue. What should you do?

Accepted Answer

Correct answer: A. The correct answer is A. Option A: Grant the service account BigQuery Data Viewer and BigQuery Job User roles. BigQuery is a serverless, petabyte-scale data warehouse for fast SQL analytics with no infrastructure to manage. A service account provides an identity for workloads to access Google Cloud APIs securely.

Google Cloud Professional Cloud Developer PCD — Question 65