MENU
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?
Suggested Answer: B
Get Premium Professional Cloud Developer Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
24 comments · newest first
AL
Allene
2 days ago
It gives necessary permissions without overdoing it.
SH
Shoshana
8 days ago
Why A?
AL
Allene
13 days ago
I think option A is the best.
LA
Lanie
18 days ago
I’m not sure about C. It adds another layer to manage.
DA
Daryl
23 days ago
Option C sounds interesting. Creating a view could simplify things.
YV
Yvonne
28 days ago
But B might be too much access. A is safer.
GE
German
1 month ago
I prefer option B. More permissions can help avoid issues.
NA
Nathan
1 month ago
It gives the necessary permissions without overdoing it.
SH
Sharika
1 month ago
Why A?
NA
Nathan
2 months ago
I think option A is the best.
OD
Odette
2 months ago
I'm surprised there's a permission error at all! Shouldn't it just work?
ZA
Zack
2 months ago
Wait, why would you create a new dataset? That seems unnecessary.
RO
Rodrigo
2 months ago
B seems better, more permissions for editing.
CH
Chara
2 months ago
Totally agree with option A!
DA
Dacia
2 months ago
A) Grant the service account BigQuery Data Viewer and BigQuery Job User roles.
TW
Twana
3 months ago
Wait, why would you need to copy the table? That seems odd!
TO
Tori
3 months ago
D) seems like overkill for a permission issue.
CA
Carlton
3 months ago
C) sounds like a workaround, but is it really necessary?
RE
Reuben
3 months ago
I think B) is better for more access.
JO
Jolene
3 months ago
A) Grant the service account BigQuery Data Viewer and BigQuery Job User roles.
RE
Reyes
4 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.
SH
Shoshana
4 months ago
I feel like creating a view might be a workaround, but it seems more complicated than just fixing the permissions.
BA
Barrie
4 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.
MA
Ma
5 months ago
I remember something about service accounts needing specific roles to execute queries, but I'm not sure which ones are necessary.