ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 87 - Professional Cloud Developer discussion

Report
Export

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?

A.
Grant the service account BigQuery Data Viewer and BigQuery Job User roles.
Answers
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.
Answers
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.
Answers
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.
Answers
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.
Suggested answer: B
asked 18/09/2024
leconte maxime
36 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first