DBS-C01 Management and Operations — Timed 15 Questions

Question 1

A company is running an Amazon RDS for MySQL Multi-AZ DB instance. The primary instance in us-east-1a experiences an unexpected failure. After the automatic failover, the application team reports that write latency has increased significantly. The new primary instance is in us-east-1b. The DB instance class and storage configuration are identical. What is the MOST likely cause of the increased write latency?

Accepted Answer

The application is connecting to the DB instance in a different Availability Zone, increasing network latency.. Option B is correct because after failover, the new primary DB instance resides in us-east-1b, while the application likely continues to connect to the original endpoint or is still running in us-east-1a. This cross-AZ network hop introduces additional latency for write operations, as the application must send data over the network between Availability Zones. The DB instance class and storage are identical, so performance differences are not due to hardware changes.

Answer

The DB instance class in us-east-1b is a different size than the original.

Answer

The Multi-AZ configuration uses asynchronous replication, causing higher latency.

Answer

The new primary is in the same Availability Zone as the application, but the standby is in a different AZ, causing synchronous replication overhead.

Question 2

A database administrator is troubleshooting an Amazon RDS for PostgreSQL DB instance that is experiencing high CPU utilization. The administrator runs the following query to find the current running queries:

SELECT pid, now() - pg_stat_activity.query_start AS duration, query, state
FROM pg_stat_activity
WHERE state = 'active';

The output shows a high number of queries with a state of 'active' and durations exceeding several minutes. What should the administrator do FIRST to reduce CPU utilization?

Accepted Answer

Use pg_terminate_backend to terminate the long-running queries.. Option C is correct because the immediate cause of high CPU utilization is the long-running active queries consuming resources. Using pg_terminate_backend to terminate these queries will quickly free up CPU cycles, providing immediate relief. This is the first troubleshooting step before making configuration changes or scaling, as it directly addresses the symptom shown in the pg_stat_activity output.

Answer

Modify the max_connections parameter to limit concurrent sessions.

Answer

Scale up the DB instance to a larger instance class.

Answer

Enable pg_stat_statements to collect query performance data.

Question 3

A company is using Amazon DynamoDB with on-demand capacity mode. The application experiences occasional throttling during peak hours. The operations team wants to reduce throttling without changing the application code. What should they do?

Accepted Answer

Switch to provisioned capacity mode and configure auto scaling.. Option B is correct because DynamoDB on-demand capacity mode does not allow manual adjustment of capacity units; it scales automatically but can still throttle if traffic exceeds the previous peak by a large margin. Switching to provisioned capacity mode with auto scaling allows you to set a higher minimum capacity and scale proactively based on actual usage patterns, reducing throttling without code changes. This approach gives more control over capacity limits while still automating adjustments.

Answer

Increase the read and write capacity units in the on-demand mode.

Answer

Enable DynamoDB Accelerator (DAX) to cache reads.

Answer

Use DynamoDB global tables to distribute traffic across regions.

Question 4

A company is migrating an on-premises Microsoft SQL Server database to Amazon RDS for SQL Server. The database uses SQL Server Agent jobs, custom CLR assemblies, and cross-database queries. Which of the following will require modification before migration?

Accepted Answer

SQL Server Agent jobs. SQL Server Agent jobs are not supported in Amazon RDS for SQL Server because RDS is a managed service that does not provide access to the underlying operating system or the SQL Server Agent service. To migrate job scheduling, you must use alternatives such as AWS Database Migration Service (DMS) tasks, AWS Lambda, or Amazon RDS for SQL Server native scheduling via stored procedures and Windows Task Scheduler on an EC2 instance.

Answer

Cross-database queries

Answer

Custom CLR assemblies

Answer

Stored procedures that use dynamic SQL

Question 5

A company is using Amazon RDS for MySQL with a cross-Region read replica to support disaster recovery. The primary DB instance is in us-west-2, and the read replica is in us-east-1. The read replica is used for reporting and also serves as a failover target. The operations team notices that the read replica lag is consistently above 10 seconds during peak hours. What should the team do to reduce replica lag?

Accepted Answer

Increase the DB instance class of the read replica.. Increasing the DB instance class of the read replica provides more CPU and memory resources, which allows the replica to apply changes from the binary log more quickly. Cross-Region replication lag is often caused by the replica being unable to keep up with the write rate on the primary, so scaling up the replica directly addresses the bottleneck in applying binlog events.

Answer

