Google Professional Cloud Developer Exam - Topic 16 Question 8 Discussion

Actual exam question for Google's Professional Cloud Developer exam

Question #: 8
Topic #: 16

[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?

AGrant the service account BigQuery Data Viewer and BigQuery Job User roles.

BGrant the service account BigQuery Data Editor and BigQuery Data Viewer roles.

CCreate a view in BigQuery from the SQL query and SELECT* from the view in the CLI.

DCreate a new dataset in BigQuery, and copy the source table to the new dataset Query the new dataset and table from the CLI.

Show Suggested Answer

Suggested Answer: B

by Zona at May 08, 2022, 05:36 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Kaycee

5 months ago

Wait, why would you need to create a new dataset? That seems odd.

upvoted 0 times

...

Percy

6 months ago

D sounds like overkill for a simple permission issue.

upvoted 0 times

...

Tonja

6 months ago

C seems unnecessary, just fix the permissions!

upvoted 0 times

...

Helga

6 months ago

I think B might be better, more access for editing.

upvoted 0 times

...

Mauricio

6 months ago

A looks like the right choice for permissions.

upvoted 0 times

...

Dorothea

6 months ago

I practiced a question similar to this, and I feel like the service account roles are key, but I can't remember if we need both roles or just one.

upvoted 0 times

...

Karon

6 months ago

Creating a view sounds familiar, but I can't recall if that would actually solve the permission error we're facing.

upvoted 0 times

...

Therese

6 months ago

I think granting both Data Editor and Job User roles might be the right approach, but I need to double-check the permissions needed for batch queries.

upvoted 0 times

...