AWS Certified Data Engineer - Associate DEA-C01 — Topic 1 Question 280

Question

A data engineer is writing a query to join two tables in Amazon Athena. The data engineer needs to choose the correct join order for the tables to optimize query performance. Which solution will meet these requirements?

Accepted Answer

Correct answer: B. The correct answer is B. Option B: Specify the larger table on the left side of the join and the smaller table on the right side of the join.

AWS Certified Data Engineer - Associate DEA-C01 — Question 280