25 Technology: Databases & Storage Practice Questions & Answers
Every Technology: Databases & Storage practice question from the AWS Cloud Practitioner Practice Test, with the correct answer and a short explanation.
Start practice test →1. A company moves its MySQL database from an Amazon EC2 instance to Amazon RDS. Which task remains the company's responsibility after the move?
- A.Patching the operating system beneath the database engine
- B.Taking and retaining routine automated database backups
- C.Replacing failed disks and hardware in the host servers
- D.Tuning application queries that run against the database schema✓ Answer
With Amazon RDS, AWS takes over operating system and database patching, backups, high availability and hardware, but the customer always owns how its application and queries use the database. Moving to a managed service reduces operational work without removing query optimization from the customer's side.
Ref QB-5W829XSource: Amazon RDS User Guide, comparison of responsibilities for Amazon RDS and a database on Amazon EC2Report a problem with this question
2. A company runs a licensed database product that Amazon RDS does not offer, and the vendor requires custom agents and settings on the operating system. Which option fits this need?
- A.Amazon EC2, because the team controls the operating system and installed software✓ Answer
- B.Amazon Aurora, because it can run any vendor's database engine on managed hosts
- C.Amazon RDS, because it hands the team the host operating system for any engine
- D.Amazon DynamoDB, because its storage nodes accept custom operating system agents
Hosting the database on Amazon EC2 gives the customer full control of the operating system and database software, which is what custom agents and an unsupported product require. The customer then also takes on patching, backups, high availability and scaling, which is the management a managed service would otherwise remove.
Ref QB-KDQHGVSource: AWS decision guide: Choosing an AWS database service; Amazon RDS User Guide, Amazon RDS compared with a database on Amazon EC2Report a problem with this question
3. A company's Amazon RDS database must keep running after an Availability Zone outage, with automatic failover. Read performance is not a concern. Which feature addresses this need?
- A.Amazon ElastiCache, which holds repeated query results in a memory cache
- B.A manual DB snapshot, which saves a point-in-time copy for a later restore
- C.A Multi-AZ deployment, which keeps a standby ready for automatic failover✓ Answer
- D.A read replica, which adds asynchronous copies that serve extra read traffic
A Multi-AZ deployment maintains a standby in another Availability Zone and fails over to it automatically, so its purpose is availability. Read replicas exist for read scaling, and a snapshot must be restored by hand, so neither provides automatic failover for this need.
Ref QB-4WVP3WSource: Amazon RDS User Guide, Multi-AZ deploymentsReport a problem with this question
4. Daytime reporting queries are overloading an online store's Amazon RDS database, although writes are healthy. The store uses a Multi-AZ DB instance deployment. What should it add to move those reads onto separate DB instances?
- A.Automated backups, which let reporting tools query the retained daily backup files
- B.A second standby instance, which takes read traffic while it waits for a failover
- C.Amazon EBS snapshots, which let reporting tools query stored point-in-time data
- D.Read replicas, which answer read-only queries from asynchronously updated copies✓ Answer
Read replicas are asynchronously updated copies that serve read-only traffic, so they take read load off the primary. The standby in a Multi-AZ DB instance deployment exists for failover and does not serve reads, and backups and snapshots have to be restored before anything can query them.
Ref QB-PDSHZYSource: Amazon RDS User Guide, Working with DB instance read replicas; Multi-AZ DB instance deploymentsReport a problem with this question
5. A company wants to leave a commercial database for a fully managed relational engine that is compatible with PostgreSQL and whose storage grows automatically. Which service fits?
- A.Amazon DocumentDB, a managed JSON document database with MongoDB compatibility
- B.Amazon Redshift, a managed data warehouse built for large-scale analytics queries
- C.Amazon Aurora, a managed relational engine compatible with MySQL and PostgreSQL✓ Answer
- D.Amazon DynamoDB, a serverless key-value and document store with no JOIN operator
Amazon Aurora is a fully managed relational engine in the Amazon RDS family, compatible with MySQL and PostgreSQL only, and its cluster volume grows automatically while keeping copies across three Availability Zones. That combination makes it a common target when leaving commercial engines such as Oracle or SQL Server.
Ref QB-7WXPKZSource: Amazon Aurora User Guide, What is Amazon Aurora; Aurora storage and reliabilityReport a problem with this question
6. A mobile game needs a key-value database for player sessions and scores, with single-digit millisecond performance at any scale and no servers or maintenance windows to manage. Which service fits?
- A.Amazon Redshift, a data warehouse built for analytics on large datasets
- B.Amazon DynamoDB, a serverless NoSQL database with no servers to manage✓ Answer
- C.Amazon Neptune, a graph database built around links between many records
- D.Amazon RDS, a relational database that runs on DB instances you must size
Amazon DynamoDB is a serverless, fully managed NoSQL service for key-value and document data that delivers single-digit millisecond performance at any scale, with no servers, versions or maintenance windows. Session stores, shopping carts and game scores are its typical uses.
Ref QB-NDE7UXSource: Amazon DynamoDB Developer Guide, What is Amazon DynamoDBReport a problem with this question
7. An architect is reviewing Amazon DynamoDB for an order system and wants to separate fact from myth. Which statement about DynamoDB is accurate?
- A.It has no JOIN operator, yet it supports ACID transactions across items✓ Answer
- B.It offers SQL-style JOIN operators, and it stays inside a single AZ
- C.It offers SQL-style JOIN operators, yet it has no ACID transactions
- D.It has no JOIN operator, and all its reads are eventually consistent
Amazon DynamoDB has no JOIN operator, because related data is modeled differently than in a relational database, but it does support ACID transactions across items. It also offers strongly consistent reads and replicates data across three Availability Zones by default, so being NoSQL does not mean giving up those guarantees.
Ref QB-6WKCEYSource: Amazon DynamoDB Developer Guide, DynamoDB transactions; read consistency; comparison of relational and NoSQL designReport a problem with this question
8. A web application runs the same queries against Amazon RDS over and over. The team wants an in-memory caching layer with microsecond reads to reduce the load on the database. Which service fits?
- A.Amazon Redshift, a warehouse that holds the database tables in memory
- B.Amazon ElastiCache, an in-memory cache that is placed in front of the database✓ Answer
- C.Amazon CloudFront, an edge network that stores the database query results
- D.AWS Storage Gateway, a local cache for on-premises files and volumes
Amazon ElastiCache is a managed in-memory data store and cache, with Valkey, Memcached and Redis OSS engines, that typically sits in front of a database and answers repeated reads in microseconds. CloudFront caches web content at the edge rather than database queries, and Storage Gateway serves on-premises access to cloud storage.
Ref QB-RDG7C3Source: Amazon ElastiCache User Guide, What is Amazon ElastiCacheReport a problem with this question
9. A team stores flexible JSON-like documents and its application already uses MongoDB drivers. It wants a fully managed AWS database with MongoDB compatibility. Which service fits?
- A.Amazon Neptune, a graph database that follows links among connected records
- B.Amazon ElastiCache, an in-memory store that caches frequently read documents
- C.Amazon RDS, a relational database that stores data in fixed tables and rows
- D.Amazon DocumentDB, a document database that works with MongoDB drivers✓ Answer
Amazon DocumentDB is the managed document database for JSON-like data, and its MongoDB compatibility lets applications keep using MongoDB drivers and tools. The cue here is the data model plus the compatibility requirement, which rules out graph, relational and caching services.
Ref QB-9WNCX3Source: Amazon DocumentDB Developer Guide, What is Amazon DocumentDBReport a problem with this question
10. A bank wants to uncover fraud rings by following relationships among accounts, devices and addresses across many levels of connection. Which database is built for this kind of highly connected data?
- A.Amazon Aurora, a relational database that models every link as a table join
- B.Amazon Neptune, a graph database that stores relationships as first-class data✓ Answer
- C.Amazon DocumentDB, a document database that nests related records in JSON
- D.Amazon DynamoDB, a key-value database that joins tables at any scale
Amazon Neptune is a managed graph database, so relationships are stored and traversed directly, which suits fraud detection, social networks and recommendation engines. Relational joins become unwieldy across many levels of connection, and DynamoDB has no JOIN operator at all.
Ref QB-X47STRSource: Amazon Neptune User Guide, What is Amazon Neptune; AWS decision guide: Choosing an AWS database serviceReport a problem with this question
11. A company is moving from an on-premises Oracle database to Amazon Aurora PostgreSQL-Compatible Edition. Which tool converts the database schema to the new engine?
- A.AWS SCT, which translates schema objects from one engine to another✓ Answer
- B.AWS Migration Hub, which converts schemas while it tracks each migration
- C.AWS Application Migration Service, which rebuilds the database schemas
- D.Migration Evaluator, which converts schemas as it builds a business case
AWS SCT (AWS Schema Conversion Tool) converts the schema when the engine changes and flags what it cannot convert automatically. The rule to remember is that an engine change uses AWS SCT for the schema and AWS DMS for the data; Migration Evaluator builds the cost case and Migration Hub tracks progress, and neither converts schemas.
Ref QB-EMZK8RSource: AWS Schema Conversion Tool User Guide, What is the AWS Schema Conversion ToolReport a problem with this question
12. A company has already prepared the target schema on Amazon Aurora. It must now copy the table data from its on-premises SQL Server database to Aurora. Which service performs this step?
- A.AWS Application Discovery Service, which collects and copies database rows
- B.AWS SCT, which moves table rows to the target during schema conversion
- C.Migration Evaluator, which builds a business case and transfers the data
- D.AWS DMS, which moves data from a source endpoint to a target endpoint✓ Answer
AWS DMS (AWS Database Migration Service) moves data from a source endpoint to a target endpoint, for both same-engine and different-engine migrations, and at least one endpoint must be on an AWS service. AWS SCT handles the schema, while Application Discovery Service and Migration Evaluator support planning.
Ref QB-Y4J4ZSSource: AWS Database Migration Service User Guide, What is AWS Database Migration ServiceReport a problem with this question
13. A media company needs to keep millions of images and backup files that applications retrieve through an API over the internet. Nothing needs to be mounted as a disk. Which type of storage fits best?
- A.File storage in Amazon EFS, which shares folders through mounted NFS
- B.Block storage in Amazon EBS, which attaches volumes to EC2 instances
- C.Object storage in Amazon S3, which keeps data as objects in buckets✓ Answer
- D.Block storage on instance store, which uses disks on the physical host
Amazon S3 stores data as objects in buckets and is reached through an API, which suits backups, static assets, media, logs and data lakes. It is not a mountable block disk, so EBS and instance store solve a different problem, and EFS is for shared file access.
Ref QB-FMCXDSSource: Amazon S3 User Guide, What is Amazon S3Report a problem with this question
14. A company keeps thumbnails that it can regenerate from originals at any time. They are read infrequently but must open immediately, and the company accepts losing them if one Availability Zone is lost. Which storage class is the most cost-effective fit?
- A.S3 Standard-IA, which spreads rarely read objects across several AZs
- B.S3 One Zone-IA, which stores rarely read objects in a single AZ for less✓ Answer
- C.S3 Glacier Deep Archive, which requires a restore before any object is read
- D.S3 Standard, which suits frequently read objects stored across several AZs
S3 One Zone-IA gives immediate access to infrequently read data at a lower cost by storing it in one Availability Zone, so it fits data that can be re-created. Its durability is designed the same as the other classes, but the data is not resilient to the loss of that zone.
Ref QB-Z4WE6USource: Amazon S3 User Guide, Understanding and managing Amazon S3 storage classesReport a problem with this question
15. A new dataset has an access pattern nobody can predict, and it may change over time. The team does not want to write age-based rules or pay retrieval fees. Which Amazon S3 option fits?
- A.S3 Lifecycle rules, which move objects on an age schedule that you define
- B.S3 Intelligent-Tiering, which moves objects among tiers by observed access✓ Answer
- C.S3 Glacier Instant Retrieval, which is priced for objects read very rarely
- D.S3 Standard-IA, which charges a fee each time rarely read objects are fetched
S3 Intelligent-Tiering monitors each object and moves it among access tiers automatically, with no retrieval fees, which is why it suits unknown or changing patterns. S3 Lifecycle rules are the better choice only when access is predictable by age, because you define the schedule yourself.
Ref QB-GMQ9KTSource: Amazon S3 User Guide, S3 Intelligent-Tiering; Understanding and managing Amazon S3 storage classesReport a problem with this question
16. A hospital archives medical images that are opened only a few times a year, but when a doctor requests one it must open at once, with no restore step. Which storage class offers the lowest cost for this need?
- A.S3 Glacier Deep Archive, which needs a long restore before objects can be read
- B.S3 Glacier Flexible Retrieval, which needs a restore before objects can be read
- C.S3 Glacier Instant Retrieval, which serves archived objects without a restore✓ Answer
- D.S3 Standard, which serves objects at once but costs more for rarely read data
S3 Glacier Instant Retrieval is an archive class that serves objects immediately with no restore, and it is priced for data read rarely. S3 Glacier Flexible Retrieval and S3 Glacier Deep Archive cost less to store but require a restore first, which the hospital cannot accept, and S3 Standard costs more for data this rarely read.
Ref QB-259SBVSource: Amazon S3 User Guide, Understanding S3 Glacier storage classes for long-term data storageReport a problem with this question
17. A company must keep compliance records for many years and almost never reads them. A restore that takes many hours is acceptable, and the priority is the lowest possible storage cost. Which storage class fits?
- A.S3 Intelligent-Tiering, which adds a monitoring charge for automatic moves
- B.S3 One Zone-IA, which lowers cost by keeping rarely read data in a single AZ
- C.S3 Glacier Deep Archive, which trades slow restores for a very low price✓ Answer
- D.S3 Glacier Instant Retrieval, which keeps archives ready for immediate reads
S3 Glacier Deep Archive is the lowest-cost storage in AWS, intended for long-term retention of data that is almost never read, and the tradeoff is a slow restore before reading. Because the company accepts that wait, paying more for immediate access in another class brings it no benefit.
Ref QB-HM3MRUSource: Amazon S3 User Guide, Understanding S3 Glacier storage classes for long-term data storageReport a problem with this question
18. Application logs in Amazon S3 are read often during their first month, rarely after that, and must be deleted after one year. The pattern is fully predictable by age. Which feature automates this?
- A.An S3 Lifecycle policy, which transitions and then expires objects by age✓ Answer
- B.S3 Intelligent-Tiering, which deletes objects after access to them has stopped
- C.AWS Backup, which moves live bucket objects into cheaper S3 storage classes
- D.An S3 bucket policy, which grants access and also moves objects on a schedule
An S3 Lifecycle policy has two kinds of action: transitions move objects to lower-cost classes and expirations delete them, both at ages you define. That is why it fits a predictable pattern, whereas Intelligent-Tiering changes tiers without deleting anything and AWS Backup manages backups rather than live objects.
Ref QB-T4SE5MSource: Amazon S3 User Guide, Managing the lifecycle of objectsReport a problem with this question
19. An application on Amazon EC2 needs block storage for its data drive, and the data must remain in place after the instance is stopped overnight to save money. Which option fits?
- A.An Amazon S3 bucket, which mounts as a block drive that survives a stop and start
- B.An Amazon EFS file system, which presents itself to the instance as a block drive
- C.An Amazon EBS volume, which persists independently of the instance's running life✓ Answer
- D.An instance store volume, which keeps its data on the host across a stop and start
An Amazon EBS volume is durable block storage that persists independently of the instance's running life, so it survives a stop and start. Instance store data is lost on a stop, and S3 and EFS are object and file storage rather than block drives.
Ref QB-AMK9JKSource: Amazon EC2 User Guide, Amazon EBS volumes; Data persistence for instance store volumesReport a problem with this question
20. A team keeps temporary scratch files on Amazon EC2 instance store volumes. Which event will those files survive?
- A.Rebooting the instance, since the disks stay with the same host✓ Answer
- B.Hibernating the instance, since the disk contents are saved with memory
- C.Stopping the instance, since the data moves to Amazon EBS for the pause
- D.Terminating the instance, since AWS holds the disks for the next launch
Instance store data lives on disks physically attached to the host, so it persists through a reboot, when the instance stays on that host. It is lost when the instance stops, hibernates or terminates, or when the underlying disk fails, which is why it suits only temporary or replicated data.
Ref QB-NW6A9ESource: Amazon EC2 User Guide, Data persistence for instance store volumesReport a problem with this question
21. A company assumed AWS backs up its Amazon EBS volumes on its own, then learned that it has no recovery points. What should it do to get point-in-time backups?
- A.Open a request with AWS Support, since nightly copies of each volume are kept for it
- B.Create EBS snapshots or schedule them in AWS Backup, since customers must set this up✓ Answer
- C.Turn on Multi-AZ for the volume, since its standby copies count as recovery points
- D.Copy the data to instance store, since host disks act as the volume's recovery point
AWS does not back up EBS volumes automatically, so the customer must take snapshots or use AWS Backup. Snapshots are point-in-time and incremental, stored in Amazon S3 buckets that you cannot access directly, and they can restore a volume in any Availability Zone in the Region.
Ref QB-6ECFUESource: Amazon EC2 User Guide, Amazon EBS snapshots; AWS Backup Developer GuideReport a problem with this question
22. A company is moving Windows applications to AWS. They rely on SMB shares, Windows ACLs and Active Directory, and the company wants a fully managed native Windows file server. Which service fits?
- A.Amazon FSx for OpenZFS, a managed file system aimed at Linux and NFS clients
- B.Amazon EFS, an elastic NFS file system that also runs on Windows-based instances
- C.Amazon EBS, a block volume that Windows instances all share through SMB
- D.Amazon FSx for Windows File Server, a managed native SMB file service✓ Answer
Amazon FSx for Windows File Server is a fully managed native Windows file system with SMB access, Active Directory integration and Windows ACLs. Amazon EFS is not supported on Windows-based EC2 instances, so the rule is shared Linux to EFS and Windows, SMB or Active Directory to FSx for Windows File Server.
Ref QB-PWHMEFSource: Amazon FSx for Windows File Server User Guide, What is FSx for Windows File Server; Amazon EFS User GuideReport a problem with this question
23. On-premises applications must keep reaching files over SMB and NFS with low latency from a local cache, while the data itself is stored in Amazon S3. Which service fits?
- A.AWS Storage Gateway, a local appliance that caches S3-backed data on premises✓ Answer
- B.Amazon EFS, a Regional file system that keeps a local copy in each office
- C.AWS Direct Connect, a private network link that caches S3-backed data on premises
- D.AWS Backup, a managed service that exposes its vaults as local SMB file shares
AWS Storage Gateway connects on-premises environments to AWS storage through an appliance that gives low-latency local access from a cache, and its S3 File Gateway offers SMB or NFS access to objects in Amazon S3. Volume Gateway and Tape Gateway apply the same hybrid idea to iSCSI volumes and virtual tapes.
Ref QB-7EQSZFSource: AWS Storage Gateway User Guide, What is AWS Storage Gateway; Amazon S3 File GatewayReport a problem with this question
24. A company wants one place to set backup policies across Amazon EBS, Amazon RDS, Amazon DynamoDB and Amazon EFS, with cross-Region copies and compliance reporting. Which service fits?
- A.S3 Lifecycle, which moves objects in a bucket between storage classes by age
- B.AWS Storage Gateway, which gives on-premises apps cached access to cloud data
- C.AWS Elastic Disaster Recovery, which replicates servers for fast failover
- D.AWS Backup, which centrally applies backup plans across many AWS services✓ Answer
AWS Backup is a fully managed service that centralizes and automates data protection through backup plans applied across services, with cross-Region and cross-account copies, encrypted vaults, Vault Lock and Audit Manager reporting. It manages backups rather than being a storage type, which separates it from S3 Lifecycle and Storage Gateway.
Ref QB-QWVXKGSource: AWS Backup Developer Guide, What is AWS BackupReport a problem with this question
25. A company needs its critical servers replicated continuously to AWS so that, after a disaster, they can be launched and running again quickly. Which service is built for this server recovery need?
- A.AWS Elastic Disaster Recovery, which replicates servers for rapid recovery✓ Answer
- B.AWS Backup, which stores scheduled copies under policies in backup vaults
- C.AWS Application Migration Service, which rehosts servers in a one-time move
- D.Amazon S3 Glacier, which holds archived server images at very low cost
AWS Elastic Disaster Recovery continuously replicates servers so that they can be launched quickly on AWS after a disaster, which makes its role server recovery. AWS Backup protects data through scheduled copies under policies, and Application Migration Service is for moving servers rather than standing by for recovery.
Ref QB-8E357HSource: AWS Elastic Disaster Recovery User Guide, What is Elastic Disaster RecoveryReport a problem with this question
Other topics in this exam
Practice questions built from the domains and task statements in the published AWS exam guide (CLF-C02). AWS and AWS Certified Cloud Practitioner are trademarks of Amazon.com, Inc. or its affiliates; this site is not affiliated with or endorsed by Amazon Web Services, and these are not real exam questions. Fees, scoring, exam languages, Support plans, service names and prices change over time — confirm the current details on the AWS website before you book. The real exam also has multiple-response questions, which this single-answer practice does not reproduce. AWS exam guide (CLF-C02) →