Courseiva

AWS Certified Database Specialty DBS-C01 (DBS-C01) — Questions 12011275

1663 questions total · 23pages · All types, answers revealed

Page 16

Page 17 of 23

Page 18
1201
MCQhard

An IAM policy is attached to a user to restrict access to a DynamoDB table. What does this policy allow the user to do?

A.Read and write items only where the partition key equals 'customer_123'
B.Read and write any item in the Orders table
C.Scan the entire Orders table
D.Perform all DynamoDB actions on the Orders table
AnswerA

The condition restricts operations to items with LeadingKeys 'customer_123'.

Why this answer

The IAM policy uses a condition key `dynamodb:LeadingKeys` with a condition operator `ForAllValues:StringEquals` to restrict access to items where the partition key equals 'customer_123'. This allows the user to perform read and write operations only on items matching that specific partition key value, enforcing fine-grained access control at the item level.

Exam trap

The trap here is that candidates often assume a policy restricting access to a specific partition key still allows a full table Scan, but DynamoDB's fine-grained access control with `dynamodb:LeadingKeys` explicitly denies any operation that does not specify the allowed partition key, including Scans.

How to eliminate wrong answers

Option B is wrong because the policy explicitly restricts access to items with partition key 'customer_123', not any item in the table. Option C is wrong because a Scan operation would access all items in the table, which violates the partition key restriction; the policy does not allow scanning the entire table. Option D is wrong because the policy does not allow all DynamoDB actions; it only allows specific actions (like GetItem, PutItem, UpdateItem, DeleteItem, Query) conditioned on the partition key value, and actions like CreateTable or DeleteTable are not permitted.

1202
MCQmedium

Refer to the exhibit. A DBA sees the above error log entries for an Amazon RDS for MySQL DB instance. Which action should the DBA take to resolve the 'Too many connections' error?

A.Modify the DB parameter group to increase max_connections
B.Reboot the DB instance
C.Modify the DB security group to allow more connections
D.Reset the DB instance master user password
AnswerA

Increasing max_connections allows more connections.

Why this answer

Increasing the max_connections parameter in the DB parameter group allows the MySQL instance to handle more concurrent connections, directly resolving the 'Too many connections' error. Option B is incorrect because rebooting the DB instance does not change the connection limit, only temporarily clears existing connections. Option C is incorrect because modifying the DB security group adjusts network access rules, not the database's internal connection limit.

Option D is incorrect because resetting the master user password addresses authentication issues, not the connection limit.

1203
MCQeasy

A security audit reveals that an Amazon RDS for MySQL DB instance is accessible from the internet. The security team requires that the database be accessible only from a specific set of application servers within the same VPC. Which solution should be implemented?

A.Modify the DB instance's security group to allow inbound traffic only from the application servers' security group.
B.Apply a network ACL that denies inbound traffic from 0.0.0.0/0 and allows from the application servers' IP range.
C.Enable encryption at rest on the DB instance to prevent unauthorized access.
D.Move the DB instance to a private subnet and configure a bastion host for access.
AnswerA

Security group references allow traffic from instances with that security group.

Why this answer

Modifying the DB instance's security group to allow inbound traffic only from the application servers' security group restricts access to only those instances, using the security group as a source for a more dynamic and manageable solution. Option B is incorrect because network ACLs are stateless and apply at the subnet level, not the instance level, and allowing from the application servers' IP range is less flexible and secure than using security group references. Option C is incorrect because enabling encryption at rest protects data at rest but does not control network access.

Option D is incorrect because moving to a private subnet and using a bastion host is unnecessary when the application servers are in the same VPC; a security group rule is simpler and more appropriate.

1204
MCQeasy

A company needs to audit all SQL queries executed on an Amazon RDS for SQL Server database. Which AWS service should be used?

A.Amazon RDS Database Activity Streams
B.Amazon VPC Flow Logs
C.Amazon CloudWatch Logs
D.AWS CloudTrail
AnswerA

Database Activity Streams capture database activity such as SQL queries in near real-time.

Why this answer

Amazon RDS Database Activity Streams provides a near real-time feed of database activity, including SQL queries, making it ideal for auditing all SQL queries on an RDS for SQL Server database. AWS CloudTrail (Option D) logs API calls to AWS services, not SQL queries. VPC Flow Logs (Option B) capture network traffic metadata, not database queries.

Amazon CloudWatch Logs (Option C) can store and monitor logs but requires a log source; RDS does not natively send SQL logs to CloudWatch unless integrated with Database Activity Streams, which is the direct solution. Therefore, Option A is correct.

1205
MCQmedium

A database engineer is monitoring an Amazon RDS for PostgreSQL instance and notices that the 'DiskQueueDepth' metric is consistently above 100. The instance uses gp2 storage with 1000 GB allocated. What is the most likely cause of the high disk queue depth?

A.Replication lag between the primary and standby instance
B.The instance has reached the IOPS limit of the gp2 volume
C.Insufficient memory allocated to the instance
D.Network throughput limit is being exceeded
AnswerB

For a 1000 GB gp2 volume, baseline IOPS is 3000; sustained I/O beyond that causes queuing.

Why this answer

A consistently high DiskQueueDepth (above 100) on an Amazon RDS for PostgreSQL instance with gp2 storage indicates that the volume is saturating its IOPS limit. gp2 volumes provide a baseline of 3 IOPS per GB (up to 16,000 IOPS), so a 1000 GB gp2 volume has a baseline of 3000 IOPS. When the workload exceeds this baseline, the volume relies on burst credits, and once credits are exhausted, IOPS are throttled to the baseline, causing I/O requests to queue up and the DiskQueueDepth metric to rise.

Exam trap

The trap here is that candidates may confuse DiskQueueDepth with memory or network metrics, or assume that any high queue depth automatically indicates a hardware failure, rather than recognizing it as a symptom of IOPS exhaustion on gp2 storage.

How to eliminate wrong answers

Option A is wrong because replication lag between primary and standby instances is measured by the 'ReplicaLag' metric, not DiskQueueDepth, and it does not directly cause high disk queue depth on the primary instance. Option C is wrong because insufficient memory allocated to the instance would manifest as high swap usage or low FreeableMemory, not as a high DiskQueueDepth, which is a storage I/O metric. Option D is wrong because network throughput limits are tracked by metrics like 'NetworkThroughput' or 'NetworkPacketsIn/Out', and exceeding them would cause packet loss or latency, not a buildup of I/O requests at the disk level.

1206
MCQeasy

A database specialist sees the above error in the application logs for an Amazon RDS for MySQL DB instance. The application is a web server running on an EC2 instance. What is the most likely cause?

A.The database user password has expired.
B.A user attempted to execute an invalid SQL query.
C.The database connection timed out due to inactivity or network connectivity issues.
D.The database instance has run out of disk space.
AnswerC

Common cause of 'server has gone away'.

Why this answer

The error message in the application logs indicates a connection timeout, which occurs when the client (EC2 web server) cannot establish or maintain a TCP connection to the RDS MySQL DB instance within the configured timeout period. This is most commonly caused by network connectivity issues (e.g., security group rules, NACLs, route tables, or VPC misconfigurations) or prolonged inactivity that triggers the MySQL `wait_timeout` or `interactive_timeout` setting, causing the server to close the connection. Option C directly addresses this scenario, while the other options produce different error codes or symptoms.

Exam trap

The trap here is that candidates often confuse connection timeout errors with authentication or query syntax errors, but the specific error message in the logs (e.g., 'Connection timed out' or 'Lost connection to MySQL server during query') directly points to network or timeout issues, not SQL or credential problems.

How to eliminate wrong answers

Option A is wrong because an expired database user password would result in an authentication failure error (e.g., 'Access denied for user') at connection time, not a timeout error. Option B is wrong because an invalid SQL query would produce a MySQL syntax error (e.g., 'You have an error in your SQL syntax') after the connection is successfully established, not a timeout before or during the query execution. Option D is wrong because running out of disk space on the RDS instance would cause write failures or the instance to become read-only (e.g., 'The MySQL server is running with the --read-only option'), not a connection timeout.

1207
MCQhard

A company runs a multi-tenant SaaS application on Amazon RDS for PostgreSQL. Each tenant has an isolated database. Recently, the application experienced a sudden increase in connection errors and slow query performance. Amazon RDS instance metrics show high CPU utilization and a high number of database connections. The application uses connection pooling with PgBouncer running on an EC2 instance. The team suspects the issue is due to a few noisy tenants opening too many connections. The current architecture uses one RDS instance per tenant. The company wants to optimize for workload-specific database design to handle noisy tenants without affecting other tenants. Which design should be implemented to isolate noisy tenants and reduce costs?

A.Use RDS for PostgreSQL with pg_partman to partition data by tenant and implement connection limits per tenant using PostgreSQL advisory locks.
B.Replace RDS with Amazon Aurora PostgreSQL and use Aurora Auto Scaling to handle connection spikes.
C.Move all tenants to a single RDS instance with separate schemas and use RDS Proxy to manage connections.
D.Create separate RDS instances for large tenants and use a single RDS instance for small tenants, with PgBouncer connection pooling per instance.
AnswerD

This isolates noisy tenants on dedicated instances while consolidating small tenants, balancing isolation and cost.

Why this answer

It directly addresses the need to isolate noisy tenants by creating separate RDS instances for large (noisy) tenants while consolidating small tenants onto a single instance, each fronted by its own PgBouncer connection pool. This design prevents a single tenant's connection surge from affecting others, optimizes costs by avoiding over-provisioning for all tenants, and aligns with workload-specific database design principles for multi-tenant SaaS on RDS for PostgreSQL.

Exam trap

The trap here is that candidates may assume a single shared database with connection pooling (Option C) or a fully managed scaling solution (Option B) can solve noisy neighbor problems, but the DBS-C01 exam tests the understanding that workload isolation requires separate database instances or dedicated resources, not just connection management or auto-scaling of a shared cluster.

How to eliminate wrong answers

Option A is wrong because pg_partman is for table partitioning, not connection isolation, and advisory locks do not enforce per-tenant connection limits at the database level—they are application-level coordination mechanisms, not a substitute for connection pooling or instance isolation. Option B is wrong because Aurora Auto Scaling scales the entire cluster, not per-tenant, so a noisy tenant would still consume shared resources and cause contention; it also does not inherently isolate tenants or reduce costs compared to the targeted instance-per-tenant-group approach. Option C is wrong because moving all tenants to a single RDS instance with separate schemas and using RDS Proxy still shares CPU, memory, and I/O across all tenants, so a noisy tenant can degrade performance for others; RDS Proxy manages connections but does not provide workload isolation.

1208
MCQmedium

A company is migrating a 50 GB PostgreSQL database from on-premises to Amazon RDS for PostgreSQL. The network bandwidth between on-premises and AWS is 50 Mbps. The migration must complete within 24 hours. What is the most efficient way to transfer the initial data?

A.Use AWS Snowball to physically transfer the database backup to AWS, then load into RDS.
B.Use AWS DMS to perform a full load directly over the internet.
C.Set up a VPN connection and use AWS DMS with ongoing replication.
D.Use pg_dump to export the database and upload to S3 via the internet, then restore into RDS.
AnswerD

Correct because pg_dump to S3 via the internet leverages the available bandwidth efficiently, and the transfer can complete in a few hours, well within the 24-hour deadline.

Why this answer

The most efficient method is to use pg_dump to export the database, upload the dump file to Amazon S3 via the internet (or using AWS CLI with multipart upload), and then restore it into Amazon RDS for PostgreSQL. Given the database size of 50 GB and a 50 Mbps link, the theoretical transfer time is about 2.3 hours, and even with realistic overhead and retransmissions, it can complete well within the 24-hour window. This approach avoids the shipping delay and logistical overhead of AWS Snowball, which would take several days to arrive and process.

Exam trap

The trap is that candidates overestimate the impact of network overhead and assume Snowball is required for any large data transfer. In reality, for a 50 GB database over a 50 Mbps link, direct network transfer is faster and simpler than physical shipping.

How to eliminate wrong answers

