Answer-first summary for fast verification
Answer: Assign the IAM role of BigQuery User to a Google Group that contains the members of the BI team.
The correct answer is D. Assigning the IAM role of BigQuery User to a Google Group that contains the members of the BI team will allow them to run custom SQL queries against the latest data in BigQuery. This role provides the necessary permissions to read the dataset's metadata, list tables, and run queries. Options A, B, and C do not directly address the requirement of running custom SQL queries against the latest data in BigQuery. Option A only provides a view access via Data Studio, option B involves managing service account keys, and option C incorrectly suggests moving the data to an internal data warehouse, which is unnecessary and irrelevant to the task.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
You are overseeing a critical project for your company's Business Intelligence (BI) department. This project involves a data pipeline that continuously ingests real-time data into BigQuery through streaming processes. To ensure that the BI department can effectively analyze and leverage this data, it is essential that users have the capability to execute custom SQL queries on the most current data available in BigQuery. What actions should you take to achieve this objective?
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.
No comments yet.