Google Professional Cloud Developer
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
When executing batch SQL queries against a BigQuery dataset by passing a SQL file to the BigQuery CLI and redirecting the output, you encounter a permission error. How should you resolve this issue?
A
Grant the service account BigQuery Data Viewer and BigQuery Job User roles.
B
Grant the service account BigQuery Data Editor and BigQuery Data Viewer roles.
C
Create a view in BigQuery from the SQL query and SELECT* from the view in the CLI.*
D
Create a new dataset in BigQuery, and copy the source table to the new dataset Query the new dataset and table from the CLI.