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

Question 1

A company is planning to migrate an on-premises Microsoft SQL Server database to Amazon RDS for SQL Server. The database is 2 TB and the company wants to minimize downtime. They intend to use AWS Database Migration Service (AWS DMS) with ongoing replication. Which TWO actions should the company take to ensure that the migration captures ongoing changes efficiently? (Choose two.)

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

Accepted Answer

Set the AWS DMS task to use 'Full Load and CDC' mode.. To efficiently capture ongoing changes when migrating SQL Server to RDS for SQL Server with AWS DMS, you must enable MS-CDC on the source database and tables, and configure the DMS task to perform both full load and CDC. MS-CDC provides the mechanism for DMS to read changes, while the task mode ensures that changes are replicated after the initial load. These two actions together enable minimal downtime migration.

Answer

Create a new AWS DMS replication instance with Multi-AZ enabled.

Answer

Configure the source database to use the 'Simple' recovery model.

Answer

Enable Transparent Data Encryption (TDE) on the source database.

Question 2

A company is migrating its on-premises Oracle database to Amazon RDS for Oracle. The database uses a non-standard block size of 16 KB and the company wants to use Oracle Data Pump for the migration. They have created an RDS for Oracle instance with the default block size. During the import, they encounter errors indicating that the data pump file cannot be imported due to block size mismatch. What should the company do to resolve this issue?

Accepted Answer

Create a new RDS for Oracle instance with a matching 16 KB block size and perform the import there.. Amazon RDS for Oracle requires the database block size to be specified at instance creation and it cannot be changed afterward. When migrating using Data Pump, the export file's block size must match the target database's block size. Therefore, creating a new RDS instance with the same 16 KB block size is necessary to successfully import the Data Pump file.

Answer

Modify the RDS for Oracle instance to change the block size to 16 KB using the MODIFY DATABASE command.

Answer

Use Oracle GoldenGate to replicate the data instead of Data Pump, as it is block size agnostic.

Answer

Convert the Data Pump export file to use the default block size using the DBMS_DATAPUMP package.

Question 3

A company is deploying a new Amazon DynamoDB table for a high-traffic application. They need to ensure that the table can handle sudden spikes in read and write traffic without manual intervention. Which DynamoDB capacity mode should they choose?

Accepted Answer

On-demand capacity mode. On-demand capacity mode is designed for workloads with unpredictable traffic patterns. It automatically scales to handle sudden spikes without manual intervention, and you pay only for the read and write requests you use. This makes it the best choice for high-traffic applications with variable demand.

Answer

Provisioned capacity mode with auto scaling enabled

Answer

Global tables with provisioned capacity

Answer

Reserved capacity mode

Question 4

A company is planning to migrate a large on-premises MySQL database to Amazon Aurora MySQL. The database is 10 TB in size and the company wants to minimize downtime during the migration. They decide to use AWS Database Migration Service (AWS DMS) with a full load plus change data capture (CDC). Which of the following must be configured on the source MySQL database to support CDC?

Accepted Answer

Enable binary logging and set the binlog_format parameter to ROW.. AWS DMS uses the MySQL binary log to capture ongoing changes for CDC. The binary log must be enabled, and the binlog_format must be set to ROW so that DMS can read row-level changes. This is a prerequisite for CDC tasks. Without these settings, the CDC phase will fail or not capture changes.

Answer

Set the transaction isolation level to READ COMMITTED.

Answer

Enable the general query log to capture all SQL statements.

Answer

Enable the slow query log and set long_query_time to 0.

Question 5

A logistics company is migrating its on-premises Oracle database to Amazon RDS for Oracle. The database is 4 TB and must be migrated with less than 10 minutes of downtime. The company has set up an AWS Direct Connect connection and wants to use AWS DMS. Which combination of source endpoint settings and AWS DMS task configuration will achieve the required minimal downtime?

Accepted Answer

Use Oracle LogMiner with change data capture (CDC) and a full load plus ongoing replication task.. To achieve minimal downtime, AWS DMS must perform a full load to copy existing data and then use change data capture (CDC) to replicate ongoing changes. Oracle LogMiner is the supported CDC method for Oracle sources. A full load plus ongoing replication task allows the target to stay synchronized until cutover. Other options either lack CDC, use unsupported methods, or introduce manual steps that increase downtime.

Answer

Use Oracle Binary Reader with a full load only task and then manually apply changes after the load.

Answer

Use Oracle LogMiner with a full load only task and then perform a second full load to capture changes.

Answer

Use Oracle Data Pump to export and import the database, then use AWS DMS for ongoing replication.

Question 6

A company is deploying a new Amazon DynamoDB table that will be used by an application with unpredictable read and write patterns. The company wants to ensure that the table can automatically scale its throughput capacity based on the workload, while minimizing manual intervention and cost. Which action should be taken?

