Courseiva

CCNA Db Mgmt Ops Questions

75 of 300 questions · Page 1/4 · Db Mgmt Ops topic · Answers revealed

1
MCQhard

A company is using Amazon DynamoDB with on-demand capacity. The application performs many small writes that are throttled frequently. The company wants to minimize costs while reducing throttling. What should the company do?

A.Increase the write capacity units manually.
B.Use DynamoDB Accelerator (DAX) to cache writes.
C.Switch to provisioned capacity with auto scaling.
D.Use batch writes to combine small writes.
AnswerC

Provisioned with auto scaling can handle predictable patterns and reduce cost vs. on-demand.

Why this answer

DynamoDB on-demand capacity can throttle small writes if the traffic pattern exceeds the table's previous peak traffic, as on-demand capacity scales based on traffic volume but has a per-second burst limit. Switching to provisioned capacity with auto scaling allows you to set a baseline capacity that matches the application's average write throughput, while auto scaling adjusts capacity based on actual usage, reducing throttling without the premium cost of on-demand capacity for predictable workloads.

Exam trap

The trap here is that candidates assume on-demand capacity automatically handles all traffic patterns without throttling, but on-demand throttles when traffic exceeds the table's previous peak, and they may overlook that switching to provisioned capacity with auto scaling provides a cost-effective solution for predictable workloads with frequent small writes.

How to eliminate wrong answers

Option A is wrong because DynamoDB on-demand capacity does not use manual write capacity units; you cannot increase them manually as on-demand scales automatically, and manually setting provisioned capacity would require switching away from on-demand. Option B is wrong because DynamoDB Accelerator (DAX) is an in-memory cache for reads, not writes; it does not reduce write throttling as writes still go directly to DynamoDB. Option D is wrong because batch writes combine multiple write operations into a single API call, which can improve throughput efficiency but does not address the root cause of throttling under on-demand capacity, and the question states the application performs many small writes that are throttled frequently, implying the issue is capacity limits, not write batching.

2
MCQeasy

A company is migrating an on-premises Oracle database to Amazon RDS for Oracle. During the migration, they need to ensure minimal downtime. Which AWS service should be used for the migration?

A.AWS Database Migration Service
B.AWS DataSync
C.Amazon S3 Transfer Acceleration
D.AWS Server Migration Service
AnswerA

DMS supports homogeneous and heterogeneous migrations with minimal downtime.

Why this answer

AWS Database Migration Service (DMS) is the correct choice because it is specifically designed for migrating databases to AWS with minimal downtime. DMS supports homogeneous migrations (e.g., Oracle to Oracle) and heterogeneous migrations (e.g., Oracle to Amazon Aurora), and it can perform continuous replication using change data capture (CDC) to keep the source and target databases synchronized during the migration, allowing you to cut over with only a brief pause.

Exam trap

The trap here is that candidates may confuse AWS DMS with general-purpose data transfer services like DataSync or S3 Transfer Acceleration, not realizing that DMS is the only service that supports live database replication with transaction consistency and minimal downtime.

How to eliminate wrong answers

Option B (AWS DataSync) is wrong because it is designed for moving large amounts of file data (e.g., NFS, SMB shares) to Amazon S3, EFS, or FSx, not for live database replication with transaction consistency. Option C (Amazon S3 Transfer Acceleration) is wrong because it only speeds up uploads to S3 buckets over the internet by using AWS edge locations; it does not handle database schema, data types, or ongoing replication. Option D (AWS Server Migration Service) is wrong because it is used for migrating entire virtual machines (VMs) from on-premises to AWS as Amazon Machine Images (AMIs), not for database-level migration with minimal downtime.

3
MCQmedium

A database administrator is troubleshooting a slow-running query on an Amazon RDS for PostgreSQL DB instance. The query plan shows a sequential scan on a large table. The table has a primary key and an index on the column used in the WHERE clause. Why might the query optimizer choose a sequential scan over an index scan?

A.The query is expected to return a large percentage of rows.
B.The query is a SELECT * without a WHERE clause.
C.The table's statistics are outdated.
D.The index on the column is not being used because it is a composite index with a different column order.
AnswerA

Correct: When the query returns a large percentage of rows, a sequential scan is more efficient than random I/O from an index.

Why this answer

When a query is expected to return a large percentage of rows, a sequential scan is often more efficient than an index scan due to the overhead of random I/O from the index. Option B is wrong because the scenario includes a WHERE clause, so SELECT * without WHERE does not apply. Option C is wrong because outdated statistics could cause the optimizer to choose a sequential scan, but the question asks for a reason the planner might choose sequential scan; outdated stats are a possible cause but not the direct reason given in A.

Option D is wrong because the index order does not automatically force its use; the optimizer decides based on selectivity.

4
Multi-Selecteasy

A company is using Amazon ElastiCache for Redis to cache database query results. The cache cluster is a single node. The application experiences increased latency when the cache misses. Which TWO actions can improve the cache hit ratio?

Select 2 answers
A.Increase the Time-to-Live (TTL) for cached items.
B.Disable persistence to free memory.
C.Decrease the Time-to-Live (TTL) for cached items.
D.Add read replicas to the ElastiCache cluster.
E.Implement lazy loading to populate the cache on read requests.
AnswersA, E

Increasing TTL keeps data in cache longer, reducing cache misses.

Why this answer

Options A and E are correct. Option A: Increasing TTL keeps data in cache longer, reducing cache misses. Option E: Implementing lazy loading populates the cache on read requests, improving hit ratio over time.

Option B is wrong because disabling persistence does not affect cache hit ratio. Option C is wrong because decreasing TTL would increase cache misses. Option D is wrong because adding read replicas improves read throughput but does not improve cache hit ratio.

5
MCQmedium

A social media company runs a large Amazon DynamoDB table (Users) with 10 TB of data. The table uses on-demand capacity. Recently, the application started experiencing occasional ProvisionedThroughputExceeded exceptions during read-heavy periods. The table's read metrics show that consumed read capacity is consistently below 50% of provisioned capacity. The application uses eventually consistent reads. The table has a global secondary index (GSI) on the 'status' attribute. The GSI's read capacity consumption is often at 100% of its provisioned capacity. What is the most likely cause of the throttling?

A.The on-demand capacity mode is not suitable for this workload; switch to provisioned with auto scaling.
B.The base table's read capacity is insufficient despite on-demand mode.
C.The GSI is throttling because its read capacity is not set to on-demand, or the GSI's partition key is causing hot partitions.
D.The application should use strongly consistent reads to reduce throttling.
AnswerC

GSI has its own capacity; if it throttles, base table reads that use the GSI may be throttled.

Why this answer

The GSI has its own read capacity settings. If the GSI is throttled, reads on the base table that require the GSI may also be throttled. Option C is correct because the GSI is likely using provisioned capacity, not on-demand, and its read capacity is often at 100%, causing throttling.

Option A is incorrect because on-demand capacity mode for the base table is not the issue; the issue is the GSI. Option B is incorrect because the base table's read capacity is not the bottleneck (consumed read capacity is below 50%). Option D is incorrect because using strongly consistent reads would increase read consumption, not reduce throttling.

6
Multi-Selectmedium

A company is running an Amazon RDS for MySQL DB instance with Multi-AZ. The company wants to perform a major version upgrade with minimal downtime. Which TWO actions should be taken? (Choose TWO.)

Select 2 answers
A.Use the AWS CLI to modify the DB instance with the --allow-major-version-upgrade flag.
B.Use the AWS Management Console to modify the DB instance and apply the upgrade immediately.
C.Enable automatic minor version upgrades on the DB instance.
D.Create a read replica, upgrade the replica to the new version, and promote it to become the primary.
E.Take a snapshot and restore to the new version.
AnswersB, D

For Multi-AZ, this performs the upgrade on the standby first, then fails over, minimizing downtime.

Why this answer

The correct answers are B and D. Option B: Using the AWS Management Console to modify the DB instance and apply the upgrade immediately is a valid method to perform a major version upgrade, though it will cause some downtime. Option D: Creating a read replica, upgrading it first, and promoting it minimizes downtime because the primary remains available during the upgrade.

Option A is incorrect because the --allow-major-version-upgrade flag is used with the AWS CLI, but it must be combined with a modification; however, simply using the flag is not sufficient. Option C is incorrect because automatic minor version upgrades do not affect major version upgrades. Option E is incorrect because restoring a snapshot does not upgrade the engine version.

7
MCQeasy

A company is using Amazon DynamoDB and needs to export data to Amazon S3 for analysis. Which AWS service can perform this export without writing custom code?

A.AWS Data Pipeline
B.Amazon EMR
C.AWS Glue
D.DynamoDB Console
AnswerC

Glue can run ETL jobs to export DynamoDB data to S3.

Why this answer

AWS Glue provides a built-in DynamoDB-to-S3 export feature that requires no custom code. You can create a Glue job using the 'Export DynamoDB table to S3' blueprint, which automatically handles schema inference, data conversion, and partitioning. This is the only option that directly supports the export without writing any code.

Exam trap

The trap here is that candidates may choose AWS Data Pipeline because it is a traditional ETL service, but they overlook that AWS Glue now offers a simpler, code-free export blueprint specifically for DynamoDB-to-S3, making it the most direct answer.

How to eliminate wrong answers

Option A is wrong because AWS Data Pipeline requires defining a pipeline with activities and resources, which involves configuration but not custom code; however, it is not the simplest or most direct service for this task and is deprecated in favor of Glue. Option B is wrong because Amazon EMR requires you to write or run custom scripts (e.g., Spark or Hive) to export data from DynamoDB to S3, which does not meet the 'without writing custom code' requirement. Option D is wrong because the DynamoDB Console only allows manual export of table data to S3 via the 'Export to S3' feature, but this is a one-time, manual operation, not an automated service; the question asks for a 'service' that can perform the export, and the console is a UI, not a service.

8
MCQeasy

A company is migrating an on-premises Oracle database to Amazon RDS for Oracle. The database is 2 TB in size and has a 100 Mbps internet connection. The migration must be completed within 3 days with minimal downtime. Which approach is MOST suitable?

A.Export the database as a dump file, upload to S3, and restore to RDS.
B.Use AWS Database Migration Service (DMS) with a full load from an AWS Snowball device, then ongoing replication.
C.Use AWS DMS with full load over the internet, then ongoing replication.
D.Create a VPN connection to AWS and use Oracle Data Pump over the VPN.
AnswerB

Snowball handles the initial large data transfer, and DMS provides minimal downtime replication.

Why this answer

The 2 TB database cannot be fully loaded over a 100 Mbps internet connection within 3 days (theoretical max transfer ~2.6 TB in 3 days, but real-world throughput is lower due to overhead and contention). AWS Snowball provides a physical appliance to transfer the full load offline, bypassing bandwidth constraints, and then AWS DMS ongoing replication captures and applies changes with minimal downtime.

Exam trap

The trap here is that candidates underestimate the real-world throughput of a 100 Mbps link for a 2 TB transfer, assuming theoretical maximum speeds, and overlook the Snowball option as a viable offline data transfer method for large databases with tight timelines.

How to eliminate wrong answers

Option A is wrong because exporting to a dump file, uploading to S3, and restoring to RDS requires significant downtime for the export and restore, and the 100 Mbps connection makes the upload of a 2 TB dump file impractical within 3 days (estimated >50 hours at full speed, ignoring overhead). Option C is wrong because AWS DMS full load over the internet with a 100 Mbps link cannot complete the initial 2 TB transfer within 3 days due to bandwidth limitations and network overhead, risking migration failure. Option D is wrong because Oracle Data Pump over a VPN over the same 100 Mbps internet connection still faces the same bandwidth bottleneck, and the VPN adds encryption overhead, making the transfer even slower.