Option B is wrong because AWS DMS over the internet at 50 Mbps would take at least 2.3 hours under perfect conditions, but network overhead, latency, and potential congestion make it unreliable to complete within 24 hours, and DMS is designed for ongoing replication, not just initial bulk transfer. Option C is wrong because setting up a VPN and using DMS with ongoing replication adds unnecessary complexity and latency; the VPN overhead reduces effective throughput, and ongoing replication is not needed for a one-time migration of initial data. Option D is wrong because pg_dump over the internet to S3 would be limited by the same 50 Mbps bandwidth, and the upload time plus the restore time from S3 to RDS would likely exceed 24 hours due to network inefficiencies and the need to download the backup from S3 to the RDS instance.

1209
MCQhard

A company is migrating a 5 TB SQL Server database to Amazon RDS for SQL Server. The migration must be completed within 48 hours with minimal downtime. The network bandwidth between on-premises and AWS is 500 Mbps. What is the MOST efficient migration strategy?

A.Use AWS Snowball to transfer the full database to an RDS instance, then use AWS DMS for ongoing replication
B.Upgrade network bandwidth to 10 Gbps using AWS Direct Connect
C.Use AWS Database Migration Service (AWS DMS) with ongoing replication
D.Use AWS Schema Conversion Tool (AWS SCT) to migrate the schema, then use bulk insert
AnswerA

Snowball transfers data offline, avoiding network bandwidth limitations, then DMS handles ongoing changes.

Why this answer

A 5 TB database over 500 Mbps would take approximately 23 hours for the initial full load alone (5 TB * 8 / 500 Mbps = 80,000 seconds ≈ 22.2 hours), leaving insufficient time for ongoing replication within the 48-hour window. AWS Snowball provides a physical transfer of the full database, bypassing network constraints, and then AWS DMS can perform ongoing change data capture (CDC) replication to apply incremental changes with minimal downtime.

Exam trap

The trap here is that candidates often assume DMS alone can handle large migrations within tight timeframes, underestimating the network transfer time for the full load, and overlook Snowball as a physical transport solution for initial data seeding.

How to eliminate wrong answers

Option B is wrong because upgrading to 10 Gbps Direct Connect is not the most efficient strategy; it would still require a full network transfer of 5 TB, which at 10 Gbps takes about 1.1 hours for the initial load, but provisioning and configuring Direct Connect often takes days or weeks, exceeding the 48-hour migration window. Option C is wrong because using only AWS DMS with ongoing replication would require the initial full load to traverse the 500 Mbps link, taking over 22 hours, and then CDC replication would need to catch up, risking exceeding the 48-hour limit and causing extended downtime. Option D is wrong because AWS Schema Conversion Tool (SCT) is used for heterogeneous migrations (e.g., Oracle to SQL Server), not for homogeneous SQL Server to SQL Server migrations; additionally, bulk insert would still require network transfer of the full 5 TB, which is too slow over 500 Mbps.

1210
MCQeasy

A company needs to rotate the master user password for an Amazon RDS for MySQL DB instance. What is the recommended way to do this without downtime?

A.Modify the DB instance and set a new password, which will cause a reboot for the change to take effect.
B.Update the DB parameter group with the new password.
C.Use the AWS Management Console, CLI, or API to modify the DB instance with a new master password.
D.Delete the DB instance and launch a new one with the new password.
AnswerC

The password change is applied immediately without requiring a reboot.

Why this answer

Using the AWS Management Console, CLI, or API to modify the DB instance with a new master password updates the password without any downtime or reboot. Option A is incorrect because modifying the DB instance and setting a new password does not cause a reboot; password changes take effect immediately. Option B is incorrect because updating the DB parameter group does not change the master password.

Option D is incorrect because deleting and relaunching the instance is unnecessary and would cause downtime.

1211
MCQeasy

A company is deploying a new RDS for MySQL database and needs to ensure that connections are encrypted using TLS. Which parameter should be configured?

A.Set the ssl_ca parameter to the RDS CA certificate.
B.Set the require_secure_transport parameter to ON.
C.Set the tls_version parameter to TLSv1.2.
D.Set the rds.force_ssl parameter to 1 in the DB parameter group.
AnswerD

rds.force_ssl=1 enforces that all connections use SSL/TLS.

Why this answer

In Amazon RDS for MySQL, the `rds.force_ssl` parameter must be set to 1 in the DB parameter group to enforce TLS/SSL for all connections. This parameter, when enabled, requires clients to use SSL/TLS encryption when connecting to the database instance, ensuring data in transit is encrypted.

Exam trap

The trap here is that candidates often confuse the MySQL native `require_secure_transport` parameter (which is not available in RDS) with the RDS-specific `rds.force_ssl` parameter, or they mistakenly think that setting a TLS version alone enforces encryption.

How to eliminate wrong answers

Option A is wrong because the `ssl_ca` parameter is used to specify the Certificate Authority (CA) certificate for client-side verification, not to enforce encryption; it is typically set on the client side, not in the RDS parameter group. Option B is wrong because `require_secure_transport` is a MySQL Server system variable (available in MySQL 8.0.28+), but it is not supported in Amazon RDS for MySQL; RDS uses `rds.force_ssl` instead. Option C is wrong because setting `tls_version` to TLSv1.2 only restricts the allowed TLS protocol version but does not enforce encryption; clients could still connect without TLS if encryption is not mandated.

1212
MCQhard

A company uses Amazon Redshift for data warehousing. The security team requires that all data loaded into the cluster be encrypted at rest using a customer-managed KMS key. The cluster is currently unencrypted. What is the most efficient way to achieve this requirement with minimal data loss?

A.Unload the data from the existing cluster to S3, create a new encrypted cluster using the KMS key, and reload the data from S3.
B.Change the cluster parameter group to enable encryption.
C.Modify the cluster and enable encryption in the Redshift console.
D.Take a snapshot of the cluster, copy the snapshot with encryption, and restore from the encrypted snapshot.
AnswerA

This is the recommended approach to migrate data to an encrypted cluster.

Why this answer

An existing unencrypted Redshift cluster cannot be encrypted in place. The only way to achieve encryption using a customer-managed KMS key is to unload the data to S3, create a new encrypted cluster with the desired KMS key, and reload the data. Options B, C, and D are incorrect because Redshift does not support enabling encryption on an existing cluster, modifying an existing cluster to enable encryption, or adding encryption to an unencrypted snapshot.

1213
MCQhard

A company runs a critical application on Amazon RDS for PostgreSQL with Multi-AZ. The database has a large table (over 500 GB) that is frequently updated. The operations team notices that the primary instance's CPU usage is consistently above 90%, and the replica lag between the primary and standby is increasing during peak hours. The application can tolerate a few seconds of downtime. The team needs to reduce CPU load and improve write performance without changing the application code. Which action should be taken?

A.Upgrade the DB instance class to a larger size with more vCPUs.
B.Increase the backup retention period to reduce I/O during backups.
C.Modify the DB instance to use asynchronous replication instead of synchronous.
D.Create a read replica in the same region and offload read queries to it.
AnswerA

More CPU capacity reduces the load on the primary and helps keep up with replication.

Why this answer

Upgrading to a larger DB instance class provides additional vCPUs, reducing CPU utilization and alleviating replication lag. Option B is wrong: increasing the backup retention period does not reduce I/O during backups; it only keeps backups longer and does not address CPU or write performance. Option C is wrong: Multi-AZ RDS for PostgreSQL uses synchronous replication; switching to asynchronous replication is not possible without compromising durability, and it would not reduce CPU load on the primary.

Option D is wrong: creating a read replica offloads read queries, but it does not reduce write load or CPU usage from writes on the primary instance; replication lag may persist or increase.

1214
MCQmedium

A company is designing a database for an IoT application that ingests millions of small sensor readings per second. The data is append-only and queries are primarily time-based aggregations with low latency requirements (under 10 ms). Which AWS database service is most suitable for this workload?

A.Amazon DynamoDB
B.Amazon ElastiCache
C.Amazon Aurora
D.Amazon Timestream
AnswerD

Timestream is purpose-built for time-series data with fast ingestion and aggregation.

Why this answer

Amazon Timestream is a purpose-built time-series database designed for IoT and operational applications that ingest high volumes of append-only data. It automatically manages storage tiers (in-memory and magnetic) and provides built-in time-based aggregation functions, enabling queries with sub-10 ms latency for recent data. This makes it the most suitable choice for the described workload of millions of sensor readings per second with low-latency aggregation queries.

Exam trap

The trap here is that candidates often choose Amazon DynamoDB for its low-latency and scalability reputation, overlooking that it lacks native time-series features like automatic retention policies and time-based aggregation functions, which are critical for this specific workload.

How to eliminate wrong answers

Option A is wrong because Amazon DynamoDB is a key-value and document database optimized for single-digit millisecond latency at any scale, but it lacks native time-series optimizations such as automatic data tiering, time-based partitioning, and built-in aggregation functions, requiring complex application-level sharding and retention management for append-only time-series data. Option B is wrong because Amazon ElastiCache is an in-memory caching service (Redis/Memcached) that can provide sub-millisecond latency but is not designed for persistent, high-ingestion append-only workloads; it would require significant engineering to manage data retention, durability, and time-series queries, and its cost becomes prohibitive for storing millions of events per second. Option C is wrong because Amazon Aurora is a relational database with ACID compliance and high throughput, but it is not optimized for time-series data; its row-based storage and indexing overhead cause write bottlenecks at millions of writes per second, and it lacks native time-based partitioning and aggregation functions, leading to higher latency and cost for this workload.

1215
MCQhard

A company uses an Amazon RDS for PostgreSQL database with Multi-AZ deployment. The security team wants to audit all SQL queries executed against the database for compliance purposes. Which solution should be implemented to capture and store the queries?

A.Use AWS CloudTrail to capture SQL queries.
B.Enable Performance Insights and store the data in CloudWatch Logs.
C.Enable RDS event notifications for database queries.
D.Enable PostgreSQL query logging and publish logs to Amazon CloudWatch Logs.
AnswerD

PostgreSQL can log all queries, and those logs can be sent to CloudWatch Logs for storage and analysis.

Why this answer

Enabling PostgreSQL query logging and publishing those logs to CloudWatch Logs captures all SQL queries for auditing. Option A is wrong because CloudTrail captures API calls, not SQL queries. Option B is wrong because Performance Insights captures performance metrics, not the text of SQL queries.

Option C is wrong because RDS event notifications are for database events (e.g., failover, scaling), not for capturing SQL query text.

1216
MCQhard

A company uses Amazon DynamoDB with on-demand capacity mode for a critical application. During a marketing campaign, the application experienced throttled requests despite the on-demand mode. The table has a single partition key. The database specialist notices that the throttling occurs sporadically even though overall traffic is within limits. What is the most likely cause?

A.The table's provisioned capacity is set too low.
B.The table's partition key is causing a hot partition, leading to throttling on that partition.
C.The table's auto scaling is not configured correctly.
D.The application is exceeding the DynamoDB account-level throughput limits.
AnswerB

A single partition key can cause hot partitions; DynamoDB's on-demand mode partitions data, but a single hot key can still throttle.

Why this answer

On-demand mode accommodates traffic spikes, but if a single partition key is used, all traffic goes to one partition. DynamoDB partitions data by partition key; a single hot key can throttle requests even if overall throughput is within limits. Provisioned capacity is not used.

Auto scaling is not relevant. The partition limit is a hard limit.

1217
Multi-Selecteasy

Which TWO AWS services can be used to implement a serverless database architecture for variable workloads?

Select 2 answers
A.Amazon Redshift
B.Amazon Aurora Serverless v2
C.Amazon RDS Proxy
D.Amazon ElastiCache
E.Amazon DynamoDB
AnswersB, E

Aurora Serverless automatically scales capacity.

Why this answer

Amazon Aurora Serverless v2 is correct because it automatically scales database capacity up or down based on application demand, providing a serverless architecture for variable workloads without the need to manage database instances. Amazon DynamoDB is correct because it is a fully managed NoSQL serverless database that automatically scales throughput and storage to handle variable workloads, requiring no server provisioning or management.

Exam trap

The trap here is that candidates often confuse Amazon RDS Proxy (a connection management service) with a serverless database, or assume Amazon Redshift can function as a serverless transactional database, when in fact it is a data warehouse requiring cluster provisioning.

1218
MCQeasy

A startup is building a mobile application that requires a database to store user preferences and session data. The data is accessed by user ID and requires single-digit millisecond latency. The workload is read-heavy with occasional writes. Which database service is MOST cost-effective?

A.Amazon Aurora Serverless
B.Amazon ElastiCache for Memcached
C.Amazon DynamoDB with on-demand capacity
D.Amazon RDS for MySQL with provisioned IOPS
AnswerC