Enable Multi-AZ on the primary DB instance.

Answer

Increase the backup retention period for the primary DB instance.

Answer

Disable binary logging (binlog) on the primary DB instance.

Question 6

A company is using an Amazon Aurora MySQL DB cluster. The company wants to implement a backup strategy that supports point-in-time recovery (PITR) with a recovery time objective (RTO) of 15 minutes and a recovery point objective (RPO) of 5 minutes. Which TWO actions should the company take?

Accepted Answer

Configure automated backups with a retention period of at least 5 minutes beyond the current time.. Option A is correct because Aurora automated backups are continuous and incremental, and the retention period must be set to at least 1 day (not 5 minutes) to enable point-in-time recovery (PITR). However, the key insight is that automated backups are always enabled by default with a 1-day retention, and PITR can restore to any point within that retention window, supporting an RPO of 5 minutes as Aurora's backup process captures changes every 5 minutes. Option E is correct because Aurora Backtrack allows you to 'rewind' the cluster to a specific point in time without restoring from a backup, achieving an RTO of 15 minutes or less by directly moving the cluster to a previous state, provided Backtrack is enabled with a backtrack window of at least 5 minutes.

Answer

Create manual snapshots every 5 minutes.

Answer

Enable cross-Region replication for the cluster.

Answer

Enable parallel query for the cluster.

Question 7

A company is running a production Amazon DynamoDB table with on-demand capacity. The table experiences occasional throttling during traffic spikes. The table's partition key is a timestamp, and the workload is write-heavy. The operations team needs to reduce throttling. Which THREE actions should the team take? (Choose three.)

Accepted Answer

Add a random suffix to the partition key to distribute writes evenly.. Option A is correct because adding a random suffix to the timestamp partition key breaks the sequential write pattern, distributing writes evenly across all partitions. This prevents hot partitions, which are the root cause of throttling in a write-heavy workload with a monotonically increasing partition key.

Answer

Increase the read capacity units for the table.

Answer

Enable DynamoDB global tables to distribute write traffic.

Question 8

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?

Accepted Answer

The read replica is in a different AWS Region than the source.. Option D is correct because 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.

Answer

The source DB instance is running a different MySQL version.

Answer

The read replica has Multi-AZ disabled.

Answer

The read replica is using a smaller instance class than the source.

Question 9

An IAM policy is attached to a user who needs to restore an Amazon RDS DB instance from a DB snapshot. The user attempts to restore and receives an 'Access Denied' error. Which missing permission is MOST likely causing the failure?

Accepted Answer

rds:CreateDBInstance. To restore an Amazon RDS DB instance from a DB snapshot, the user must have the `rds:CreateDBInstance` permission. This is because the restore operation internally calls the CreateDBInstance API to create a new DB instance from the specified snapshot. Without this permission, the request fails with an 'Access Denied' error, even if the user has permissions to describe snapshots or instances.

Answer

rds:DescribeDBSnapshots

Answer

rds:DescribeDBInstances

Answer

rds:CreateDBSubnetGroup

Question 10

A company's Amazon RDS for PostgreSQL instance is experiencing high CPU utilization. The DB instance is a db.r5.xlarge with 500 GB of General Purpose SSD (gp2) storage. The application team reports that write-intensive batch jobs are causing latency. The DBA notices that the ReadIOPS metric is low but WriteIOPS is consistently near the instance's maximum. Which action would most effectively reduce write latency?

Accepted Answer

Increase the allocated storage to 1,000 GB to increase baseline IOPS.. The correct answer is B because increasing the allocated storage for a gp2 volume from 500 GB to 1,000 GB doubles the baseline IOPS from 1,500 to 3,000 (gp2 baseline is 3 IOPS per GB). Since the write-intensive workload is hitting the maximum IOPS of the current volume, this increase directly raises the IOPS ceiling, reducing write latency without changing storage type.

Answer

Change the storage type to Provisioned IOPS (io1) with the same IOPS.

Answer

Add a read replica to distribute read traffic.

Answer

Enable Multi-AZ deployment to offload writes to a standby instance.

Question 11

A developer accidentally deleted a critical table from an Amazon RDS for MySQL DB instance. Automated backups are enabled with a retention period of 7 days. The deletion occurred 3 hours ago. What is the fastest way to restore the deleted table without affecting other tables?

Accepted Answer