Accepted Answer

Create the table with on-demand capacity mode.. On-demand capacity mode is designed for workloads with unpredictable traffic. It automatically scales to handle capacity requirements and charges per request, eliminating the need to manage capacity. Provisioned mode, even with automatic scaling, requires configuration and may not respond quickly enough to sudden spikes. DAX is for read caching and does not help with write scaling.

Answer

Create the table with provisioned capacity mode and enable DynamoDB Accelerator (DAX) for caching.

Answer

Create the table with provisioned capacity mode and use AWS Auto Scaling to adjust capacity based on CloudWatch alarms.

Answer

Create the table with provisioned capacity mode and set up automatic scaling for read and write capacity.

Question 7

A company is migrating an on-premises Microsoft SQL Server database to Amazon RDS for SQL Server. The database uses SQL Server Agent jobs and linked servers. After migration, the jobs and linked servers must continue to function. Which action should be taken to meet these requirements?

Accepted Answer

Use the native backup and restore method to migrate the database, then reconfigure SQL Server Agent jobs and linked servers on the RDS instance.. SQL Server Agent jobs and linked servers are not part of a database backup, so they must be manually recreated on the RDS instance after migration. Native backup and restore is a supported method for migrating the database itself, and then you can script and deploy the jobs and linked servers using T-SQL. Other migration methods do not handle these instance-level objects.

Answer

Use AWS DMS to migrate the database, and DMS will automatically migrate SQL Server Agent jobs and linked servers.

Answer

Use the RDS for SQL Server native backup and restore, and RDS will automatically enable and configure SQL Server Agent and linked servers based on the backup.

Answer

Use the AWS Schema Conversion Tool (AWS SCT) to convert the database, and it will also migrate SQL Server Agent jobs and linked servers.

Question 8

A company is migrating a large on-premises MongoDB database to Amazon DocumentDB. The migration must be completed with minimal downtime. The database is 500 GB and has a high write throughput. Which AWS service should be used to perform the migration?

Accepted Answer

AWS Database Migration Service (AWS DMS) with ongoing replication. AWS DMS supports MongoDB to Amazon DocumentDB migrations with ongoing replication, enabling minimal downtime. It performs a full load and then continuously replicates changes, so the cutover can be quick. Native tools or offline methods would cause significant downtime and are not suitable for high write throughput.

Answer

AWS Snowball Edge

Answer

AWS DataSync

Answer

MongoDB native tools like mongodump and mongorestore

Question 9

A company is migrating a large on-premises MySQL database to Amazon Aurora MySQL. They want to minimize downtime and ensure data consistency. They have set up an AWS Database Migration Service (AWS DMS) task with ongoing replication. During the migration, they notice that the target Aurora cluster is experiencing high write latency. Which action should the company take to improve write performance on the target?

Accepted Answer

Configure the AWS DMS task to use a higher number of apply threads.. High write latency on the Aurora target during DMS replication is often due to serialized apply of changes. AWS DMS allows configuring multiple apply threads to parallelize writes, which can greatly improve throughput and reduce latency. This is a targeted adjustment that leverages Aurora's ability to handle concurrent transactions. Other options like instance resizing or binary logging do not directly address the apply bottleneck.

Answer

Modify the AWS DMS task to use a smaller batch size for apply.

Answer

Enable binary logging on the Aurora cluster.

Answer

Increase the instance size of the Aurora cluster.

Question 10

A financial services company is deploying a new Amazon Aurora PostgreSQL database cluster. They require that the database be encrypted at rest using a customer managed AWS KMS key and that encryption cannot be changed after creation. They also need to ensure that snapshots and automated backups are encrypted. Which action should be taken to meet these requirements?

Accepted Answer

Enable encryption at rest when creating the Aurora cluster and specify the customer managed KMS key.. Aurora encryption at rest is enabled only at cluster creation. You must specify the customer managed KMS key during creation. Once set, encryption cannot be disabled or changed. Automated backups and snapshots inherit the encryption. Therefore, the correct action is to enable encryption and choose the customer managed key when creating the cluster.

Answer

Create the Aurora cluster with encryption using the default AWS managed KMS key, then later change to a customer managed key.

Answer

Create the Aurora cluster without encryption, then modify the cluster to enable encryption using the customer managed KMS key.

Answer

Create the Aurora cluster with encryption using a customer managed KMS key, and enable encryption on automated backups separately.

Question 11

A company is migrating a large on-premises Oracle database to Amazon Aurora PostgreSQL using AWS Schema Conversion Tool (AWS SCT) and AWS Database Migration Service (AWS DMS). During the migration, they encounter issues with stored procedures and functions. The company needs to ensure that the converted code is functionally equivalent and performs well. Which action should they take to validate and optimize the converted code?

Accepted Answer

Use AWS SCT to convert the code, then use the AWS SCT assessment report and action items to manually refactor problematic objects. AWS SCT converts procedural code and provides an assessment report that identifies objects needing manual intervention. By using the report and action items, you can refactor problematic code to ensure functional equivalence and performance. This is the standard approach for migrating stored procedures and functions. Other options either do not address validation or are not supported.

Answer

Manually rewrite all stored procedures and functions from scratch in PL/pgSQL to ensure optimal performance

Answer

Use AWS DMS to replicate the stored procedures and functions directly, as DMS supports procedural code replication

Answer

Use AWS SCT to automatically convert the code and then run the application against Aurora PostgreSQL to identify issues

Question 12

A company is migrating a large on-premises MySQL database to Amazon Aurora MySQL. The migration must be completed with minimal downtime, and the cutover should be quick. The company plans to use AWS DMS with a replication instance. Which TWO actions should be taken to achieve minimal downtime during the cutover? (Choose two.)

Accepted Answer

Enable change data capture (CDC) on the source database before starting the full load.. To achieve minimal downtime with AWS DMS, you must enable CDC to capture ongoing changes and pre-create the target schema to avoid delays during the full load. CDC keeps the target synchronized so that the cutover only requires a brief pause in writes. Pre-creating schema and indexes ensures that the full load runs efficiently and the target is ready for cutover as soon as replication catches up.

Answer

Use full LOB mode to ensure all large objects are migrated quickly.

Answer

Use a single replication instance with maximum allocated storage to handle the full load and CDC.

Answer

Configure the replication instance in a single Availability Zone to reduce latency.

Question 13

A company is migrating an on-premises Oracle database to Amazon RDS for Oracle. The database is 8 TB and the network link between the data center and AWS has a bandwidth of 100 Mbps. The company needs to complete the migration within a 5-day maintenance window and wants to use AWS DMS for the cutover. Which approach should be used to meet these requirements with minimal downtime?

Accepted Answer

Order an AWS Snowball Edge device, copy the backup to it, ship it to AWS, and then restore to RDS for Oracle. Use AWS DMS for ongoing replication after the initial load.. The correct approach is to use AWS Snowball Edge for the initial bulk transfer because the existing network bandwidth is insufficient to move 8 TB within 5 days. After the data is loaded into Amazon RDS for Oracle, AWS DMS can replicate ongoing changes from the on-premises database to the RDS instance, allowing for a cutover with minimal downtime once replication catches up.

Answer

Use AWS DMS with a direct internet connection for the full load and change data capture (CDC).

Answer

Use AWS DMS with a direct connect connection at 1 Gbps and perform a full load and CDC.

Answer

Use AWS Database Migration Service (AWS DMS) with a VPN connection and enable compression to speed up the transfer.

Question 14

A company is deploying an Amazon RDS for MySQL Multi-AZ DB cluster. The company wants to ensure that the cluster can survive an Availability Zone failure with minimal downtime and that the data is durably stored. Which statement describes the replication and failover behavior of this deployment?

Accepted Answer

The cluster uses synchronous replication to two standby instances in different Availability Zones, and failover is automatic.. Amazon RDS for MySQL Multi-AZ DB clusters provide a writer and two readers across three AZs. Data is synchronously replicated to both readers, ensuring durability and zero data loss on failover. Failover is automatic and typically completes within 60 seconds, providing minimal downtime. This architecture is designed for high availability and fault tolerance.

Answer

The cluster uses asynchronous replication to a standby replica in another Availability Zone, and failover is automatic.

Answer

The cluster uses asynchronous replication to two standby instances in different Availability Zones, and failover is automatic.

Answer

The cluster uses synchronous replication to one standby instance in another Availability Zone, and failover is manual.

Question 15

A company is planning to migrate a large on-premises MySQL database to Amazon Aurora MySQL. They want to minimize downtime and ensure data consistency. They will use AWS DMS. Which TWO actions should be taken to meet these requirements? (Choose two.)

Accepted Answer

Configure the AWS DMS task to perform a full load and ongoing replication (CDC).. To minimize downtime and ensure consistency, the DMS task must perform both a full load and ongoing replication (CDC). This requires binary logging on the source MySQL database with ROW format. These two actions allow DMS to copy existing data and continuously apply changes, enabling a quick cutover. The other options are either incorrect or not essential for the stated requirements.

Answer

Set the target endpoint to use the 'Drop and create tables' mode for the full load.

Answer

Configure the AWS DMS replication instance in the same AWS Region as the target Aurora cluster.

Answer

Use a single-AZ Aurora cluster to reduce replication latency.