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

Question 1

A company is migrating a 2 TB on-premises Microsoft SQL Server database to Amazon RDS for SQL Server. The migration must have minimal downtime. The company uses AWS DMS with ongoing CDC. During the full load phase, the DMS task fails with an error indicating that the source table 'Orders' has a large number of LOB columns and the task is running out of memory. The DMS replication instance is a dms.c4.large with 4 GB RAM. The company needs to complete the migration successfully. What should the company do?

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

Accepted Answer

Increase the replication instance size to dms.c4.xlarge (8 GB RAM).. Increasing the replication instance size provides more memory to handle LOB columns during the full load phase. Option A is incorrect because setting the LOB chunk size to 64 KB may reduce memory consumption per LOB but might not be sufficient to resolve the out-of-memory error; increasing instance size is a more direct solution. Option C is incorrect because splitting the table into multiple tasks does not address the underlying memory constraint; it could even increase memory usage due to multiple tasks running simultaneously. Option D is incorrect because disabling LOB support would truncate LOB data, leading to data loss.

Answer

Set the LOB chunk size to 64 KB in the task settings.

Answer

Split the 'Orders' table into multiple DMS tasks running in parallel.

Answer

Change the DMS task settings to disable LOB support for the 'Orders' table.

Question 2

A company is deploying a new application on Amazon RDS for PostgreSQL. The application requires a database with a specific parameter group that sets 'max_connections' to 500 and 'shared_buffers' to 25% of the instance memory. The company uses CloudFormation to deploy the RDS instance. The CloudFormation template creates a DBInstance with a DBParameterGroup. The deployment fails because the parameter group cannot be associated with the DB instance. What is the most likely cause?

Accepted Answer

The parameter group uses an invalid value for 'shared_buffers' because it must be an integer, not a percentage.. The most likely cause is that the parameter group uses an invalid value for 'shared_buffers' because it must be an integer, not a percentage. In RDS for PostgreSQL, parameter values must be specified as integers or specific units, not as percentages. The parameter group cannot be associated with the DB instance if it contains invalid parameter values. Other options are less likely because 'max_connections' of 500 is valid for many instance classes, CloudFormation does not require a DependsOn clause for parameter groups, and parameter groups are region-specific but the template would create it in the same region.

Answer

The 'max_connections' value of 500 exceeds the allowed maximum for the instance class.

Answer

The CloudFormation template does not include a DependsOn clause linking the DBParameterGroup to the DBInstance.

Answer

The DBParameterGroup is not in the same region as the DBInstance.

Question 3

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 can sustain 200 Mbps. The company wants to complete the migration in under 24 hours with minimal downtime. Which AWS service should they use to transfer the database backup files?

Accepted Answer

AWS Snowball Edge. When network bandwidth is insufficient to transfer large database backups within the required window, AWS Snowball Edge is the appropriate choice. It physically moves the data, avoiding the 200 Mbps bottleneck, and integrates with AWS for import into S3. AWS DMS, DataSync, and Storage Gateway all rely on the network and cannot meet the time constraint for 8 TB.

Answer

AWS Database Migration Service (AWS DMS) with a change data capture (CDC) task

Answer

AWS Storage Gateway file gateway

Answer

AWS DataSync

Question 4

A company is migrating an on-premises Oracle database to Amazon RDS for Oracle. The database is 8 TB, and the company's network has a consistent 200 Mbps upload bandwidth. The migration must be completed within 24 hours. Which service should be used to transfer the database backup files to Amazon S3?

Accepted Answer

AWS Snowball Edge. For large datasets and limited bandwidth, AWS Snowball Edge is the appropriate service to meet tight time constraints. It physically moves the data, bypassing network transfer limitations. Once the device is shipped to AWS, the data is copied to Amazon S3, and then the Oracle backup files can be restored to RDS for Oracle using the native backup and restore feature, satisfying the 24-hour requirement.

Answer

AWS Database Migration Service (AWS DMS)

Answer

AWS Storage Gateway file gateway

Answer

AWS DataSync

Question 5

A company is migrating its on-premises Oracle database to Amazon RDS for Oracle. The database is 2 TB and the company requires near-zero downtime during cutover. They have established a 1 Gbps AWS Direct Connect connection. Which migration approach should be used?

Accepted Answer

Use AWS Database Migration Service (AWS DMS) with ongoing replication to synchronize the on-premises database with RDS for Oracle, then cut over during a maintenance window.. AWS DMS with ongoing replication is the correct choice because it minimizes downtime by continuously replicating changes from the source to the target. The other methods either require downtime, are unsupported for hybrid configurations, or involve offline data transfer that cannot keep up with ongoing changes. This ensures a smooth cutover with minimal disruption.

Answer

Take a full database export using Oracle Data Pump, transfer the dump file over Direct Connect, and import it into RDS for Oracle.

Answer

Use AWS Snowball Edge to transfer a physical backup to AWS, restore it to Amazon S3, and then import it into RDS for Oracle using Amazon RDS procedures.

Answer

Configure Oracle Data Guard between the on-premises database and RDS for Oracle to maintain a standby copy, then perform a switchover.