9
MCQhard

A database team is migrating an on-premises Oracle database to Amazon Aurora PostgreSQL. The team needs to ensure minimal downtime and data consistency. Which approach should be used?

A.Use the PostgreSQL foreign data wrapper (FDW) to link the Oracle database
B.Use AWS Server Migration Service (SMS) to replicate the database
C.Use AWS Database Migration Service (DMS) with ongoing replication using change data capture (CDC)
D.Use pg_dump and pg_restore to migrate the data during a maintenance window
AnswerC

AWS DMS with ongoing CDC replication captures incremental changes from the Oracle source redo logs, enabling near-zero downtime migration by continuously synchronising transactions to Aurora PostgreSQL until cutover. This satisfies the stem’s requirement for minimal downtime and data consistency, as CDC maintains transactional integrity without halting the source database during the bulk load phase.

Why this answer

AWS DMS with ongoing replication using change data capture (CDC) is the correct approach because it enables a live migration with minimal downtime. DMS can perform a full load of the Oracle database and then continuously replicate ongoing changes from Oracle to Aurora PostgreSQL, ensuring data consistency at the point of cutover. This method avoids the need for a long maintenance window and supports heterogeneous migrations with automatic schema conversion.

Exam trap

The trap here is that candidates often confuse AWS DMS with simpler dump-and-restore tools (pg_dump/pg_restore) or assume that a foreign data wrapper can perform a migration, when in fact DMS is the only AWS managed service designed specifically for heterogeneous database migrations with minimal downtime via CDC.

How to eliminate wrong answers

Option A is wrong because the PostgreSQL foreign data wrapper (FDW) is used for querying remote databases in real-time, not for migrating data with minimal downtime and consistency guarantees; it does not provide a managed replication or cutover mechanism. Option B is wrong because AWS Server Migration Service (SMS) is designed for migrating virtual machines (VMs) from on-premises to AWS, not for database-level replication; it cannot handle heterogeneous database migrations or CDC. Option D is wrong because pg_dump and pg_restore require taking the source database offline or using a maintenance window, which contradicts the requirement for minimal downtime; this approach also does not support ongoing replication to keep data consistent during migration.

10
MCQeasy

A database administrator needs to track changes to an Amazon RDS DB instance's configuration, such as modifications to the DB instance class or security group. Which AWS service should be used?

A.Amazon CloudWatch Logs
B.AWS Config
C.AWS CloudTrail
D.AWS Systems Manager Patch Manager
AnswerB

AWS Config tracks configuration changes and provides a history.

Why this answer

AWS Config records configuration changes to RDS instances. Option A is wrong because CloudWatch Logs are for log data, not configuration changes. Option C is wrong because CloudTrail records API calls, not configuration state.

Option D is wrong because Systems Manager Patch Manager is for patching.

11
MCQhard

A database specialist is troubleshooting a performance issue on an Amazon RDS for MySQL DB instance. The CPU utilization is consistently above 90%, but the IOPS and memory metrics are well within limits. Which tool should the specialist use to identify the root cause?

A.Enable AWS CloudTrail to log database queries.
B.Use Amazon RDS Enhanced Monitoring to view OS-level metrics.
C.Check RDS events in the AWS Management Console.
D.Use Amazon RDS Performance Insights to identify the top SQL queries by CPU usage.
AnswerD

Performance Insights provides query-level performance data.

Why this answer

Amazon RDS Performance Insights provides a database performance tuning and monitoring feature that visualizes database load and helps identify the top SQL queries consuming the most CPU. Since the CPU is consistently above 90% while IOPS and memory are normal, Performance Insights can directly correlate high CPU usage to specific SQL statements, enabling the specialist to pinpoint the root cause efficiently.

Exam trap

The trap here is that candidates confuse Enhanced Monitoring (OS-level metrics) with Performance Insights (database-level query analysis), assuming OS metrics alone can identify the specific SQL causing high CPU, when in fact they only show the symptom, not the cause.

How to eliminate wrong answers

Option A is wrong because AWS CloudTrail logs API calls and management actions, not database queries or SQL execution details, so it cannot help identify CPU-intensive queries. Option B is wrong because Amazon RDS Enhanced Monitoring provides OS-level metrics (e.g., CPU, memory, disk I/O at the hypervisor level) but does not show which SQL queries are consuming CPU; it only indicates that CPU is high, not the cause. Option C is wrong because RDS events in the AWS Management Console notify about operational events (e.g., failovers, maintenance) but do not provide query-level performance data or SQL execution details.

12
MCQhard

A company is deploying an Amazon Aurora MySQL database. The company requires that the database withstand the loss of two copies of data without impacting write availability. Which configuration should the company use?

A.Aurora with 3 copies of data in 3 Availability Zones
B.Aurora with 2 copies of data in 2 Availability Zones
C.Aurora with 3 copies of data in 2 Availability Zones
D.Aurora with 6 copies of data across 3 Availability Zones
AnswerD

Aurora automatically stores 6 copies across 3 AZs, allowing it to tolerate loss of two copies without affecting write availability.

Why this answer

Aurora MySQL stores 6 copies of data across 3 Availability Zones. The database can withstand the loss of up to two copies without affecting write availability, provided the copies are distributed across AZs. Option D (6 copies across 3 AZs) is correct.

Option A (3 copies in 3 AZs) is incorrect because Aurora uses 6 copies, not 3. Option B (2 copies in 2 AZs) provides insufficient redundancy. Option C (3 copies in 2 AZs) is not the architecture; Aurora uses 6 copies across 3 AZs.

13
MCQmedium

A gaming company uses Amazon Aurora PostgreSQL for its leaderboard data. The database has a writer instance and two reader instances. The application frequently queries the leaderboard to display top players. The queries involve sorting and aggregation on a large table with millions of rows. Recently, the queries started timing out during peak hours. The database administrator analyzed the workload and found that the reader instances are underutilized, while the writer instance has high CPU due to write operations. The administrator wants to offload the read-heavy leaderboard queries to the readers without modifying the application code. What should the administrator do?

A.Configure the application to use the Aurora reader endpoint for read-only queries.
B.Upgrade the writer instance to a larger instance class to handle both read and write operations.
C.Create additional reader instances to distribute the read load.
D.Implement a read-only Aurora cluster and point read queries to it.
AnswerA

The reader endpoint load balances across readers, offloading reads from the writer.

Why this answer

The Amazon Aurora reader endpoint automatically distributes read-only connections across all available reader instances. Since the reader instances are underutilized, using the reader endpoint offloads the read-heavy leaderboard queries from the writer instance without any application code modifications. Option B is incorrect because upgrading the writer instance does not offload read queries and does not utilize the underutilized readers.

Option C is incorrect because the existing readers are underutilized; adding more readers would not solve the problem of directing queries to them. Option D is incorrect because creating a separate read-only Aurora cluster is unnecessary and more complex than using the existing reader endpoint.

14
MCQhard

A company uses Amazon DynamoDB with global tables for a multi-region application. The application writes to the table in us-east-1. A developer notices that updates made in us-east-1 are not appearing in the replica in eu-west-1 after several minutes. Which action should be taken to diagnose the issue?

A.Review the CloudWatch metrics for ReplicationLatency and PendingReplicationCount for the global table.
B.Modify the application to use the eu-west-1 endpoint for writes.
C.Check that the table has an active DynamoDB Streams stream with StreamSpecification set to KEYS_ONLY.
D.Verify that the TTL attribute on the table is correctly configured.
AnswerA

These metrics show the replication status and can identify delays or errors in the replication process.

Why this answer

CloudWatch metrics ReplicationLatency (the time lag between when an item is written to one replica and when it appears in another) and PendingReplicationCount (the number of items waiting to be replicated) directly help diagnose replication delays in DynamoDB global tables. Option B is incorrect because writes should continue to the local region (us-east-1); using the eu-west-1 endpoint would not resolve replication latency and could cause consistency issues. Option C is incorrect because DynamoDB Streams is automatically enabled for global tables with NEW_AND_OLD_IMAGES (not KEYS_ONLY) to replicate updates; checking the stream specification is not a diagnostic step for delays.

Option D is incorrect because TTL (Time to Live) is for automatic item expiration, not related to replication performance or delays.

15
Multi-Selectmedium

A company is running a production Amazon RDS for MySQL Multi-AZ DB instance. The database administrator needs to perform a minor version upgrade with minimal downtime. Which TWO actions should be taken? (Choose TWO.)

Select 2 answers
A.Modify the DB instance to enable automatic minor version upgrade.
B.Apply the upgrade immediately during the next maintenance window.
C.Create a read replica, upgrade the replica, and promote it.
D.Modify the DB instance to be a Single-AZ deployment to simplify the upgrade.
E.Stop the DB instance before applying the upgrade.
AnswersA, B

Automatic upgrades apply during maintenance window with minimal downtime.

Why this answer

Enabling automatic minor version upgrades on an RDS for MySQL Multi-AZ instance allows Amazon RDS to apply the upgrade during the next maintenance window with minimal downtime. During the upgrade, RDS patches the standby first, then performs a failover to make the standby the new primary, resulting in a brief (typically under 60 seconds) interruption rather than a full outage. This approach leverages the Multi-AZ architecture to reduce downtime compared to manual upgrades.

Exam trap

The trap here is that candidates often assume 'immediate' means faster and less downtime, but in a Multi-AZ setup, applying the upgrade immediately actually causes more downtime than using the maintenance window with automatic upgrades, because the rolling failover approach is designed to minimize disruption.

16
MCQeasy

A database administrator notices that the free storage space on an Amazon RDS for PostgreSQL DB instance is decreasing rapidly. The instance has automated backups enabled with a retention period of 7 days. Which action should be taken to monitor storage usage and prevent running out of space?

A.Create a lifecycle policy to automatically move old backup files to Amazon S3 Glacier.
B.Set up a CloudWatch alarm on the FreeStorageSpace metric to notify when space is low.
C.Increase the allocated storage for the DB instance immediately.
D.Enable Performance Insights to track storage usage.
AnswerB

CloudWatch alarms provide proactive monitoring and alerting for storage usage.

Why this answer

Setting a CloudWatch alarm on the FreeStorageSpace metric allows proactive monitoring and notification when storage is low. Option A is incorrect because lifecycle policies to move backups to S3 Glacier are not applicable to RDS automated backups; they are managed separately. Option C is incorrect because increasing storage is a reactive measure, not a monitoring action, and may cause downtime.

Option D is incorrect because Performance Insights focuses on database performance, not storage tracking.

17
MCQeasy

A company is using Amazon ElastiCache for Redis to cache database query results. The application team reports that cache hit ratio has dropped significantly. What is the first step to investigate?

A.Run the Redis INFO command to see memory usage
B.Review the ElastiCache event logs for node failures
C.Check the CacheHitRate and Evictions metrics in CloudWatch
D.Check the Redis AOF persistence logs
AnswerC

These metrics directly indicate cache effectiveness.

Why this answer

When the cache hit ratio drops significantly, the first step is to investigate whether the cache is evicting keys due to memory pressure or if the working set no longer fits. CloudWatch metrics such as `CacheHitRate` and `Evictions` provide immediate visibility into these conditions without requiring direct Redis access. This aligns with the AWS Well-Architected Framework's principle of observability before making configuration changes.

Exam trap

The trap here is that candidates assume the first step should be a low-level Redis command (INFO) or logs, but AWS best practice emphasizes using CloudWatch metrics for initial investigation because they provide aggregated, historical data without requiring direct access to the cluster.

How to eliminate wrong answers