DynamoDB provides single-digit millisecond latency and is cost-effective for variable read-heavy workloads.

Why this answer

Amazon DynamoDB with on-demand capacity is the most cost-effective choice because it provides single-digit millisecond latency for key-value lookups by user ID, scales automatically to handle read-heavy workloads with occasional writes, and charges only for the reads and writes consumed, avoiding the cost of provisioning for peak capacity. The on-demand mode eliminates the need for capacity planning, making it ideal for unpredictable or variable traffic patterns typical of a startup's mobile application.

Exam trap

The trap here is that candidates often choose Amazon ElastiCache for Memcached (Option B) because of its low latency, but they overlook the requirement for a durable database that persists session data, whereas Memcached is a volatile cache with no built-in persistence or replication for data durability.

How to eliminate wrong answers

Option A is wrong because Amazon Aurora Serverless is a relational database designed for transactional workloads with ACID compliance, not optimized for simple key-value lookups with single-digit millisecond latency, and its cold-start latency and higher per-request cost make it less cost-effective for a read-heavy, occasional-write workload. Option B is wrong because Amazon ElastiCache for Memcached is an in-memory cache, not a durable database; it lacks persistence and data durability, making it unsuitable for storing user preferences and session data that must survive restarts. Option D is wrong because Amazon RDS for MySQL with provisioned IOPS incurs fixed costs for provisioned IOPS and instance hours, which is wasteful for a read-heavy workload with occasional writes, and its relational overhead adds unnecessary latency compared to a NoSQL key-value store.

1219
MCQeasy

A developer accidentally deleted an RDS database. Which action will allow the database to be restored with the least data loss?

A.Restore from the latest automated backup using point-in-time recovery.
B.Use the 'Recycle Bin' feature to recover the RDS instance.
C.Restore from the latest manual snapshot.
D.Create a new RDS instance and hope for the best.
AnswerA

Automated backups allow restoration to any point within the retention period, minimizing data loss.

Why this answer

Point-in-time recovery (PITR) allows you to restore an RDS DB instance to any second within the automated backup retention period, typically up to the last five minutes. This minimizes data loss because it replays transaction logs from the latest automated backup to the specified time, recovering changes made right up to the deletion moment. Automated backups are enabled by default with a 7-day retention, making PITR the most granular recovery option.

Exam trap

The trap here is that candidates may assume manual snapshots are the safest recovery method, but they lack the transaction log replay capability of PITR, leading to greater data loss than using automated backups with point-in-time recovery.

How to eliminate wrong answers

Option B is wrong because the Recycle Bin feature is available for Amazon RDS only in certain AWS Regions and for specific instance types, and it retains deleted instances for a limited time (default 1 day) but does not recover transaction logs, so data loss can be greater than PITR. Option C is wrong because manual snapshots capture the database at a specific point in time and do not include transaction logs for replay, so you lose all changes made after the snapshot was taken. Option D is wrong because creating a new RDS instance without restoring from a backup results in a blank database, losing all data entirely.

1220
MCQeasy

A database administrator notices that the CPU utilization on an Amazon RDS for PostgreSQL instance is consistently above 90% during peak hours. Which CloudWatch metric should be checked first to identify the cause of the high CPU usage?

A.DatabaseConnections
B.NetworkThroughput
C.SwapUsage
D.ReadIOPS
AnswerA

High connections can lead to high CPU from session management.

Why this answer

A high number of database connections can lead to increased CPU usage as each connection requires processing. Option B is wrong because NetworkThroughput measures network traffic, which is not a primary cause of high CPU. Option C is wrong because SwapUsage indicates memory pressure, not CPU.

Option D is wrong because ReadIOPS measures disk I/O and may not directly cause high CPU.

1221
MCQeasy

A company has an Amazon Redshift cluster with two dc2.large nodes. The cluster is used for daily ETL jobs and reporting. The operations team receives an alert that the cluster's disk space is 90% full. The ETL jobs are failing with 'disk full' errors. The team needs to resolve the issue quickly with minimal downtime. Which action should be taken?

A.Perform a deep copy to re-sort and reclaim space.
B.Run the VACUUM command to reclaim space from deleted rows.
C.Resize the cluster to a larger node type, such as dc2.large to ds2.xlarge, or add more nodes.
D.Unload old data to Amazon S3 and delete from the cluster.
AnswerC

Resizing increases the total storage capacity, resolving the disk full issue.

Why this answer

Resizing the cluster to a larger node type or adding more nodes increases the total storage capacity, directly addressing the disk full issue. Option A is wrong because a deep copy reorganizes data but does not increase storage capacity. Option B is wrong because VACUUM reclaims space from deleted rows but may not free enough space when the cluster is already 90% full.

Option D is wrong because unloading data to S3 removes data from the cluster only if deleted, but the statement does not include deletion; even if deleted, the space is not reclaimed until VACUUM.

1222
MCQhard

A company wants to migrate an on-premises MySQL database to Amazon RDS for MySQL. The database is 500 GB and experiences heavy write traffic. They need to minimize downtime and ensure no data loss. Which approach should they take?

A.Use AWS DMS with a full load task, then cut over the application to RDS.
B.Set up MySQL replication from the on-premises database to RDS, then promote the RDS instance when ready.
C.Create an RDS read replica of the on-premises database, then promote it to a standalone instance.
D.Use mysqldump to export the database and mysql command to import into RDS during a maintenance window.
AnswerB

Replication captures ongoing changes, minimizing downtime and ensuring data consistency.

Why this answer

Setting up native MySQL replication from the on-premises database to Amazon RDS for MySQL allows continuous synchronization with minimal downtime. When ready, you simply stop replication and promote the RDS instance, ensuring zero data loss since all transactions are replicated in near real-time.

Exam trap

The trap here is that candidates confuse AWS DMS's ongoing replication (CDC) with a full load task, or mistakenly think RDS read replicas can be created from external databases, leading them to choose options that either risk data loss or are technically impossible.

How to eliminate wrong answers

Option A is wrong because AWS DMS with a full load task only captures a point-in-time snapshot and does not handle ongoing changes, leading to data loss if writes continue during migration. Option C is wrong because an RDS read replica cannot be created from an on-premises database; read replicas are only supported within AWS RDS or cross-Region, not from external sources. Option D is wrong because mysqldump and mysql import require an application downtime window and do not provide continuous replication, risking data loss if writes occur during the export/import process.

1223
MCQmedium

A company's Amazon RDS for PostgreSQL instance is running out of storage. The DB instance has auto-scaling enabled, but the storage did not increase. What is the most likely cause?

A.The DB instance class does not support storage auto-scaling.
B.The DB instance is smaller than the minimum storage size for auto-scaling.
C.The DB instance has exceeded the Maximum Storage Duration setting.
D.The storage usage has not reached the maximum allocated storage.
AnswerC

As the most likely cause is that the maximum storage threshold has been reached, preventing further auto-scaling.

Why this answer

Amazon RDS storage auto-scaling will not increase storage beyond the maximum storage threshold set by the user. If the instance has reached this maximum threshold, auto-scaling stops, even if free space is low. The phrase 'Maximum Storage Duration' in the option refers to this threshold.

Option D is incorrect because the condition for auto-scaling is based on free space being below 10%, not on whether the maximum storage has been reached. If the maximum threshold has not been reached, auto-scaling should occur when free space is low.

Exam trap

Candidates often confuse 'maximum storage threshold' with 'allocated storage'. The threshold is the upper limit for auto-scaling; once reached, no further scaling occurs.

1224
MCQmedium

A company is running a production Amazon RDS for MySQL Multi-AZ DB instance. The database experiences intermittent high latency and the CloudWatch 'ReadLatency' metric spikes during periods of heavy read traffic. The application uses a single database endpoint. What is the MOST effective way to reduce read latency without changing the application code?

A.Enable a Multi-AZ deployment with one or more readable standby replicas.
B.Implement database sharding across multiple RDS instances.
C.Enable Multi-AZ on the existing DB instance to provide a standby for failover.
D.Increase the DB instance class to a larger size.
AnswerA

Readable standby replicas in Multi-AZ allow read traffic to be directed to the standby, reducing load on the primary and lowering read latency, without code changes.

Why this answer

Enabling a Multi-AZ deployment with one or more readable standby replicas allows you to offload read traffic to the standby instances using the Read Replica endpoint, reducing load on the primary and lowering ReadLatency. Since the application uses a single database endpoint, you can use Amazon RDS's built-in reader endpoint (for a Multi-AZ DB cluster) or configure a custom DNS to distribute reads, without modifying application code. This directly addresses the intermittent high latency during heavy read traffic by scaling read capacity horizontally.

Exam trap

The trap here is that candidates confuse 'Multi-AZ' with 'readable standby' — classic Multi-AZ provides high availability but no read scaling, while the newer Multi-AZ DB cluster (or adding Read Replicas) is required to reduce read latency.

How to eliminate wrong answers

Option B is wrong because database sharding requires application code changes to route queries to the correct shard, which violates the constraint of not changing application code. Option C is wrong because enabling Multi-AZ on the existing DB instance only provides a standby for failover (not readable), which does not reduce read latency during normal operations. Option D is wrong because increasing the DB instance class to a larger size may improve performance but is less cost-effective and does not scale read capacity as efficiently as adding readable replicas, especially under intermittent heavy read traffic.

1225
Multi-Selecteasy

Which TWO database design considerations are critical when migrating a high-traffic e-commerce website from Oracle to Amazon Aurora MySQL? (Choose 2.)

Select 2 answers
A.Enable eventual consistency for read replicas to reduce latency
B.Review and adapt application SQL queries for MySQL compatibility
C.Evaluate the impact of Aurora's storage engine on query performance
D.Use Aurora Multi-Master to distribute write load
E.Compress all tables to reduce storage costs
AnswersB, C

Oracle and MySQL differ in SQL syntax.

Why this answer

Oracle and MySQL use different SQL dialects, data types, and functions. Migrating a high-traffic e-commerce application requires reviewing and adapting all SQL queries to ensure compatibility with Aurora MySQL, including handling Oracle-specific features like sequences, hierarchical queries (CONNECT BY), and PL/SQL stored procedures. Failure to do so will cause runtime errors or degraded performance.

Exam trap

The trap here is that candidates often assume Aurora Multi-Master is the best choice for high write loads, but the exam tests understanding that Multi-Master introduces conflict resolution overhead and is typically not recommended for standard e-commerce workloads, where a single writer with read replicas is more appropriate.

1226
MCQeasy

A company is running a MySQL database on Amazon RDS for a web application. The application experiences read-heavy traffic, and the company wants to improve read performance without changing the application code. Which design should the database specialist recommend?

A.Implement an Amazon ElastiCache Redis cluster in front of the database.
B.Create one or more read replicas of the RDS DB instance.
C.Increase the instance size of the RDS DB instance.
D.Enable DynamoDB Accelerator (DAX) for the RDS instance.
AnswerB

Read replicas offload read traffic from the primary instance, improving read performance without application changes.

Why this answer

Amazon RDS read replicas allow you to offload read traffic from the primary DB instance without any application code changes. The application simply connects to the read replica endpoint(s) for SELECT queries, while writes continue to the primary instance. This directly addresses the read-heavy workload by distributing read requests across multiple copies of the database.

Exam trap

The trap here is that candidates may confuse read replicas with caching solutions like ElastiCache, but the key constraint is 'without changing the application code' — read replicas require only a connection string change, whereas caching requires code modifications to implement cache logic.

How to eliminate wrong answers

Option A is wrong because while ElastiCache Redis can improve read performance for cached data, it requires application code changes to implement cache-aside or other caching patterns, and it does not serve as a direct database read endpoint for existing queries. Option C is wrong because scaling up the instance size (vertical scaling) improves both read and write performance but does not specifically address read-heavy traffic in a cost-effective manner; it also does not distribute the read load across multiple nodes. Option D is wrong because DynamoDB Accelerator (DAX) is an in-memory cache for Amazon DynamoDB, not for Amazon RDS MySQL; it is incompatible with RDS and cannot be used to accelerate MySQL queries.

1227
MCQmedium

A company is using Amazon DynamoDB with on-demand capacity. The operations team notices that the number of throttled write requests has increased. Which metric should be monitored to determine if the table's write capacity is being exceeded?

