Your application requires a relational database with native support for JSON/JSONB data types, the ability to create indexes directly on JSON data, and full support for complex joins and ACID transactions. Which database engine should you choose?
SQLite
Amazon Aurora
PostgreSQL
MySQL
PostgreSQL is the best fit because it provides native JSON and JSONB data types and allows you to create GIN or GiST indexes directly on JSONB columns, giving excellent performance for JSON queries. It also offers rich join capabilities and fully ACID-compliant transactions.
MySQL introduced a JSON type (starting in 5.7), but JSON columns cannot be indexed directly-you must create generated or functional columns first, which is less flexible.
Amazon Aurora is a managed database engine offered by AWS; its PostgreSQL-compatible edition would meet the requirements, but its MySQL-compatible edition inherits the same JSON-indexing limitations as MySQL. Because the option listed is simply "Amazon Aurora" without specifying the PostgreSQL edition, it is not the most clearly correct choice.
SQLite stores JSON as plain text via the JSON1 extension and lacks native binary JSON support or GIN-style indexing, making it a weaker choice for these requirements.
Therefore, PostgreSQL is the most appropriate engine.
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
All IT & Cybersecurity Package plans include the following perks and exams .
Our pricing is simple. Full access to all certifications and exams in each package, for one price.
As many practice tests for as many topics as you want.
Use study mode non-stop, no limits.
Access to our AI assistant, Bash, trained to help you pass your exam.
Track your scores over time in study mode and report cards.
See how you improve over time, and where you need to focus.
Access our store with even bigger discounts than before.
Unlimited access to all performance questions and be prepared for the real thing.
All IT & Cybersecurity Package plans include unlimited access to the following study materials.
Create an account or sign in to access our study materials.