Option A is wrong because running the Redis INFO command requires direct access to the Redis endpoint and does not provide historical trend data; it only shows a point-in-time snapshot, which is insufficient for diagnosing a drop in cache hit ratio over time. Option B is wrong because ElastiCache event logs record node lifecycle events (e.g., failover, maintenance) but do not capture cache performance metrics like hit ratio or evictions; they are useful for operational incidents, not performance degradation. Option D is wrong because AOF persistence logs are used for durability and data recovery, not for monitoring cache efficiency; checking them would not reveal why the cache hit ratio has dropped.

18
MCQhard

A company is using Amazon Aurora MySQL-Compatible Edition. The database has frequent deadlocks, and the application team suspects that the isolation level is causing the issue. The current isolation level is REPEATABLE READ. The team wants to reduce deadlocks while maintaining data consistency. Which isolation level should be recommended?

A.READ UNCOMMITTED
B.READ COMMITTED
C.SNAPSHOT ISOLATION
D.SERIALIZABLE
AnswerB

READ COMMITTED reduces the number of locks held, thereby decreasing the likelihood of deadlocks while still preventing dirty reads.

Why this answer

(READ COMMITTED) is correct because it reduces locking compared to REPEATABLE READ, which helps minimize deadlocks in high-concurrency environments. In READ COMMITTED, MySQL uses row-level locks only for the duration of the statement, not the entire transaction, reducing the chance of deadlocks. It still provides consistent reads at the statement level, avoiding dirty reads.

Option A (READ UNCOMMITTED) is wrong because it allows dirty reads and is not suitable for transactional consistency. Option C (SNAPSHOT ISOLATION) is wrong because it is not supported by MySQL; it is a SQL Server feature. Option D (SERIALIZABLE) is wrong because it increases locking, leading to more deadlocks.

19
Multi-Selectmedium

A company is using Amazon RDS for MySQL with Multi-AZ deployment. The DBA receives an alert that the standby replica is lagging behind the primary. Which TWO actions should the DBA take to investigate the issue? (Choose TWO.)

Select 2 answers
A.Check the 'Replica Lag' metric for any read replicas.
B.Verify network latency between the primary and standby.
C.Check the 'ReplicaLag' metric in Amazon CloudWatch.
D.Increase the allocated storage to improve IOPS.
E.Change the replication type from asynchronous to synchronous.
AnswersB, C

High network latency can cause replication lag.

Why this answer

The correct answers are B and C. In Amazon RDS Multi-AZ deployments, the standby replica is synchronously replicated from the primary, and the 'ReplicaLag' metric in CloudWatch is used to monitor the replication delay. Checking this metric (option C) helps identify lag.

Additionally, verifying network latency between the primary and standby (option B) can uncover connectivity issues causing lag. Option A is incorrect because Multi-AZ does not have read replicas; Read Replicas are separate from the Multi-AZ standby. Option D is incorrect because storage size does not directly affect replication lag.

Option E is incorrect because Multi-AZ uses synchronous replication, and changing to asynchronous would not solve the issue and is not a supported change for Multi-AZ.

20
Multi-Selectmedium

A company is migrating an on-premises Oracle database to Amazon RDS for Oracle. Which TWO methods can the database specialist use to minimize downtime during the migration?

Select 2 answers
A.Use Oracle Recovery Manager (RMAN) to back up and restore.
B.Use Oracle GoldenGate to replicate data continuously.
C.Use AWS Database Migration Service (DMS) with ongoing replication.
D.Take a full database backup and restore to RDS.
E.Use Oracle Data Pump to export and import the database.
AnswersB, C

GoldenGate provides real-time replication with minimal downtime.

Why this answer

Oracle GoldenGate enables continuous, real-time data replication from the source Oracle database to Amazon RDS for Oracle, allowing the source to remain fully operational during the migration. When the cutover is performed, only a brief pause is needed to apply any final transactions, minimizing downtime to seconds or minutes.

Exam trap

The trap here is that candidates often assume any backup-and-restore or export/import method (like RMAN or Data Pump) can be performed with minimal downtime, but these methods inherently require the source database to be offline or in a consistent state for a significant period, unlike continuous replication technologies such as GoldenGate or DMS with CDC.

21
MCQhard

Refer to the exhibit. A database administrator runs the AWS CLI command to check the status of an Amazon RDS MySQL DB instance. Based on the output, what action is required to apply the pending modifications?

A.Reboot the DB instance to apply the pending parameter group changes.
B.Take a snapshot of the DB instance before applying changes.
C.Modify the DB parameter group to change the parameter values.
D.Modify the DB instance to set the backup retention period to 7.
AnswerA

The ParameterApplyStatus shows 'pending-reboot', so a reboot is required to apply the parameter changes.

Why this answer

The output shows 'ParameterApplyStatus: pending-reboot', which indicates that changes to the DB parameter group (specifically the parameter modifications) require a reboot to take effect. While there are also pending modifications for the backup retention period and master user password, these do not necessitate a reboot. Therefore, the correct action is to reboot the DB instance (Option A).

Options B, C, and D are incorrect: taking a snapshot is not required, modifying the parameter group has already been done (the status reflects pending-reboot), and altering the backup retention period is not the immediate action needed for the pending reboot.

22
MCQhard

Refer to the exhibit. An RDS for PostgreSQL instance shows frequent checkpoints every 10 seconds. What is the most likely cause?

A.Autovacuum is not running, causing bloat.
B.The instance is running out of storage space.
C.There are too many concurrent connections.
D.The 'max_wal_size' parameter is set too low, causing frequent WAL switches.
AnswerD

Low max_wal_size leads to frequent checkpoints.

Why this answer

Frequent checkpoints in PostgreSQL are often caused by small WAL size settings. The 'max_wal_size' parameter controls the maximum size of WAL files before a checkpoint is triggered. If set too low, the database will perform checkpoints more frequently to recycle WAL segments.

Option A is incorrect because autovacuum bloat does not directly cause frequent checkpoints. Option B is incorrect because storage space issues may cause other symptoms, but not specifically checkpoint frequency. Option C is incorrect because concurrent connections may increase workload but do not directly cause frequent checkpoints; the checkpoint timing is driven by WAL generation rate and WAL size limits.

23
MCQhard

A company is using Amazon DynamoDB with on-demand capacity mode. The application experiences occasional throttling on a table during peak hours. The table's read and write requests are within the throughput limits, but the provisioned read/write capacity is exceeded. What is the most likely cause of this throttling?

A.The table's previous peak throughput was lower than the current traffic, and DynamoDB is still adapting.
B.The table has a hot partition that is receiving more requests than the partition can handle.
C.The table has exceeded the maximum allowed throughput for on-demand capacity mode.
D.The table's provisioned read/write capacity is set too low.
AnswerA

On-demand capacity mode can throttle if traffic exceeds the table's previous peak by a large margin, as DynamoDB needs time to scale up.

Why this answer

On-demand capacity mode in DynamoDB automatically scales based on the table's previous peak throughput. If current traffic suddenly exceeds that previous peak, DynamoDB may throttle requests until it adapts to the new traffic level, even if the requests are within the eventual on-demand limits. Option B is incorrect because although a hot partition can cause throttling, the question states that read and write requests are within the throughput limits, implying the issue is not at the partition level but rather a sudden spike beyond the adapted peak.

Option C is incorrect because on-demand mode has no maximum throughput limit; it scales automatically. Option D is incorrect because on-demand mode does not use provisioned capacity; it scales without manual configuration.

24
MCQeasy

A company runs an Amazon RDS for SQL Server DB instance in a VPC. The security group for the DB instance allows inbound traffic on port 1433 from the application servers' security group. The application servers can connect to the database, but a database administrator cannot connect from their workstation using SQL Server Management Studio (SSMS). What is the MOST likely cause?

A.The security group does not allow inbound traffic from the DBA workstation's IP address.
B.The DBA is using an incompatible version of SSMS.
C.The DB instance is configured as Multi-AZ, which restricts direct connections.
D.The DB instance has encryption enabled, which blocks non-encrypted connections.
AnswerA

The security group only allows traffic from the app servers; the DBA's IP is not allowed.

Why this answer

