Question 20
Developers want objects grouped by application and grants applied to that namespace, without dedicating compute. Which organization fits?
Explanation
Correct Answer
Correct: schemas group database objects without allocating warehouse compute. Separate schema organizes and scopes database objects and privileges.
Incorrect Answers
Not the best choice: Resource monitor tracks credit thresholds and can notify or suspend managed warehouses; the scenario instead requires schemas group database objects without allocating warehouse compute.
Dedicated virtual warehouse separates the compute pool used by a workload but does not itself perform credit-budget alerting or provide a schema namespace. The scenario instead selects Separate schema, as indicated by the stated operational requirement.
Not the best choice: Warehouse size increase increases compute capacity within a warehouse cluster; the scenario instead requires schemas group database objects without allocating warehouse compute.