Exam AWS Certified Data Analytics - Specialty topic 1 question 126 discussion

Answer C WLM is main feature which supports Concurrency scaling and SQA.

Answer: C In some cases, you might have multiple sessions or users running queries at the same time. In these cases, some queries might consume cluster resources for long periods of time and affect the performance of other queries. For example, suppose that one group of users submits occasional complex, long-running queries that select and sort rows from several large tables. Another group frequently submits short queries that select only a few rows from one or two tables and run in a few seconds. In this situation, the short-running queries might have to wait in a queue for a long-running query to complete. WLM helps manage this situation.

C: I passed the test

Correct answer is C as Redshift Workload Management can help define multiple query queues and manage the scheduling between long and short running workloads. https://docs.aws.amazon.com/redshift/latest/dg/cm-c-implementing-workload-management.html Option A is wrong as Concurrency scaling helps support virtually unlimited concurrent users and concurrent queries, with consistently fast query performance. Option B is wrong as Short query acceleration (SQA) prioritizes selected short-running queries ahead of longer-running queries. Option D is wrong as materialized view contains a precomputed result set, based on an SQL query over one or more base tables.

Answer : C

WLM will manage query execution

C - WLM addresses exactly that (managing query workload)

Answer-C

Answer : C

Answer : C

Answer: C https://docs.aws.amazon.com/redshift/latest/dg/cm-c-implementing-workload-management.html