Examtopics

Professional Cloud Developer

64
66

Topic 1 Question 65
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?
- Grant the service account BigQuery Data Viewer and BigQuery Job User roles.
- Grant the service account BigQuery Data Editor and BigQuery Data Viewer roles.
- Create a view in BigQuery from the SQL query and SELECT* from the view in the CLI.
- Create a new dataset in BigQuery, and copy the source table to the new dataset Query the new dataset and table from the CLI.
ユーザの投票
コメント(7)
- I think A is the correct one.
  
  👍 14
  donchick2020/12/21
- Ans A only https://cloud.google.com/bigquery/docs/access-control#bigquery In Ans B Bigquery Data Editor is not required.
  
  👍 4
  cloud_mk2021/04/01
- Principle of least privilege so A is the answer
  
  👍 3
  syu31svc2021/07/09
シャッフルモード

64
66