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…
Choose your answer, then check it against the explanation.
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?
Question 17 of 35
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 …