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

Question 1

A company is migrating a 10 TB Oracle database to Amazon Aurora PostgreSQL. They need to minimize downtime and ensure data consistency. Which TWO steps should be included in the migration plan? (Choose two.)

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

Accepted Answer

Use AWS Schema Conversion Tool (AWS SCT) to convert the Oracle schema to PostgreSQL.. For a heterogeneous migration from Oracle to Aurora PostgreSQL, AWS SCT is required to convert the schema, and AWS DMS with CDC is needed to migrate data with minimal downtime. The combination ensures that the schema is compatible and that ongoing changes are replicated until cutover. Other options do not address the core requirements of schema conversion and continuous data replication.

Answer

Use Oracle Data Pump to export the database and import it directly into Aurora PostgreSQL.

Answer

Enable Aurora Global Database to replicate data from the on-premises Oracle database.

Answer

Create an Aurora PostgreSQL read replica in the same AWS Region and promote it after migration.

Question 2

A company is deploying a new Amazon RDS for MySQL database. They want to ensure that the database is highly available and can automatically fail over to a standby instance in case of an Availability Zone failure. Which feature should they enable?

Accepted Answer

Multi-AZ deployment. Multi-AZ deployment is the correct feature for automatic failover in Amazon RDS for MySQL. It maintains a synchronous standby in another Availability Zone and automatically promotes it if the primary fails. Read replicas, automated backups, and RDS Proxy do not provide automatic failover on their own.

Answer

Amazon RDS Proxy

Answer

Read replicas

Answer

Automated backups

Question 3

A company is deploying a new Amazon Aurora PostgreSQL database cluster. They require that the database be encrypted at rest using a customer managed key (CMK) in AWS KMS. They also need to ensure that snapshots of the database are encrypted with the same CMK. Which configuration should be used?

Accepted Answer

Enable encryption at rest when creating the Aurora cluster and select the CMK.. To encrypt an Aurora cluster with a CMK, you must specify the CMK during cluster creation. Encryption cannot be enabled after creation. Snapshots of the encrypted cluster will automatically use the same CMK. This ensures both the database and snapshots are encrypted with the desired key.

Answer

Enable encryption at rest on the Aurora cluster using the default AWS managed key, and then use AWS KMS grants to allow access to the CMK for snapshots.

Answer

Enable encryption on the Aurora cluster using the default AWS managed key, then create a copy of the cluster with the CMK.

Answer

Create the Aurora cluster without encryption, then modify it to enable encryption using the CMK.

Question 4

A company is deploying a new Amazon RDS for SQL Server database. They need to ensure that the database is encrypted at rest using a customer-managed AWS KMS key. Which action should be taken?

Accepted Answer

Enable encryption at rest when creating the RDS instance and select the customer-managed KMS key.. Encryption at rest for RDS must be enabled at instance creation, and you can select a customer-managed KMS key at that time. Once enabled, the key cannot be changed. The other options are either impossible or do not meet the requirement of using a customer-managed KMS key.

Answer

Enable encryption at rest using the default AWS managed key for RDS, then change the key to a customer-managed key after creation.

Answer

Create the RDS instance without encryption, then modify the instance to enable encryption using the AWS Management Console.

Answer

Use Transparent Data Encryption (TDE) at the database level with a customer-managed key stored in AWS KMS.

Question 5

A company is planning to migrate an on-premises MySQL database to Amazon RDS for MySQL. The database is 500 GB and the company wants to minimize downtime. They have set up AWS DMS with a replication instance. During testing, they notice that the replication instance is not capturing changes from the source database. What is the most likely cause?

Accepted Answer

The source database binary logging is not enabled.. AWS DMS requires binary logging on MySQL sources to capture ongoing changes. Without it, CDC cannot function. The other options might cause different issues but not specifically prevent change capture. Ensuring binary logging is enabled with ROW format is essential for MySQL migrations with DMS.

Answer

The AWS DMS replication instance is under-provisioned.

Answer

The replication instance is in a different VPC than the target database.

Answer

The target database does not have sufficient storage.

Question 6

A company is migrating a large on-premises MongoDB database to Amazon DocumentDB. The database is 500 GB and the company wants to minimize downtime. They have a 1 Gbps AWS Direct Connect connection. Which migration strategy should be used?

Accepted Answer

