DEA-C01 • Practice Test 23
Free DEA-C01 practice test — 15 questions with explanations. Set 23. No signup required.
Refer to the exhibit. A data engineer creates an Amazon Redshift table with the above DDL. The engineer runs a query to find all orders for a specific customer within a date range. Which statement about query performance is correct?
Refer to the exhibit.
CREATE TABLE orders (
order_id INT PRIMARY KEY,
customer_id INT,
order_date DATE,
total_amount DECIMAL(10,2)
) DISTSTYLE KEY DISTKEY (customer_id) SORTKEY (order_date);