nerdexam
AmazonAmazon

DAS-C01 · Question #67

DAS-C01 Question #67: Real Exam Question with Answer & Explanation

Sign in or unlock DAS-C01 to reveal the answer and full explanation for question #67. The question stem and answer options stay visible for context.

Processing

Question

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?

Options

  • AEnable concurrency scaling in the workload management (WLM) queue.
  • BAdd more nodes using the AWS Management Console during peak hours. Set the distribution
  • CUse elastic resize to quickly add nodes during peak times. Remove the nodes when they are not
  • DUse a snapshot, restore, and resize operation. Switch to the new target cluster.

Unlock DAS-C01 to see the answer

You've previewed enough free DAS-C01 questions. Unlock DAS-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#Redshift Concurrency Scaling#Workload Management (WLM)#Query Performance#Cost Optimization
Full DAS-C01 PracticeBrowse All DAS-C01 Questions