DBS-C01 · Question #224
DBS-C01 Question #224: Real Exam Question with Answer & Explanation
Sign in or unlock DBS-C01 to reveal the answer and full explanation for question #224. The question stem and answer options stay visible for context.
Question
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?
Options
- AMigrate the database to a new Amazon Redshift data warehouse.
- BEnable hash joins on the database by setting the variable optimizer_switch to hash_join=on.
- CTake a snapshot of the DB cluster. Create a new DB instance by using the snapshot, and enable
- DAdd an Aurora read replica.
Unlock DBS-C01 to see the answer
You've previewed enough free DBS-C01 questions. Unlock DBS-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.