1Which of the following best describes the primary use case for a Relational Database Management System (RDBMS) in the cloud?
A.High-speed ingestion of time-series telemetry data
B.Managing complex relationships with structured data and schemas
C.Storing unstructured media files like images and videos
D.Storing simple key-value pairs with flexible schemas
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.Optimizing application SQL queries
C.OS patching and hardware maintenance
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.AWS Global Accelerator
B.Amazon ElastiCache
C.Amazon RDS Proxy
D.Amazon RDS Multi-AZ
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.Read Replica
B.Cross-Region Snapshot
C.Single-AZ Deployment
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.Oracle
B.PostgreSQL
C.IBM Db2
D.MariaDB
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.I/O operations are suspended briefly while the backup is initiated
B.The database shuts down completely
C.There is no impact on I/O operations
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.Enable Multi-AZ deployment
B.Create Read Replicas
C.Use Amazon S3 for storage
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.90 days
C.14 days
D.7 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.Point-in-Time Recovery
B.Snapshot Restore
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.Graph Database
B.Relational Database
C.Key-Value and Document Database
D.Time-Series 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 Serverless
C.Aurora Parallel Query
D.Aurora Multi-Master
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 Database Migration Service (DMS)
B.AWS DataSync
C.AWS Storage Gateway
D.AWS Schema Conversion Tool (SCT)
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 DynamoDB
D.Amazon Timestream
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.Multi-AZ uses synchronous replication; Read Replicas use asynchronous replication
B.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.On-Demand Capacity
B.Fixed Capacity
C.Reserved Capacity
D.Provisioned 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.Cost Optimization
C.Performance Efficiency
D.Sustainability
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 QLDB
C.Amazon Timestream
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 DynamoDB
B.Amazon QLDB
C.Amazon Aurora
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 stores the long-term backup
B.It converts the schema
C.It connects to source and target to facilitate data transfer
D.It acts as the final database server
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.Database Cloning
D.Global Database
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 WAF
B.AWS Certificate Manager
C.AWS Shield
D.AWS KMS (Key Management Service)
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 standalone primary DB instance
B.It is deleted immediately
C.It becomes a backup archive
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.DynamoDB Streams
B.Point-in-Time Recovery
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.Three copies across two Availability Zones
B.Two copies in one Availability Zone
C.Six copies across three 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.Amazon S3 Buckets
B.RDS Parameter Groups
C.EC2 User Data
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 Redshift
B.Amazon DynamoDB
C.Amazon Neptune
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.VPC Endpoints
B.Read Replicas
C.DynamoDB Global Tables
D.Cross-Region Replication
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.Change Data Capture
B.Cloud Database Connector
C.Complete Database Creation
D.Continuous Data Copy
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 Security 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.Use a public IP address
B.Allow 0.0.0.0/0 in the RDS Security Group
C.Allow the EC2 Security Group ID in the RDS Security Group inbound rules
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 DynamoDB
B.Amazon Aurora
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 eliminates storage costs entirely
B.It reduces the cost of data transfer out to the internet
C.It offers predictable pricing for write-heavy applications by removing I/O charges
D.It provides free reserved instances
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 RDS for Cassandra
B.Amazon Keyspaces
C.Amazon Neptune
D.Amazon ElastiCache
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 converted to manual snapshots
C.They are kept for 7 days
D.They are archived to Glacier
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 capturing a time-ordered sequence of item-level modifications
C.By sending emails via SES
D.By directly querying S3
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.Deploying in a Private Subnet without a Public IP
B.Using IAM Users
C.Deploying in a Public Subnet with an Internet Gateway
D.Enabling Multi-AZ
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 group databases for billing
B.To specify which Availability Zones and subnets the DB instance can use
C.To manage database passwords
D.To define the firewall rules
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 Snowmobile
D.AWS Direct Connect
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 firewall blocking all connections
B.A loss of internet connectivity
C.Replication lag increasing
D.A sudden spike in the number of connection requests to the database
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.Vertical Scaling
B.Diagonal Scaling
C.Horizontal Scaling
D.Sharding
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 encrypt the table
B.To define the table schema
C.To uniquely identify each item in the table
D.To link to other tables
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-platforming
D.Re-hosting (Lift and Shift)
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 Serverless
B.Aurora Multi-Master
C.Aurora Global Database
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 compresses data automatically
B.It automatically increases the storage size when free space runs low
C.It adds Read Replicas when storage is full
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.Automated backups
C.Full control over the operating system kernel
D.High availability setup ease
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 encrypt data
B.To query data directly in Amazon S3 without loading it into Redshift
C.To manage user access
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.