Use AWS Database Migration Service (AWS DMS) with a change data capture (CDC) task to replicate ongoing changes from MongoDB to DocumentDB.. AWS DMS with CDC is the correct strategy because it supports MongoDB to DocumentDB migrations and provides continuous replication for minimal downtime. The other methods either lack continuous replication, are unsupported, or introduce significant delays. This ensures a smooth cutover with minimal disruption.

Answer

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

Answer

Configure MongoDB replica set and add DocumentDB as a secondary, then promote it to primary.

Answer

Use mongodump and mongorestore to export and import the database, then set up change stream replication manually.

Question 7

A company is migrating a 10 TB on-premises Oracle database to Amazon RDS for Oracle. The network link to AWS is 100 Mbps. The database must remain fully operational during the migration, and the cutover must complete within a 30-minute window. Which migration strategy should be used?

Accepted Answer

Use AWS Database Migration Service (AWS DMS) with ongoing replication, then perform a cutover after the replication lag reaches zero.. For a large, live database migration over a slow network with a tight cutover window, AWS DMS with ongoing replication is the correct choice. It performs an initial full load and then continuously applies source changes to the target. Once replication lag is near zero, you can stop writes at the source, let DMS catch up, and promote the target within minutes. Other methods either require downtime or do not support continuous synchronization.

Answer

Use AWS Database Migration Service (AWS DMS) with full load only, scheduling the migration during a maintenance window to minimize impact.

Answer

Use Oracle Data Pump to export the database to an Amazon S3 bucket, then use AWS DMS to load the dump files into Amazon RDS for Oracle.

Answer

Use AWS Snowball Edge to transfer a physical backup of the database to AWS, then restore it to Amazon RDS for Oracle.

Question 8

A company is migrating an on-premises Oracle database to Amazon RDS for Oracle. The database uses a custom character set and requires a specific time zone. The migration must be completed with minimal downtime. Which approach should be used to meet these requirements?

Accepted Answer

Use AWS DMS with a full load plus ongoing replication, and create the target RDS instance with the required character set and time zone.. AWS DMS with ongoing replication minimizes downtime by continuously replicating changes. The target RDS instance must be created with the required character set and time zone, which are set at instance creation and cannot be changed later. This combination meets both the minimal downtime and configuration requirements.

Answer

Use Oracle Data Pump to export the database and import it into RDS for Oracle, then modify the character set and time zone after import.

Answer

Use AWS SCT to convert the schema and then use AWS DMS for data migration, but leave the default character set and time zone on the RDS instance.

Answer

Create an RDS for Oracle instance with the desired character set and time zone, then use a database link to copy data directly from the on-premises database.

Question 9

A company is deploying an Amazon DynamoDB table for a new application. The table will store session data with a TTL attribute. The company wants to ensure that expired items are automatically deleted and that the deletion does not consume write capacity. Which configuration should they use?

Accepted Answer

Enable TTL on the table and specify the TTL attribute name.. DynamoDB TTL automatically deletes expired items without consuming write capacity. It is a native feature that requires enabling TTL and specifying the attribute. Other methods involve manual or triggered deletions that consume capacity.

Answer

Enable DynamoDB Accelerator (DAX) and configure TTL on the DAX cluster.

Answer

Create a global secondary index (GSI) on the TTL attribute and query for expired items to delete them.

Answer

Use a DynamoDB Streams trigger to delete expired items with a Lambda function.

Question 10

A financial services company runs an Amazon Aurora MySQL cluster in us-east-1 that must be replicated to eu-west-1 for disaster recovery. The RPO requirement is under one second and the RTO requirement is under one minute. The database team wants a managed solution that does not require them to administer any replication instances. Which deployment approach meets these requirements?

Accepted Answer

Create an Amazon Aurora Global Database with the primary cluster in us-east-1 and a secondary cluster in eu-west-1.. Aurora Global Database is purpose-built for cross-Region disaster recovery: it replicates storage at the physical layer with sub-second typical lag and allows promotion of a secondary cluster in under a minute. Because AWS manages the replication, no replication instances need administration, which directly matches the stated RPO and RTO requirements.

Answer

Create a cross-Region read replica of the Aurora cluster in eu-west-1 and promote it during a failover event.

Answer

Enable Aurora Multi-AZ with automatic failover and rely on the standby replica in eu-west-1 for disaster recovery.

Answer

Configure AWS Database Migration Service with change data capture from us-east-1 to an Aurora cluster in eu-west-1.

