Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Google Professional Cloud Developer Exam - Topic 13 Question 121 Discussion

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?
B) Grant the service account BigQuery Data Editor and BigQuery Data Viewer roles.
A) Grant the service account BigQuery Data Viewer and BigQuery Job User 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.

Google Professional Cloud Developer Exam - Topic 13 Question 121 Discussion

Actual exam question for Google's Professional Cloud Developer exam
Question #: 121
Topic #: 13
[All Professional Cloud Developer Questions]

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?

Show Suggested Answer Hide Answer
Suggested Answer: B

by Corazon at May 15, 2026, 01:56 AM

Limited Time Offer

25%

Off

Get Premium Professional Cloud Developer Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Zack
4 days ago
Wait, why would you create a new dataset? That seems unnecessary.
upvoted 0 times
...
Rodrigo
9 days ago
B seems better, more permissions for editing.
upvoted 0 times
...
Chara
14 days ago
Totally agree with option A!
upvoted 0 times
...
Dacia
19 days ago
A) Grant the service account BigQuery Data Viewer and BigQuery Job User roles.
upvoted 0 times
...
Twana
24 days ago
Wait, why would you need to copy the table? That seems odd!
upvoted 0 times
...
Tori
29 days ago
D) seems like overkill for a permission issue.
upvoted 0 times
...
Carlton
1 month ago
C) sounds like a workaround, but is it really necessary?
upvoted 0 times
...
Reuben
1 month ago
I think B) is better for more access.
upvoted 0 times
...
Jolene
1 month ago
A) Grant the service account BigQuery Data Viewer and BigQuery Job User roles.
upvoted 0 times
...
Reyes
2 months ago
I vaguely remember that copying tables to a new dataset isn't usually necessary unless there's a permissions issue with the original dataset.
upvoted 0 times
...
Shoshana
2 months ago
I feel like creating a view might be a workaround, but it seems more complicated than just fixing the permissions.
upvoted 0 times
...
Barrie
2 months ago
I think I practiced a similar question where granting roles was the solution, but I can't recall if Data Editor is needed for this case.
upvoted 0 times
...
Ma
4 months ago
I remember something about service accounts needing specific roles to execute queries, but I'm not sure which ones are necessary.
upvoted 0 times
...

Save Cancel