The DBA's workstation is not within the VPC, so it needs a public IP and the security group must allow inbound traffic from the workstation's IP. Option A (DBA's IP not in security group) is correct. Option B (SSMS version) is unlikely; Option C (Multi-AZ) irrelevant; Option D (encryption) does not prevent connection.

25
MCQmedium

A company has an Amazon DynamoDB table with on-demand capacity mode. The table experiences a sudden spike in traffic, and the application starts receiving ProvisionedThroughputExceededException errors. What is the most likely cause?

A.The provisioned read capacity units are insufficient
B.The table has reached the maximum number of read capacity units
C.The traffic spike exceeded the previous peak traffic by more than double in a short period
D.Auto Scaling is not configured to increase capacity
AnswerC

DynamoDB on-demand mode uses a token bucket algorithm; sudden huge spikes can cause throttling.

Why this answer

DynamoDB on-demand capacity mode can throttle requests if the traffic spike exceeds the previous peak traffic by more than double within a short period. This is due to the adaptive capacity mechanism that requires time to scale. Option A is wrong because on-demand mode does not have provisioned read/write capacity units.

Option B is wrong because on-demand mode does not have a maximum number of capacity units; it scales automatically but with a ramp-up limit. Option D is wrong because Auto Scaling is not applicable to on-demand mode; it uses a different scaling model.

26
MCQmedium

A company is using Amazon RDS for PostgreSQL with read replicas to offload read traffic. The company wants to ensure that the read replicas are always in sync with the primary instance. Which metric should the company monitor to detect replication lag?

A.DiskQueueDepth
B.ReplicaLag
C.TransactionLogsDiskUsage
D.ReadLatency
AnswerB

This metric shows the time difference between the primary and replica in seconds.

Why this answer

The correct metric to monitor for replication lag in Amazon RDS for PostgreSQL read replicas is ReplicaLag. This metric is available in CloudWatch and directly indicates the time difference between the primary instance and the read replica. Option A (DiskQueueDepth) measures the number of pending I/O requests, not replication lag.

Option C (TransactionLogsDiskUsage) measures the amount of transaction logs, which is related but not a direct lag metric. Option D (ReadLatency) measures the latency of read operations, not the synchronization delay.

27
MCQhard

A company uses Amazon RDS for PostgreSQL with Multi-AZ deployment. They experience increased write latency during peak hours. The DB instance size is db.r5.large. Which action would MOST effectively reduce write latency?

A.Switch to a db.r5.xlarge instance type.
B.Disable the Multi-AZ feature and use asynchronous replication with a read replica for failover.
C.Enable the synchronous_commit parameter to 'off'.
D.Enable Multi-AZ with two standby replicas.
AnswerB

Asynchronous replication reduces write latency; read replica can be promoted for failover.

Why this answer

Multi-AZ deployments maintain a synchronous standby replica, which adds write latency because the primary must wait for the standby to acknowledge writes. Disabling Multi-AZ and using asynchronous replication to a read replica eliminates this synchronous overhead, allowing writes to complete faster. Option A increases instance size but doesn't address synchronous replication overhead; option C (synchronous_commit off) risks data loss and is not recommended; option D adds another standby, increasing overhead.

28
MCQmedium

A company is migrating an on-premises Oracle database to Amazon RDS for Oracle. The database size is 500 GB. The migration must have minimal downtime. Which AWS service should be used to perform the migration?

A.AWS Snowball Edge
B.AWS Database Migration Service (DMS)
C.AWS DataSync
D.Amazon RDS for Oracle snapshot copy
AnswerB

DMS supports Oracle to RDS Oracle migrations with minimal downtime using change data capture.

Why this answer

AWS Database Migration Service (DMS) is the correct choice because it supports heterogeneous migrations from Oracle to Amazon RDS for Oracle with minimal downtime. DMS can perform continuous replication using Oracle's change data capture (CDC) via LogMiner or binary reader, allowing the source database to remain operational during the migration. This makes it ideal for a 500 GB database where downtime must be minimized.

Exam trap

The trap here is that candidates often confuse AWS DataSync or Snowball Edge as viable options for live database migrations, but DataSync is for file/object transfers and Snowball Edge is for offline bulk data movement, neither of which support ongoing change replication or minimal-downtime database migration.

How to eliminate wrong answers

Option A is wrong because AWS Snowball Edge is a physical data transfer device designed for large-scale offline data migrations (typically >10 TB) or environments with limited network bandwidth, not for minimal-downtime online database migrations. Option C is wrong because AWS DataSync is a service for transferring files and objects between on-premises storage and AWS (e.g., NFS, SMB, S3), not for live database replication or heterogeneous database migrations. Option D is wrong because Amazon RDS for Oracle snapshot copy only works between existing RDS instances (e.g., cross-region or cross-account copies) and cannot ingest data from an on-premises Oracle database; it requires the source to already be an RDS instance.

29
MCQhard

A company runs a critical application on an Amazon RDS for MySQL DB instance. The company requires that the database be available with minimal downtime during a disaster recovery scenario. The current RDS instance is in us-east-1. The company wants to have a standby database in us-west-2 with automatic failover. What should the company do to meet this requirement?

A.Create a Multi-AZ deployment in us-west-2 and use Amazon Route 53 to failover.
B.Take daily snapshots and copy them to us-west-2. Restore from snapshot in us-west-2 during a disaster.
C.Create a cross-region read replica in us-west-2. Configure automatic failover using Amazon Route 53 health checks.
D.Create a Multi-AZ deployment in us-east-1.
AnswerC

The read replica can be promoted quickly, and Route 53 can redirect traffic automatically.

Why this answer

An RDS cross-region read replica can be promoted to a standalone instance in a disaster, providing automatic failover with minimal downtime when combined with Route 53 health checks. Option A (Multi-AZ in us-west-2) does not provide cross-region failover; Multi-AZ only provides high availability within a single region. Option B (snapshots) requires manual restoration and incurs downtime.

Option D (Multi-AZ in us-east-1) only protects against Availability Zone failures within us-east-1, not region failures. Therefore, option C is the correct solution.

30
Multi-Selecteasy

A company is planning to migrate its on-premises Oracle database to Amazon RDS for Oracle. The database uses Oracle Data Guard for disaster recovery. Which TWO AWS services can be used to assess the database and plan the migration? (Choose TWO.)

Select 2 answers
A.AWS Migration Hub
B.CloudEndure Disaster Recovery
C.AWS Snowball
D.AWS Database Migration Service (DMS)
E.AWS Schema Conversion Tool (SCT)
AnswersD, E

DMS can migrate data and assess compatibility.

Why this answer

AWS Database Migration Service (DMS) can migrate the Oracle database to RDS, while the AWS Schema Conversion Tool (SCT) assesses the source database and converts the schema to target format. Option A (AWS Migration Hub) tracks migrations but does not assess databases. Option B (CloudEndure Disaster Recovery) is for server-level disaster recovery, not database assessment.

Option C (AWS Snowball) is for offline data transfer, not assessment or migration planning.

31
Multi-Selecthard

A financial services company runs an Amazon Aurora MySQL database cluster with a single writer and two readers. The cluster handles critical transactional workloads. Over the past month, the database experienced intermittent read replica lag spikes that caused stale reads in application queries. The database administrator needs to identify the root cause and reduce replica lag. Which THREE steps should the administrator take to diagnose and mitigate the issue?

Select 3 answers
A.Switch from a single-writer cluster to Multi-AZ DB instance to reduce replication lag.
B.Upgrade the reader instances to a larger instance class to match the writer.
C.Use Performance Insights on the reader instances to identify high-load queries causing resource contention.
D.Check the binlog retention hours parameter and reduce it if set to a high value.
E.Enable slow query logging on the writer instance and analyze long-running transactions.
AnswersC, D, E

Performance Insights can pinpoint resource bottlenecks on readers.

Why this answer

Using Performance Insights on reader instances helps identify high-load queries causing resource contention, which can lead to replica lag. Option D is correct because a high binlog retention hours parameter can cause the replica to spend more time replaying binary logs; reducing it can mitigate lag. Option E is correct because enabling slow query logging on the writer instance helps identify long-running transactions that may lock rows or generate excessive binlog data, thereby causing replication delays.

Option A is incorrect because switching from an Aurora cluster to a Multi-AZ DB instance does not address replica lag; Multi-AZ is for failover redundancy, not replication performance. Option B is incorrect because upgrading reader instances to match the writer's class may help if readers are underpowered, but this is not a direct diagnostic step and may not resolve the root cause if the issue stems from the writer side.

32
MCQhard

A company has a production Amazon Aurora MySQL DB cluster with one writer and two reader instances. The application uses a custom connection pool that uses the writer endpoint for all database calls. The application is experiencing increased latency during peak hours. A database specialist suggests using the reader endpoint for read-only queries. What change is required on the application side to implement this recommendation?

A.Modify the Aurora cluster to enable load balancing for the reader endpoint.
B.Create a new custom endpoint for read-only queries and use it instead of the reader endpoint.
C.Replace the writer endpoint with the reader endpoint in the connection pool configuration.
D.Update the application's connection logic to use the cluster endpoint for writes and the reader endpoint for reads.
AnswerD

The reader endpoint distributes read traffic across all reader instances, reducing writer load.

Why this answer

The application needs to differentiate between read and write queries and send read queries to the reader endpoint while write queries continue to use the writer endpoint. No changes to the Aurora cluster are needed; Aurora automatically handles connectivity to reader instances via the reader endpoint. The cluster endpoint remains unchanged for writes.

33
Multi-Selectmedium

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?

Select 2 answers
A.Configure automated backups with a retention period of at least 1 day.
B.Create manual snapshots every 5 minutes.
C.Enable cross-Region replication for the cluster.
D.Enable parallel query for the cluster.
E.Enable Aurora Backtrack.
AnswersA, E

Automated backups enable PITR.

Why this answer

Aurora automated backups with a retention period of at least 1 day provide continuous backup and point-in-time recovery (PITR) with an RPO of 5 minutes because transaction logs are uploaded every 5 minutes. This meets the required RPO of 5 minutes, and restoring can achieve an RTO under 15 minutes. Option E is correct because Aurora Backtrack allows rewinding the cluster to a specific point in time, achieving an RPO of 5 minutes and an RTO of minutes (typically under 15).

No other option meets both the stated RTO and RPO.

Exam trap

The trap here is that candidates assume automated backups require a retention period of exactly 5 minutes to achieve a 5-minute RPO, but Aurora's PITR is based on the frequency of transaction log application (every 5 minutes) and the retention period must be at least 1 day; the 5-minute RPO is inherent to the service, not configurable via retention period.

34
MCQhard

A data warehouse team is migrating from Amazon Redshift to Amazon Redshift RA3 nodes. The current cluster uses 10 DC2.large nodes. The new cluster will use 4 RA3.xlarge nodes. After the migration, the team notices that query performance is significantly slower. Which factor is the MOST likely cause of the performance degradation?

A.The data distribution style is set to EVEN instead of KEY.
B.The cluster does not have enough disk space for the workload.
C.The cluster has fewer nodes, reducing parallelism.
D.RA3 nodes are not optimized for large datasets.
AnswerC

RA3 nodes separate compute and storage; fewer compute nodes reduce parallelism.

Why this answer

Reducing the number of nodes from 10 to 4 decreases the parallelism, even though RA3 nodes have more compute capacity per node. Redshift distributes data across slices, and each node has multiple slices. With fewer nodes, the total number of slices is lower, reducing the degree of parallelism for query execution, which can lead to slower performance for large queries.

Option A is incorrect because the distribution style (EVEN vs KEY) affects data distribution but is not the most likely cause here; the question does not indicate a change in distribution style. Option B is incorrect because RA3 nodes use managed storage with ample capacity; disk space is not constrained. Option D is incorrect because RA3 nodes are optimized for large datasets; the issue is not the node type but the reduction in parallelism due to fewer nodes.

35
MCQeasy

A database administrator is reviewing the configuration of an RDS MySQL instance. Based on the exhibit, which change would MOST improve the database's performance under heavy write workloads without increasing costs significantly?

A.Change the DB parameter group to a custom one with optimized MySQL parameters.
B.Increase the backup retention period to 35 days to improve performance.
C.Enable Multi-AZ to improve write performance.
D.Change the storage type from gp2 to gp3 to get higher baseline IOPS and throughput.
AnswerD

gp3 offers better performance per dollar than gp2.

Why this answer

Gp3 storage provides higher baseline IOPS and throughput than gp2 at the same cost, which directly improves performance under heavy write workloads. Option A is incorrect because parameter group tuning can help but is not the most impactful change without additional cost. Option B is incorrect because backup retention period does not affect performance.

Option C is incorrect because Multi-AZ provides high availability, not improved write performance.

36
MCQeasy

A database administrator is monitoring Amazon RDS for PostgreSQL using CloudWatch. The DB instance shows high CPU utilization, but the number of connections is normal. What is the most likely cause of the high CPU utilization?

A.The DB instance has a low burst balance for gp2 storage.
B.The instance is low on memory and is swapping.
C.There are long-running queries or missing indexes causing high CPU usage.
D.The DB instance has a large number of Read Replicas.
AnswerC

Inefficient queries can consume CPU cycles even with normal connection counts.

Why this answer

High CPU utilization with a normal number of connections often indicates inefficient queries or missing indexes, which cause full table scans and excessive CPU usage. Option A is incorrect because gp2 burst balance affects storage performance, not CPU. Option B is incorrect because memory pressure and swapping typically cause high I/O wait times, not sustained high CPU.

Option D is incorrect because Read Replicas offload read traffic, they do not cause high CPU on the primary instance.

37
MCQmedium

Refer to the exhibit. A database engineer runs the query above to troubleshoot an application error. The query returns no results even though the database is generating errors. What is the most likely reason?

A.The log stream format uses a different field name for the error message
B.The regex pattern does not match because it is case-sensitive
C.The query does not specify a time range, so no results are returned
D.The log group has not been configured to export to CloudWatch Logs
AnswerA

Correct. The log stream format might use a different field name for the error message, such as 'errorMessage' or 'event.message'. The query expects the field 'message', but the actual log stream may store the error in another field, causing the query to return no results.

Why this answer

The query filters on the 'message' field, but the log stream format may use a different field name for the error message, such as 'errorMessage' or 'event.message'. Since the query returns no results despite errors existing, the most likely reason is a field name mismatch. Option B is incorrect because the query uses a regex pattern with case-insensitive matching (indicated by the 'i' flag), so case sensitivity is not an issue.

Option C is incorrect because queries in CloudWatch Logs Insights default to the last 15 minutes if no time range is specified, so that would not cause zero results if errors are recent. Option D is incorrect because exporting to CloudWatch Logs is not required for querying; the logs are already in CloudWatch Logs.

38
MCQhard

A company is migrating an on-premises Oracle database to Amazon RDS for Oracle using AWS DMS. The source database is 2 TB and has high transaction volume. The migration needs minimal downtime. Currently, full load completes but CDC task fails with 'ORA-1555: snapshot too old' errors. What should the DBA do to resolve this?

A.Restart the migration with a new full load and use a smaller task.
B.Increase the undo retention period and undo tablespace size on the source Oracle database.
C.Enable supplemental logging on the source and use a larger DMS instance.
D.Reduce the transaction volume by pausing non-essential transactions during CDC.
AnswerB

Larger undo retention prevents snapshot too old errors.

Why this answer

The 'ORA-1555: snapshot too old' error occurs when Oracle's undo data for a read-consistent view is overwritten before DMS can read it. Increasing the undo retention period and undo tablespace size on the source database ensures that undo data is preserved longer, allowing DMS's CDC task to read consistent data without errors. Option B is correct because it directly addresses the root cause.

Option A would restart the full load but not fix the CDC failure. Option C (supplemental logging and larger DMS instance) does not resolve undo retention issues. Option D (reducing transactions) is not practical and may cause data loss.

Therefore, the correct solution is to increase undo retention and tablespace size.

39
MCQhard

A company runs a critical application on Amazon RDS for MySQL with Multi-AZ deployment. The application performs frequent writes. The DB instance's CPU utilization is consistently above 80%, and the write latency is high. The company wants to improve write performance without changing the application code. Which solution is MOST effective?

A.Enable Multi-AZ with synchronous replication to a standby instance.
B.Add a read replica to offload read traffic.
C.Increase the DB instance class to a larger size with more vCPUs.
D.Migrate the database to Amazon Aurora MySQL.
AnswerD

Amazon Aurora MySQL uses a distributed storage system with a separate log writer, reducing write latency and improving overall write performance. It also handles high CPU utilization better due to its efficient architecture.

Why this answer

Migrating to Amazon Aurora MySQL is the most effective solution because Aurora uses a distributed, SSD-backed storage system with a separate log writer process that reduces write latency. Increasing the DB instance class (Option C) can improve CPU capacity but does not address the underlying storage write latency as effectively as Aurora. Adding a read replica (Option B) offloads read traffic but does not improve write performance.

Enabling Multi-AZ with synchronous replication (Option A) is already in place and can increase write latency due to synchronous replication; it does not solve the high CPU utilization issue.

40
Multi-Selectmedium

A company is migrating an on-premises Oracle database to Amazon Aurora PostgreSQL. The database has several large tables with frequent INSERT and UPDATE operations. Which TWO actions should be taken to optimize performance after migration?

Select 2 answers
A.Enable autovacuum and configure it to run more frequently on the large tables.
B.Use the Aurora PostgreSQL integration with Amazon S3 for bulk data loading.
C.Set synchronous_commit to ON to ensure data durability.
D.Deploy an RDS Proxy in front of the Aurora cluster to reduce connection overhead.
E.Partition the large tables by date to improve query performance.
AnswersA, B

Autovacuum prevents bloat from frequent updates, maintaining query performance.

Why this answer

Options A and B are correct. Enabling autovacuum and tuning it to run more frequently on large tables is essential in PostgreSQL to reclaim storage and prevent transaction ID wraparound, which is critical after a migration with high DML. Using Aurora PostgreSQL integration with Amazon S3 for bulk data loading is efficient because it leverages parallel processing and avoids network overhead.

Option C is incorrect because setting synchronous_commit to ON reduces performance for write-heavy workloads by waiting for disk writes; OFF or REMOTE_WRITE is recommended. Option D is incorrect because RDS Proxy helps with connection management but does not directly optimize DML performance for large tables. Option E is incorrect because while partitioning can help query performance, it is not a direct optimization for INSERT/UPDATE operations and may add complexity; Aurora's storage layer already handles large tables efficiently.

41
Multi-Selecteasy

A company is migrating its on-premises PostgreSQL database to Amazon Aurora PostgreSQL. The migration must have minimal downtime. Which THREE steps should be taken as part of the migration plan? (Select THREE.)

Select 3 answers
A.Perform a test migration to validate the process.
B.Enable Multi-AZ on the Aurora cluster before migration.
C.Update the application connection string to point to the Aurora cluster after cutover.
D.Use AWS DMS to perform a full load and then ongoing replication.
E.Disable automated backups on the Aurora cluster to improve performance.
AnswersA, C, D

Testing ensures the migration works correctly before the actual cutover.

Why this answer

Performing a test migration validates the entire process, including schema compatibility, data integrity, and replication lag, before the actual cutover. This reduces the risk of unexpected failures during the live migration, which is critical for achieving minimal downtime.

Exam trap

The trap here is that candidates may confuse enabling Multi-AZ as a migration requirement, when it is actually a high-availability feature unrelated to the migration process itself.

42
Multi-Selectmedium

A company is designing a disaster recovery strategy for Amazon DynamoDB. The strategy must have an RPO of 5 minutes and RTO of 1 hour. Which TWO options meet these requirements? (Choose 2.)

Select 2 answers
A.On-demand backups
B.Point-in-time recovery (PITR)
C.Cross-Region Replication (CRR) to S3
D.Global tables
E.Scheduled backups using AWS Backup
AnswersB, D

PITR allows restore to any point within seconds, meeting RPO.

Why this answer

Point-in-time recovery (PITR) enables continuous backups of DynamoDB tables with 1-second granularity over a 35-day window, allowing restoration to any point within that window. This supports an RPO of 5 minutes because you can restore to a specific timestamp within seconds of the failure, and the RTO of 1 hour is achievable as table restoration typically completes within that timeframe for most table sizes.

Exam trap

The trap here is that candidates often confuse on-demand backups or scheduled backups with PITR, not realizing that only PITR provides continuous, granular recovery points, and that Global tables are the only option that provides automatic cross-region failover without manual restore operations.

43
MCQmedium

A company runs an Amazon Aurora MySQL database with read replicas to handle read traffic. During a recent load test, the primary instance CPU utilization reached 90%, but read replicas remained below 50%. The application uses a custom ORM that connects to a single endpoint. Which change will best distribute read traffic?

A.Configure the application to use the Aurora reader endpoint for read queries.
B.Use Amazon RDS Proxy with read/write splitting.
C.Place the read replicas behind an Application Load Balancer.
D.Enable Aurora Auto Scaling for replicas and use the cluster endpoint for both read and write.
AnswerA

Reader endpoint load balances across read replicas.

Why this answer

The Aurora reader endpoint automatically load balances SELECT queries across all read replicas, distributing read traffic effectively. Option B is incorrect: Amazon RDS Proxy provides connection pooling but does not split read/write traffic; it uses the cluster endpoint, which directs to the primary instance. Option C is incorrect: Aurora read replicas are not standard EC2 instances and cannot be placed behind an Application Load Balancer; the reader endpoint is the intended mechanism.

Option D is incorrect: The cluster endpoint always points to the primary instance, so using it for reads would not distribute load; Aurora Auto Scaling adds replicas, but they are only utilized when the reader endpoint is used.

44
MCQeasy

A developer needs to restore an Amazon RDS for PostgreSQL DB instance to a specific point in time within the retention period. What must be enabled for this operation to be possible?

A.Deletion protection enabled.
B.A read replica in the same region.
C.Automated backups with a retention period greater than 0.
D.Multi-AZ deployment.
AnswerC

PITR relies on automated backups and transaction logs.

Why this answer

Automated backups with a retention period greater than 0 are required for point-in-time recovery (PITR) in Amazon RDS. Option A is incorrect because deletion protection prevents accidental deletion but does not enable PITR. Option B is incorrect because read replicas are used for read scaling and disaster recovery, not for PITR.

Option D is incorrect because Multi-AZ provides high availability but is not a prerequisite for PITR.

45
MCQeasy

An Amazon RDS for SQL Server instance is running out of storage space. The instance uses 500 GB of Magnetic storage. The database specialist needs to increase storage to 1 TB with minimal downtime. Which solution meets these requirements?

A.Create a snapshot of the DB instance and restore it with larger storage.
B.Convert the storage type to General Purpose (gp2) and then increase size.
C.Modify the DB instance and increase the allocated storage to 1 TB.
D.Use AWS DMS to migrate the database to a new instance with 1 TB storage.
AnswerC

Modifying storage online is supported with minimal downtime.

Why this answer

Modifying the DB instance to increase allocated storage is the correct approach because it can be done with minimal downtime. Amazon RDS for SQL Server supports dynamic storage scaling, allowing you to increase the allocated storage size without requiring a snapshot or migration. The instance remains available during the modification, although a brief performance impact may occur.

Option A is incorrect because restoring from a snapshot requires significant downtime and does not offer a direct storage increase on the existing instance. Option B is incorrect because converting storage type (e.g., from Magnetic to General Purpose) is a separate modification that also incurs downtime, and it is not necessary to change storage type before increasing size; you can modify storage size directly. Option D is incorrect because using AWS DMS is overkill for a simple storage increase and introduces additional complexity and potential downtime during the migration process.

46
MCQhard

A company has a production Amazon RDS for PostgreSQL Multi-AZ DB instance. The company's security team requires that all database connections use IAM database authentication. The company also needs to ensure that connections from a specific application server are allowed only if the server has a valid IAM role. Which combination of steps should the database administrator take to meet these requirements?

A.Create a database user with a strong password. Enable IAM database authentication. Assign the application server an IAM policy that allows rds-db:connect. Configure the application to use the password.
B.Enable IAM database authentication. Create a database user matching the IAM user ARN. Grant the application server's IAM user the rds_iam role. Configure the application to use an authentication token.
C.Enable IAM database authentication. Create a database user that matches the IAM role ARN. Configure the application to use the database master username and password.
D.Enable IAM database authentication on the RDS instance. Create a database user that matches the IAM role ARN. Grant the application server's IAM role the rds_iam role. Configure the application to generate an authentication token using the IAM role's credentials.
AnswerD

This ensures connections use IAM authentication and the application server's role is required.

Why this answer

IAM database authentication for RDS PostgreSQL requires mapping IAM roles to database users. Steps: 1) Enable IAM database authentication on the RDS instance. 2) Create a database user that matches the IAM role ARN (the role assumed by the application server). 3) Grant the rds_iam role to the application server's IAM role to allow it to authenticate. 4) Configure the application to generate an authentication token using the IAM role's credentials. Option D is correct because it includes all these steps.

