A Company Has a Data Warehouse in Amazon Redshift That

question 126

Multiple Choice

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.

---

Definitions:

Memo Format

A structured method of communication typically used within organizations to convey information or directives in a concise manner.

Direct Approach

A communication style that involves stating the main point or objective at the beginning, often used in clear and straightforward situations.

Indirect Approach

A communication strategy that involves presenting information in a less straightforward manner, often used to soften the delivery of sensitive or complex messages.

Businesspeople

Individuals engaged in commercial, industrial, or professional activities, aiming to achieve economic or organizational goals.