01
Choose one
1 point
An online shop retrieves and updates cart items by customer identifier. Traffic is bursty, and these operations do not require arbitrary SQL joins. Which database best fits this access pattern?
Free Practice Quiz Question List
6 Database Selection Case Studies Online Quiz Questions
Use this free practice quiz with 20 questions to review 6 Database Selection Case Studies, test your knowledge, and prepare for your next test or exam.
20 questions
02
Fill in the blank
1 point
Amazon RDS read replicas replicate , so an application should check whether any resulting replica lag is acceptable for the queries routed to them.
03
True or false
1 point
True or false: Amazon Redshift is the default operational database for application transactions such as order processing.
- A
True
- B
False
04
Written response
1 point
In DynamoDB, what problem can poorly distributed partition-key values create when traffic is concentrated on a small number of partitions?
05
Choose one
1 point
A business application already uses PostgreSQL, SQL joins, constraints, and transactions. The team wants managed backups and has no demonstrated need for unusually high database throughput. Which is the most sensible starting choice?
- A
Amazon Redshift, because it is optimized for reporting across datasets
- B
Amazon DynamoDB, because all high-volume applications should use key-value access
- C
Amazon RDS for PostgreSQL, because it offers a managed relational engine compatible with the application's needs
- D
Amazon Aurora, because every relational application needs a cluster architecture
06
True or false
1 point
True or false: An RDS Multi-AZ standby intended for failover automatically serves as a read-scaling replica.
- A
True
- B
False
07
Fill in the blank
1 point
To make operational data available for reporting in Amazon Redshift, a company needs an appropriate from its operational sources.
08
Written response
1 point
According to the selection method, what should guide database selection before a team chooses a service name?
09
Choose one
1 point
An application uses Amazon Aurora and wants to serve read traffic separately from transactional writes. Which Aurora component can serve those reads, subject to the application's consistency needs?
- A
The writer instance, which should handle all reads and writes
- B
Reader instances, when the application can tolerate relevant replication behavior
- C
The cluster storage layer, which directly handles application SQL queries
- D
A Redshift warehouse, which is automatically part of every Aurora cluster
10
Choose all
1 point
Which actions are recommended when validating an Aurora design? Select all correct choices.
- A
Benchmark representative transactions and concurrent reads
- B
Test failover from the application's perspective
- C
Model expected compute, storage, and I/O costs
- D
Assume client reconnection will work without testing
- E
Route all writes to reader instances
11
Choose all
1 point
An e-commerce system needs transactional checkout, fast key-based cart lookups, and historical reporting. Which service-role assignments match those needs? Select all correct choices.
- A
Use Aurora or RDS for orders and inventory that need relational constraints and transactions
- B
Use DynamoDB for carts or sessions with primarily key-based access
- C
Use Redshift for historical reporting and analytical queries, populated by a data pipeline
- D
Use Redshift as the authoritative database for checkout transactions
- E
Use DynamoDB as the default store for flexible relational joins and constraints
12
Open ended
1 point
A team is choosing a database for a new application but has not yet settled on a service. Describe a practical sequence the team should follow to make and validate its choice.
13
Choose one
1 point
Before committing to a database service and deployment, what should a team verify about the intended AWS Region?
- A
Assume every engine feature is available in every Region
- B
Choose a deployment before checking whether it supports the application's requirements
- C
Verify that the needed engine features and deployment options are available in the intended Region
- D
Use the service with the most familiar name without checking compatibility
14
Choose one
1 point
A company is moving a PostgreSQL business application that depends on SQL joins, constraints, and transactions. It wants managed backups and a familiar engine, with no demonstrated need for unusually high throughput. Which service is the most sensible starting point?
- A
Amazon RDS for PostgreSQL
- B
Amazon DynamoDB
- C
Amazon Redshift
15
Choose one
1 point
A company needs dashboards that scan and aggregate years of sales data from multiple operational systems. The reports should not slow checkout or order processing. Which service best fits the analytical workload?
- A
Amazon RDS
- B
Amazon DynamoDB
- C
Amazon Redshift
16
Choose one
1 point
An online shop has bursty traffic and usually retrieves or updates cart items by customer identifier. These operations do not require arbitrary SQL joins. Which design best matches this access pattern?
- A
Amazon Redshift for flexible joins across cart items
- B
Amazon DynamoDB with keys designed around cart lookups
- C
Amazon RDS for PostgreSQL for arbitrary SQL joins
17
True or false
1 point
A team routes read-only queries to an Amazon RDS read replica. Because replication is asynchronous, the team should confirm that replica lag is acceptable for those queries.
- A
True
- B
False
18
Choose one
1 point
An order service has relational data and transactional rules, variable load, and many reads to serve while keeping a writable primary. Which option should the team evaluate for its cluster design and reader instances?
- A
Evaluate Aurora with a compatible MySQL or PostgreSQL engine
- B
Use Redshift as the writable transactional database
- C
Use DynamoDB because the workload needs relational transactions
19
Written response
1 point
In Aurora's cluster architecture, what is separated from the database instances?
20
Written response
1 point
In DynamoDB, what problem can arise when partition-key values distribute traffic poorly?
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.