Option A is wrong because it uses a password instead of an authentication token. Option B is wrong because it references an IAM user ARN instead of a role ARN. Option C is wrong because it does not enable IAM authentication and uses a password.

47
Multi-Selecthard

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.)

Select 3 answers
A.Add more shards to the cluster to increase total memory.
B.Reduce the time-to-live (TTL) for cached items to free up memory faster.
C.Enable cluster mode to distribute data across multiple shards.
D.Increase the node type to a larger instance class, such as r6g.2xlarge.
E.Configure the cache to use lazy loading only for write-through operations.
AnswersA, C, D

More shards increase aggregate memory and distribute load.

Why this answer

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.

Exam trap

The trap here is that candidates may think reducing TTL (option B) helps free memory faster, but in reality it increases cache misses and database load, making the problem worse during spikes.

48
MCQmedium

Refer to the exhibit. An IAM policy is attached to a user who needs to manage Amazon RDS DB instances. When the user attempts to modify a DB instance, they receive an 'AccessDenied' error. What is the most likely cause?

A.The policy does not include the 'rds:ModifyDBInstance' action for the specific DB instance ARN.
B.The policy is missing the 'rds:ListTagsForResource' permission needed for the console.
C.The user is trying to modify a Multi-AZ DB instance which requires additional permissions.
D.The policy requires a condition to allow modifications during the maintenance window.
AnswerB

The console requires ListTagsForResource to display instance details; without it, modify operations fail.

Why this answer

The IAM policy attached to the user includes the 'rds:ModifyDBInstance' action, so the user should be able to modify DB instances via the API or CLI. However, the AWS Management Console frequently requires additional read-only permissions to render the interface, such as 'rds:ListTagsForResource' to display tags. Without this permission, the console may throw an 'AccessDenied' error when attempting a modification, even though the underlying modify action is allowed.

This is the most likely cause of the error.

49
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 24/7 uptime requirement. The migration must have minimal downtime and support ongoing replication. Which TWO services or features should the specialist use to accomplish this?

