DBS-C01 Deployment and Migration Practice Test 6 — 15 Questions

Question 1

A company is deploying a multi-region application with Amazon Aurora Global Database. They need to ensure that the secondary region can be promoted to primary with minimal data loss in the event of a regional failure. Which configuration should they use?

Choose an answer to begin — your selection is scored in the full session.

Accepted Answer

Deploy Amazon Aurora Global Database with one primary Region and up to five secondary Regions.. Amazon Aurora Global Database is designed for low-latency cross-Region replication and provides a managed failover capability that promotes a secondary Region to primary with a Recovery Point Objective (RPO) of typically less than 1 second. This configuration meets the requirement of minimal data loss during a regional failure because replication is done at the storage layer, not through asynchronous binlog replication, ensuring near-zero lag.

Answer

Deploy Amazon Aurora Serverless with cross-Region replication.

Answer

Deploy Amazon RDS for MySQL with cross-Region read replicas.

Answer

Deploy Amazon RDS for PostgreSQL with Multi-AZ and cross-Region snapshot copy.

Question 2

A company is migrating a 100 GB SQL Server database to Amazon RDS for SQL Server. They need to minimize downtime and ensure that only the schema is converted. Which tool should they use?

Accepted Answer

AWS Schema Conversion Tool (SCT). AWS Schema Conversion Tool (SCT) is the correct choice because it is specifically designed to convert database schemas (including stored procedures, functions, and data types) from one engine to another, such as SQL Server to Amazon RDS for SQL Server. Since the requirement is to minimize downtime and only convert the schema (not migrate data), SCT can perform an offline schema conversion without impacting the source database, whereas DMS is a continuous data replication tool that would incur downtime for schema changes.

Answer

AWS Database Migration Service (DMS)

Answer

AWS DMS with schema conversion enabled

Answer

SQL Server Management Studio (SSMS)

Question 3

A company is deploying a new application that requires low-latency reads from a relational database across multiple AWS Regions. The application is read-heavy and can tolerate eventual consistency. Which deployment option meets these requirements?

Accepted Answer

Deploy Amazon Aurora Global Database with a primary Region and read replicas in secondary Regions.. Amazon Aurora Global Database is designed for low-latency global reads and disaster recovery, allowing up to five secondary Regions with dedicated read replicas that replicate data with a typical latency of under one second. This meets the requirement for low-latency reads across multiple Regions while tolerating eventual consistency, as reads from secondary Regions are eventually consistent with the primary.

Answer

Deploy Amazon RDS for PostgreSQL with Multi-AZ and read replicas in the same Region.

Answer

Deploy a single Amazon RDS for MySQL instance with cross-Region read replicas.

Answer

Deploy Amazon DynamoDB Global Tables in multiple Regions.

Question 4

A company is migrating an on-premises Oracle database to Amazon RDS for Oracle. The database uses Oracle Data Pump for export/import. The migration must be completed within a short maintenance window. Which migration approach should they use?

Accepted Answer

Use AWS Database Migration Service with full load and change data capture (CDC).. AWS Database Migration Service (DMS) with full load and change data capture (CDC) is the correct approach because it minimizes downtime by performing an initial full load of the Oracle database and then continuously replicating ongoing changes until the cutover, allowing the migration to complete within a short maintenance window. Unlike Oracle Data Pump, which requires the source database to be offline during export/import, DMS with CDC keeps the source operational and only requires a brief outage at final cutover.

Answer

Use AWS Snowball to transfer the database files to AWS and then restore to RDS.

Answer

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

Answer

Use AWS Schema Conversion Tool (SCT) to convert the schema and then use DMS for data migration.

Question 5

A company wants to deploy a MySQL database that automatically scales read capacity based on traffic without manual intervention. Which AWS database offering should they use?

Accepted Answer

Amazon Aurora with Auto Scaling for read replicas. Amazon Aurora with Auto Scaling for read replicas is correct because it automatically adjusts the number of Aurora Replicas based on changes in read workload, scaling read capacity without manual intervention. Aurora's Auto Scaling monitors the average CPU utilization or connections of the reader fleet and adds or removes replicas to maintain a target metric, providing seamless read scaling for MySQL-compatible databases.

