Parson Fortunes Ltd is an Asian-based department store operator with an extensive network of 131 stores, spanning approximately 4.1 million square meters of retail space across cities in India, China, Vietnam, Indonesia and Myanmar.
Parson built a VPC to host their entire enterprise infrastructure on cloud. Parson has large assets of data around 20 TB’s of structured data and 45 TB of unstructured data and is planning to host their data warehouse on AWS and unstructured data storage on S3. The files sent from their on premise data center are also hosted into S3 buckets. Parson IT team is well aware of the scalability, performance of AWS services capabilities. Parson hosts their web applications, databases and the data warehouse built on Redshift in VPC. The administrator want to improve the query improve and planning to implement Workload Management (WLM) in Redshift. Suggest some of the best practices! select 4 options.

Answer options:

A.Configure up to eight query queues and set the number of queries that can run in each of those queues concurrently
B.Set up rules to route queries to particular queues based on the user running the query or labels
C.Configure the amount of CPU allocated to each queue, so that large queries run in queues with more CPU than other queues
D.Configure the WLM timeout property to limit short-running queries.
E.Short query acceleration (SQA) prioritizes selected short-running queries ahead of longer- running queries in a dedicated space
F.if you enable Short query acceleration (SQA), long-running queries contend with short queries for slots in a queue
G. If you enable Short query acceleration (SQA), you can reduce or eliminate workload management (WLM) queues that are dedicated to running short queries

Answer : A, B, E, G
Option A is correct - Configure up to eight query queues and set the number of queries that can run in each of those queues concurrently. You can set up rules to route queries to particular queues based on the user running the query or labels that you specify. You can also configure the amount of memory allocated to each queue, so that large queries run in queues with more memory than other queues. You can also configure the WLM timeout property to limit long-running queries. 
https://docs.aws.amazon.com/redshift/latest/dg/cm-c-implementing-workload-management.html
Option B is correct -Configure up to eight query queues and set the number of queries that can run in each of those queues concurrently. You can set up rules to route queries to particular queues based on the user running the query or labels that you specify. You can also configure the amount of memory allocated to each queue, so that large queries run in queues with more memory than other queues. You can also configure the WLM timeout property to limit long-running queries. 
https://docs.aws.amazon.com/redshift/latest/dg/cm-c-implementing-workload-management.html
Option C is incorrect - Configure up to eight query queues and set the number of queries that can run in each of those queues concurrently. You can set up rules to route queries to particular queues based on the user running the query or labels that you specify. You can also configure the amount of memory allocated to each queue, so that large queries run in queues with more memory than other queues. You can also configure the WLM timeout property to limit long- running queries. 
https://docs.aws.amazon.com/redshift/latest/dg/cm-c-implementing-workload-management.html
Option D is incorrect -Configure up to eight query queues and set the number of queries that can run in each of those queues concurrently. You can set up rules to route queries to particular queues based on the user running the query or labels that you specify. You can also configure the amount of memory allocated to each queue, so that large queries run in queues with more memory than other queues. You can also configure the WLM timeout property to limit long-running queries. 
https://docs.aws.amazon.com/redshift/latest/dg/cm-c-implementing-workload-management.html
Option E is correct -Short query acceleration (SQA) prioritizes selected short-running queries ahead of longer-running queries. SQA executes short-running queries in a dedicated space, so that SQA queries aren`t forced to wait in queues behind longer queries. SQA only prioritizes queries that are short-running and are in a user-defined queue. With SQA, short-running queries begin running more quickly and users see results sooner.
If you enable SQA, you can reduce or eliminate workload management (WLM) queues that are dedicated to running short queries. In addition, long-running queries don`t need to contend with short queries for slots in a queue, so you can configure your WLM queues to use fewer query slots. When you use lower concurrency, query throughput is increased and overall system performance is improved for most workloads. 
https://docs.aws.amazon.com/redshift/latest/dg/wlm-short-query-acceleration.html
Option F is incorrect -Short query acceleration (SQA) prioritizes selected short-running queries ahead of longer-running queries. SQA executes short-running queries in a dedicated space, so that SQA queries aren`t forced to wait in queues behind longer queries. SQA only prioritizes queries that are short-running and are in a user-defined queue. With SQA, short-running queries begin running more quickly and users see results sooner.
If you enable SQA, you can reduce or eliminate workload management (WLM) queues that are dedicated to running short queries. In addition, long-running queries don`t need to contend with short queries for slots in a queue, so you can configure your WLM queues to use fewer query slots. When you use lower concurrency, query throughput is increased and overall system performance is improved for most workloads. 
https://docs.aws.amazon.com/redshift/latest/dg/wlm-short-query-acceleration.html
Option G is correct -Short query acceleration (SQA) prioritizes selected short-running queries ahead of longer-running queries. SQA executes short-running queries in a dedicated space, so that SQA queries aren`t forced to wait in queues behind longer queries. SQA only prioritizes queries that are short-running and are in a user-defined queue. With SQA, short-running queries begin running more quickly and users see results sooner.
If you enable SQA, you can reduce or eliminate workload management (WLM) queues that are dedicated to running short queries. In addition, long-running queries don`t need to contend with short queries for slots in a queue, so you can configure your WLM queues to use fewer query slots. When you use lower concurrency, query throughput is increased and overall system performance is improved for most workloads. 
https://docs.aws.amazon.com/redshift/latest/dg/wlm-short-query-acceleration.html