Question 57:
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?
Answer options:
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.