AWS Certified Solutions Architect Associate SAA-C03 Practice Question
A social media startup is currently designing their backend services, including the database architecture for their new messaging feature. The messaging system requires efficient handling of complex queries, including full-text searches and geographic location-based queries for their expanding global user base. Which database engine should the startup use to enable these capabilities in a cost-effective manner?
DynamoDB, because of its managed scalability and performance aspects
PostgreSQL, due to its advanced indexing and support for full-text search and geospatial data
Amazon Aurora, as it is a MySQL and PostgreSQL-compatible relational database built for the cloud
MySQL, given its widespread adoption and ease of use
PostgreSQL is known for its advanced indexing strategies and full-text search capabilities. It also offers advanced features like Geospatial database support through PostGIS, which can handle geographic location-based queries efficiently. This makes PostgreSQL suitable for applications that require complex querying capabilities. While MySQL is also a solid choice for various use cases, it does not match the advanced querying capabilities of PostgreSQL, especially in terms of geographical and full-text search features. DynamoDB may offer scalability and performance, but it is less suited for complex queries like those used in full-text searches. Lastly, Amazon Aurora is a high-performance database engine compatible with MySQL and PostgreSQL, but for specific needs of complex querying, PostgreSQL itself provides the necessary functionality without incurring the additional cost that Aurora might entail.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is full-text search in PostgreSQL, and how does it work?
Open an interactive chat with Bash
How does PostgreSQL handle geographic location-based queries?
Open an interactive chat with Bash
Why is PostgreSQL often preferred over MySQL for complex queries?