A.ThrottledWriteRequests
B.WriteThrottleEvents
C.ProvisionedWriteCapacityUnits
D.ConsumedWriteCapacityUnits
AnswerB

This metric directly shows the number of throttled write requests.

Why this answer

'WriteThrottleEvents' is the Amazon CloudWatch metric that directly indicates throttled write requests. Option A is wrong because 'ThrottledWriteRequests' is not a standard CloudWatch metric name (the correct name is WriteThrottleEvents). Option C is wrong because 'ProvisionedWriteCapacityUnits' is not applicable for on-demand capacity.

Option D is wrong because 'ConsumedWriteCapacityUnits' shows actual usage, not throttling.

1228
MCQhard

A database administrator runs the above AWS CLI command to troubleshoot replication issues. The DB instance 'mydb' is a read replica of 'my-source-db'. The administrator notices that the replica lag is increasing. Which of the following is the MOST likely cause?

A.The source DB instance is running a different MySQL version.
B.The read replica has Multi-AZ disabled.
C.The read replica is using a smaller instance class than the source.
D.The read replica is in a different AWS Region than the source.
AnswerD

Cross-Region replication introduces network latency, causing lag.

Why this answer

When a read replica is in a different AWS Region than the source, the replication traffic must traverse the public internet or a VPN connection, introducing network latency and potential bandwidth constraints. This cross-region lag is a common cause of increasing replica lag, as the asynchronous MySQL replication relies on a single I/O thread to download the binary log events from the source, and any network delay directly impacts the replica's ability to keep up.

Exam trap

The trap here is that candidates often assume instance size (Option C) is the primary cause of replica lag, but the question explicitly mentions a cross-Region scenario (implied by the AWS CLI command targeting a different Region), making network latency the most likely culprit over compute capacity.

How to eliminate wrong answers

Option A is wrong because MySQL cross-version replication is supported as long as the source version is lower than or equal to the replica version, and version mismatch typically causes replication to fail entirely rather than just increasing lag. Option B is wrong because Multi-AZ on a read replica affects high availability and failover behavior, not the replication lag between the source and the replica. Option C is wrong because while a smaller instance class can contribute to lag if the replica lacks sufficient CPU or memory to apply changes, the most likely cause given the scenario of a cross-region replica is the network latency inherent in the geographic distance, not the instance size.

1229
MCQhard

Refer to the exhibit. A database administrator runs the AWS CLI command and gets the following output: {"Engine":"mysql","DBInstanceStatus":"available","MultiAZ":true,"SecondaryAvailabilityZone":"us-east-1b"}. What can be concluded about the database deployment?

A.The database is a Single-AZ deployment.
B.The database has a Read Replica in a different Availability Zone.
C.The database is an Amazon Aurora cluster.
D.The database is a Multi-AZ deployment with a standby in a different Availability Zone.
AnswerD

MultiAZ true and SecondaryAZ present.

Why this answer

The output shows `"MultiAZ":true` and `"SecondaryAvailabilityZone":"us-east-1b"`, which are explicit indicators of a Multi-AZ deployment for an RDS MySQL instance. In a Multi-AZ deployment, Amazon RDS automatically provisions and maintains a synchronous standby replica in a different Availability Zone, and the `SecondaryAvailabilityZone` field confirms the standby's location. This matches option D exactly.

Exam trap

The trap here is that candidates confuse the `SecondaryAvailabilityZone` field with a Read Replica or Aurora's multi-AZ nature, but only a Multi-AZ deployment with a synchronous standby explicitly populates this field in the describe output for a non-Aurora RDS instance.

How to eliminate wrong answers

Option A is wrong because `"MultiAZ":true` directly contradicts a Single-AZ deployment, which would have `"MultiAZ":false` or omit the field. Option B is wrong because Read Replicas are asynchronous and do not appear in the `SecondaryAvailabilityZone` field of the primary instance's describe output; Read Replicas are separate DB instances with their own endpoint. Option C is wrong because Amazon Aurora clusters do not use the `MultiAZ` or `SecondaryAvailabilityZone` fields in the same way; Aurora uses a cluster volume and DB instances across AZs, and the engine would be `aurora-mysql` or `aurora`, not `mysql`.

1230
MCQhard

A company has an Amazon RDS for SQL Server Multi-AZ DB instance with a standby replica in a different AWS Region. The database is encrypted with a KMS key. The company needs to implement automated backups that are also encrypted and stored in a cross-region S3 bucket. The backups must be retained for 3 years. Which solution meets these requirements with the LEAST administrative effort?

A.Configure RDS to send automated backups directly to the cross-region S3 bucket using the AWS Backup service.
B.Enable automated backups on the RDS instance, configure cross-Region backup copy to a destination Region, and store the backups in an S3 bucket with S3 Object Lock enabled for retention.
C.Use AWS Database Migration Service (DMS) to continuously replicate the database to an S3 bucket in the target region.
D.Create manual snapshots of the RDS instance, copy them to the cross-region S3 bucket using AWS CLI, and set a lifecycle policy for retention.
AnswerA

AWS Backup can automate RDS backups and store them in a cross-region S3 bucket, fulfilling all requirements with minimal effort.

Why this answer

AWS Backup can be used to manage automated backups of RDS instances and store them in a cross-region S3 bucket. AWS Backup natively supports RDS and allows you to create backup plans that automatically take snapshots and copy them to a different region, storing them in S3. The backups are encrypted using the KMS key, and you can set retention policies for 3 years.

This solution requires minimal administrative effort as AWS Backup automates the entire process. Option B is incorrect because RDS cross-Region backup copy stores backups in the destination region's RDS-managed storage, not in an S3 bucket as required. Option C is incorrect because AWS DMS is designed for migrations, not for ongoing backup management.

Option D is incorrect because manual snapshots require manual intervention and do not provide automated backups.

1231
MCQhard

A company is using Amazon DynamoDB with client-side encryption using the DynamoDB Encryption Client. The encryption keys are stored in AWS KMS. The security team wants to ensure that the encryption keys can be used only by authorized applications. What should be done?

A.Store the encryption keys in AWS CloudHSM instead of KMS.
B.Use AWS Secrets Manager to store the encryption keys and rotate them automatically.
C.Use an IAM policy that denies access to the DynamoDB table unless the request includes the correct key.
D.Use a KMS key policy that grants access only to the specific IAM roles used by the applications.
AnswerD

KMS key policies can restrict which principals can use the key.

Why this answer

A KMS key policy that restricts decryption permissions to specific IAM roles ensures only authorized applications can use the client-side encryption keys. Option A is incorrect because storing keys in CloudHSM does not by itself enforce application-level authorization; key policies are still needed. Option B is incorrect because Secrets Manager is for storing secrets, not for managing key permissions; it does not replace KMS key policies.

Option C is incorrect because IAM policies alone cannot deny DynamoDB access based on encryption keys; access control is managed via the key policy and IAM permissions.

1232
MCQeasy

A company has an Amazon DynamoDB table with provisioned capacity. The table experiences occasional spikes in write traffic that exceed the provisioned write capacity units (WCU). Which feature should the database specialist enable to handle these spikes without throttling?

A.Enable DynamoDB burst capacity.
B.Configure DynamoDB Auto Scaling for write capacity.
C.Use DynamoDB Accelerator (DAX) to cache writes.
D.Switch to on-demand capacity mode.
AnswerB

Auto Scaling adjusts capacity automatically to handle spikes.

Why this answer

DynamoDB Auto Scaling automatically adjusts the provisioned read and write capacity based on actual traffic patterns, enabling the table to handle spikes without throttling while maintaining cost efficiency. Option A is incorrect because burst capacity provides a limited buffer for short-term spikes but can be exhausted, leading to throttling. Option C is incorrect because DAX is an in-memory cache for read operations, not writes.

Option D is incorrect because switching to on-demand capacity mode can handle spikes but may result in higher costs compared to Auto Scaling with provisioned capacity.

1233
MCQeasy

Refer to the exhibit. A developer created an IAM policy with the above command and attached it to a user. What is the security implication of this policy?

A.The policy restricts access to only one specific DB instance.
B.The policy allows only actions in the us-east-1 region.
C.The policy grants full administrative access to all RDS resources in the account.
D.The policy only allows read-only access to RDS.
AnswerC

This is the security risk.

Why this answer

The policy allows all RDS actions on all resources, granting full administrative access to all RDS resources in the account. This is overly permissive and violates the principle of least privilege. Option A is wrong because the policy does not restrict to a specific region.

Option B is wrong because it does not restrict to a specific region. Option D is wrong because it does not restrict to read-only access.

1234
MCQhard

A company uses Amazon Aurora MySQL for a SaaS application. Each tenant has a separate database. The company wants to implement a centralized monitoring solution that collects performance metrics from all tenant databases. The solution should be cost-effective and require minimal overhead. Which approach should be used?

A.Use AWS DMS to continuously replicate metrics to a central RDS instance.
B.Consolidate all tenants into a single RDS MySQL instance and use separate schemas.
C.Run an AWS Lambda function that queries each database's performance_schema every minute and stores results in S3.
D.Use Amazon CloudWatch Agent to collect custom metrics from each Aurora instance and aggregate in CloudWatch.
AnswerD

CloudWatch Agent collects metrics with low overhead.

Why this answer

Amazon CloudWatch Agent can be installed on each Aurora instance to collect custom performance metrics (e.g., from performance_schema) and publish them as CloudWatch custom metrics. This approach is cost-effective because it uses CloudWatch’s pay-per-metric model and eliminates the need for a separate aggregation database or continuous data movement. It also requires minimal overhead as the agent handles collection and aggregation natively, with no additional infrastructure to manage.

Exam trap

The trap here is that candidates often assume a centralized database or Lambda-based polling is required for aggregation, but the CloudWatch Agent’s native custom metrics capability provides a simpler, serverless, and cost-effective solution that aligns with the ‘minimal overhead’ requirement.

How to eliminate wrong answers

Option A is wrong because AWS DMS is designed for database migration and continuous replication of table-level data, not for collecting and aggregating performance metrics; it would introduce unnecessary complexity, cost, and latency. Option B is wrong because consolidating all tenants into a single RDS MySQL instance with separate schemas violates the requirement for separate databases per tenant and introduces cross-tenant performance noise, security risks, and scalability limits. Option C is wrong because running a Lambda function every minute to query each database’s performance_schema would incur significant invocation costs, potential cold-start latency, and network overhead; it also lacks built-in aggregation and retention, requiring additional S3 processing.

1235
MCQeasy

A company runs an Amazon RDS for Oracle DB instance. The database administrator wants to receive an alert when the storage space is below 10% of the allocated storage. Which Amazon CloudWatch metric and alarm threshold should be used?

A.Metric: FreeStorageSpace, Condition: < 10% of 100 GB (10 GB)
B.Metric: BinaryLogUsage, Condition: > 10%
C.Metric: FreeableMemory, Condition: < 10% of total memory
D.Metric: DiskQueueDepth, Condition: > 10
AnswerA

FreeStorageSpace metric with a threshold of 10 GB (assuming 100 GB allocated) would trigger when free space is below 10%.

Why this answer

The correct metric is FreeStorageSpace, which reports the available storage in bytes. To alert when storage is below 10% of allocated, compute the threshold as 10% of the total allocated storage (e.g., 10 GB for 100 GB). Option A defines the condition correctly.

Option B is wrong because BinaryLogUsage applies to MySQL, not Oracle. Option C is incorrect as FreeableMemory tracks memory, not storage. Option D is wrong because DiskQueueDepth measures I/O queue depth, not storage capacity.

1236
MCQmedium

A company is deploying a new web application that uses Amazon RDS for MySQL. The application has unpredictable read traffic spikes. The company wants to minimize read latency and automatically scale read capacity. What is the MOST cost-effective solution?

A.Use Amazon ElastiCache as a caching layer
B.Use Amazon RDS Proxy to manage connections
C.Deploy the RDS instance in a Multi-AZ configuration
D.Create an Amazon RDS read replica and configure the application to use it for read traffic
AnswerD

Read replicas offload read traffic and can be scaled manually; they are cost-effective.

Why this answer

Amazon RDS read replicas allow you to offload read traffic from the primary DB instance to one or more replicas, which can be scaled horizontally by adding more replicas as needed. This is the most cost-effective solution among the options for handling unpredictable read spikes because it directly addresses read capacity scaling without the cost of a full caching layer. Multi-AZ provides only high availability, not read scaling; ElastiCache adds cost and complexity; RDS Proxy manages connections but does not scale read capacity.

