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 questionsCorrect Answer:
B. Enable hash joins on the database by setting the variable optimizer_switch to hash_join=on.
Keep practicing
Take the free DBS-C01 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other DBS-C01 practice questions
- Question 1A company has a hybrid environment in which a VPC connects to an on-premises network thro…
- Question 2A Database Specialist migrated an existing production MySQL database from on-premises to …
- Question 3A media company is using Amazon RDS for PostgreSQL to store user dat a. The RDS DB instan…
- Question 4A Database Specialist is working with a company to launch a new website built on Amazon A…
- Question 5A company has a database monitoring solution that uses Amazon CloudWatch for its Amazon R…
- Question 6A financial services company is developing a shared data service that supports different …
