1Which of the following best describes the primary use case for a Relational Database Management System (RDBMS) in the cloud?
A.Storing simple key-value pairs with flexible schemas
B.Storing unstructured media files like images and videos
C.Managing complex relationships with structured data and schemas
D.High-speed ingestion of time-series telemetry data
Correct Answer: Managing complex relationships with structured data and schemas
Explanation:
RDBMS (like Amazon RDS) is optimized for structured data where defining relationships (joins) and maintaining strict schema integrity are critical.
Incorrect! Try again.
2In the context of Amazon RDS, what is the primary responsibility of AWS under the Shared Responsibility Model?
A.Designing the database schema
B.OS patching and hardware maintenance
C.Optimizing application SQL queries
D.Managing database users and permissions
Correct Answer: OS patching and hardware maintenance
Explanation:
AWS manages the underlying infrastructure, operating system patching, and hardware health, while the customer manages the data, schema, and access control.
Incorrect! Try again.
3Which Amazon RDS feature provides a fully managed, highly available database proxy that manages thousands of concurrent connections to relational databases?
A.Amazon RDS Multi-AZ
B.Amazon RDS Proxy
C.AWS Global Accelerator
D.Amazon ElastiCache
Correct Answer: Amazon RDS Proxy
Explanation:
Amazon RDS Proxy sits between the application and the database to pool and share established database connections, improving scalability and resiliency.
Incorrect! Try again.
4When configuring Amazon RDS, which deployment option should be selected to ensure high availability and automatic failover during a hardware outage?
A.Single-AZ Deployment
B.Multi-AZ Deployment
C.Cross-Region Snapshot
D.Read Replica
Correct Answer: Multi-AZ Deployment
Explanation:
Multi-AZ deployments provision a synchronous standby replica in a different Availability Zone to handle automatic failover in case of infrastructure failure.
Incorrect! Try again.
5Which of the following database engines is NOT available as a managed service within Amazon RDS?
A.MariaDB
B.IBM Db2
C.Oracle
D.PostgreSQL
Correct Answer: IBM Db2
Explanation:
Amazon RDS supports Amazon Aurora, PostgreSQL, MySQL, MariaDB, Oracle, and Microsoft SQL Server. IBM Db2 is easily run on EC2 but is not a standard RDS engine.
Incorrect! Try again.
6What happens to the I/O operations of a Single-AZ Amazon RDS instance during a database snapshot?
A.There is no impact on I/O operations
B.The database shuts down completely
C.I/O operations are suspended briefly while the backup is initiated
D.The database switches to read-only mode
Correct Answer: I/O operations are suspended briefly while the backup is initiated
Explanation:
On a Single-AZ instance, I/O may be briefly suspended during the snapshot process. In a Multi-AZ deployment, the backup is taken from the standby instance to avoid this.
Incorrect! Try again.
7To improve the read performance of a heavy read-intensive application using Amazon RDS, which feature should be implemented?
A.Use Amazon S3 for storage
B.Create Read Replicas
C.Enable Multi-AZ deployment
D.Increase the instance size
Correct Answer: Create Read Replicas
Explanation:
Read Replicas allow you to offload read traffic from the primary database instance, thereby increasing the aggregate read throughput.
Incorrect! Try again.
8What is the maximum retention period for Amazon RDS automated backups?
A.35 days
B.7 days
C.14 days
D.90 days
Correct Answer: 35 days
Explanation:
The maximum retention period for automated backups in Amazon RDS is 35 days. The default is usually 7 days.
Incorrect! Try again.
9Which Amazon RDS feature allows you to revert the database to any specific second during the retention period?
A.Snapshot Restore
B.Point-in-Time Recovery
C.Lazy Loading
D.Atomic Rollback
Correct Answer: Point-in-Time Recovery
Explanation:
Point-in-Time Recovery uses transaction logs and automated backups to restore a database instance to a specific second within the retention window.
Incorrect! Try again.
10Amazon DynamoDB is best categorized as which type of database?
A.Time-Series Database
B.Key-Value and Document Database
C.Graph Database
D.Relational Database
Correct Answer: Key-Value and Document Database
Explanation:
DynamoDB is a fully managed NoSQL database service that supports key-value and document data structures.
Incorrect! Try again.
11Which Amazon Aurora feature allows the database to automatically start up, shut down, and scale capacity based on application needs?
A.Aurora Multi-Master
B.Aurora Parallel Query
C.Aurora Global Database
D.Aurora Serverless
Correct Answer: Aurora Serverless
Explanation:
Aurora Serverless provides on-demand, auto-scaling configuration for Amazon Aurora, automatically adjusting capacity based on application demand.
Incorrect! Try again.
12A developer needs to store session state data that requires sub-millisecond latency. Which AWS service is best suited for this?
A.Amazon RDS
B.Amazon ElastiCache
C.Amazon Redshift
D.Amazon Neptune
Correct Answer: Amazon ElastiCache
Explanation:
Amazon ElastiCache (Redis or Memcached) is an in-memory data store designed for sub-millisecond latency, making it ideal for session management and caching.
Incorrect! Try again.
13When migrating a schema from a proprietary database (like Oracle) to an open-source engine (like PostgreSQL) on AWS, which tool assists in converting the schema?
A.AWS Storage Gateway
B.AWS Schema Conversion Tool (SCT)
C.AWS DataSync
D.AWS Database Migration Service (DMS)
Correct Answer: AWS Schema Conversion Tool (SCT)
Explanation:
AWS SCT automatically converts the database schema of the source database to a format compatible with the target AWS database.
Incorrect! Try again.
14Which AWS service is specifically designed for analyzing relationships between highly connected data, such as social networks?
A.Amazon Timestream
B.Amazon Neptune
C.Amazon DynamoDB
D.Amazon Aurora
Correct Answer: Amazon Neptune
Explanation:
Amazon Neptune is a fully managed graph database service built for storing and navigating highly connected datasets.
Incorrect! Try again.
15What is the primary difference between Amazon RDS Multi-AZ and Read Replicas regarding data replication?
A.Both use synchronous replication
B.Both use asynchronous replication
C.Multi-AZ uses synchronous replication; Read Replicas use asynchronous replication
D.Multi-AZ uses asynchronous replication; Read Replicas use synchronous replication
Multi-AZ writes to the standby synchronously for durability. Read Replicas use asynchronous replication for scalability.
Incorrect! Try again.
16In Amazon DynamoDB, which capacity mode is best suited for unpredictable workloads with sudden traffic spikes?
A.Provisioned Capacity
B.Reserved Capacity
C.On-Demand Capacity
D.Fixed Capacity
Correct Answer: On-Demand Capacity
Explanation:
On-Demand Capacity mode automatically accommodates workload traffic as it ramps up or down, charging per request rather than for provisioned throughput.
Incorrect! Try again.
17Which Well-Architected principle is applied when using Amazon RDS IAM Authentication instead of hardcoded database passwords?
A.Performance Efficiency
B.Sustainability
C.Security
D.Cost Optimization
Correct Answer: Security
Explanation:
Using IAM Authentication eliminates the need to manage database passwords, adhering to security best practices regarding credential management.
Incorrect! Try again.
18Which AWS database service is serverless, fully managed, and specifically designed for time-series data?
A.Amazon Redshift
B.Amazon QLDB
C.Amazon DocumentDB
D.Amazon Timestream
Correct Answer: Amazon Timestream
Explanation:
Amazon Timestream is a fast, scalable, and serverless time-series database service for IoT and operational applications.
Incorrect! Try again.
19A company requires a database that provides an immutable, cryptographically verifiable log of data changes. Which service should they choose?
A.Amazon DynamoDB
B.Amazon Aurora
C.Amazon QLDB
D.Amazon RDS
Correct Answer: Amazon QLDB
Explanation:
Amazon Quantum Ledger Database (QLDB) provides a transparent, immutable, and cryptographically verifiable transaction log.
Incorrect! Try again.
20When performing a heterogeneous database migration using AWS DMS, what role does the Replication Instance play?
A.It connects to source and target to facilitate data transfer
B.It acts as the final database server
C.It converts the schema
D.It stores the long-term backup
Correct Answer: It connects to source and target to facilitate data transfer
Explanation:
The DMS Replication Instance is the compute resource that runs the migration software, connecting to the source, reading data, and writing to the target.
Incorrect! Try again.
21Which feature of Amazon Aurora allows it to create a clone of a production database in seconds without copying the data initially?
A.Parallel Query
B.Backtrack
C.Global Database
D.Database Cloning
Correct Answer: Database Cloning
Explanation:
Aurora Database Cloning uses a copy-on-write protocol, allowing clones to be created almost instantly without duplicating the physical storage until changes are made.
Incorrect! Try again.
22To encrypt Amazon RDS data at rest, what service is integrated with RDS?
A.AWS KMS (Key Management Service)
B.AWS WAF
C.AWS Certificate Manager
D.AWS Shield
Correct Answer: AWS KMS (Key Management Service)
Explanation:
AWS KMS manages the encryption keys used to encrypt Amazon RDS instances, snapshots, and backups at rest.
Incorrect! Try again.
23What is the result of promoting an Amazon RDS Read Replica?
A.It becomes a backup archive
B.It becomes a standalone primary DB instance
C.It is deleted immediately
D.It replaces the original Multi-AZ standby
Correct Answer: It becomes a standalone primary DB instance
Explanation:
Promoting a Read Replica decouples it from the source and converts it into a standalone, writable database instance.
Incorrect! Try again.
24Which Amazon DynamoDB feature enables in-memory caching for read-heavy workloads, reducing latency from milliseconds to microseconds?
A.DAX (DynamoDB Accelerator)
B.DynamoDB Streams
C.Point-in-Time Recovery
D.Global Tables
Correct Answer: DAX (DynamoDB Accelerator)
Explanation:
DAX is a fully managed, highly available, in-memory cache for DynamoDB that delivers up to a 10x performance improvement.
Incorrect! Try again.
25Under the Well-Architected Framework's 'Reliability' pillar, how does Amazon Aurora store data?
A.Six copies across three Availability Zones
B.Two copies in one Availability Zone
C.Three copies across two Availability Zones
D.One copy in S3
Correct Answer: Six copies across three Availability Zones
Explanation:
Aurora enhances reliability by maintaining six copies of data across three Availability Zones, allowing it to handle loss of storage nodes or AZs.
Incorrect! Try again.
26Which option allows a database administrator to securely manage database credentials without embedding them in application code?
A.EC2 User Data
B.Amazon S3 Buckets
C.RDS Parameter Groups
D.AWS Secrets Manager
Correct Answer: AWS Secrets Manager
Explanation:
AWS Secrets Manager allows you to rotate, manage, and retrieve database credentials, programmatically replacing hardcoded secrets.
Incorrect! Try again.
27Which AWS database service is fully compatible with MongoDB workloads?
A.Amazon Neptune
B.Amazon Redshift
C.Amazon DynamoDB
D.Amazon DocumentDB
Correct Answer: Amazon DocumentDB
Explanation:
Amazon DocumentDB (with MongoDB compatibility) is a fast, scalable, highly available, and fully managed document database service that supports MongoDB workloads.
Incorrect! Try again.
28For a global application requiring low-latency local reads and writes in multiple regions, which DynamoDB feature is appropriate?
A.DynamoDB Global Tables
B.Read Replicas
C.Cross-Region Replication
D.VPC Endpoints
Correct Answer: DynamoDB Global Tables
Explanation:
Global Tables provide a fully managed, multi-region, and multi-master database that allows you to write to and read from DynamoDB in multiple regions.
Incorrect! Try again.
29When migrating a database using AWS DMS, what is 'CDC'?
A.Cloud Database Connector
B.Continuous Data Copy
C.Complete Database Creation
D.Change Data Capture
Correct Answer: Change Data Capture
Explanation:
CDC stands for Change Data Capture, a method used by DMS to replicate ongoing changes from the source database to the target after the initial load.
Incorrect! Try again.
30Which RDS feature allows you to control the parameters and configuration settings that apply to a DB instance?
A.DB Option Groups
B.DB Security Groups
C.DB Subnet Groups
D.DB Parameter Groups
Correct Answer: DB Parameter Groups
Explanation:
DB Parameter Groups act as a container for engine configuration values that can be applied to one or more DB instances.
Incorrect! Try again.
31What is the recommended method to allow an EC2 instance to connect to an RDS database within a VPC?
A.Allow 0.0.0.0/0 in the RDS Security Group
B.Configure VPC Peering
C.Allow the EC2 Security Group ID in the RDS Security Group inbound rules
D.Use a public IP address
Correct Answer: Allow the EC2 Security Group ID in the RDS Security Group inbound rules
Explanation:
Using Security Group referencing is the most secure method, allowing traffic only from instances associated with the specific EC2 security group.
Incorrect! Try again.
32Which database service is a Petabyte-scale data warehouse used for Online Analytical Processing (OLAP)?
A.Amazon Redshift
B.Amazon Aurora
C.Amazon DynamoDB
D.Amazon RDS
Correct Answer: Amazon Redshift
Explanation:
Amazon Redshift is a fully managed, petabyte-scale data warehouse service in the cloud, optimized for complex queries and OLAP.
Incorrect! Try again.
33In the context of 'Cost Optimization', what is a benefit of using Amazon Aurora I/O-Optimized configuration?
A.It offers predictable pricing for write-heavy applications by removing I/O charges
B.It reduces the cost of data transfer out to the internet
C.It provides free reserved instances
D.It eliminates storage costs entirely
Correct Answer: It offers predictable pricing for write-heavy applications by removing I/O charges
Explanation:
Aurora I/O-Optimized charges for storage and compute but includes I/O operations in the price, benefitting I/O-intensive workloads.
Incorrect! Try again.
34Which AWS service allows you to run Apache Cassandra workloads with a managed serverless experience?
A.Amazon Keyspaces
B.Amazon ElastiCache
C.Amazon RDS for Cassandra
D.Amazon Neptune
Correct Answer: Amazon Keyspaces
Explanation:
Amazon Keyspaces (for Apache Cassandra) is a scalable, highly available, and managed Apache Cassandra-compatible database service.
Incorrect! Try again.
35What happens to the automated backups of an RDS instance if the instance is deleted without a final snapshot?
A.They are converted to manual snapshots
B.They are archived to Glacier
C.They are deleted immediately
D.They are kept for 7 days
Correct Answer: They are deleted immediately
Explanation:
When an RDS instance is deleted, all automated backups are deleted. Manual snapshots are retained. You must explicitly request a final snapshot to save the data.
Incorrect! Try again.
36How does Amazon DynamoDB Streams facilitate event-driven architectures?
A.By directly querying S3
B.By capturing a time-ordered sequence of item-level modifications
C.By sending emails via SES
D.By balancing load across regions
Correct Answer: By capturing a time-ordered sequence of item-level modifications
Explanation:
DynamoDB Streams captures changes (inserts, updates, deletes) which can trigger AWS Lambda functions to perform actions, enabling event-driven patterns.
Incorrect! Try again.
37Which mechanism ensures that an RDS database is deployed in a private network and not accessible from the public internet?
A.Enabling Multi-AZ
B.Deploying in a Public Subnet with an Internet Gateway
C.Using IAM Users
D.Deploying in a Private Subnet without a Public IP
Correct Answer: Deploying in a Private Subnet without a Public IP
Explanation:
To secure a database, it should be placed in a private subnet within a VPC, ensuring it has no public IP address and is not directly reachable from the internet.
Incorrect! Try again.
38When applying 'Performance Efficiency' to a database layer, what does 'Selection' refer to?
A.Choosing the right database engine (SQL vs NoSQL) for the workload
B.Selecting the cheapest option
C.Selecting the region with the most availability zones
D.Selecting the backup retention period
Correct Answer: Choosing the right database engine (SQL vs NoSQL) for the workload
Explanation:
Performance Efficiency involves selecting the correct resource type (e.g., Relational for structured data, Key-Value for high speed) to match the workload requirements.
Incorrect! Try again.
39What is the primary function of a DB Subnet Group in Amazon RDS?
A.To specify which Availability Zones and subnets the DB instance can use
B.To define the firewall rules
C.To group databases for billing
D.To manage database passwords
Correct Answer: To specify which Availability Zones and subnets the DB instance can use
Explanation:
A DB Subnet Group is a collection of subnets (typically private) designated for your RDS instance in a VPC.
Incorrect! Try again.
40Which Amazon RDS engine supports the 'Backtrack' feature to rewind the database cluster to a specific time without restoring from a backup?
A.Amazon RDS for MariaDB
B.Amazon Aurora MySQL
C.Amazon RDS for Oracle
D.Amazon RDS for SQL Server
Correct Answer: Amazon Aurora MySQL
Explanation:
Backtrack is a feature specific to Amazon Aurora (MySQL-compatible) that allows quick rewinds of the database state.
Incorrect! Try again.
41For a read-heavy workload on DynamoDB, which error indicates that the provisioned throughput has been exceeded?
This exception occurs when the request rate is too high for the provisioned read/write capacity units.
Incorrect! Try again.
42Which tool can efficiently move large amounts of data (Exabytes) from on-premises to AWS offline, useful for initial large-scale database migrations?
A.AWS DMS
B.AWS Direct Connect
C.AWS Snowmobile
D.AWS VPN
Correct Answer: AWS Snowmobile
Explanation:
AWS Snowmobile is an Exabyte-scale data transfer service used to move extremely large amounts of data to AWS offline via a physical truck.
Incorrect! Try again.
43In terms of connection management, what is a 'Connection Storm'?
A.Replication lag increasing
B.A loss of internet connectivity
C.A sudden spike in the number of connection requests to the database
D.A firewall blocking all connections
Correct Answer: A sudden spike in the number of connection requests to the database
Explanation:
A connection storm occurs when many client applications attempt to connect to the database simultaneously, often causing the database to become unresponsive.
Incorrect! Try again.
44Which scaling strategy involves changing the instance type of an RDS database (e.g., from t3.medium to r5.large)?
A.Horizontal Scaling
B.Sharding
C.Vertical Scaling
D.Diagonal Scaling
Correct Answer: Vertical Scaling
Explanation:
Vertical scaling (scaling up) involves increasing the compute and memory resources of the existing instance.
Incorrect! Try again.
45What is the purpose of the 'Primary Key' in Amazon DynamoDB?
A.To uniquely identify each item in the table
B.To link to other tables
C.To encrypt the table
D.To define the table schema
Correct Answer: To uniquely identify each item in the table
Explanation:
In DynamoDB, the Primary Key (Partition Key or Partition Key + Sort Key) must uniquely identify every item in the table.
Incorrect! Try again.
46When migrating a database to AWS, which strategy involves moving the application and database with minimal changes?
A.Re-architecting
B.Retiring
C.Re-hosting (Lift and Shift)
D.Re-platforming
Correct Answer: Re-hosting (Lift and Shift)
Explanation:
Re-hosting involves moving the database 'as-is' (e.g., to EC2) without significant changes to the architecture or code.
Incorrect! Try again.
47Which Aurora feature allows a single database to span multiple AWS Regions with low-latency replication?
A.Cross-Region Snapshots
B.Aurora Multi-Master
C.Aurora Serverless
D.Aurora Global Database
Correct Answer: Aurora Global Database
Explanation:
Aurora Global Database replicates data to other regions with typical latency of less than 1 second, enabling fast local reads and disaster recovery.
Incorrect! Try again.
48How does Amazon RDS Storage Auto Scaling work?
A.It compresses data automatically
B.It adds Read Replicas when storage is full
C.It automatically increases the storage size when free space runs low
D.It deletes old data to make room
Correct Answer: It automatically increases the storage size when free space runs low
Explanation:
RDS Storage Auto Scaling detects when free storage space is low and scales up the storage volume automatically without downtime.
Incorrect! Try again.
49Which of the following is NOT a benefit of using managed database services like RDS over self-managed databases on EC2?
A.Automatic software patching
B.Full control over the operating system kernel
C.High availability setup ease
D.Automated backups
Correct Answer: Full control over the operating system kernel
Explanation:
With managed services like RDS, you lose access to the underlying OS. If you need OS-level control, you must use a self-managed database on EC2.
Incorrect! Try again.
50When utilizing Amazon Redshift for data warehousing, what is the role of 'Spectrum'?
A.To backup data to Glacier
B.To manage user access
C.To query data directly in Amazon S3 without loading it into Redshift
D.To encrypt data
Correct Answer: To query data directly in Amazon S3 without loading it into Redshift
Explanation:
Redshift Spectrum allows you to run queries against exabytes of unstructured data in Amazon S3 without having to load the data into Redshift tables.