Answer-first summary for fast verification
Answer: Create multiple DBSQL warehouses, one for each business unit, and implement strict access controls on each warehouse.
Creating multiple DBSQL warehouses ensures that each business unit has its own environment, which simplifies access control and performance management. This approach aligns with best practices for segregation of business units across the catalog and ensures data isolation and security.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
You are tasked with creating a DBSQL warehouse for a large multinational corporation. The corporation has multiple business units, each requiring separate access controls and performance levels. Describe the steps you would take to ensure that the DBSQL warehouse meets these requirements, including how you would handle data object access control and segregation of business units across the catalog.
A
Create a single DBSQL warehouse and use tags to differentiate access for each business unit.
B
Create multiple DBSQL warehouses, one for each business unit, and implement strict access controls on each warehouse.
C
Create a single DBSQL warehouse and use SQL views to segregate data for each business unit.
D
Create a single DBSQL warehouse and use database-level permissions to control access for each business unit.
No comments yet.