True or false: Amazon Redshift is designed to be the primary database for an application's frequent, small transactional reads and writes.
1 Choosing an AWS Database Online Quiz Questions
Use this free practice quiz with 20 questions to review 1 Choosing an AWS Database, test your knowledge, and prepare for your next test or exam.
True or false: When choosing DynamoDB, an application can assume arbitrary relational joins will be available and efficient.
- A
True
- B
False
In DynamoDB, tables and keys should be designed around the application's required .
Before choosing based on service names alone, a short using realistic data and access patterns can help evaluate a database design.
A workload stores JSON-like documents and needs richer queries across document fields. Which AWS database service does the material suggest considering?
What RDS availability option can help provide high availability if an instance or Availability Zone fails?
A booking application must check availability and create reservations while preventing conflicting updates. Which database choice is the most appropriate starting point?
- A
Amazon Redshift
- B
Amazon RDS or Amazon Aurora
- C
Amazon DynamoDB
- D
Amazon DocumentDB
A shopping-cart service retrieves or updates each cart directly by customer or cart identifier and must handle high request volume. Which service is the best fit to evaluate first?
- A
Amazon Redshift
- B
Amazon DynamoDB
- C
Amazon RDS for Oracle
- D
Amazon Aurora
Executives need to compare sales across regions, products, and months using years of historical data. Which service is designed for this analytical workload?
- A
Amazon RDS
- B
Amazon DynamoDB
- C
Amazon Redshift
- D
Amazon Aurora
A small application needs a familiar PostgreSQL engine and has moderate, predictable demand. Which service is a reasonable starting choice before comparing alternatives?
- A
Amazon RDS for PostgreSQL
- B
Amazon Redshift
- C
Amazon DynamoDB
- D
Amazon DocumentDB
Select all workload requirements that point toward Amazon RDS or Aurora.
- A
The application needs joins across related entities.
- B
Requests are mostly known lookups by key at very high throughput.
- C
The application needs constraints to keep related records correct.
- D
Transactions must span multiple related records.
- E
Queries scan and aggregate large historical datasets.
Select all statements about DynamoDB read consistency that are supported by the material.
- A
Strongly consistent reads are supported for some table reads.
- B
Global secondary indexes support strongly consistent reads.
- C
Strongly consistent reads are supported for local-secondary-index reads.
- D
Streams support strongly consistent reads.
- E
Every DynamoDB read is strongly consistent by default.
A retailer needs to process live orders and also analyze sales trends across years of transactions. Propose a database approach for both workloads and explain how you would validate that the choices meet the retailer's needs.
A retailer needs to analyze large historical datasets with aggregations and reports. Which AWS database service is designed for this analytical workload?
An application is moving to a managed service but must continue using a familiar PostgreSQL engine. Which option is the most direct starting point?
- A
Amazon RDS for PostgreSQL
- B
Amazon Redshift
- C
Amazon DynamoDB
- D
Amazon DocumentDB
An application stores JSON-like documents and must query across their fields. Which option is the best fit to consider?
- A
Amazon DynamoDB, because arbitrary relational joins are available by default
- B
Amazon DocumentDB, because it is document-oriented
- C
Amazon Redshift, because it is designed for small transactional lookups
- D
Amazon RDS, because it is a key-value database
True or false: Read replicas can help serve read traffic, but they are not a substitute for choosing an appropriate high-availability configuration.
- A
True
- B
False
A booking system must check availability and create a reservation while preventing conflicting updates. Which database choice is the most natural starting point?
- A
Amazon Redshift, because analytical scans are its main strength
- B
Amazon DynamoDB, because key lookups provide arbitrary joins
- C
Amazon RDS or Aurora, because relational transactions and relationships fit the workload
- D
Amazon DocumentDB, because document-field queries prevent conflicting reservations
When designing DynamoDB tables and keys, what should they be designed around?
A team is comparing databases for a workload with sharp demand peaks. Which approach is most reliable for evaluating cost?
- A
Choose the service with the highest theoretical peak scale, since that guarantees the lowest bill
- B
Compare only storage prices because requests and replicas do not affect total cost
- C
Assume on-demand scaling is always cheaper when demand varies
- D
Estimate and test viable options using representative workloads and relevant cost drivers
Related study packs and tools
- Quiz
1 Networking Fundamentals
A medium-difficulty quiz on networking fundamentals, including communication roles, protocol layers, data units, and network models.
CompTIA A+ NetworkingUpdated - Flashcards
2 Protocols and Ports
Review how TCP and UDP work, what common network ports indicate, and how to interpret port clues cautiously.
CompTIA A+ NetworkingUpdated - Quiz
2 Protocols and Ports
A medium-difficulty quiz on interpreting network protocols, ports, and common traffic patterns.
CompTIA A+ NetworkingUpdated - Quiz
3 Accessories and Peripheral Devices
A medium-difficulty quiz on selecting, connecting, configuring, and troubleshooting laptop accessories and peripheral devices.
CompTIA A+ Mobile DevicesUpdated - Quiz
4 Wi-Fi Networks
A 14-question quiz on Wi-Fi networks, moving from core concepts to applied troubleshooting and explanation.
CompTIA A+ NetworkingUpdated - Quiz
5 Network Operations and Reliability
A medium-difficulty quiz on network operations, monitoring, configuration management, resilience, and recovery planning.
- Quiz
5 Network Services and Name Resolution
A medium-difficulty quiz on diagnosing DHCP, DNS, and network-service problems, progressing from core concepts to multi-step troubleshooting.
- Quiz
5 Other AWS Compute Options
A medium-difficulty quiz on choosing AWS compute services by workload pattern, deployment needs, and level of infrastructure control.
AWS Compute ServicesUpdated - Study guide
6 Security Operations and Incident Response
Learn how security teams monitor activity, manage vulnerabilities, respond to incidents, preserve digital evidence, and restore services safely.
- Quiz
6 SOHO Network Setup and Troubleshooting
A medium-difficulty quiz on setting up, securing, and troubleshooting a small-office/home-office network.
CompTIA A+ NetworkingUpdated - Study guide
8 Comprehensive Security+ Practice and Review
A scenario-focused guide to Security+ SY0-701 concepts, emphasizing evidence-based incident response, access control, cryptography, vulnerability handling, recovery objectives, and risk governance.
- Study guide
8 Security Operations and Incident Response
Learn how to recognize and assess security incidents, preserve evidence, contain and remove threats, restore trustworthy services, and improve security through lessons learned.