Question 11

A financial services firm is migrating a 4 TB on-premises Oracle database to Amazon RDS for Oracle. The migration window is 6 hours, and the source database can be taken offline only during that window. The firm wants to use AWS Database Migration Service (AWS DMS) to minimize cutover time. Which combination of tasks should be performed to meet the requirement?

Accepted Answer

Create a full-load plus change data capture (CDC) DMS task, let the full load complete, allow CDC to apply changes, then stop the application and switch over during the window.. A full-load plus CDC task moves the bulk of the data while the source stays online, then continuously applies changes. Only a short final catch-up and cutover require the application to be stopped, keeping the offline window within 6 hours. Full-load-only would miss changes, and CDC-only requires a pre-seeded consistent target, which is impractical here.

Answer

Create a full-load-only DMS task, run it during the migration window, then stop the application and switch the connection string to RDS.

Answer

Create a CDC-only DMS task, seed the target with an RMAN backup restored to RDS, then start the task to apply changes.

Answer

Create a full-load plus CDC DMS task, but configure the target to use Amazon RDS for Oracle with a read replica to offload the apply process.

Question 12

A company is deploying a new Amazon DynamoDB table for a high-traffic web application. The application requires consistent single-digit millisecond latency at any scale. The company wants to minimize operational overhead and avoid capacity planning. Which DynamoDB capacity mode should a database specialist recommend?

Accepted Answer

On-demand capacity mode.. DynamoDB on-demand capacity mode automatically scales read and write capacity to handle workload changes without capacity planning. It provides consistent low-latency performance and is ideal for unpredictable traffic. Provisioned modes require setting capacity units, and DAX is a caching solution that does not address capacity planning.

Answer

DynamoDB Accelerator (DAX) with provisioned capacity.

Answer

Provisioned capacity mode with auto scaling enabled.

Answer

Provisioned capacity mode with reserved capacity.

Question 13

A company is deploying an Amazon DynamoDB table that will be used by an application with unpredictable read traffic. The table must automatically scale read capacity to handle spikes while minimizing cost. Which solution should be used?

Accepted Answer

Use DynamoDB on-demand capacity mode.. DynamoDB on-demand capacity mode automatically scales to handle unpredictable traffic and charges per request, making it cost-effective for variable workloads. Provisioned mode with auto scaling or high RCUs does not provide the same seamless scaling and cost efficiency.

Answer

Use provisioned capacity mode with a high read capacity unit (RCU) setting to handle peaks.

Answer

Use provisioned capacity mode with auto scaling enabled for read capacity.

Answer

Use DynamoDB Accelerator (DAX) to cache reads and reduce the need for scaling.

Question 14

A company is migrating an on-premises Oracle database to Amazon RDS for Oracle. The database is 2 TB and the company requires a maximum downtime of 15 minutes during cutover. Which combination of AWS services should be used to achieve this?

Accepted Answer

AWS Database Migration Service (AWS DMS) with ongoing replication and AWS Schema Conversion Tool (AWS SCT). AWS DMS with ongoing replication keeps the target synchronized with the source, enabling a cutover with minimal downtime. AWS SCT handles schema and code conversion. Together they provide a reliable migration path for a 2 TB Oracle database with a 15-minute downtime requirement, unlike full-load-only or offline methods.

Answer

Amazon RDS for Oracle native replication using Oracle Data Guard

Answer

AWS DMS with full load only and AWS SCT

Answer

Oracle Data Pump export/import with AWS Snowball Edge

Question 15

A company is deploying a new Amazon Aurora MySQL cluster. They need to ensure that the database can be restored to any point in time within the last 35 days, and that automated backups are retained even if the cluster is deleted. The backup retention period must be set to 35 days. Which combination of actions should a database specialist take?

Accepted Answer

Configure the backup retention period to 35 days and enable the 'Retain automated backups' option when deleting the cluster.. To meet both PITR and post-deletion retention, set the backup retention period to 35 days and select the option to retain automated backups when deleting the cluster. This ensures automated backups are preserved for the retention period even after the cluster is gone.

Answer

Enable automated backups with a retention period of 35 days and enable the 'Copy tags to snapshots' option.

Answer

Set the backup retention period to 35 days and take a manual snapshot before deleting the cluster.

Answer

Enable automated backups with a retention period of 35 days and enable deletion protection on the cluster.