Google Cloud Associate Cloud Engineer — Question 165

You are managing a project for the Business Intelligence (BI) department in your company. A data pipeline ingests data into BigQuery via streaming. You want the users in the BI department to be able to run the custom SQL queries against the latest data in BigQuery. What should you do?

Answer options

• A. Create a Data Studio dashboard that uses the related BigQuery tables as a source and give the BI team view access to the Data Studio dashboard.
• B. Create a Service Account for the BI team and distribute a new private key to each member of the BI team.
• C. Use Cloud Scheduler to schedule a batch Dataflow job to copy the data from BigQuery to the BI team's internal data warehouse.
• D. Assign the IAM role of BigQuery User to a Google Group that contains the members of the BI team.

Correct answer: D

Explanation

The correct answer is D because assigning the IAM role of BigQuery User to a Google Group allows all BI team members to run their own SQL queries against the data in BigQuery. Option A does not provide direct access to run queries, rather just view access to a dashboard. Option B is not necessary as service accounts are typically used for application access rather than individual user access. Option C involves transferring data which is unnecessary when users need direct query access to the latest data.