Select 2 answers
A.Oracle Data Guard to replicate to RDS.
B.Amazon RDS cross-Region automated backups.
C.An AWS DMS replication instance.
D.AWS Schema Conversion Tool (AWS SCT).
E.AWS Database Migration Service (AWS DMS) with change data capture (CDC).
AnswersC, E

An AWS DMS replication instance is the compute resource that runs DMS tasks, including full load and ongoing CDC replication, enabling minimal downtime migration.

Why this answer

Options C and E are correct. Option C: An AWS DMS replication instance is required to run AWS DMS tasks, including migration with ongoing replication. Option E: AWS DMS with change data capture (CDC) enables ongoing replication with minimal downtime.

Option D is incorrect because AWS Schema Conversion Tool (AWS SCT) is used for heterogeneous migrations (e.g., Oracle to PostgreSQL), not for homogeneous Oracle-to-Oracle migrations. Option A is incorrect because Oracle Data Guard is not supported for direct replication to Amazon RDS for Oracle; DMS is used instead. Option B is incorrect because cross-Region automated backups are a backup feature, not a migration tool for minimal downtime migration.

50
MCQeasy

A database administrator runs the above AWS CLI command. What is the purpose of the command?

A.Retrieve average free storage space for mydb.
B.Retrieve average number of database connections for mydb.
C.Retrieve average CPU utilization for mydb.
D.Retrieve average write latency for mydb.
AnswerB

The metric is DatabaseConnections.

Why this answer

The AWS CLI command `aws cloudwatch get-metric-statistics` with the namespace `AWS/RDS`, metric name `DatabaseConnections`, and statistic `Average` retrieves the average number of database connections for the specified DB instance `mydb` over the given time period. The `--metric-name DatabaseConnections` parameter explicitly targets the connection count metric, making option B correct.

Exam trap

The trap here is that candidates may confuse the metric name `DatabaseConnections` with other common RDS metrics like `FreeStorageSpace` or `CPUUtilization`, or assume the command retrieves performance metrics without carefully reading the `--metric-name` parameter.

How to eliminate wrong answers

Option A is wrong because the metric for free storage space is `FreeStorageSpace`, not `DatabaseConnections`. Option C is wrong because CPU utilization is tracked under the metric name `CPUUtilization`, not `DatabaseConnections`. Option D is wrong because write latency is measured by the metric `WriteLatency`, not `DatabaseConnections`.

51
MCQeasy

Refer to the exhibit. A database administrator runs the AWS CLI command shown. The output is: ["available", false]. What does this output indicate about the DB instance?

A.The DB instance is in the process of being modified to enable Multi-AZ.
B.The DB instance is in a Multi-AZ deployment and is available.
C.The DB instance is stopped and is not in a Multi-AZ configuration.
D.The DB instance is available and is not configured for Multi-AZ.
AnswerD

The status is 'available' and MultiAZ is false.

Why this answer

The output shows the DBInstanceStatus is 'available' and MultiAZ is false. Option A is incorrect because MultiAZ false indicates it is not in the process of being modified to enable Multi-AZ. Option B is incorrect because MultiAZ is false, meaning it is not in a Multi-AZ deployment.

Option C is incorrect because the status is 'available', not 'stopped'.

52
MCQeasy

A company is using Amazon DynamoDB with global tables. The application writes to a table in the us-east-1 region. The database administrator notices that updates made in us-east-1 are not appearing in the replica table in eu-west-1. What is the most likely cause?

A.DynamoDB Streams are not enabled on the table.
B.The replication delay is set too high.
C.Point-in-time recovery is not enabled on the replica table.
D.The IAM role for replication does not have sufficient permissions.
AnswerA

Global tables require DynamoDB Streams to be enabled for replication to work.

Why this answer

DynamoDB global tables rely on DynamoDB Streams to replicate changes. If streams are not enabled, updates will not be replicated to other regions. Option B is incorrect because DynamoDB does not have a configurable replication delay; replication is near real-time.

Option C is incorrect because point-in-time recovery is a backup feature and does not affect replication. Option D is incorrect because insufficient IAM permissions would typically cause error messages or failures, not a silent lack of replication.

53
Multi-Selectmedium

Which TWO actions can be taken to monitor the health of an Amazon DynamoDB table? (Choose 2.)

Select 2 answers
A.Use AWS Trusted Advisor to check table limits
B.Enable Amazon CloudWatch metrics for the table
C.Enable DynamoDB Streams and process events with AWS Lambda
D.Use DynamoDB Accelerator (DAX) to improve response times
E.Set up CloudWatch alarms for ThrottledRequests
AnswersB, E

CloudWatch metrics like ConsumedWriteCapacityUnits, ThrottledRequests indicate health.

Why this answer

Enabling CloudWatch metrics for a DynamoDB table provides key health indicators such as read/write capacity utilization, throttled requests, and latency. Option E is correct because setting up CloudWatch alarms on ThrottledRequests allows you to proactively detect and respond to throttling events, which directly impacts table health. Option A is incorrect because AWS Trusted Advisor checks overall account limits but does not provide real-time health monitoring of a specific table.

Option C is incorrect because DynamoDB Streams capture item-level changes for event-driven processing, not for monitoring the table's operational health. Option D is incorrect because DAX is an in-memory cache that improves read performance, not a monitoring tool.

54
MCQeasy

A SysOps administrator is tasked with monitoring the free storage space on all Amazon RDS DB instances. Which AWS service should be used to set up an alarm that sends an email notification when free storage space falls below a threshold?

A.AWS CloudTrail to monitor storage events.
B.AWS Config to track storage configuration changes.
C.Amazon CloudWatch with an alarm on the FreeStorageSpace metric and an SNS topic.
D.Amazon Inspector to check for storage vulnerabilities.
AnswerC

CloudWatch monitors metrics and can trigger actions via SNS.

Why this answer

Amazon CloudWatch provides the `FreeStorageSpace` metric for RDS DB instances, which reports the amount of available storage in bytes. You can create a CloudWatch alarm on this metric and configure it to send a notification via an Amazon SNS topic when the value falls below a specified threshold, enabling proactive monitoring of storage capacity.

Exam trap

The trap here is confusing logging/auditing services (CloudTrail, Config) or security scanners (Inspector) with the monitoring and alerting capabilities of CloudWatch, leading candidates to select a service that cannot evaluate real-time metric thresholds.

How to eliminate wrong answers

Option A is wrong because AWS CloudTrail records API calls for auditing and governance, not real-time storage metrics; it cannot monitor free storage space or trigger alarms. Option B is wrong because AWS Config tracks configuration changes to AWS resources (e.g., DB instance class or storage type) but does not provide continuous metric monitoring or threshold-based alerting for storage usage. Option D is wrong because Amazon Inspector is a vulnerability management service that scans for software vulnerabilities and unintended network exposure, not for monitoring storage space on RDS instances.

55
MCQmedium

A company has an Amazon RDS for MySQL DB instance that is running low on storage. The current allocated storage is 500 GB, and the free space is down to 10 GB. The database administrator wants to increase storage with minimal downtime. Which action should be taken?

A.Use the AWS Management Console to modify the DB instance and increase the allocated storage.
B.Stop the DB instance, modify the allocated storage, and start the instance.
C.Create a snapshot of the current DB instance, restore it to a new larger instance, and point the application to the new endpoint.
D.Enable storage autoscaling and wait for the automatic increase.
AnswerA

Modifying storage is an online operation with minimal impact.

Why this answer

RDS supports modifying storage online with minimal downtime. Increasing allocated storage from 500 GB to, for example, 600 GB can be done via a modification to the DB instance. The instance remains available during the modification, though a brief performance impact may occur.

Stopping the instance is unnecessary. Creating a snapshot and restoring would cause longer downtime. Waiting for autoscaling might not be quick enough if space is critically low.

56
MCQmedium

A company uses Amazon DynamoDB for a gaming application. During a new game launch, the table experiences throttling on write requests. The table has a provisioned capacity of 10,000 WCU and 5,000 RCU. The write traffic pattern shows spikes up to 15,000 WCU for 5 minutes. Which action would resolve the throttling with minimal cost impact?

A.Use Amazon SQS to buffer the write requests
B.Increase the provisioned WCU to 20,000 permanently
C.Enable Auto Scaling for DynamoDB with a target utilization of 70%
D.Enable DynamoDB Accelerator (DAX) for the table
AnswerC

Enabling Auto Scaling dynamically adjusts provisioned capacity based on traffic, handling spikes cost-effectively by scaling up during high demand and down during low demand.

Why this answer

Auto Scaling for DynamoDB automatically adjusts provisioned write capacity based on actual traffic, handling spikes up to 15,000 WCU without manual intervention and minimizing cost by scaling down during low traffic. Option A is wrong: SQS buffers requests but does not directly resolve DynamoDB throttling; it adds latency and complexity. Option B is wrong: permanently increasing WCU to 20,000 is costly and wasteful for short spikes.

Option D is wrong: DynamoDB Accelerator (DAX) is an in-memory cache for read-heavy workloads, not for write throughput.

57
MCQeasy

A database administrator is troubleshooting a sudden increase in read latency on an Amazon RDS for PostgreSQL instance. The instance has 200 GB of General Purpose SSD (gp2) storage with 600 provisioned IOPS. The administrator notices that the average queue depth is consistently above 4. Which action is the MOST effective way to reduce read latency?

A.Enable Multi-AZ deployment to offload reads to the standby.
B.Change the instance type to a larger size with more vCPUs.
C.Migrate to an io1 volume with 3000 provisioned IOPS.
D.Increase the allocated storage to 500 GB without changing IOPS.
AnswerC

Increasing IOPS addresses the queue depth and reduces latency.

Why this answer

Migrating to an io1 volume with 3000 provisioned IOPS directly increases the available IOPS, addressing the high queue depth and reducing read latency. Option A is incorrect because Multi-AZ does not allow read traffic to the standby; the standby is only used for failover. Option B is incorrect because increasing the instance size may not resolve the I/O bottleneck if the issue is insufficient IOPS.

Option D is incorrect because increasing the allocated storage for gp2 increases baseline IOPS (3 IOPS per GB), but the option specifies not changing IOPS, so it would not help; even if it did, 500 GB would provide 1500 IOPS, which may still not be sufficient.

58
MCQeasy

A company wants to encrypt an existing unencrypted Amazon RDS for SQL Server instance. What is the MOST efficient way to achieve this?

A.Create a read replica with encryption enabled.
B.Modify the DB instance to enable encryption.
C.Create a snapshot of the DB instance and copy it with encryption enabled. Restore the snapshot to a new encrypted instance.
D.Use AWS DMS to migrate data to a new encrypted instance.
AnswerC

This is the recommended approach.

Why this answer

You cannot directly enable encryption on an existing unencrypted RDS instance. The most efficient method is to take a snapshot of the instance, copy it with encryption enabled (which re-encrypts the data using AWS KMS), and then restore that snapshot to a new encrypted DB instance. This approach minimizes downtime and leverages native RDS snapshot capabilities without requiring external tools.

Exam trap

The trap here is that candidates assume you can simply modify an existing RDS instance to enable encryption (Option B), but AWS requires encryption to be set at creation time, so the snapshot-restore workflow is the only native way to convert an unencrypted instance to encrypted.

How to eliminate wrong answers

Option A is wrong because creating a read replica with encryption enabled requires the source instance to already be encrypted; you cannot create an encrypted read replica from an unencrypted source. Option B is wrong because RDS does not support modifying an existing unencrypted DB instance to enable encryption—encryption can only be enabled at creation time. Option D is wrong because while AWS DMS can migrate data to a new encrypted instance, it is less efficient than the snapshot method, as it requires setting up a replication task and incurs additional data transfer overhead.