Exam trap

The trap here is that candidates often confuse Multi-AZ (which provides high availability but no read scaling) with read replicas (which provide read scaling but not automatic failover), leading them to select Multi-AZ as a solution for read performance.

How to eliminate wrong answers

Option A is wrong because Amazon ElastiCache adds operational complexity and cost for a caching layer that may not be necessary for simple read offloading, and it does not directly scale the database's read capacity for unpredictable spikes. Option B is wrong because Amazon RDS Proxy manages connection pooling and improves application scalability, but it does not increase read throughput or reduce read latency for read-heavy workloads. Option C is wrong because Multi-AZ configuration provides high availability and failover support, not read scaling; the standby instance cannot serve read traffic, so it does not help with read spikes.

1237
Multi-Selectmedium

Which TWO actions should a company take to secure an Amazon RDS for MySQL database that is accessible from the internet? (Choose two.)

Select 2 answers
A.Use a security group that restricts inbound traffic to only the required IP addresses.
B.Disable encryption at rest to reduce latency.
C.Use the default VPC with a public subnet and a network ACL that allows all traffic.
D.Launch the DB instance in a public subnet with a public IP address.
E.Place the DB instance in a private subnet without a public IP address.
AnswersA, E

Security groups act as a virtual firewall to control inbound traffic.

Why this answer

Options A and E are correct. Option A: Using a security group to restrict inbound traffic to only required IP addresses limits exposure to the internet. Option E: Placing the DB instance in a private subnet without a public IP address ensures it is not directly accessible from the internet.

Option B is incorrect because disabling encryption at rest reduces security and does not address internet accessibility. Option C is incorrect because using the default VPC with a public subnet and a network ACL that allows all traffic increases exposure. Option D is incorrect because launching the DB instance in a public subnet with a public IP address makes it directly reachable from the internet.

1238
MCQmedium

A company's Amazon RDS for Oracle instance is running out of storage space. The database administrator wants to add storage without downtime. Which action should be taken?

A.Delete old archived redo logs to free up space.
B.Take a snapshot and restore to a larger instance.
C.Use the 'Modify DB Instance' action to increase the allocated storage.
D.Create a new DB instance with larger storage and migrate the data.
AnswerC

RDS allows online storage modification.

Why this answer

Amazon RDS allows you to modify allocated storage online using the 'Modify DB Instance' action without significant downtime. Option A is wrong because deleting old archived redo logs can free up space temporarily but does not add storage and may impact point-in-time recovery. Option B is wrong because taking a snapshot and restoring to a larger instance requires downtime during the restore process.

Option D is wrong because creating a new instance and migrating data involves downtime and is more complex than simply modifying storage.

1239
MCQhard

Refer to the exhibit. A developer deploys this CloudFormation template. An application on the EC2 instance cannot connect to the RDS MySQL database. What is the MOST likely cause?

A.The EC2 security group allows inbound MySQL from 0.0.0.0/0 but the RDS security group only allows traffic from the VPC CIDR, which does not include the EC2 security group.
B.The RDS instance has encryption enabled, preventing access from EC2.
C.The RDS instance has DeletionProtection enabled, which blocks connections.
D.The EC2 instance is in a different Availability Zone than the RDS instance.
AnswerA

RDS SG should allow traffic from EC2 SG, not just VPC CIDR.

Why this answer

The RDS security group only allows inbound MySQL traffic from the VPC CIDR (e.g., 10.0.0.0/16), but the EC2 instance's security group is not referenced. Since the EC2 instance's private IP may fall outside that CIDR (e.g., if it uses a different subnet or a public IP), the RDS security group blocks the connection. Security group rules must explicitly reference the EC2 security group ID to allow traffic from that specific instance, not just the VPC CIDR.

Exam trap

The trap here is that candidates assume a VPC CIDR rule in the RDS security group will automatically cover all EC2 instances in the VPC, but they overlook that the EC2 instance's private IP might be outside that CIDR (e.g., due to subnet allocation or NAT) or that security group referencing is required for proper traffic flow.

How to eliminate wrong answers

Option B is wrong because RDS encryption (using AWS KMS) encrypts data at rest and does not affect network connectivity or authentication; it does not block connections from EC2. Option C is wrong because DeletionProtection prevents accidental deletion of the RDS instance, not inbound connections; it has no impact on database connectivity. Option D is wrong because RDS instances and EC2 instances can communicate across Availability Zones within the same VPC without any connectivity issues, as long as security groups and network ACLs permit the traffic.

1240
MCQmedium

A database administrator is troubleshooting an Amazon RDS for SQL Server instance that is experiencing high 'ReadIOPS' and 'ReadLatency'. The instance uses General Purpose SSD (gp2) storage. The 'BurstBalance' metric is 0%. What should the administrator do to improve performance?

A.Enable Multi-AZ to distribute the load
B.Increase the allocated storage or switch to Provisioned IOPS
C.Create a read replica to offload read traffic
D.Disable automatic backups to reduce I/O
AnswerB

Increasing volume size increases baseline IOPS for gp2; switching to io1/io2 provides consistent IOPS.

Why this answer

When BurstBalance is 0%, the gp2 volume has exhausted its burst credits and is operating at baseline IOPS. To improve performance, you can increase the volume size (which increases baseline IOPS) or switch to Provisioned IOPS (io1/io2) for consistent performance. Option A is wrong because enabling Multi-AZ does not increase I/O performance; it provides high availability.

Option C is wrong because creating a read replica offloads read traffic but does not improve write performance or reduce latency on the primary instance. Option D is wrong because disabling automatic backups reduces storage I/O but does not directly improve ReadIOPS or ReadLatency; the primary issue is exhausted burst credits.

1241
MCQhard

A social media analytics company uses Amazon DynamoDB as the primary data store for user session data. Each session record has a partition key of user_id (String) and a sort key of session_start_time (Number, epoch). The application often queries the most recent 10 sessions for a given user. The traffic pattern shows that 90% of reads are for the last 10 sessions, while 10% are for historical sessions. The table has a provisioned read capacity of 5000 RCU and consistently experiences throttled read requests during peak hours. The company wants to optimize read performance without changing the provisioned capacity. Which design change will MOST improve read performance for this workload?

A.Create a Global Secondary Index (GSI) with the same partition key and a sort key of session_start_time, but query with ScanIndexForward=false and Limit=10.
B.Increase the provisioned read capacity to 10000 RCU to handle the peak load.
C.Enable DynamoDB Accelerator (DAX) with default settings to cache the most recent sessions.
D.Configure Amazon ElastiCache for Redis as a read-through cache for session data.
AnswerA

A GSI with the sort key reversed allows efficient retrieval of recent sessions using a single Query with ScanIndexForward=false and Limit=10.

Why this answer

Creating a GSI with the same partition key (user_id) and sort key (session_start_time) allows you to query with ScanIndexForward=false and Limit=10 to efficiently retrieve only the most recent 10 sessions per user. This avoids scanning all sessions for a user, reducing consumed read capacity and eliminating throttling without increasing provisioned RCU. The GSI also supports the 90% workload pattern by providing a targeted index that minimizes read unit consumption.

Exam trap

The trap here is that candidates often assume caching (DAX or ElastiCache) is the best solution for read-heavy workloads, but in this scenario the inefficiency is due to querying the base table without an index that supports efficient retrieval of the last N items, so a GSI with reversed sort order directly reduces read consumption without adding cache management overhead.

How to eliminate wrong answers

Option B is wrong because increasing provisioned read capacity to 10000 RCU does not optimize read performance; it only increases capacity, which contradicts the requirement to not change provisioned capacity and does not address the root cause of inefficient queries. Option C is wrong because enabling DAX with default settings caches hot items but does not reduce the read capacity consumed per query; the underlying table still uses the same number of read units for each query, and DAX does not change the query pattern to avoid full scans. Option D is wrong because configuring ElastiCache for Redis as a read-through cache adds complexity and latency for cache misses, and does not reduce the read capacity consumption on DynamoDB for the frequent last-10-sessions queries; it also does not address the inefficient scan pattern on the base table.

1242
MCQeasy

A company wants to centrally manage database user credentials and rotate them automatically. The database is an Amazon RDS for MySQL instance. Which AWS service should be used?

A.AWS Secrets Manager
B.AWS CloudHSM
C.AWS Identity and Access Management (IAM)
D.AWS Systems Manager Parameter Store
AnswerA

Correct. AWS Secrets Manager provides centralized management and automatic rotation of RDS MySQL credentials.

Why this answer

AWS Secrets Manager (option A) is the correct service because it is designed to centrally manage database credentials and can automatically rotate them for Amazon RDS for MySQL instances on a schedule you define. Option B (AWS CloudHSM) provides hardware security modules for cryptographic key storage, not credential management or rotation. Option C (IAM) is used for controlling access to AWS resources and supports IAM database authentication for RDS, but it does not manage database user passwords or provide automatic rotation of those passwords.

Option D (AWS Systems Manager Parameter Store) can store secrets securely, but it does not offer native automatic rotation of RDS database credentials; that functionality requires Secrets Manager.

Exam trap

A common trap is to choose IAM (option C) because IAM database authentication allows database access without passwords. However, the requirement is to manage database user credentials and rotate them automatically, which is a core feature of Secrets Manager, not IAM.

1243
Multi-Selectmedium

Which TWO of the following are valid methods to control network access to an Amazon RDS DB instance? (Select TWO.)

Select 2 answers
A.VPC security groups
B.DB subnet groups
C.AWS WAF
D.IAM policies
E.DB parameter groups
AnswersA, B

Security groups act as a virtual firewall for your DB instance to control inbound and outbound traffic.

Why this answer

A and B are correct. VPC security groups (A) act as a virtual firewall to control inbound and outbound traffic to the RDS instance at the network level. DB subnet groups (B) determine which subnets the RDS instance can be deployed in, effectively controlling network access by restricting the IP ranges that can reach the instance.

AWS WAF (C) is a web application firewall for HTTP/HTTPS traffic, not for network-level RDS access. IAM policies (D) control API-level permissions, not network traffic. DB parameter groups (E) manage database engine configuration settings and do not affect network access.

1244
Multi-Selectmedium

A company is migrating its Oracle database to Amazon RDS for Oracle. The security team requires that all data be encrypted at rest using a customer-managed AWS KMS key. Which TWO steps are necessary to achieve this?

Select 2 answers
A.Migrate the data using Oracle Data Pump to the new encrypted instance.
B.Modify the DB instance to enable encryption using a KMS key.
C.Create a new DB instance and specify the KMS key for encryption.
D.Enable encryption at rest on the existing RDS instance by modifying the DB instance.
E.Use the default RDS encryption key (aws/rds) to encrypt the instance.
AnswersA, C

Data must be migrated to the new encrypted instance.

Why this answer

To enable encryption at rest with a customer-managed KMS key in Amazon RDS for Oracle, you must create a new DB instance and specify the KMS key for encryption (Option C). Encryption cannot be enabled on an existing RDS instance without migrating to a new encrypted instance (Options B and D are incorrect). After creating the encrypted instance, you can migrate the Oracle database using Oracle Data Pump to the new encrypted instance (Option A).

Using the default RDS encryption key (Option E) does not meet the requirement of a customer-managed key. Therefore, the two necessary steps are A and C.

1245
MCQhard

A company uses Amazon RDS for MySQL with read replicas. The application writes to the primary and reads from the replicas. Occasionally, the application reads stale data from the replicas. Which action would ensure read-after-write consistency without impacting write performance?

A.Set the replica_read_consistency parameter to 'session'.
B.Use the reader endpoint and increase the replica lag threshold.
C.Configure the application to read from the primary instance for critical queries.
D.Enable the 'rds_set_replication_status' parameter on the read replicas.
AnswerC

Reading from primary guarantees consistency.

Why this answer

Using the primary instance for reads that require consistency ensures the application reads the latest data. Session-level replication checks are not supported in standard MySQL.

1246
MCQeasy

A company has an Amazon DynamoDB table with on-demand capacity mode. The table is used by a serverless application. The company wants to receive an alert when the read request rate exceeds a certain threshold. Which CloudWatch metric and alarm should be used?

