GoogleGoogle
PROFESSIONAL-CLOUD-DEVELOPER · Question #13
PROFESSIONAL-CLOUD-DEVELOPER Question #13: Real Exam Question with Answer & Explanation
The correct answer is A: Grant the service account BigQuery Data Viewer and BigQuery Job User roles.. https://cloud.google.com/bigquery/docs/access-control#bigquery
Integrating Google Cloud services with applications: Security and Access
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?
Options
- AGrant the service account BigQuery Data Viewer and BigQuery Job User roles.
- BGrant the service account BigQuery Data Editor and BigQuery Data Viewer roles.
- CCreate a view in BigQuery from the SQL query and SELECT* from the view in the CLI.
- DCreate a new dataset in BigQuery, and copy the source table to the new dataset Query the new
Explanation
https://cloud.google.com/bigquery/docs/access-control#bigquery
Topics
#BigQuery IAM#Permissions Management#Service Accounts#BigQuery CLI
Community Discussion
No community discussion yet for this question.