59
MCQeasy

A company's RDS for MySQL instance is experiencing high CPU utilization. Which AWS service should be used to set up automated actions to scale the instance vertically?

A.AWS Systems Manager Automation with a custom runbook
B.AWS Auto Scaling with a target tracking scaling policy
C.AWS Lambda function to modify the DB instance class
D.Amazon CloudWatch Alarms to send an SNS notification to the DBA
AnswerC

An AWS Lambda function can be triggered by a CloudWatch alarm to call the RDS modify-db-instance API and change the instance class, enabling automated vertical scaling.

Why this answer

For automated vertical scaling of an RDS for MySQL instance, the most direct approach among the options is to use an AWS Lambda function that modifies the DB instance class, triggered by a CloudWatch alarm based on CPU utilization. AWS Auto Scaling (B) only supports horizontal scaling for RDS (adding read replicas) and does not natively change instance class. Systems Manager Automation (A) could orchestrate a change but is less straightforward than Lambda.

CloudWatch Alarms (D) only notify; they cannot automatically scale without an action target like Lambda. Therefore, option C is the best choice.

Exam trap

The trap is that candidates assume AWS Auto Scaling handles both horizontal and vertical scaling for RDS, but it only supports horizontal scaling (adding/removing replicas). Vertical scaling (changing instance class) requires a custom automation, such as a Lambda function triggered by CloudWatch Alarms.

How to eliminate wrong answers

Option A is wrong because AWS Systems Manager Automation runbooks are designed for operational tasks like patching or configuration changes, not for automatically scaling RDS instances based on real-time metrics. Option C is wrong because while a Lambda function could modify the DB instance class via API calls, it is not a managed service purpose-built for automated scaling; it requires custom code, monitoring, and error handling, making it less reliable and more complex than AWS Auto Scaling. Option D is wrong because CloudWatch Alarms sending SNS notifications only alert the DBA to the issue; they do not perform any automated scaling action, which is explicitly required by the question.

60
MCQhard

A company is using Amazon ElastiCache for Redis as a caching layer in front of an Amazon Aurora MySQL database. The application is experiencing higher latency than expected. Which database design pattern should the specialist recommend to improve read performance?

A.Increase the ElastiCache cluster size to accommodate more data.
B.Enable Multi-AZ on the ElastiCache cluster and use read replicas.
C.Use Aurora Replicas to offload read traffic from the primary instance.
D.Implement Amazon DynamoDB Accelerator (DAX) in front of Aurora.
AnswerC

Aurora Replicas can handle read queries and reduce latency.

Why this answer

The application is experiencing higher latency than expected despite using ElastiCache for Redis. This indicates that the cache is not effectively absorbing read traffic, likely due to cache misses or insufficient cache hit ratio. By using Aurora Replicas, read traffic can be offloaded from the primary Aurora instance, reducing load and improving read performance directly at the database layer, which complements the caching layer.

Exam trap

The trap here is that candidates may assume that increasing cache capacity (Option A) or adding cache replicas (Option B) will solve read performance issues, but the real problem is that the cache is not effectively reducing database load, so the solution must address the database read path directly with Aurora Replicas.

How to eliminate wrong answers

Option A is wrong because simply increasing the ElastiCache cluster size does not address the root cause of high latency; it only provides more capacity for data, but if the cache hit ratio is low or the application is not using the cache effectively, more nodes will not reduce latency. Option B is wrong because enabling Multi-AZ on ElastiCache provides high availability and failover, but does not improve read performance; read replicas in ElastiCache are not used to offload read traffic in the same way as database read replicas, and Multi-AZ is for redundancy, not read scaling. Option D is wrong because Amazon DynamoDB Accelerator (DAX) is an in-memory cache for DynamoDB, not for Aurora MySQL; it is incompatible with Aurora and would require migrating the database to DynamoDB, which is not a recommended pattern for this scenario.

61
MCQmedium

A company is running an Amazon RDS for MySQL DB instance with Multi-AZ deployment. The database experiences a failover due to a hardware failure. After the failover, the application team reports that a critical stored procedure is missing. What should the database administrator do to prevent this issue in the future?

A.Create the stored procedure as a function instead.
B.Modify the DB parameter group to enable binary logging.
C.Ensure that the stored procedure is created on both the primary and standby instances by using a script or manually recreating it after failover.
D.Increase the binlog retention period to ensure the stored procedure is captured.
AnswerB

Correct. Enabling binary logging ensures all DDL changes are logged, which helps in replication consistency and provides the ability to recover from replication issues that might cause a stored procedure to be missing after failover.

Why this answer

In Amazon RDS MySQL Multi-AZ deployments, all database objects including stored procedures are replicated via synchronous storage-level replication. Therefore, a missing stored procedure after a failover is unlikely and indicates a potential replication issue. To prevent this, enabling binary logging ensures that DDL statements (such as CREATE PROCEDURE) are captured in binary logs.

This allows binary log replication to maintain consistency, reduces the risk of orphaned objects, and provides the ability to recover using point-in-time restore if needed. Thus, modifying the DB parameter group to enable binary logging is the best preventive measure.

62
MCQmedium

A company runs an Amazon RDS for PostgreSQL DB instance with Multi-AZ enabled. The primary instance is in us-east-1a and the standby is in us-east-1b. During a routine audit, the security team discovers that database connections are being terminated unexpectedly. The database administrator reviews the RDS events and sees an event: 'A Multi-AZ failover has been completed.' What step should be taken to determine the cause of this failover?

A.Examine Amazon CloudWatch metrics for increased CPU or memory usage
B.Check the RDS console for maintenance windows
C.Review RDS events and AWS CloudTrail logs for API calls related to the failover
D.Run the describe-db-instances CLI command to check the status of the standby
AnswerC

RDS events and CloudTrail logs capture API calls and system events that can reveal the exact cause of the failover, such as a manual failover request or underlying hardware issues.

Why this answer

Reviewing RDS events and AWS CloudTrail logs is the correct step because these services record detailed information about the failover, including any API calls that may have triggered the failover or underlying issues. Option A is incorrect because CloudWatch metrics show resource utilization (CPU, memory) but do not directly indicate the cause of a failover. Option B is incorrect because maintenance windows are scheduled events; although they may cause failovers, simply checking the console for maintenance windows does not provide a definitive cause for an unexpected failover.

Option D is incorrect because the describe-db-instances CLI command shows the current status of instances (e.g., whether the standby is available) but does not provide historical information about why the failover occurred.

63
MCQmedium

A company runs a production Amazon RDS for MySQL Multi-AZ DB instance. The database experiences a failover event. After the failover, the application team reports increased latency for write operations. Which action should be taken to investigate the issue?

A.Increase the allocated storage for the DB instance to reduce I/O contention.
B.Enable automated backups and configure a backup window.
C.Verify that the application is using the correct DB endpoint and that DNS has propagated.
D.Modify the DB instance to a larger instance class to improve write performance.
AnswerC

After failover, the DNS record updates to point to the new primary; ensuring the application resolves the correct endpoint is critical.

Why this answer

After a failover, the DNS record updates to point to the new primary. If DNS has not propagated, the application may be connecting to the old primary or experiencing routing issues, leading to increased write latency. Verifying DNS resolution ensures the application is using the correct endpoint.

Option A is incorrect because increasing storage does not directly address latency caused by DNS propagation; it might help with I/O contention under normal conditions, but it is not the appropriate first step for investigating post-failover latency.

Option B is incorrect because automated backups do not impact write latency; they run in the background and do not interfere with database operations.

Option D is incorrect because changing the instance class can improve performance, but the immediate issue after failover is likely DNS propagation, not insufficient compute capacity.

64
MCQmedium

A team is migrating an on-premises Oracle database to Amazon Aurora PostgreSQL. The database is 2 TB and has a 6-hour maintenance window. Which AWS service should the team use to minimize downtime?

A.AWS Database Migration Service (AWS DMS)
B.Amazon S3 Transfer Acceleration
C.AWS Snowball Edge
D.Amazon EC2 with Oracle installed
AnswerA

DMS supports heterogeneous migrations with minimal downtime.

Why this answer

AWS DMS is the correct choice because it can perform a live migration from Oracle to Aurora PostgreSQL with minimal downtime using ongoing replication (change data capture). It supports heterogeneous migrations, automatically converting the source schema and data types, and can handle a 2 TB database within the 6-hour maintenance window by using multiple parallel tasks and large instance types.

Exam trap

AWS often tests the misconception that offline transfer services like Snowball are suitable for minimal-downtime migrations, but the trap here is that Snowball requires a full data export and import, which cannot achieve the sub-hour cutover needed within a 6-hour maintenance window.

How to eliminate wrong answers

Option B (Amazon S3 Transfer Acceleration) is wrong because it only speeds up uploads to S3 over the internet but does not provide any database migration or replication capabilities, nor does it support ongoing synchronization to minimize downtime. Option C (AWS Snowball Edge) is wrong because it is designed for offline, bulk data transfer of large datasets (e.g., 2 TB) and cannot perform live, ongoing replication; using it would require a full data dump and reload, causing significant downtime beyond the 6-hour window. Option D (Amazon EC2 with Oracle installed) is wrong because it simply rehosts the Oracle database on AWS without addressing the migration to Aurora PostgreSQL, and it does not provide any native mechanism for minimal-downtime heterogeneous migration or schema conversion.

65
MCQmedium

A healthcare company runs a critical application on Amazon RDS for PostgreSQL with a Multi-AZ deployment. The database stores patient records and must comply with HIPAA regulations. Recently, a security audit revealed that the database is using the default port 5432 and that SSL connections are not enforced. The security team requires that all connections to the database use SSL and that the default port be changed to 5439 to reduce the risk of automated attacks. The database administrator needs to implement these changes with minimal downtime. What should the administrator do?

A.Create a new RDS instance with the desired settings, migrate the data using pg_dump, and update the application connection string.
B.Update the security group inbound rules to only allow traffic on port 5439 and enforce SSL at the network level.
C.Modify the default DB parameter group to change the port and enable SSL, then apply it to the instance without a reboot.
D.Modify the DB parameter group associated with the instance to set 'ssl' to '1' and 'port' to 5439. Reboot the instance to apply the changes.
AnswerD

Parameter changes require a reboot; this method has minimal downtime.

Why this answer

Modifying the DB parameter group to require SSL (set 'ssl' to '1') and change the port to 5439, then rebooting the instance, applies the changes with minimal downtime (a few minutes). Option A is wrong because creating a new RDS instance and migrating with pg_dump involves significant downtime and complexity. Option B is wrong because updating security group inbound rules only controls network access, not database-level SSL enforcement; SSL must be enabled on the database itself.

Option C is wrong because you cannot modify the default DB parameter group; you must use a custom parameter group, and changing the port requires a reboot.

66
MCQmedium

A company is migrating an on-premises Oracle database to Amazon RDS for Oracle. The database is 2 TB in size. The company wants to minimize downtime during the migration. Which AWS service should be used to perform an online migration with minimal downtime?

A.AWS Direct Connect
B.AWS Database Migration Service (DMS)
C.AWS Snowball
D.Amazon S3
AnswerB

DMS supports continuous replication for minimal downtime migration.

Why this answer

AWS Database Migration Service (DMS) supports ongoing replication to minimize downtime. Snowball is for offline data transfer. S3 is not a migration service.

Direct Connect provides a dedicated network connection but is not a migration service itself.

67
MCQeasy

A company has an Amazon Aurora MySQL DB cluster with a single writer and two readers. The writer instance fails, and the failover mechanism promotes one of the readers to writer. The application, which uses a custom connection pool, continues to experience errors for several minutes. What should the database administrator do to minimize downtime during future failovers?