A.Alarm on the 'ConsumedReadCapacityUnits' metric.
B.Alarm on the 'ReadThrottleEvents' metric.
C.Alarm on the 'ProvisionedReadCapacityUnits' metric.
D.Alarm on the 'SuccessfulRequestLatency' metric.
AnswerA

This metric shows actual read usage.

Why this answer

The 'ConsumedReadCapacityUnits' metric reflects the actual number of read capacity units consumed by the table. By setting an alarm on this metric, you can trigger an alert when the read request rate exceeds a defined threshold, which is appropriate for an on-demand table where capacity scales automatically but you still want to monitor usage.

Exam trap

The trap here is that candidates often confuse throttling events (ReadThrottleEvents) with actual consumption, but the question asks for an alert when the read request rate exceeds a threshold, which requires monitoring consumption, not throttling.

How to eliminate wrong answers

Option B is wrong because 'ReadThrottleEvents' measures throttled read requests, not the request rate itself; it would only alert after throttling occurs, not before exceeding a threshold. Option C is wrong because 'ProvisionedReadCapacityUnits' is only applicable to provisioned capacity mode, not on-demand mode, and would always be zero or irrelevant. Option D is wrong because 'SuccessfulRequestLatency' measures response time, not request rate, and is not suitable for alerting on throughput thresholds.

1247
Multi-Selectmedium

A security engineer is designing a disaster recovery plan for an Amazon DynamoDB table that contains sensitive data. The table is encrypted using an AWS KMS customer managed key (CMK). The engineer needs to ensure that the table can be restored in a different AWS Region. Which TWO actions must be taken to enable cross-region restores with the same encryption? (Choose TWO.)

Select 2 answers
A.Enable point-in-time recovery (PITR) on the table.
B.Enable DynamoDB global tables.
C.Export the table to S3 and copy the S3 objects to the destination Region.
D.Create a multi-Region KMS key in the source and replicate it to the destination Region.
E.Create a CloudHSM key and use it for encryption.
AnswersA, D

PITR is required for cross-region restores.

Why this answer

To enable cross-region restores of an encrypted DynamoDB table, you need to have the table's backups available in the destination region. Cross-region restores require point-in-time recovery (PITR) to be enabled on the source table (Option A). Additionally, because the table uses a customer managed KMS key, you must create a multi-Region KMS key (or replicate the key) in the destination region so that DynamoDB can use it to decrypt the backup during restore (Option D).

Option B (global tables) is for live replication, not for backup/restore scenarios. Option C (export to S3 and copy) does not preserve the same encryption because the exported data is not encrypted with the KMS key. Option E (CloudHSM) is not supported for DynamoDB encryption.

1248
MCQeasy

A developer runs the command `aws rds describe-db-instances --db-instance-identifier mydb` and gets the output containing `Source_Region: us-east-1` and `Replica_Mode: async`. Which conclusion can be drawn about the database configuration?

A.The database is a Multi-AZ read replica
B.The database engine is Aurora MySQL
C.The database is a primary instance in a Multi-AZ deployment
D.The database is a read replica of another instance
AnswerD

ReadReplicaSourceDBInstanceIdentifier indicates it is a replica.

Why this answer

The output from the describe-db-instances command indicates that this database is configured as a read replica. Read replicas in Amazon RDS are identified by the presence of a source region and asynchronous replication mode, which are characteristic of read replica configurations. Multi-AZ deployments use synchronous replication and do not expose these fields, making option D the only viable conclusion.

Exam trap

The trap here is that candidates confuse Multi-AZ standby instances with read replicas, but Multi-AZ uses synchronous replication and does not expose `Source_Region` or `Replica_Mode`, whereas read replicas use asynchronous replication and always show these fields.

How to eliminate wrong answers

Option A is wrong because Multi-AZ read replicas do not exist; Multi-AZ is a high-availability feature for primary instances, not a replica configuration. Option B is wrong because the output does not show any Aurora-specific fields such as `DBClusterIdentifier` or `Engine: aurora-mysql`, and the presence of `Replica_Mode: async` is common to both RDS MySQL and Aurora read replicas, but the lack of cluster context makes Aurora unlikely. Option C is wrong because a primary instance in a Multi-AZ deployment would not have `Source_Region` or `Replica_Mode` fields; those are exclusive to read replicas.

1249
MCQmedium

A media company stores video metadata in Amazon DynamoDB. Each record has a partition key of video_id and a sort key of uploaded_timestamp. The application frequently queries videos by genre and upload date. The access pattern is read-heavy with occasional writes. The table is provisioned with 3000 RCUs and 1000 WCUs. The company notices that queries by genre are slow and consume many RCUs. Which design change should be made to optimize for this workload?

A.Use DynamoDB Accelerator (DAX) to cache query results.
B.Create a local secondary index (LSI) with genre as sort key and uploaded_timestamp as partition key.
C.Increase the provisioned RCUs to 6000.
D.Create a global secondary index (GSI) with genre as partition key and uploaded_timestamp as sort key.
AnswerD

A GSI with genre as partition key allows efficient queries by genre and date.

Why this answer

Creating a Global Secondary Index (GSI) with genre as the partition key and uploaded_timestamp as the sort key allows efficient querying by genre and date without scanning the entire table. This directly supports the access pattern, reducing RCU consumption by using index key lookups instead of full table scans. The GSI is ideal for read-heavy workloads with occasional writes, as it offloads query traffic from the main table.

Exam trap

The trap here is that candidates may confuse LSIs and GSIs, incorrectly assuming an LSI can change the partition key, when in fact LSIs must share the main table's partition key, making them unsuitable for querying by a different attribute like genre.

How to eliminate wrong answers

Option A is wrong because DAX caches query results to reduce latency and RCU consumption, but it does not address the root cause of slow queries by genre—the lack of an appropriate index for that access pattern; DAX would still require expensive scans on cache misses. Option B is wrong because a Local Secondary Index (LSI) must have the same partition key as the main table (video_id), so it cannot support queries by genre as the partition key; using genre as sort key with video_id as partition key would not enable efficient genre-based queries. Option C is wrong because increasing RCUs to 6000 only adds more read capacity without fixing the inefficient query pattern; it would increase cost without resolving the underlying design issue of scanning the entire table for genre queries.

1250
MCQmedium

An application uses an Amazon RDS for MySQL database. The security team requires that all traffic to the database be encrypted in transit. Which configuration ensures this?

A.Use the default RDS parameter group.
B.Create a custom DB parameter group with the require_secure_transport parameter set to ON.
C.Configure the security group to allow only port 3306 from the application.
D.Use a network ACL to restrict inbound traffic to port 3306.
AnswerB

Setting require_secure_transport to ON enforces encrypted connections.

Why this answer

Setting require_secure_transport to ON in a custom DB parameter group enforces SSL/TLS for all connections to the RDS MySQL database, ensuring encryption in transit. Option A is wrong because the default parameter group does not enforce SSL. Option C is wrong because security groups control network access at the port level, not encryption.

Option D is wrong because network ACLs are stateless and do not enforce encryption.

1251
Multi-Selecteasy

A company wants to store session state for a web application that runs on Amazon EC2 instances behind an Application Load Balancer. The session data is ephemeral and must be highly available. Which two AWS services are suitable for this use case? (Choose two.)

Select 2 answers
A.Amazon DynamoDB
B.Amazon ElastiCache for Redis with replication
C.Amazon Redshift
D.Amazon S3
E.Amazon RDS for MySQL
AnswersA, B

Fast, scalable, and highly available key-value store.

Why this answer

Amazon DynamoDB is a fully managed, serverless NoSQL key-value and document database that offers single-digit millisecond latency at any scale. It is ideal for storing ephemeral session state because it provides built-in high availability and durability by replicating data across multiple Availability Zones (AZs) automatically, without requiring manual failover or replication configuration.

Exam trap

The trap here is that candidates often choose Amazon S3 for its durability and low cost, overlooking its eventual consistency model and higher latency, which are unsuitable for real-time session state; or they pick Amazon RDS for MySQL assuming relational databases are always the safest choice, ignoring the overhead and lack of native TTL/expiration features for ephemeral data.

1252
MCQhard

A company runs a critical Amazon RDS for PostgreSQL database. They notice that the 'DiskQueueDepth' metric is consistently high and the 'FreeStorageSpace' is below 10%. The database is used for OLTP workloads. What is the MOST immediate action to take?

A.Upgrade to a larger DB instance class.
B.Modify the DB instance to increase allocated storage.
C.Switch the instance to Provisioned IOPS storage.
D.Create a read replica to offload read traffic.
AnswerB

Increasing storage immediately addresses the low free space and can reduce disk queue depth by allowing more I/O operations.

Why this answer

Increasing allocated storage quickly addresses the low free storage space (below 10%) and high DiskQueueDepth, which indicates I/O bottlenecks due to insufficient storage. Option A is wrong because upgrading to a larger instance class improves memory and CPU but does not directly resolve storage shortage or I/O throttling caused by low disk space. Option C is wrong because switching to Provisioned IOPS improves latency and throughput but does not increase storage capacity.

Option D is wrong because creating a read replica offloads read traffic but does not increase storage on the primary instance.

1253
MCQmedium

An Amazon RDS for Oracle DB instance is experiencing high swap usage. The database administrator wants to reduce swap usage. Which action should be taken?

A.Change the storage type from gp2 to io1
B.Increase the DB instance class to a larger size with more memory
C.Delete archived redo logs to free up space
D.Enable Multi-AZ to distribute the load
AnswerB

More memory reduces the need for swap.

Why this answer

High swap usage on an Amazon RDS for Oracle DB instance indicates that the operating system is using disk-based swap space as a substitute for physical RAM, which severely degrades database performance. Increasing the DB instance class to a larger size with more memory directly addresses the root cause by providing additional RAM, reducing or eliminating the need for swapping. This is the correct action because swap usage is a memory pressure issue, not a storage or availability problem.

Exam trap

The trap here is that candidates confuse high swap usage with a storage performance or availability issue, leading them to choose storage type changes or Multi-AZ, when the real solution is to address insufficient memory by scaling the instance class.

How to eliminate wrong answers

Option A is wrong because changing the storage type from gp2 to io1 improves I/O performance and latency but does not increase the amount of available RAM, so it cannot reduce swap usage. Option C is wrong because deleting archived redo logs frees up storage space in the recovery area, not memory; swap usage is unrelated to log retention or disk space. Option D is wrong because enabling Multi-AZ provides high availability and automatic failover by replicating data to a standby instance, but it does not distribute memory load or reduce swap usage on the primary instance.

1254
MCQeasy

Refer to the exhibit. A database specialist is taking a final snapshot of an RDS DB instance before deletion. The command returns the output shown. The snapshot is at 75% progress. What should the specialist do next?

A.Use the describe-db-snapshots command with --db-snapshot-identifier to get more details.
B.Use the stop-db-instance command to pause the snapshot.
C.Wait for the snapshot status to become 'available' before deleting the instance.
D.Delete the DB instance immediately; the snapshot will continue in the background.
AnswerC

Snapshot must be available before deletion to ensure completeness.

Why this answer

An RDS DB instance cannot be deleted while a final snapshot is in progress; the snapshot must reach the 'available' status first. The AWS CLI output shows the snapshot at 75% progress, meaning the snapshot is still being created. Attempting to delete the instance before the snapshot completes will result in an error, as the deletion operation requires the snapshot to be fully available.

Exam trap

The trap here is that candidates may assume the snapshot continues independently after instance deletion (Option D), but AWS RDS enforces that the instance cannot be deleted until the final snapshot is fully available, preventing data loss.

How to eliminate wrong answers

Option A is wrong because the describe-db-snapshots command with --db-snapshot-identifier would only return the same progress information already shown; it does not change the snapshot status or allow deletion. Option B is wrong because the stop-db-instance command is used to stop a running DB instance, not to pause a snapshot; snapshots are atomic operations that cannot be paused once started. Option D is wrong because deleting the DB instance immediately while the snapshot is in progress will cause the deletion to fail; the snapshot does not continue in the background after instance deletion — the snapshot creation is tied to the instance lifecycle.

1255
MCQmedium

A company needs to store and manage user sessions for a web application. The application runs on multiple EC2 instances, and sessions must be accessible from any instance. The team wants a fully managed, highly available, and low-latency solution. Which AWS service should they use?

A.Amazon RDS for MySQL
B.Amazon ElastiCache for Redis
C.Amazon DynamoDB
D.Amazon S3
AnswerB

Redis is ideal for session storage with low latency and high availability.