Question 6

A company is migrating an on-premises Oracle database to Amazon RDS for Oracle. The database is 2 TB and must be migrated with minimal downtime. The company has a 100 Mbps dedicated network connection. Which AWS service should be used to perform the migration?

Accepted Answer

AWS Database Migration Service (AWS DMS) with change data capture (CDC). AWS DMS with change data capture allows for a full load followed by continuous replication of changes, enabling minimal downtime cutover. The other options either require downtime or are not supported for RDS for Oracle. DMS is the AWS-recommended service for heterogeneous and homogeneous migrations with minimal downtime.

Answer

Oracle Data Guard to replicate to Amazon RDS for Oracle

Answer

AWS Snowball Edge to transfer the database backup files

Answer

Native Oracle export/import utilities

Question 7

A company is deploying a new Amazon Aurora MySQL database cluster. The security team requires that all data at rest and in transit be encrypted, and that the encryption keys be managed by the company. The database must be able to fail over to a secondary region in case of a regional outage. Which combination of steps should be taken to meet these requirements?

Accepted Answer

Create an Aurora MySQL cluster with encryption at rest using an AWS KMS customer managed key, enable SSL/TLS for connections, and create an Aurora Global Database.. To meet encryption at rest with customer-managed keys, in-transit encryption, and cross-region failover, you must create an Aurora MySQL cluster with a customer managed KMS key, enable SSL/TLS, and use an Aurora Global Database. Aurora Global Database is the only Aurora feature that provides cross-region disaster recovery with low-latency replication.

Answer

Create an Aurora MySQL cluster without encryption at rest, enable SSL/TLS for connections, and create an Aurora Global Database.

Answer

Create an Aurora MySQL cluster with encryption at rest using a customer managed key, disable SSL/TLS, and create an Aurora Global Database.

Answer

Create an Aurora MySQL cluster with encryption at rest using the default AWS managed key, enable SSL/TLS for connections, and create a cross-region read replica.

Question 8

A financial services company is deploying a new Amazon Aurora MySQL cluster for a trading analytics application. The database must be highly available across three Availability Zones and survive an AZ failure with minimal downtime. The company wants to use the most cost-effective Aurora configuration that meets these requirements. Which deployment approach should a database specialist recommend?

Accepted Answer

Create an Aurora MySQL cluster with one writer instance and two Aurora Replicas in different Availability Zones.. Aurora automatically replicates data six ways across three Availability Zones. Adding Aurora Replicas in separate AZs enables automatic failover to a replica if the writer fails, with minimal downtime. This configuration is cost-effective because it uses Aurora's built-in storage replication and does not require cross-Region resources. Global Database and manual snapshots are not appropriate for single-Region AZ resilience.

Answer

Create an Aurora MySQL global database with a primary Region and a secondary Region for failover.

Answer

Create an Aurora MySQL cluster with a single writer instance and enable Multi-AZ deployment at the cluster level.

Answer

Create an Aurora MySQL cluster with a writer instance in one AZ and configure a manual snapshot copy to another AZ.

Question 9

A company is planning to migrate a 10 TB MySQL database from on-premises to Amazon Aurora MySQL. The migration must be completed with minimal downtime. The company has a 10 Gbps AWS Direct Connect connection. Which TWO actions should be taken to meet these requirements? (Choose two.)

Accepted Answer

Pre-create the Aurora cluster and configure the source database to write binary logs, then use AWS DMS to perform a full load plus CDC.. Using AWS DMS with CDC and pre-creating the Aurora cluster with binary logging enabled are essential for a minimal downtime migration. DMS handles both the initial full load and ongoing replication, while pre-configuring the target ensures readiness. The other options either introduce downtime, use inappropriate tools, or focus on HA/DR rather than migration.

Answer

Take a mysqldump of the source database and restore it to Aurora, then set up binary log replication.

Answer

Use AWS Snowball Edge to transfer the database backup to Amazon S3, then use AWS DMS to load from S3 to Aurora.

Answer

Enable multi-AZ on the Aurora cluster and use Aurora Global Database for replication.

Question 10

A company is planning to migrate an on-premises Oracle database to Amazon RDS for Oracle. The database is 10 TB and has a high transaction rate. The company wants to minimize downtime during the migration and needs to ensure data consistency. Which two actions should be taken to meet these requirements? (Choose two.)

Accepted Answer

Configure the RDS for Oracle instance with the same character set and national character set as the source database.. To minimize downtime and ensure data consistency when migrating a large Oracle database to RDS for Oracle, use AWS DMS with CDC for ongoing replication, and ensure the target instance uses the same character sets as the source. DMS handles the initial load and ongoing changes, while matching character sets prevents data corruption. These two actions directly address the requirements.

Answer

Use AWS Snowball Edge to transfer the database backup files to Amazon S3.

Answer

Enable automatic backups on the RDS for Oracle instance.

Answer

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

Question 11

A company is migrating an on-premises Oracle database to Amazon RDS for Oracle. The database is 8 TB and the company has a 24-hour maintenance window. The network link between the on-premises data center and AWS has a bandwidth of 100 Mbps. The company wants to minimize downtime and ensure data consistency. Which migration strategy should a database specialist use?

