You have created a platform wherein companies can place their data in Redshift tables for their order history. There are 5 major players which take up 80% of the data hosted and a small number of other players. You need to ensure that the resources for querying is distributed properly for the big players since they take up a major percentage of the data on Redshift. How can you achieve this without much additional maintenance overhead?

Answer options:

A.Create a separate user group and make use of Workload Management
B.Segregate the clusters based on the major players
C.Make sure the tables are created based on the EVEN distribution style
D.Make sure the tables are created based on the ALL distribution style

Answer – A
The AWS Documentation mentions the following
Amazon Redshift workload management (WLM) enables users to flexibly manage priorities within workloads so that short, fast-running queries won`t get stuck in queues behind long-running queries.
Amazon Redshift WLM creates query queues at runtime according to service classes, which define the configuration parameters for various types of queues, including internal system queues and user-accessible queues. From a user perspective, a user-accessible service class and a queue are functionally equivalent. For consistency, this documentation uses the term queue to mean a user-accessible service class as well as a runtime queue.
Option B is incorrect since this would add a maintenance overhead for the entire solution
Options C and D are incorrect since the distribution styles would assist with ensuring performance for the major players
For more information on workload management, please refer to the below URL
https://docs.aws.amazon.com/redshift/latest/dg/c_workload_mngmt_classification.html