Home
AWS
AWS Certified Solutions Architect Associate SAA-C03
Study Mode

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?

SQLite
PostgreSQL
Amazon Aurora
MySQL

Next Question

Correct Incorrect Unanswered

Report Issue

Answer Description

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?

Open an interactive chat with Bash

AWS Certified Solutions Architect Associate SAA-C03

Design High-Performing Architectures

Your Score:

Settings & Objectives

Design Secure Architectures

Design Resilient Architectures

Design High-Performing Architectures

Design Cost-Optimized Architectures

Random Mode

Random Mixed

Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.

Rotate by Objective

Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Hide Score

Check or uncheck an objective to set which questions you will receive.

Wipe Score

Report Issue

Bash, the Crucial Exams Chat Bot

AI Bot