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:

Inheritance of Power

refers to the transfer of authority, control, or influence over others from one generation to another within families, dynasties, or organizations.

Rational Thoughts

The process of thinking clearly, logically, and without emotional bias.

Traditional Authority

A type of leadership in which the authority of an organization or a ruling regime is largely tied to tradition or custom.

Legal

Pertaining to the system of rules that a particular country or community recognizes as regulating the actions of its members and may enforce by the imposition of penalties.