Why this answer

Amazon ElastiCache for Redis is the correct choice because it provides a fully managed, in-memory data store with sub-millisecond latency, making it ideal for storing user session data that must be accessed from any EC2 instance. Redis supports atomic operations and data structures (e.g., TTL-based key expiration) that are well-suited for session management, and its replication and Multi-AZ failover ensure high availability. This meets the requirement for a fully managed, highly available, and low-latency solution without the overhead of managing a database cluster.

Exam trap

The trap here is that candidates often choose Amazon DynamoDB because it is fully managed and highly available, but they overlook the specific requirement for 'low-latency' (sub-millisecond) that only an in-memory cache like ElastiCache for Redis can provide, and they miss that DynamoDB's latency is higher due to disk I/O and consistency models.

How to eliminate wrong answers

Option A is wrong because Amazon RDS for MySQL is a relational database with disk-based storage, which introduces higher latency for session lookups compared to an in-memory store, and it requires more operational overhead for scaling and failover. Option C is wrong because Amazon DynamoDB is a NoSQL database that, while fully managed and highly available, has higher read/write latency (typically single-digit milliseconds) compared to ElastiCache for Redis (sub-millisecond), and it is not optimized for ephemeral session data with automatic TTL expiration as efficiently as Redis. Option D is wrong because Amazon S3 is an object storage service with high latency (often tens to hundreds of milliseconds) and is not designed for frequent, low-latency read/write operations required for user sessions; it also lacks native session management features like atomic operations or TTL.

1256
MCQhard

A company is deploying a new Amazon DynamoDB table with global tables for a multi-region application. The application requires strongly consistent reads in the primary region and eventual consistency in secondary regions. Which write strategy should they use?

A.Use conditional writes to ensure consistency
B.Use DynamoDB global tables with last writer wins (LWW) conflict resolution
C.Use DynamoDB Streams to replicate writes to secondary regions
D.Use DynamoDB transactions across regions
AnswerB

LWW provides eventual consistency across regions; strong read in primary region is supported.

Why this answer

DynamoDB global tables use last writer wins (LWW) conflict resolution based on the timestamp in the update, which automatically handles concurrent writes across regions. This strategy satisfies the requirement for strongly consistent reads in the primary region and eventual consistency in secondary regions, as global tables replicate data asynchronously and LWW ensures convergence without additional application logic.

Exam trap

The trap here is that candidates often confuse conditional writes or transactions with cross-region consistency mechanisms, not realizing that DynamoDB global tables inherently use LWW and do not support strongly consistent reads across regions.

How to eliminate wrong answers

Option A is wrong because conditional writes are used for optimistic locking or idempotency within a single table, not for cross-region conflict resolution or consistency management in global tables. Option C is wrong because DynamoDB Streams can capture changes but require custom replication logic (e.g., via Lambda) to write to another region, which is not a built-in write strategy for global tables and adds complexity without inherent conflict resolution. Option D is wrong because DynamoDB transactions are limited to a single region and cannot span across regions, making them unsuitable for multi-region write strategies.

1257
MCQhard

The exhibit shows an IAM policy attached to a user. The user needs to create a manual snapshot of an RDS DB instance named 'production-db'. Which action will the user be able to perform?

A.Create a manual snapshot of 'production-db' with the name 'production-db-snapshot'.
B.Create a manual snapshot of 'production-db' with the name 'mydb-production-snapshot'.
C.Describe the 'production-db' DB instance.
D.Delete the 'production-db' DB instance.
AnswerB

The snapshot name starts with 'mydb-', matching the allowed resource pattern.

Why this answer

The IAM policy allows CreateDBSnapshot only on DB instances with names starting with 'mydb-', and the snapshot name must also match the pattern 'mydb-*'. The snapshot name 'mydb-production-snapshot' satisfies that pattern. Option A is wrong because 'production-db-snapshot' does not start with 'mydb-'.

Option C is wrong because the question asks about creating a snapshot, not describing instances. Option D is wrong because the policy does not grant DeleteDBInstance permission.

1258
MCQhard

A company runs a production Amazon RDS for MySQL DB instance with Multi-AZ. The database is used by a web application. The application team reports that the database is experiencing intermittent connection timeouts and increased latency. The CloudWatch metrics show that the database connections spike to the maximum allowed (max_connections) during peak hours, and the CPU utilization is high. The team needs to resolve the connection issues without modifying the application code. The application uses connection pooling at the application layer. Which action should be taken?

A.Create a read replica and direct read queries to it.
B.Deploy an Amazon RDS Proxy in front of the DB instance.
C.Increase the 'max_connections' parameter to allow more connections.
D.Change the DB instance class to a smaller size to reduce the maximum connections.
AnswerB

Amazon RDS Proxy efficiently manages connection pooling, reducing the number of connections to the database and lowering CPU overhead, thus resolving connection timeouts without code changes.

Why this answer

RDS Proxy manages connection pooling efficiently, reducing the number of connections to the database and lowering CPU overhead. Option A is wrong because read replicas do not reduce write connection load. Option C is wrong because increasing max_connections may lead to resource exhaustion.

Option D is wrong because switching to a smaller instance would worsen the problem.

1259
Multi-Selecthard

A company is migrating an on-premises Oracle database to Amazon RDS for Oracle. The database is 2 TB in size and has a tight migration window of 8 hours. Which THREE steps should be taken to minimize downtime during the migration?

Select 3 answers
A.Take a manual snapshot of the source database before migration.
B.Use AWS Schema Conversion Tool (AWS SCT) to convert the schema.
C.Use AWS Database Migration Service (AWS DMS) with ongoing replication.
D.Disable automated backups on the target RDS instance during migration.
E.Deploy a large RDS instance class to speed up the initial load.
AnswersC, D, E

Correct. AWS Database Migration Service (AWS DMS) with ongoing replication allows continuous replication from source to target, minimizing downtime during the final cutover.

Why this answer

AWS DMS with ongoing replication (option C) allows continuous data replication from the source to the target, minimizing downtime during the final cutover. Disabling automated backups on the target RDS instance (option D) reduces I/O overhead and speeds up the migration process. Deploying a large RDS instance class (option E) provides higher network and disk throughput, accelerating the initial data load.

Option A is incorrect because a manual snapshot is not used for migration, and option B is incorrect because AWS SCT is for schema conversion, not data replication.

1260
MCQeasy

A developer executed a DELETE statement without a WHERE clause on an Amazon RDS for PostgreSQL instance. The transaction is still open. Which action should the developer take to undo the DELETE without affecting other operations?

A.Execute COMMIT and then run a recovery script.
B.Use the Point-in-Time Recovery feature to restore the database to a time before the DELETE.
C.Execute ROLLBACK in the same session.
D.Stop the DB instance and restore from the latest snapshot.
AnswerC

ROLLBACK undoes all changes made in the current transaction.

Why this answer

The correct action is to execute ROLLBACK in the same session. Since the transaction is still open, issuing ROLLBACK will undo the DELETE statement without affecting other operations. Option A is incorrect because COMMIT would make the DELETE permanent.

Option B is incorrect because Point-in-Time Recovery restores the entire DB instance to a past state, which is unnecessary and affects other data. Option D is incorrect because stopping and restoring from a snapshot would also affect other data and is not the simplest solution.

1261
MCQmedium

A company is migrating an on-premises PostgreSQL database to Amazon RDS for PostgreSQL. The database currently uses a custom extension that is not supported by RDS. The application relies heavily on this extension for advanced statistical analysis. Which design approach should the company take to minimize application changes?

A.Migrate to PostgreSQL on Amazon EC2 and install the custom extension.
B.Migrate to Amazon DynamoDB and implement statistical analysis using DynamoDB streams and Lambda.
C.Migrate to Amazon RDS for PostgreSQL and install the custom extension on the RDS instance.
D.Migrate to Amazon RDS for PostgreSQL and implement the extension's functionality using AWS Lambda functions called via triggers.
AnswerD

Lambda can replicate the extension's behavior without modifying the application.

Why this answer

It allows the company to offload the unsupported custom extension's statistical analysis logic to AWS Lambda functions, which can be invoked via RDS PostgreSQL triggers. This approach minimizes application changes by keeping the database schema and query patterns largely intact, while the Lambda functions handle the advanced computations externally. RDS does not allow custom extensions, so this pattern leverages RDS for PostgreSQL's native trigger support to integrate with Lambda without modifying the application's core database interactions.

Exam trap

The trap here is that candidates assume RDS for PostgreSQL supports all PostgreSQL extensions, but AWS explicitly restricts custom extensions, making Option C a common distractor that seems plausible but is technically impossible.

How to eliminate wrong answers

Option A is wrong because migrating to PostgreSQL on Amazon EC2, while allowing custom extensions, requires significant operational overhead for patching, backups, and high availability, and does not minimize application changes more than the trigger-based approach. Option B is wrong because migrating to Amazon DynamoDB would require a complete rewrite of the application's data access layer and statistical analysis logic, as DynamoDB is a NoSQL key-value and document database with a different query model and no native support for PostgreSQL extensions. Option C is wrong because Amazon RDS for PostgreSQL does not allow installation of custom extensions; only AWS-provided extensions are supported, so this option is technically infeasible.

1262
MCQhard

A company is using Amazon DynamoDB with a global table that replicates data across two AWS Regions. The security team requires that all data be encrypted at rest with a customer-managed AWS KMS key. How should the company configure the KMS keys to meet this requirement?

A.Create a single KMS key in the primary region and use it for both replicas.
B.Use AWS managed encryption as DynamoDB does not support customer managed KMS keys for global tables.
C.Create a separate KMS key in each region and assign each replica table its regional KMS key.
D.Create a multi-Region KMS key and use it for both replicas.
AnswerC

Each replica table can use its own regional KMS key.

Why this answer

For DynamoDB global tables, each replica table can use a different KMS key. You must create a KMS key in each region and configure the table to use the regional key. Option A is incorrect because a single KMS key cannot be used across regions; KMS keys are region-specific.

Option B is incorrect because using the same key across regions is not possible. Option D is incorrect because DynamoDB global tables support encryption with customer managed keys.

1263
Multi-Selecteasy

Which TWO AWS services can be used to monitor and alert on suspicious database access patterns in Amazon RDS? (Choose 2.)

Select 2 answers
A.Amazon Inspector
B.Amazon CloudWatch
C.AWS Trusted Advisor
D.AWS Config
E.Amazon GuardDuty
AnswersB, E

Amazon CloudWatch monitors RDS metrics and logs, and can trigger alarms based on suspicious access patterns (e.g., failed authentication attempts).

Why this answer

The correct answers are Amazon CloudWatch (B) and Amazon GuardDuty (E). Amazon CloudWatch can monitor RDS metrics and create alarms based on access patterns like failed login attempts. Amazon GuardDuty is a threat detection service that uses machine learning to identify suspicious database access activity.

Option A (Amazon Inspector) is for vulnerability assessment, not monitoring access patterns. Option C (AWS Trusted Advisor) provides best practice checks and recommendations. Option D (AWS Config) is for resource configuration tracking and compliance.

1264
Multi-Selecthard

A company is moving a large-scale time-series application from Cassandra to a managed AWS service. The workload involves high-frequency writes (millions per second) and queries that aggregate data over time windows. Which THREE AWS services are suitable for this time-series workload?

Select 3 answers
A.Amazon OpenSearch Service
B.Amazon Aurora
C.Amazon DynamoDB
D.Amazon Timestream
E.Amazon Redshift
AnswersA, C, D

Supports time-series ingestion and aggregation.

Why this answer

Amazon OpenSearch Service is suitable because it supports high-frequency writes via bulk indexing and provides powerful aggregation queries (e.g., date histograms, percentiles) over time windows, making it ideal for time-series analytics. It can ingest millions of events per second when properly scaled with optimized shard strategies and using the OpenSearch ingest pipeline.

Exam trap

The trap here is that candidates often choose Amazon Redshift for time-series analytics due to its columnar storage, overlooking its high write latency and lack of support for real-time, high-frequency ingestion at millions of writes per second.

1265
Multi-Selecthard

A company is using Amazon RDS for MySQL to host a web application. The security team has identified that the application is vulnerable to SQL injection attacks. The team wants to implement a defense-in-depth strategy to protect the database. Which THREE measures should be taken to mitigate SQL injection risks?

