1Which of the following best describes the primary use case for a Relational Database Management System (RDBMS) in the cloud?
A.Managing complex relationships with structured data and schemas
B.Storing simple key-value pairs with flexible schemas
C.Storing unstructured media files like images and videos
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.Optimizing application SQL queries
B.Designing the database schema
C.Managing database users and permissions
D.OS patching and hardware maintenance
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.Amazon ElastiCache
D.AWS Global Accelerator
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.Read Replica
C.Cross-Region Snapshot
D.Multi-AZ Deployment
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.PostgreSQL
D.Oracle
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.The database shuts down completely
B.There is no impact on I/O operations
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.Increase the instance size
B.Use Amazon S3 for storage
C.Create Read Replicas
D.Enable Multi-AZ deployment
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.14 days
B.35 days
C.7 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.Lazy Loading
C.Atomic Rollback
D.Point-in-Time Recovery
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.Relational Database
B.Key-Value and Document Database
C.Time-Series Database
D.Graph 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 Global Database
B.Aurora Parallel Query
C.Aurora Multi-Master
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 ElastiCache
B.Amazon RDS
C.Amazon Neptune
D.Amazon Redshift
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 Database Migration Service (DMS)
D.AWS DataSync
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 Neptune
B.Amazon Aurora
C.Amazon Timestream
D.Amazon DynamoDB
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.Multi-AZ uses asynchronous replication; Read Replicas use synchronous replication
C.Multi-AZ uses synchronous replication; Read Replicas use asynchronous 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.Fixed Capacity
D.On-Demand 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.Security
B.Performance Efficiency
C.Sustainability
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 DocumentDB
B.Amazon Timestream
C.Amazon QLDB
D.Amazon Redshift
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 Aurora
B.Amazon QLDB
C.Amazon RDS
D.Amazon DynamoDB
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 acts as the final database server
B.It connects to source and target to facilitate data transfer
C.It stores the long-term backup
D.It converts the schema
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.Backtrack
B.Parallel Query
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 Shield
C.AWS WAF
D.AWS Certificate Manager
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 is deleted immediately
B.It becomes a backup archive
C.It replaces the original Multi-AZ standby
D.It becomes a standalone primary DB instance
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.Point-in-Time Recovery
B.DynamoDB Streams
C.Global Tables
D.DAX (DynamoDB Accelerator)
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.Two copies in one Availability Zone
B.One copy in S3
C.Six copies across three Availability Zones
D.Three copies across two Availability Zones
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.AWS Secrets Manager
B.RDS Parameter Groups
C.EC2 User Data
D.Amazon S3 Buckets
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 DocumentDB
C.Amazon DynamoDB
D.Amazon Redshift
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.Read Replicas
B.DynamoDB Global Tables
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.Complete Database Creation
B.Continuous Data Copy
C.Change Data Capture
D.Cloud Database Connector
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 Subnet Groups
C.DB Parameter Groups
D.DB Security 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 the EC2 Security Group ID in the RDS Security Group inbound rules
B.Use a public IP address
C.Allow 0.0.0.0/0 in the RDS Security Group
D.Configure VPC Peering
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 Aurora
B.Amazon DynamoDB
C.Amazon Redshift
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 reduces the cost of data transfer out to the internet
B.It provides free reserved instances
C.It offers predictable pricing for write-heavy applications by removing I/O charges
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 Neptune
B.Amazon ElastiCache
C.Amazon RDS for Cassandra
D.Amazon Keyspaces
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 deleted immediately
B.They are archived to Glacier
C.They are kept for 7 days
D.They are converted to manual snapshots
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 balancing load across regions
B.By sending emails via SES
C.By directly querying S3
D.By capturing a time-ordered sequence of item-level modifications
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.Using IAM Users
B.Deploying in a Private Subnet without a Public IP
C.Enabling Multi-AZ
D.Deploying in a Public Subnet with an Internet Gateway
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.Selecting the region with the most availability zones
B.Selecting the cheapest option
C.Choosing the right database engine (SQL vs NoSQL) for the workload
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 RDS for SQL Server
C.Amazon Aurora MySQL
D.Amazon RDS for Oracle
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 VPN
B.AWS DMS
C.AWS Direct Connect
D.AWS Snowmobile
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.A loss of internet connectivity
B.Replication lag increasing
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 define the table schema
B.To link to other tables
C.To encrypt the table
D.To uniquely identify each item in the table
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.Retiring
B.Re-platforming
C.Re-hosting (Lift and Shift)
D.Re-architecting
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.Aurora Global Database
B.Aurora Serverless
C.Aurora Multi-Master
D.Cross-Region Snapshots
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 deletes old data to make room
B.It compresses data automatically
C.It automatically increases the storage size when free space runs low
D.It adds Read Replicas when storage is full
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.Full control over the operating system kernel
B.High availability setup ease
C.Automatic software patching
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 manage user access
B.To encrypt data
C.To query data directly in Amazon S3 without loading it into Redshift
D.To backup data to Glacier
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.