Accepted Answer

Use AWS Snowball Edge to transfer the database backup to Amazon S3, then restore to RDS for Oracle.. With 8 TB of data and only 100 Mbps of bandwidth, transferring over the network would far exceed the 24-hour window. AWS Snowball Edge allows physically shipping the data to AWS, bypassing network limitations. Once the backup is in Amazon S3, it can be restored to RDS for Oracle. This strategy minimizes downtime and ensures data consistency.

Answer

Use AWS DataSync to copy the database files to Amazon EFS, then attach EFS to RDS for Oracle.

Answer

Use Oracle Data Guard to replicate the database to an EC2 instance, then convert it to RDS for Oracle.

Answer

Use AWS Database Migration Service (AWS DMS) with ongoing replication to migrate the database over the network.

Question 12

A company wants to migrate an on-premises Oracle database to Amazon RDS for Oracle using AWS Database Migration Service (AWS DMS). The database is 1.5 TB and can tolerate a downtime of up to 4 hours. The company needs to minimize the migration time and avoid using the source database for the initial load. Which DMS source endpoint setting should be used to achieve this?

Accepted Answer

Use the Oracle Standby feature (Active Data Guard) and point DMS to the standby database.. The correct approach is to use an Oracle Active Data Guard standby as the DMS source. This offloads the full load and CDC read operations from the primary database, reducing source overhead and potentially speeding up the migration. DMS supports connecting to a standby for both full load and change data capture, provided the standby is configured properly. Other options either add source overhead or are not valid DMS settings.

Answer

Enable Oracle LogMiner for change data capture (CDC).

Answer

Use Oracle Data Pump to export the data to Amazon S3, then load from S3 using DMS.

Answer

Set the DMS source endpoint to use Oracle LogMiner and enable 'Read replica' mode.

Question 13

A media company is deploying a new Amazon Aurora MySQL cluster to replace an aging on-premises MySQL 5.7 database. The application team needs the ability to run analytical queries against the same data without impacting transactional workload performance. The team also wants to minimize data staleness on the analytics endpoint. Which deployment approach should a database specialist recommend?

Accepted Answer

Create an Amazon Aurora MySQL cluster and enable the Amazon Aurora zero-ETL integration with Amazon Redshift to replicate data into a Redshift cluster for analytics.. Aurora zero-ETL integration with Amazon Redshift streams changes from the Aurora cluster into Redshift, giving a separate analytics engine that does not compete with transactional queries. Because replication is near real-time, the analytics endpoint stays close to current, satisfying both workload isolation and low staleness without custom ETL or impacting the primary cluster.

Answer

Create an Amazon Aurora MySQL cluster and enable Aurora parallel query so analytical queries are pushed down to the storage layer.

Answer

Create an Amazon Aurora MySQL cluster and add an Aurora Replica configured as a dedicated analytics node that reads from the shared cluster volume.

Answer

Create an Amazon Aurora MySQL cluster and add a reader endpoint that serves read-only queries from the same shared storage volume.

Question 14

A company is migrating a 4 TB on-premises Oracle database to Amazon RDS for Oracle. The database must remain fully available during the cutover, and the business requires that any changes made after the initial load are applied to the target with sub-second latency. The migration team has already provisioned the RDS for Oracle instance and configured AWS DMS. Which combination of source and target endpoints should they use to meet the latency requirement?

Accepted Answer

Source endpoint using Oracle LogMiner and target endpoint using the Amazon RDS for Oracle direct endpoint. For ongoing replication from Oracle into Amazon RDS for Oracle, DMS must read changes from the source redo logs using Oracle LogMiner and apply them directly to the RDS for Oracle target endpoint. LogMiner captures committed changes continuously, and the RDS direct endpoint supports low-latency apply, meeting the sub-second requirement while keeping the source available.

Answer

Source endpoint using Oracle LogMiner and target endpoint using AWS Database Migration Service replication instance storage

Answer

Source endpoint using Oracle Binary Reader and target endpoint using Amazon S3

Answer

Source endpoint using Oracle Data Pump and target endpoint using the Amazon RDS for Oracle direct endpoint

Question 15

A company is migrating its on-premises Oracle database to Amazon RDS for Oracle. The database uses a non-standard character set (WE8ISO8859P1) and contains national character set columns. The company wants the migration to be as seamless as possible. Which approach should they take?

Accepted Answer

Use Oracle Data Pump to export the data, then import it into an RDS for Oracle instance with a supported character set, after converting the data.. Amazon RDS for Oracle enforces a limited set of character sets, and the source WE8ISO8859P1 is not supported. The only viable method is to use Oracle Data Pump to export, convert the data to a supported character set (like AL32UTF8), and then import into RDS. This ensures data integrity and compatibility throughout the migration process.

Answer

Use AWS SCT to convert the schema and then use AWS DMS to migrate the data, relying on SCT to handle character set conversion.

Answer

Use AWS DMS with the Oracle endpoint configured to use the same character set as the source.

Answer

Create an RDS for Oracle instance with the same character set and national character set as the source.