Select 3 answers
A.Grant the minimum required permissions to the database user used by the application.
B.Move all SQL logic into stored procedures.
C.Use parameterized queries or prepared statements in the application code.
D.Enable encryption at rest for the RDS instance.
E.Deploy AWS WAF in front of the web application to filter malicious requests.
AnswersA, C, E

Least privilege limits damage if injection occurs.

Why this answer

Options A, C, and E are correct. Parameterized queries (C) prevent SQL injection by separating SQL logic from data. Least privilege (A) reduces the impact if injection occurs.

AWS WAF (E) provides a web application firewall to filter malicious input before it reaches the database. Option B is incorrect because stored procedures alone do not prevent SQL injection unless they use parameterized queries. Option D is incorrect because encryption at rest protects data at rest but does not prevent SQL injection.

1266
MCQhard

A company is running an Amazon DynamoDB table with provisioned capacity. The table has a partition key of 'user_id' and a sort key of 'timestamp'. The application performs frequent Query operations using the partition key and a range of sort keys. Recently, the 'ThrottledRequests' metric has spiked. The read and write capacity units are consistently at 80% utilization. What is the most effective way to resolve the throttling?

A.Increase the provisioned read and write capacity units
B.Add a global secondary index with a different partition key
C.Change the partition key to a more uniformly distributed attribute
D.Enable DynamoDB Auto Scaling with a higher target utilization
AnswerC

Correct: Redesigning the partition key to be more uniform evenly distributes the workload, directly addressing the root cause of throttling.

Why this answer

The throttling is likely due to uneven access patterns creating hot partitions. By changing the partition key to a more uniformly distributed attribute, the load is spread evenly across partitions, reducing throttling without needing to increase capacity. Option D is incorrect because enabling Auto Scaling with a higher target utilization delays scaling and can worsen throttling on hot partitions; it does not address the root cause.

Option A is incorrect because increasing capacity may not help if a hot partition is throttled, and it increases costs. Option B is incorrect because adding a GSI does not reduce throttling on the base table; it only provides an alternative access pattern.

Exam trap

Auto Scaling with a higher target utilization seems like a quick fix but actually makes hot partition problems worse by allowing higher utilization before scaling.

1267
MCQeasy

Refer to the exhibit. An IAM policy allows creation of a DMS replication task only if the source database engine is Oracle. A user attempts to create a replication task with a MySQL source. What will happen?

A.The action will fail with an error because the policy is malformed.
B.The action will succeed but the task will fail later.
C.The action will be allowed because the resource is '*'.
D.The action will be denied because the condition does not match.
AnswerD

Condition fails for MySQL.

Why this answer

The IAM policy includes a condition that requires the source engine to be Oracle. When the user attempts to create a DMS replication task with a MySQL source, the condition fails, and IAM denies the action by default. The explicit deny is not needed; IAM uses an implicit deny when no policy statement allows the action under the given conditions.

Exam trap

The trap here is that candidates assume a wildcard resource ('*') grants blanket permission, overlooking that conditions in the Allow statement must be satisfied for the Allow to take effect, and that IAM's default behavior is to deny any request that does not match an applicable Allow.

How to eliminate wrong answers

Option A is wrong because the policy is not malformed; it uses valid IAM policy syntax with a condition block that correctly references the dms:SourceEngine context key. Option B is wrong because the action will not succeed; IAM evaluates policies before the API call is executed, so the task creation is denied immediately and never reaches DMS. Option C is wrong because the resource being '*' does not override the condition; the condition must be satisfied for the Allow to apply, and since it is not, the action is implicitly denied.

1268
Multi-Selecthard

A company is migrating a 3 TB PostgreSQL database to Amazon Aurora PostgreSQL. The migration must have minimal downtime. Which THREE steps should be taken?

Select 3 answers
A.Disable autovacuum on the Aurora cluster to improve migration performance
B.Use AWS DMS with ongoing replication from the source PostgreSQL database
C.Use AWS Snowball Edge to transfer the data offline
D.Create an Aurora PostgreSQL read replica to offload read traffic during migration
E.Increase the instance class of the Aurora cluster to handle the migration load
AnswersB, D, E

DMS with CDC enables near-zero downtime migration.

Why this answer

AWS DMS with ongoing replication (change data capture, CDC) allows continuous synchronization from the source PostgreSQL database to the target Aurora PostgreSQL cluster, enabling a cutover with minimal downtime. This is the standard approach for live migrations where the source remains fully operational during the transfer.

Exam trap

The trap here is that candidates may assume offline methods like Snowball Edge are faster for large datasets, but the question explicitly requires minimal downtime, making continuous replication the only viable choice.

1269
Multi-Selecthard

Which THREE design patterns can improve the performance of a write-heavy application using Amazon DynamoDB?

Select 3 answers
A.Write sharding by using a composite key with a random suffix to distribute writes across partitions.
B.Enable DynamoDB adaptive capacity to allow a single partition to use more throughput.
C.Create local secondary indexes (LSIs) for all query patterns.
D.Use DynamoDB Accelerator (DAX) to offload read traffic.
E.Increase provisioned write capacity units (WCUs) to the maximum allowed.
AnswersA, B, D

Prevents hot partitions by evenly distributing write traffic.

Why this answer

Write sharding with a random suffix on the partition key distributes writes evenly across multiple partitions, preventing hot partitions. This pattern avoids throttling by ensuring no single partition exceeds its write capacity limit, which is critical for write-heavy workloads in DynamoDB.

Exam trap

The trap here is that candidates may confuse local secondary indexes (LSIs) with global secondary indexes (GSIs) or assume that increasing WCUs alone resolves hot partitions, ignoring DynamoDB's per-partition throughput limits.

1270
Multi-Selecteasy

A company is using Amazon DynamoDB with Auto Scaling enabled. The database specialist notices that write traffic is being throttled occasionally. Which TWO factors could cause throttling despite Auto Scaling?

Select 2 answers
A.The table has Global Tables enabled, causing cross-region replication overhead.
B.Auto Scaling is not configured to scale up quickly enough for sudden traffic spikes.
C.DynamoDB Accelerator (DAX) is not caching write operations.
D.The write traffic exceeds the maximum provisioned capacity that was set for Auto Scaling.
E.A hot partition where a single partition key receives a disproportionate amount of write traffic.
AnswersD, E

Auto Scaling cannot scale beyond the configured maximum.

Why this answer

Auto Scaling in DynamoDB operates within a maximum provisioned capacity ceiling. If write traffic exceeds this configured maximum, Auto Scaling cannot increase capacity further, leading to throttling. The service will return ProvisionedThroughputExceededException for requests that exceed the set maximum.

Exam trap

The trap here is that candidates often assume Auto Scaling eliminates all throttling, but it cannot prevent throttling caused by hot partitions or when traffic exceeds the configured maximum capacity ceiling.

1271
MCQhard

A company is deploying a MongoDB-compatible database using Amazon DocumentDB. The application requires the ability to perform ad-hoc queries on nested fields within documents. Which DocumentDB feature should be enabled to meet this requirement?

A.TTL indexes
B.Indexes on nested fields
C.Transactions
D.Change streams
AnswerB

Indexes allow efficient ad-hoc queries on nested fields.

Why this answer

Amazon DocumentDB supports indexing on nested fields, which allows efficient querying of sub-documents and arrays within documents. By creating indexes on specific nested paths (e.g., "address.city"), the query engine can perform index scans instead of full collection scans, enabling fast ad-hoc queries on nested fields. This feature directly meets the requirement for ad-hoc queries on nested fields.

Exam trap

The trap here is that candidates may confuse indexing features with operational features like TTL or Change streams, assuming any advanced DocumentDB feature can support nested queries, when only explicit indexing on nested fields enables efficient ad-hoc querying on sub-documents.

How to eliminate wrong answers

Option A is wrong because TTL indexes are used to automatically expire documents after a specified time period, not to enable querying on nested fields. Option C is wrong because Transactions provide atomic multi-document operations but do not improve query performance on nested fields. Option D is wrong because Change streams capture real-time data changes (inserts, updates, deletes) for event-driven applications, not for ad-hoc querying of nested fields.

1272
MCQhard

A company is using Amazon DynamoDB Accelerator (DAX) to improve read performance. Recently, the cache hit ratio has dropped significantly. The application uses strongly consistent reads. What is the most likely cause of the low cache hit ratio?

A.The DynamoDB table's write capacity is too low
B.The application is using strongly consistent reads, which bypass the DAX cache
C.The DAX cluster has too few nodes
D.The DAX cluster's TTL is set too low
AnswerB

DAX only caches eventually consistent reads; strongly consistent reads go directly to DynamoDB.

Why this answer

DAX (DynamoDB Accelerator) is designed to cache data for eventually consistent reads only. When an application uses strongly consistent reads, those requests bypass the DAX cache entirely and go directly to DynamoDB, resulting in a low cache hit ratio. Option A is incorrect because low write capacity may cause throttling but does not directly affect the cache hit ratio.

Option C is incorrect because having too few nodes can impact performance and availability, but the primary cause of the drop in cache hits is the consistency model mismatch. Option D is incorrect because while a low TTL can reduce cache effectiveness, the key issue here is that strongly consistent reads never use the cache.

1273
Multi-Selecteasy

A company is migrating an on-premises PostgreSQL database to Amazon RDS for PostgreSQL. The migration must be completed with minimal downtime. Which TWO AWS services should be used together?

Select 2 answers
A.AWS Snowball
B.AWS Database Migration Service (DMS)
C.AWS CloudEndure Migration
D.AWS Schema Conversion Tool (SCT)
E.AWS Direct Connect
AnswersB, D

DMS supports ongoing replication for minimal downtime.

Why this answer

AWS Database Migration Service (DMS) is the correct choice because it supports ongoing replication from an on-premises PostgreSQL source to Amazon RDS for PostgreSQL, enabling near-zero downtime migrations. DMS uses change data capture (CDC) to continuously replicate transactions after an initial full load, allowing the target database to stay synchronized until cutover.

Exam trap

The DBS-C01 exam often tests the misconception that AWS DMS alone is sufficient for a homogeneous migration, but the question requires TWO services, and the trap is that candidates overlook the Schema Conversion Tool (SCT) because they assume no schema changes are needed for PostgreSQL-to-PostgreSQL, ignoring potential incompatibilities with extensions or unsupported features in RDS.

1274
MCQmedium

A company has an Amazon RDS for Oracle DB instance that stores sensitive data. The security team wants to audit all SQL queries that read or modify specific columns containing personally identifiable information (PII). The audit logs must be stored for 5 years. Which solution should the database specialist implement?

A.Use Oracle fine-grained auditing to create an audit policy on the specific columns and store logs in a custom table.
B.Enable database activity streams and send logs to Amazon CloudWatch Logs with a retention of 5 years.
C.Enable RDS Enhanced Monitoring and enable SQL auditing in the parameter group.
D.Enable Oracle Audit Vault and Database Firewall.
AnswerA

Fine-grained auditing allows column-level auditing.

Why this answer

Amazon RDS for Oracle supports fine-grained auditing (FGA) to create audit policies on specific columns, and audit logs can be stored in a custom table with the desired retention period. Option B is incorrect because database activity streams capture all database activities and do not filter by specific columns, and they integrate with CloudWatch Logs where retention must be set separately. Option C is incorrect because RDS Enhanced Monitoring is for OS-level metrics, not SQL auditing.

Option D is incorrect because Oracle Audit Vault and Database Firewall are not supported on Amazon RDS for Oracle.

1275
MCQmedium

A company uses Amazon ElastiCache for Redis to cache frequently accessed data. The cache cluster experiences high CPU utilization during peak hours. The cluster has a single node of type cache.r5.large. What is the most cost-effective way to reduce CPU utilization while maintaining performance?

A.Enable encryption at rest and in transit.
B.Upgrade to a cache.r5.xlarge node type.
C.Add a read replica to distribute read traffic.
D.Increase the maxmemory-policy parameter to 'allkeys-lru'.
AnswerC

Offloads read traffic, reducing CPU on primary.

Why this answer

Adding a read replica distributes read traffic away from the primary node, reducing its CPU utilization. This is more cost-effective than upgrading to a larger instance type (option B) because you can add a smaller replica node. Option A (enabling encryption) does not reduce CPU utilization and adds overhead.

Option D (changing maxmemory-policy) also does not reduce CPU utilization.

Page 16

Page 17 of 23

Page 18