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?
Click on the arrows to vote for the correct answer
A. B. C. D.C.
The best option to allow the BI team to run custom SQL queries against the latest data in BigQuery is to assign the IAM role of BigQuery User to a Google Group that contains the members of the BI team. This option ensures that the BI team has the necessary permissions to access and query the data in BigQuery.
Explanation of each option:
A. Creating a Data Studio dashboard that uses the related BigQuery tables as a source and giving the BI team view access to the Data Studio dashboard would allow the BI team to view the data, but they would not be able to run custom SQL queries against the latest data in BigQuery.
B. Creating a Service Account for the BI team and distributing a new private key to each member of the BI team would allow them to access BigQuery programmatically, but it would not allow them to run custom SQL queries against the latest data in BigQuery.
C. Using Cloud Scheduler to schedule a batch Dataflow job to copy the data from BigQuery to the BI team's internal data warehouse would allow the BI team to access the data in their own data warehouse, but it would not allow them to run custom SQL queries against the latest data in BigQuery.
D. Assigning the IAM role of BigQuery User to a Google Group that contains the members of the BI team would allow them to run custom SQL queries against the latest data in BigQuery, as well as access and view the data in BigQuery. This option provides the necessary permissions for the BI team to work with the data in BigQuery in a flexible and efficient way.
Therefore, the correct answer is D.