A.Increase the connection pool size to handle more connections.
B.Modify the application to use the cluster endpoint instead of the instance endpoint.
C.Configure the application to use the reader endpoint for all traffic.
D.Enable Multi-AZ on the Aurora cluster.
AnswerB

The cluster endpoint automatically points to the current writer instance. After a failover, DNS is updated to point to the new writer, so using this endpoint minimizes downtime.

Why this answer

The cluster endpoint always points to the current writer, so after a failover it automatically routes to the new writer without application changes. Option A is wrong because increasing the connection pool size does not help the application detect the new writer; it could even cause more failed connections. Option C is wrong because the reader endpoint only routes to read replicas, not the writer, so write traffic would fail.

Option D is wrong because Aurora already provides Multi-AZ replication; there is no separate 'enable Multi-AZ' setting.

68
MCQhard

Refer to the exhibit. An IAM policy statement allows creating manual snapshots for an RDS instance. A database administrator is unable to create a snapshot from the AWS Management Console. The error message indicates insufficient permissions. What is the likely cause?

A.The condition key 'aws:RequestedRegion' is misspelled.
B.The policy does not include necessary read actions (e.g., 'DescribeDBInstances', 'DescribeDBSnapshots') that the console uses.
C.The resource ARN is incorrect; it should include the snapshot ARN.
D.The condition uses 'StringEquals' but should use 'StringLike' for region matching.
AnswerB

The console requires read permissions to list instances and snapshots before creating a snapshot.

Why this answer

The AWS Management Console often performs multiple API calls (such as DescribeDBInstances and DescribeDBSnapshots) to list and display resources before allowing actions. Even if the CreateDBSnapshot action is allowed, the console will fail if it cannot describe the instance or snapshots. Option A is incorrect because the condition key 'aws:RequestedRegion' is correctly spelled.

Option C is incorrect because the resource ARN correctly identifies the RDS instance for snapshot creation. Option D is incorrect because StringEquals is appropriate for matching the region exactly; StringLike is not needed.

69
MCQmedium

A company is running a production Amazon RDS for MySQL DB instance. The database size is 500 GB and the workload is write-heavy. The team notices that the automated backups are taking longer than expected and are impacting the performance during the backup window. Which action should be taken to minimize the performance impact?

A.Disable automated backups and rely on manual snapshots taken during off-peak hours.
B.Create a read replica and configure automated backups on the replica.
C.Increase the DB instance size to improve backup performance.
D.Move the backup window to a time when the workload is lowest.
AnswerB

Offloading backups to a read replica ensures that backup operations do not affect the primary instance's performance.

Why this answer

Creating a read replica and configuring automated backups on the replica offloads the backup process from the primary DB instance. Since the workload is write-heavy, this minimizes the performance impact on the primary during the backup window. Option A is incorrect because disabling automated backups removes the ability to perform point-in-time recovery, which is risky for a production database.

Option C is incorrect because increasing the DB instance size may improve backup speed but does not eliminate the performance impact on the primary instance, and it adds unnecessary cost. Option D is incorrect because moving the backup window to a low workload time does not reduce the performance impact during that window; it only changes when the impact occurs, and the workload may still be significant.

70
Multi-Selectmedium

A company is migrating a PostgreSQL database to Amazon Aurora PostgreSQL. The database has a large table that is frequently accessed. The team wants to minimize downtime during the migration. Which TWO strategies should be used together?

Select 2 answers
A.Use AWS DMS to create a target Aurora DB cluster and replicate data.
B.Take a manual snapshot of the source database and restore it to Aurora.
C.Use AWS Schema Conversion Tool (AWS SCT) to convert the schema.
D.Use AWS DMS to perform a full load followed by ongoing replication.
E.Configure Aurora as a read replica of the PostgreSQL instance.
AnswersA, D

DMS can migrate data to Aurora with ongoing replication to minimize downtime.

Why this answer

AWS DMS can perform a full load of the source PostgreSQL database to Aurora and then set up ongoing change data capture (CDC) replication to apply incremental changes, minimizing downtime by allowing the source to remain operational until cutover. Option A is correct because DMS can create and manage the target Aurora cluster as part of the replication task, while option D is correct because the combination of full load plus ongoing replication is the standard approach for near-zero downtime migrations.

Exam trap

The DBS-C01 exam often tests the misconception that a manual snapshot or read replica setup can achieve near-zero downtime, but candidates overlook that snapshots require downtime for consistency and Aurora cannot be a read replica of an external PostgreSQL instance.

71
MCQmedium

A database administrator is troubleshooting a performance issue on an Amazon RDS for SQL Server instance. The CPU utilization is consistently above 90%, and the number of database connections is high. Which Amazon CloudWatch metric should be analyzed first to determine if the issue is due to a specific query?

A.DatabaseConnections
B.ReadIOPS
C.Enhanced Monitoring (cpuUtilization per process)
D.CPUUtilization
AnswerC

Enhanced Monitoring provides per-process CPU metrics, which can help identify which process (and thus which query) is consuming the most CPU.

Why this answer

Enhanced Monitoring provides per-process CPU utilization metrics, which allow you to identify if a specific SQL Server query or session is consuming excessive CPU. Unlike aggregate metrics like CPUUtilization, Enhanced Monitoring breaks down CPU usage by process (e.g., sqlservr.exe), enabling you to pinpoint a problematic query. This is the most direct way to determine if the high CPU is driven by a specific query rather than general load.

Exam trap

The trap here is that candidates often choose CPUUtilization (Option D) because it seems directly related to CPU issues, but they overlook that Enhanced Monitoring provides the granularity needed to isolate a specific query's impact.

How to eliminate wrong answers

Option A is wrong because DatabaseConnections only shows the total number of connections, not which queries are consuming CPU; high connections can cause CPU pressure but do not identify a specific query. Option B is wrong because ReadIOPS measures disk read operations, which may correlate with query performance but does not directly indicate CPU usage per query. Option D is wrong because CPUUtilization is an aggregate instance-level metric that cannot isolate CPU usage to a specific process or query, making it insufficient for diagnosing query-level issues.

72
MCQeasy

A database administrator needs to monitor the number of database connections to an Amazon RDS for PostgreSQL instance. Which Amazon CloudWatch metric should the administrator use?

A.DatabaseConnections
B.ActiveConnections
C.ConnectionsCount
D.DBInstanceIdentifier
AnswerA

This is the standard CloudWatch metric for active connections.

Why this answer

The correct metric is `DatabaseConnections`, which is published by Amazon RDS for PostgreSQL to CloudWatch. It reports the number of client network connections to the database instance, corresponding to the `numbackends` value from the `pg_stat_database` view. This metric directly reflects the current connection count and is the standard way to monitor connection usage for RDS PostgreSQL.

Exam trap

The trap here is that candidates confuse the metric name with generic terms like 'ActiveConnections' or 'ConnectionsCount', which sound plausible but are not the exact CloudWatch metric name published by RDS, leading them to pick a non-existent metric.

How to eliminate wrong answers

Option B is wrong because `ActiveConnections` is not a valid CloudWatch metric for RDS; RDS does not publish a metric with that name. Option C is wrong because `ConnectionsCount` is not a CloudWatch metric for RDS; it is a metric name used by other services like Amazon ElastiCache, not RDS. Option D is wrong because `DBInstanceIdentifier` is a dimension (a metadata filter) used to identify a specific RDS instance in CloudWatch, not a metric that measures connection count.

73
MCQeasy

An e-commerce company uses Amazon ElastiCache for Redis as a session store for its web application. The application experiences occasional latency spikes during flash sales. The operations team notices that the Redis cluster's CPU utilization reaches 90% during these events. The current cluster is a single shard with a cache.r5.large node. The team wants to reduce CPU utilization and improve performance. What should the database administrator do?

A.Add read replicas to offload read traffic from the primary node.
B.Increase the number of replicas for data durability.
C.Disable AOF persistence to reduce write overhead.
D.Enable encryption at rest to secure data.
AnswerA

Read replicas handle read requests, reducing CPU usage on the primary.

Why this answer

Adding read replicas to an ElastiCache for Redis cluster allows read traffic to be offloaded from the primary node, reducing its CPU utilization. During flash sales, the high read load from session retrieval causes the primary's CPU to spike. Read replicas handle read queries, lowering the primary's CPU usage.

Option B is incorrect because increasing replicas for data durability (e.g., for failover) does not directly reduce CPU load; replicas also serve reads but the primary still handles writes. Option C is incorrect because disabling AOF persistence reduces write overhead only marginally; the main CPU load during flash sales is from read traffic, not persistence. Option D is incorrect because enabling encryption at rest adds CPU overhead for encryption operations, which would increase CPU utilization, not reduce it.

74
MCQhard

A company is migrating an on-premises Oracle database to Amazon RDS for Oracle. The database is 500 GB in size and has a 24/7 uptime requirement. The migration window is limited to 2 hours. Which strategy should be used to minimize downtime?

A.Use AWS Schema Conversion Tool (SCT) to convert the schema and copy data
B.Take an on-premises backup and restore to RDS using Oracle RMAN
C.Export the database to a dump file and import into RDS
D.Use AWS Database Migration Service (DMS) with ongoing replication
AnswerD

DMS supports minimal downtime by replicating changes until cutover.

Why this answer

AWS Database Migration Service (DMS) can perform ongoing replication from the source Oracle database to Amazon RDS for Oracle, allowing a minimal cutover window of under 2 hours. Option A is incorrect because AWS Schema Conversion Tool (SCT) only converts schema and does not handle data migration. Option B is incorrect because performing an on-premises backup and restoring via Oracle RMAN would require significant downtime and may exceed the 2-hour window for a 500 GB database.

Option C is incorrect because exporting to a dump file and importing into RDS requires the database to be offline or in read-only mode, causing prolonged downtime.

75
MCQmedium

A company is using Amazon Aurora MySQL-Compatible Edition. The database is experiencing performance degradation due to long-running queries. The DBA needs to identify the queries that are consuming the most resources. Which action should be taken?

A.Enable Enhanced Monitoring and review the OS process list.
B.Enable the slow query log and use a third-party tool to analyze it.
C.Use Amazon RDS Performance Insights to identify the top SQL queries.
D.Enable CloudWatch Logs for the DB instance and search for errors.
AnswerC

Performance Insights helps identify queries that are consuming the most resources.

Why this answer

Amazon RDS Performance Insights is the correct tool for this scenario because it provides a built-in, easy-to-use dashboard that visualizes database load and identifies the top SQL queries consuming the most resources, such as CPU, I/O, and wait events. Unlike other options, Performance Insights directly correlates database performance metrics with specific queries, enabling the DBA to quickly pinpoint long-running or resource-intensive queries without additional setup or third-party tools.

Exam trap

The trap here is that candidates often confuse Enhanced Monitoring (OS-level metrics) with Performance Insights (database-level query performance), leading them to choose Option A because they think OS process list will show query details, but it only shows processes, not SQL text or resource consumption per query.

How to eliminate wrong answers

Option A is wrong because Enhanced Monitoring provides OS-level metrics (e.g., CPU, memory, disk I/O) and the process list, but it does not identify individual SQL queries or their resource consumption; it focuses on the instance's operating system, not the database engine's query performance. Option B is wrong because enabling the slow query log and using a third-party tool to analyze it can help identify long-running queries, but it requires additional configuration, log management, and external analysis, making it less efficient than the native, integrated solution provided by Performance Insights. Option D is wrong because CloudWatch Logs for the DB instance captures database logs (e.g., error logs, audit logs) but does not provide a real-time, query-level performance breakdown; searching for errors would not reveal which queries are consuming the most resources.

Page 1 of 4 · 300 questions totalNext →

Ready to test yourself?

Try a timed practice session using only Db Mgmt Ops questions.