Answer

Amazon DynamoDB with auto scaling

Answer

Amazon RDS for MySQL with Multi-AZ deployment

Answer

Amazon RDS for MySQL with a Single-AZ deployment

Question 6

A company is migrating a 500 GB Oracle database to Amazon Aurora PostgreSQL. They need to convert the schema and migrate the data with minimal downtime. Which THREE actions should they take? (Choose three.)

Accepted Answer

Use AWS Schema Conversion Tool (SCT) to assess and convert Oracle-specific features like hierarchical queries.. AWS Schema Conversion Tool (SCT) is the correct tool for assessing and converting Oracle-specific features like hierarchical queries (e.g., CONNECT BY) into PostgreSQL-compatible syntax (e.g., recursive CTEs). This is essential for schema migration to Aurora PostgreSQL, and SCT provides a detailed assessment report to identify and automate conversion of such features.

Answer

Modify the application to use Aurora PostgreSQL-specific SQL syntax before migration.

Answer

Use AWS Snowball Edge to transfer the data to AWS and then load into Aurora.

Question 7

A company is deploying a new application using Amazon RDS for PostgreSQL. They require high availability with automatic failover and the ability to offload read traffic. Which TWO features should they enable? (Choose two.)

Accepted Answer

Multi-AZ deployment. Multi-AZ deployment (Option A) provides high availability by automatically provisioning and maintaining a synchronous standby replica in a different Availability Zone. If the primary DB instance fails, Amazon RDS automatically fails over to the standby, ensuring minimal downtime. Read replicas (Option B) offload read traffic by creating asynchronous copies of the database that can serve read queries, reducing load on the primary instance.

Answer

Performance Insights

Answer

Global Database

Answer

Auto Scaling for read replicas

Question 8

A company is migrating a 2 TB Oracle database to Amazon Aurora PostgreSQL. The migration must have minimal downtime and support ongoing replication. Which AWS service should be used?

Accepted Answer

AWS Database Migration Service (AWS DMS). AWS Database Migration Service (AWS DMS) is the correct choice because it supports ongoing replication (change data capture, CDC) from an Oracle source to an Amazon Aurora PostgreSQL target, enabling a migration with minimal downtime. DMS can handle a 2 TB database by using a large replication instance and tuning task settings, and it continuously replicates changes until the cutover is complete.

Answer

AWS DataSync

Answer

Amazon S3 Glacier

Answer

AWS Schema Conversion Tool (AWS SCT)

Question 9

A company needs to migrate a 10 TB SQL Server database from on-premises to Amazon RDS for SQL Server with minimal downtime. The database is heavily used with frequent write operations. Which migration strategy should be used?

Accepted Answer

Use AWS DMS with ongoing replication from the on-premises database to RDS until cutover.. AWS DMS with ongoing replication (change data capture) allows a full load of the 10 TB database followed by continuous replication of write operations from the on-premises SQL Server to Amazon RDS for SQL Server. This minimizes downtime by keeping the target database synchronized until the cutover window, where only a brief pause is needed to apply final changes and switch traffic.

Answer

Use native SQL Server backup and restore to Amazon S3, then restore to RDS.

Answer

Export the database to CSV files, upload to S3, and use the COPY command in RDS.

Answer

Use AWS Schema Conversion Tool (SCT) to convert the schema, then use AWS DMS for full load.

Question 10

A company is deploying Amazon RDS for MySQL in a Multi-AZ configuration for high availability. The database must be able to automatically failover to a standby in another Availability Zone. Which RDS feature enables this?

Accepted Answer

Multi-AZ deployment. Multi-AZ deployment for Amazon RDS automatically provisions and maintains a synchronous standby replica in a different Availability Zone. When a failure is detected, Amazon RDS automatically fails over to the standby, ensuring high availability without manual intervention. This is the native RDS feature designed specifically for automatic failover across AZs.

Answer

Automated backups

Answer

Enhanced Monitoring

Answer

Read Replicas

Question 11

A company is deploying a globally distributed application that requires a low-latency, highly available database with multi-region write support. The application needs to handle conflicts automatically. Which AWS database solution meets these requirements?

