Google Cloud Associate Cloud Engineer ACE — Topic 1 Question 178

Question

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?

Accepted Answer

Correct answer: D. The correct answer is D. Option D: Assign the IAM role of BigQuery User to a Google Group that contains the members of the BI team. BigQuery is a serverless, petabyte-scale data warehouse for fast SQL analytics with no infrastructure to manage. Cloud IAM grants fine-grained, least-privilege access to Google Cloud resources. This option meets the real-time / low-latency performance requirement.

Google Cloud Associate Cloud Engineer ACE — Question 178