Free AWS Certified Solutions Architect Associate SAA-C03 Practice Question
Your application requires a relational database with support for JSON data types, indexing of JSON data, and the ability to perform complex joins and transactions. Which database engine should you choose?
PostgreSQL is the correct choice as it is a powerful, open-source object-relational database system that supports JSON data types and has robust indexing options for JSON. It can handle complex queries, joins, and it is well-suited for transactional systems. On the other hand, although MySQL supports JSON data types as well, its capabilities for handling JSON and complex transactions are not as advanced as PostgreSQL. Amazon Aurora is compatible with MySQL and PostgreSQL, but the question specifically asks about database engines, not a specific AWS service offering. SQLite is a lightweight database engine that does not offer the same level of support for JSON data types or the same performance with complex joins and transactions compared to PostgreSQL.
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 are the advantages of using PostgreSQL for JSON data types?
Open an interactive chat with Bash
How does indexing work with JSON data in PostgreSQL?
Open an interactive chat with Bash
What distinguishes PostgreSQL from other database engines regarding transactions?