Professional Cloud Architect · Free Practice Question Hard
Question 5
Your company has multiple regional analytics teams across North America, Europe, and Asia. Each region uses its own data warehouse, but executives want to standardize KPIs globally using Looker. You are tasked with designing a solution that ensures centralized modeling, governed metrics, and consistency, while allowing regional teams to explore their data independently. What should you do?
-
A
Deploy Looker in each region and let each team maintain its own data model
-
B
Export regional datasets to Cloud Storage and refresh them weekly for Looker to use
-
C
Use LookML to define centralized models and connect Looker to a shared BigQuery dataset with row-level access controls
-
D
Use federated queries to connect all data sources directly to Looker with no modeling
Reveal correct answer
Correct answer: C
A.
Leads to model duplication, inconsistent KPIs, and increased maintenance overhead.
B.
Manual exports introduce latency, staleness, and no dynamic querying.
C.
LookML enables centralized modeling of KPIs and metrics, ensuring consistency across teams. BigQuery supports row-level security, which allows users from different regions to access only relevant subsets of data, making the solution scalable, secure, and compliant with data residency and governance requirements.
D.
Bypassing modeling removes governance and increases risk of inconsistent definitions.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
