DBS-C01 practice question 17 of 35

A manufacturing company has an. inventory system that stores information in an Amazon Aurora MySQL DB cluster. The database tables are partitioned. The database size has grown to 3 TB. Users run one-time queries by using a SQL client. Queries that use an equijoin to join large tables are taking a long time to run. Which action will improve query performance with the LEAST operational effort?

Full set: 322 questions
Answer options
A: Migrate the database to a new Amazon Redshift data warehouse.
B: Enable hash joins on the database by setting the variable optimizer_switch to hash_join=on. Correct answer
C: Take a snapshot of the DB cluster. Create a new DB instance by using the snapshot, and enable parallel query mode.
D: Add an Aurora read replica.
Correct Answer:
B. Enable hash joins on the database by setting the variable optimizer_switch to hash_join=on.
Scroll to Top