Perform a point-in-time restore of the DB instance to a time just before the deletion, then export the table.. Option D is correct because point-in-time recovery (PITR) allows you to restore the entire DB instance to any second within the automated backup retention period (7 days). By restoring to a time just before the deletion, you can then extract the deleted table using mysqldump or SELECT INTO OUTFILE, and import it back into the original instance. This is the fastest method because it leverages existing automated backups without requiring a manual snapshot or waiting for a full restore of a large instance.

Answer

Use the RDS Query Editor to run a flashback query that retrieves the deleted data.

Answer

Restore the DB instance from the latest manual snapshot and extract the table.

Answer

Restore the table from the automated backup using the AWS Management Console table-level restore feature.

Question 12

A company runs an Amazon Aurora MySQL database cluster with a primary instance and two Aurora Replicas. The application is experiencing occasional deadlocks on the primary instance during peak hours. The deadlocks cause transaction rollbacks that impact customer experience. Which design change should the company implement to minimize deadlocks?

Accepted Answer

Enable Aurora Auto Scaling for read replicas and offload read-only queries to replicas.. Option A is correct because offloading read-only queries to Aurora Replicas reduces the volume of read-write contention on the primary instance. Deadlocks often arise when concurrent transactions compete for the same resources; by directing read traffic to replicas, the primary handles fewer overlapping transactions, lowering the probability of lock conflicts. Aurora Replicas share the same underlying storage volume and serve read traffic without blocking writes on the primary, making this a targeted solution for deadlock reduction.

Answer

Set the transaction isolation level to READ UNCOMMITTED to avoid locks.

Answer

Configure Multi-AZ deployment to automatically failover during deadlocks.

Answer

Increase the DB instance class size to handle more concurrent transactions.

Question 13

A company is using Amazon DynamoDB for a gaming leaderboard. The table has a partition key of 'game_id' and a sort key of 'score'. The application performs a query to retrieve the top 10 scores for a given game_id. The query uses ScanIndexForward: false and Limit: 10. Recently, the query response time has increased. The table's read capacity is 1000 RCU, and the average item size is 1 KB. Which is the most likely cause of the increased latency?

Accepted Answer

A hot partition on the game_id key is causing throttling for that specific partition.. The increased latency is most likely due to a hot partition on the 'game_id' key. When a specific game_id receives a disproportionate amount of write or read traffic, that single partition can exceed its throughput limits (1/1000th of provisioned RCU per partition), causing throttling and retries that degrade query response time. Even though the query uses ScanIndexForward: false and Limit: 10, the request is still constrained by the partition's capacity, and throttling at the partition level leads to increased latency.

Answer

The table lacks a global secondary index on game_id, causing a full table scan.

Answer

The query is using strongly consistent reads instead of eventually consistent reads.

Answer

The provisioned read capacity is too low for the query pattern.

Question 14

A company is migrating an on-premises Oracle database to Amazon RDS for Oracle. The database is 2 TB and has a high number of small transactions. The company needs to minimize downtime during the migration. Which TWO strategies should be used together? (Choose two.)

Accepted Answer

Use AWS Database Migration Service (DMS) to perform a full load and ongoing replication.. AWS DMS with ongoing replication (CDC) is the correct choice because it allows a full load of the 2 TB database followed by continuous replication of changes, minimizing downtime by keeping the target RDS instance nearly synchronized with the source until cutover. This approach is specifically designed for large databases with high transaction volumes, as it reduces the final outage window to seconds or minutes.

Answer

Use Oracle Data Pump to export the database and import into RDS.

Answer

Set up a VPN connection between on-premises and AWS for direct database link.

Answer

Create a manual snapshot of the RDS instance during the migration.

Question 15

A company is using Amazon ElastiCache for Redis to cache frequently accessed data from an RDS MySQL database. The cache hit ratio is currently 85%. The operations team notices that during traffic spikes, the cache eviction rate increases significantly, and the database CPU utilization spikes. The cache cluster uses a single r6g.large node. Which THREE actions should the team take to improve performance? (Choose three.)

Accepted Answer

Add more shards to the cluster to increase total memory.. Option A is correct because adding more shards to the cluster increases the total available memory, which reduces the frequency of evictions during traffic spikes. With more memory, the cache can store more data without forcing out existing entries, thereby maintaining a higher cache hit ratio and reducing the load on the RDS MySQL database.

Answer

Reduce the time-to-live (TTL) for cached items to free up memory faster.

Answer

Configure the cache to use lazy loading only for write-through operations.