Answer-first summary for fast verification
Answer: Assign the IAM role of BigQuery User to the BI team's Google group.
Option A is incorrect because transferring data to another warehouse is unnecessary for querying data directly in BigQuery. Option B is incorrect due to security risks associated with distributing private keys; it's not required for SQL query access. Option D is incorrect as it only allows data viewing, not querying. Option C is correct because assigning the BigQuery User role to the BI team's Google group enables them to directly query the data in BigQuery, fulfilling their need for real-time insights without unnecessary steps or security compromises.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
As the largest analytics firm in Asia, your company's Business Intelligence team requires the ability to run custom SQL queries on the latest user activity data in BigQuery, which is loaded via streaming inserts. What is the most appropriate action to facilitate this?
A
Schedule a batch Dataflow job using Cloud Scheduler to transfer the data from BigQuery to the BI team's internal data warehouse.
B
Create a Service Account for the BI team and provide each member with a new private key.
C
Assign the IAM role of BigQuery User to the BI team's Google group.
D
Develop a Data Studio dashboard linked to the relevant BigQuery tables and grant the BI team view access to the dashboard.
No comments yet.