A company has a data warehouse in Amazon Redshift that is approximately 500 TB in size. New data is imported every few hours and read-only queries are run throughout the day and evening. There is a particularly heavy load with no writes for several hours each morning on business days. During those hours, some queries are queued and take a long time to execute. The company needs to optimize query execution and avoid any downtime.
What is the MOST cost-effective solution?
A . Enable concurrency scaling in the workload management (WLM) queue.
B . Add more nodes using the AWS Management Console during peak hours. Set the distribution style to ALL.
C . Use elastic resize to quickly add nodes during peak times. Remove the nodes when they are not needed.
D . Use a snapshot, restore, and resize operation. Switch to the new target cluster.
Answer: A
Explanation:
https://docs.aws.amazon.com/redshift/latest/dg/cm-c-implementing-workload-management.html
Latest DAS-C01 Dumps Valid Version with 77 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund