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

Question 1

A company is migrating an on-premises Oracle database to Amazon RDS for Oracle. The database uses a non-standard block size of 16 KB. The company wants to use AWS DMS with a change data capture (CDC) task for ongoing replication. Which source endpoint configuration is required to ensure the CDC task captures changes correctly?

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

Accepted Answer

Set the extra connection attribute 'useLogminerReader' to true and ensure supplemental logging is enabled.. AWS DMS requires the Binary Reader for Oracle sources with non-standard block sizes. Setting useLogminerReader to true enables this reader, and supplemental logging must be active for CDC. This ensures DMS can parse redo logs and replicate changes. Other options either disable the required reader or introduce irrelevant settings.

Answer

Add the extra connection attribute 'directPathLoad' and set 'readTableSpaceName' to true.

Answer

Configure the source endpoint to use Oracle Standby mode and enable archive log mode.

Answer

Enable supplemental logging at the database level and set the extra connection attribute 'useLogminerReader' to false.

Question 2

A financial services company is migrating its on-premises Microsoft SQL Server database to Amazon RDS for SQL Server. The database is 2 TB and the company requires that the migration be completed with minimal downtime. They plan to use native backup and restore. Which of the following is a valid approach to minimize downtime when using native backup and restore?

Accepted Answer

Perform a full backup, restore it to RDS, then repeatedly restore differential backups until cutover.. To minimize downtime with native backup and restore for SQL Server to RDS, you can restore a full backup and then apply differential backups as they are taken. At cutover, you restore the final differential backup, which is much smaller and faster than a full backup. This reduces the downtime window significantly compared to restoring only a full backup.

Answer

Enable Change Data Capture (CDC) on the source and use AWS DMS to replicate changes.

Answer

Use log shipping to continuously restore transaction log backups to the RDS instance.

Answer

Create a read replica of the on-premises database in RDS and promote it at cutover.

Question 3

A company is migrating a 12 TB on-premises Oracle database to Amazon RDS for Oracle. The network link between the data center and AWS is 500 Mbps and cannot be upgraded. The database must be migrated with minimal downtime, and the cutover must occur within a 30-minute window. Which combination of AWS services should be used to accomplish this migration?

Accepted Answer

AWS Snowball Edge to transfer the initial data, followed by AWS DMS with change data capture (CDC) for ongoing replication. AWS Snowball Edge accelerates the initial transfer of large data volumes when network bandwidth is limited and cannot be increased. After the data is loaded into Amazon RDS for Oracle, AWS DMS with change data capture continuously replicates ongoing changes from the on-premises source. This hybrid approach minimizes downtime because the bulk of the data is moved offline, and only the delta is synchronized over the network before a quick cutover.

Answer

AWS Database Migration Service (AWS DMS) with an Amazon S3 endpoint for the initial load, followed by ongoing replication using AWS DMS change data capture (CDC)

Answer

AWS DataSync to copy the Oracle data files to Amazon S3, then use AWS DMS to load from S3 to RDS for Oracle

Answer

Oracle Data Pump export/import over the network using AWS Direct Connect with a 1 Gbps connection

Question 4

A company is migrating an on-premises Oracle database to Amazon RDS for Oracle. The database uses a non-standard block size of 16 KB. The company wants to use AWS DMS with a change data capture (CDC) task for ongoing replication. Which source endpoint configuration is required to ensure the CDC task captures changes correctly?

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

Accepted Answer

Use AWS Snowball Edge to transfer a physical backup, then restore to RDS for Oracle.. The scenario requires transferring 2 TB within 24 hours over a limited 100 Mbps link, which is not feasible with network-based migration. AWS Snowball Edge allows physical shipment of data, bypassing bandwidth constraints. It also minimizes impact on the production database because the backup is taken and shipped without continuous load. Other methods either exceed the time window or are unsupported on RDS for Oracle.

Answer

Use AWS Database Migration Service (AWS DMS) with a direct connect link and full load only.

Answer

Use Oracle Data Guard to replicate the on-premises database to Amazon RDS for Oracle.

Answer

Use AWS DMS with full load and change data capture (CDC) over the internet.

Question 5

A company is deploying an Amazon DynamoDB table for a new application. The application requires strong read consistency and the ability to handle sudden spikes in traffic without manual intervention. The table must be highly available across multiple Availability Zones. Which configuration should be used?

Accepted Answer

Create a DynamoDB table with on-demand capacity mode and use strongly consistent reads in the application.. On-demand capacity mode in DynamoDB automatically scales to handle sudden traffic spikes, and DynamoDB is highly available by design. Strongly consistent reads can be requested per operation. Other options either do not provide strong consistency or do not handle spikes as efficiently.

Answer

Create a DynamoDB table with provisioned capacity mode and enable DynamoDB Accelerator (DAX).

Answer

Create a DynamoDB table with on-demand capacity mode and enable DynamoDB Streams.

Answer

Create a DynamoDB table with provisioned capacity mode and set up Auto Scaling.

Question 6

A company is deploying an Amazon Aurora PostgreSQL cluster that must be encrypted at rest using a customer-managed AWS KMS key. The security team requires that the key be rotated every 90 days. Which action should be taken to meet these requirements?

Accepted Answer

Create a customer-managed KMS key without automatic rotation, and manually rotate the key every 90 days by creating a new key and updating the alias.. AWS KMS automatic rotation is fixed at approximately every 365 days and cannot be customized. To meet a 90-day rotation requirement, you must manually create new customer-managed keys every 90 days and update the alias. This ensures that new data is encrypted with a fresh key, while old data remains decryptable with the previous key versions.

Answer

Create a customer-managed KMS key with automatic rotation enabled, and use it when creating the Aurora cluster.

Answer

Create a customer-managed KMS key with automatic rotation enabled, and use it to encrypt the Aurora cluster; then use AWS Lambda to rotate the key every 90 days via the KMS API.

Answer

Use an AWS managed key for Aurora and enable automatic rotation with a 90-day schedule using a custom KMS key policy.

Question 7

A media company runs an on-premises Oracle database that must be migrated to Amazon RDS for Oracle. The database is 4 TB, and the business requires that the cutover outage not exceed 30 minutes. The network link between the data center and AWS supports 200 Mbps of sustained throughput, and the database generates roughly 40 GB of redo per day. Which migration approach should be used?

Accepted Answer

Use AWS Database Migration Service with a change data capture task and an Oracle standby replication instance to keep the target in sync until cutover.. Continuous replication with change data capture decouples the slow bulk copy from the cutover. The initial full load of 4 TB runs ahead of time over the limited link while ongoing redo is captured and applied to the target. Only the residual change backlog must be flushed during the maintenance window, which keeps the outage within the 30-minute requirement instead of transferring the whole database live.

Answer

Configure an Oracle Active Data Guard standby on an Amazon EC2 instance and then convert the EC2 instance into an RDS for Oracle DB instance at cutover.

Answer

Take a full RMAN backup, copy the backup files to Amazon S3, and restore them into RDS for Oracle during the maintenance window.

Answer

Export the schema with Oracle Data Pump, transfer the dump file over the network, and import it into RDS for Oracle during the maintenance window.

Question 8

A company is deploying a new Amazon Aurora PostgreSQL database cluster. They need to ensure that the cluster can be restored to any point in time within the last 35 days. They also want to minimize storage costs. Which backup strategy should they implement?

Accepted Answer

Enable automated backups with a retention period of 35 days and rely on Aurora's continuous backup to Amazon S3.. Amazon Aurora automatically maintains continuous backups to Amazon S3, enabling point-in-time recovery to any second within the retention period. By setting the backup retention period to 35 days, the company can restore to any point in time within that window. This is the most cost-effective and operationally simple solution because it requires no additional backup mechanisms and storage costs are based on the incremental changes stored in S3.

Answer

Take daily manual snapshots and retain them for 35 days.

Answer

Use AWS Backup to create daily backups with a 35-day retention and store them in a cold storage tier.

Answer

Enable automated backups with a retention period of 35 days and also enable Aurora Backtrack.

Question 9

A company is migrating an on-premises Cassandra database to Amazon Keyspaces (for Apache Cassandra). They need to ensure that the migration is performed efficiently and with minimal downtime. Which TWO actions should they take to prepare for the migration? (Choose two.)

Accepted Answer

Create a target keyspace and tables in Amazon Keyspaces with the same schema as the source.. To migrate from Cassandra to Amazon Keyspaces, you must first create the target keyspace and tables with matching schemas. Then, you can use AWS DMS to migrate the data. DMS supports Amazon Keyspaces as a target and can handle the data transfer efficiently. These two actions are essential for a successful migration.

Answer

Use the Cassandra Query Language (CQL) COPY command to export data to CSV files.

Answer

Enable CDC on the source Cassandra cluster and use it with AWS DMS.

Answer

Use the cassandra-stress tool to validate the target keyspace performance.

Question 10

A company is migrating a large on-premises Microsoft SQL Server database to Amazon RDS for SQL Server. The database uses Transparent Data Encryption (TDE) with a certificate stored in the master database. The company wants to use native backup and restore to minimize downtime. Which steps should be taken to ensure a successful migration?

Accepted Answer

Export the TDE certificate and private key from the source SQL Server, upload them to Amazon RDS, and then restore the encrypted backup.. To restore a TDE-encrypted SQL Server database to RDS, you must export the TDE certificate and private key from the source instance and upload them to the RDS instance before restoring the backup. This allows RDS to decrypt the database. Disabling TDE or relying on AWS DMS does not meet the requirements for a native backup and restore with minimal downtime.

Answer

Back up the database with TDE enabled, copy the backup to Amazon S3, and restore it to RDS for SQL Server using the native restore procedure.

Answer

Use AWS DMS to migrate the database, as it automatically handles TDE-encrypted databases.

Answer

Disable TDE on the source database, back up the database, and restore it to RDS for SQL Server without encryption.

Question 11

A company is migrating an on-premises Microsoft SQL Server database to Amazon RDS for SQL Server. The database is 2 TB and the company has a maintenance window of 4 hours. They need to minimize downtime and ensure data consistency. Which migration approach should be used?

Accepted Answer

Use AWS DMS with full load and change data capture (CDC) to replicate ongoing changes.. AWS DMS with full load and CDC allows the source database to remain online during the bulk of the migration, with only a brief cutover. This approach is ideal for large databases with tight maintenance windows. Native backup and restore methods require significant downtime and are not suitable for the 4-hour window.

Answer

Use native SQL Server backup and restore to Amazon RDS for SQL Server.

Answer

Take a full backup, ship it to Amazon S3, and restore it using Amazon RDS for SQL Server's native restore.

Answer

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

Question 12

A company is migrating an on-premises Microsoft SQL Server database to Amazon RDS for SQL Server. The database is 500 GB and they want to use native backup and restore to minimize downtime. They have a limited maintenance window of 2 hours. Which method should they use to migrate the database with minimal downtime?

Accepted Answer

Use native backup and restore by backing up the database to Amazon S3 and restoring it to RDS.. Native backup and restore is a fast method for migrating large SQL Server databases to RDS. By backing up to S3 and restoring to RDS, you can minimize downtime. AWS DMS is also viable but may take longer for setup and full load. SSIS and replication are not optimal for a 2-hour window. Therefore, native backup and restore is the best choice.

Answer

Use AWS Database Migration Service (AWS DMS) with full load and CDC.

Answer

Use SQL Server Integration Services (SSIS) to export and import data.

Answer

Use SQL Server replication to replicate the database to RDS.

Question 13

A company is migrating an on-premises Microsoft SQL Server database to Amazon RDS for SQL Server. The database is 2 TB and must be migrated with minimal downtime. The company wants to use AWS Database Migration Service (AWS DMS) for the migration. Which source endpoint configuration is required to enable ongoing replication (change data capture) from the on-premises SQL Server?

Accepted Answer

Enable MS-CDC on the source database and grant the AWS DMS user the db_owner role plus VIEW SERVER STATE and SELECT on the CDC schema.. For SQL Server, AWS DMS uses MS-CDC to capture ongoing changes. The source database must have MS-CDC enabled, and the DMS user must have permissions to read the CDC tables and the transaction log. The required permissions include VIEW SERVER STATE, SELECT on the CDC schema, and execute on the CDC stored procedures. While db_owner is not strictly required, it is commonly granted in AWS documentation to simplify setup. The key is that the user must be able to access the CDC data.

Answer

Enable MS-CDC on the source database and grant the AWS DMS user the sysadmin role.

Answer

Enable MS-CDC on the source database and grant the AWS DMS user the db_owner role.

Answer

Enable MS-CDC on the source database and grant the AWS DMS user the db_datareader role.

Question 14

A financial services firm is migrating a 6 TB on-premises MySQL 8.0 database to Amazon Aurora MySQL. Regulatory rules forbid the use of AWS DMS and require that the target be validated with binary log coordinates before promotion. The firm wants the smallest possible cutover outage and can tolerate a short read-only period. Which approach meets these constraints?

Accepted Answer

Use mydumper to produce a consistent snapshot with recorded binlog coordinates, restore it into Aurora MySQL, then use mysqlbinlog to replay the captured binary logs from that coordinate onto the Aurora writer until cutover.. Capturing a consistent snapshot together with its binary log coordinates gives both a fast bulk load and a defensible, verifiable replication starting point. After the snapshot is restored into Aurora MySQL, replaying the source binary logs advances the target to the cutover point, and the recorded coordinates provide the binary-log validation the regulations require before the Aurora cluster is promoted to production.

Answer

Run mysqldump with --single-transaction against the source, stream the output into the Aurora writer endpoint, then rely on Aurora Backtrack to reconcile any rows written during the load.

Answer

Create an Aurora MySQL read replica of the on-premises database using the AWS Management Console cross-region replica wizard, then promote the replica at cutover.

Answer

Configure Aurora MySQL binary log replication by setting the cluster parameter binlog_format to ROW, then point the source MySQL server at the Aurora writer endpoint as a replica.

Question 15

A company is migrating a large on-premises Microsoft SQL Server database to Amazon RDS for SQL Server. The database uses Transparent Data Encryption (TDE) and the company wants to maintain encryption at rest in AWS. The migration must be completed with minimal downtime. Which method should be used to migrate the database while preserving TDE?

Accepted Answer

Use native SQL Server backup and restore with TDE certificate.. To preserve TDE when migrating to Amazon RDS for SQL Server, the native backup and restore method is required. It allows you to include the TDE certificate and private key, ensuring the restored database remains encrypted. This method also supports minimal downtime through differential or log backups. Other methods like AWS DMS or transactional replication do not carry over TDE settings and would require re-encryption on the target.

Answer

Use AWS DMS to migrate the database with full load and CDC.

Answer

Use AWS Database Migration Service with a custom endpoint for TDE.

Answer

Use SQL Server transactional replication to replicate data to RDS.