Chapter 11
- What is the purpose of workload groups?
Answer: Workload groups allow us to group together requests and queries and allow us to define constraints such as request limits, connection limits, and resource limits via workload group policies. This allows us to control access, monitor performance, and prevent users from consuming all of our clusters' resources.
- Assuming we have our request classification policy configured and enabled, what will happen when we execute the following query as a database administrator?
.alter cluster policy request_classification '{"IsEnabled":false}' <| iff(current_principal_is_member_of('aadgroup=TrialUsers;27447925-1f0e-41b6-b01f-973eaab478b0'), "Packt Demo","default")
Answer: The request classification policy will be disabled and all requests will be assigned to the default workload group.
- Why should you filter your data based...