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.

Simulated

Create a single DBSQL warehouse and use tags to differentiate access for each business unit.

14.1%

Create multiple DBSQL warehouses, one for each business unit, and implement strict access controls on each warehouse.

45.2%

Create a single DBSQL warehouse and use SQL views to segregate data for each business unit.

14.1%

Create a single DBSQL warehouse and use database-level permissions to control access for each business unit.

26.6%

Databricks Certified Data Engineer - Associate