DEA-C01 Question #149: Real Exam Question with Answer & Explanation

Question

A company stores employee data in Amazon Resdshift. A table names Employee uses columns named Region ID, Department ID, and Role ID as a compound sort key. Which queries will MOST increase the speed of query by using a compound sort key of the table? (Choose two.)

Options

• ASelect *from Employee where Region ID='North America';
• BSelect *from Employee where Region ID='North America' and Department ID=20;
• CSelect *from Employee where Department ID=20 and Region ID='North America';
• DSelect *from Employee where Role ID=50;
• ESelect *from Employee where Region ID='North America' and Role ID=50;