Accepted Answer

Amazon DynamoDB global tables. Amazon DynamoDB global tables provide a fully managed, multi-region, multi-active database solution that automatically replicates data across AWS Regions, supports low-latency reads and writes from any region, and uses conflict resolution based on 'last writer wins' (LWW) with a timestamp vector clock. This meets the requirement for a globally distributed application needing automatic conflict handling without custom code.

Answer

Amazon Aurora Global Database

Answer

Amazon ElastiCache for Redis global datastore

Answer

Amazon RDS Multi-AZ with cross-region read replicas

Question 12

A company is migrating a 500 GB Oracle database to Amazon RDS for Oracle. The migration must complete within a 4-hour downtime window. The network bandwidth is 1 Gbps. Which migration approach minimizes the migration time?

Accepted Answer

Use AWS DMS to perform a full load of the database to RDS.. AWS DMS performs a full load directly from the source Oracle database to the target RDS for Oracle instance over the network, leveraging the 1 Gbps bandwidth efficiently. For a 500 GB database, a full load at 1 Gbps (theoretical max ~450 Gbps per hour) can complete in under 2 hours, well within the 4-hour window, without requiring intermediate storage or schema conversion.

Answer

Use AWS Schema Conversion Tool (SCT) to convert the schema, then use AWS DMS for data migration.

Answer

Use Oracle Data Pump to export and import the database.

Answer

Use AWS DataSync to copy the database files to Amazon S3, then restore to RDS.

Question 13

A company is deploying Amazon RDS for PostgreSQL and needs to ensure that all data at rest is encrypted. Which action should be taken to enable encryption?

Accepted Answer

Specify an AWS KMS key when creating the RDS instance.. Amazon RDS for PostgreSQL supports encryption at rest using AWS Key Management Service (KMS). Encryption must be enabled at instance creation time by specifying an AWS KMS key; it cannot be enabled on an existing unencrypted instance. This ensures that the underlying storage, automated backups, read replicas, and snapshots are encrypted using the chosen KMS key.

Answer

Modify the existing RDS instance to enable encryption.

Answer

Enable encryption by default in the RDS console.

Answer

Enable encryption using S3 server-side encryption.

Question 14

A company is migrating a MySQL database to Amazon Aurora MySQL. The database has several stored procedures and triggers. During the migration, some stored procedures fail to execute. What is the most likely cause?

Accepted Answer

The stored procedures use features that are not compatible with Aurora MySQL.. Aurora MySQL is designed to be compatible with MySQL 5.6, 5.7, and 8.0, but it does not support all MySQL features. Stored procedures that rely on deprecated or non-standard MySQL features, such as certain SQL modes, storage engine-specific syntax, or unsupported functions, will fail to execute after migration. This is the most common cause of stored procedure failures during a migration to Aurora MySQL.

Answer

Aurora does not support stored procedures.

Answer

The stored procedures exceed the maximum size limit in Aurora.

Answer

The stored procedures use MyISAM tables, which are not supported by Aurora.

Question 15

A company is migrating a 3 TB SQL Server database to Amazon RDS for SQL Server. The migration must be completed with less than 15 minutes of downtime. The company has set up AWS DMS with ongoing replication. During the final cutover, the DMS task fails with a 'Target error: Cannot insert duplicate key' error. What is the most likely cause?

Accepted Answer

The target table has an identity column that is not set to allow insert of explicit values.. The error 'Cannot insert duplicate key' during DMS full load or ongoing replication indicates that the target table has an identity column that does not allow explicit value insertion. By default, SQL Server identity columns are set to NOT FOR REPLICATION = OFF, meaning DMS cannot insert rows with explicit identity values, causing duplicate key violations when the source has identity values that conflict with the target's auto-generated sequence. To resolve this, you must set the identity column to allow explicit inserts (e.g., SET IDENTITY_INSERT ON) or configure DMS to use 'Do nothing' for identity handling.

Answer

The DMS task is not set to truncate the target before loading.

Answer

The source database transaction log is full.

Answer

The source database has a primary key violation.