Topic 1 Question 139
2 つ選択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?
Select *from Employee where Region ID=’North America’;
Select *from Employee where Region ID=’North America’ and Department ID=20;
Select *from Employee where Department ID=20 and Region ID=’North America’;
Select *from Employee where Role ID=50;
Select *from Employee where Region ID=’North America’ and Role ID=50;
ユーザの投票
コメント(10)
- 正解だと思う選択肢: AB
To maximize the speed of queries using a compound sort key in Amazon Redshift, you should structure your queries to take advantage of the order of the columns in the sort key. The most efficient queries will filter or join on the columns in the same order as the sort key. Saying that, the most efficient queries would be: SELECT * FROM Employee WHERE Region_ID = 'region1' AND Department_ID = 'dept1' AND Role_ID = 'role1'; SELECT * FROM Employee WHERE Region_ID = 'region1' AND Department_ID = 'dept1'; SELECT * FROM Employee WHERE Region_ID = 'region1';
👍 7teo21572024/08/12 - 正解だと思う選択肢: BE
To maximize the speed of queries by using the compound sort key (Region ID, Department ID, and Role ID) in the Employee table in Amazon Redshift, the queries should align with the order of the columns in the sort key.
👍 6antun3ra2024/08/08 - 正解だと思う選択肢: BE
Based on the order of the compound sort key columns.
👍 5Shanmahi2024/08/05
シャッフルモード