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

Question 1

A healthcare company is migrating an on-premises Microsoft SQL Server 2019 database to Amazon RDS for SQL Server. The database uses Transparent Data Encryption (TDE) and contains tables with FILESTREAM data. The team wants to use native backup and restore to move the database with minimal effort. Which two actions must the team take to accomplish this migration? (Choose two.)

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

Accepted Answer

Create a symmetric encryption KMS key and use it to encrypt the native backup before restoring to RDS for SQL Server.. Native backup and restore on RDS for SQL Server requires the backup file to be encrypted with an AWS KMS key and staged in Amazon S3 with the S3 integration option enabled on the instance. Those two configuration steps make the migration possible without log shipping or DMS, and FILESTREAM data is carried inside the backup itself.

Answer

Convert all FILESTREAM data to regular VARBINARY columns before performing the native backup.

Answer

Attach an IAM role to the DB instance that grants access to the S3 bucket containing the backup file.

Answer

Configure the source SQL Server to use the BULK_LOGGED recovery model before taking the native backup.

Question 2

A company is planning to migrate an on-premises MySQL database to Amazon Aurora MySQL. They want to use AWS DMS for the migration. Which two actions are required to ensure the migration is successful? (Choose two.)

Accepted Answer

Create an AWS DMS replication instance in the same AWS Region as the target Aurora MySQL database.. For a successful AWS DMS migration to Aurora MySQL, enabling binary logging on the source is essential for CDC to capture ongoing changes. Placing the DMS replication instance in the same Region as the target Aurora MySQL database minimizes latency and cost. While other actions like granting privileges and setting binlog format are important, they are not the two most critical actions for the migration's success in this context.

Answer

Set the binlog_format parameter to ROW on the source MySQL database.

Answer

Configure the source MySQL database to use the InnoDB storage engine.

Answer

Grant the AWS DMS user REPLICATION SLAVE and REPLICATION CLIENT privileges on the source MySQL database.

Question 3

A company is deploying a new Amazon Aurora PostgreSQL cluster. They need to ensure that the database can be restored to any point in time within the last 35 days. The cluster must also be able to survive an Availability Zone failure without manual intervention. Which combination of actions should be taken?

Accepted Answer

Enable automated backups with a retention period of 35 days. Aurora automatically replicates data across three Availability Zones and provides fault tolerance without additional configuration.. Aurora automatically replicates data across three Availability Zones, providing fault tolerance without manual intervention. To meet the 35-day point-in-time recovery requirement, you only need to set the automated backup retention period to 35 days. No additional Multi-AZ or replica configuration is required for Availability Zone resilience.

Answer

Enable automated backups with a retention period of 35 days and configure the cluster to have at least one Aurora Replica in a different Availability Zone.

Answer

Enable automated backups with a retention period of 35 days and create a Multi-AZ deployment with a standby replica in another Availability Zone.

Answer

Enable automated backups with a retention period of 35 days and create a cross-Region read replica to handle Availability Zone failures.

Question 4

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 to other SQL Server instances. The migration must preserve these features and minimize application changes. Which two actions should a database specialist take to meet these requirements? (Choose two.)

Accepted Answer

Use native SQL Server backup and restore to migrate the database to RDS for SQL Server, ensuring the backup file is uploaded to Amazon S3 and restored via the rds_restore procedure.. Native backup and restore via Amazon S3 moves the user database to RDS for SQL Server while preserving schema and stored procedures, and linked servers must be recreated manually because their definitions live in system databases not included in the restore. Together these actions preserve SQL Server Agent jobs, linked servers, and application compatibility with minimal changes.

Answer

Configure SQL Server Agent jobs on the RDS for SQL Server instance after migration, since the native restore includes job definitions.

Answer

Enable the RDS for SQL Server option group setting for linked servers before the restore, so the linked server definitions are automatically imported.

Answer

Use the AWS Schema Conversion Tool (AWS SCT) to convert the SQL Server schema and stored procedures to a compatible format for RDS for SQL Server.

Question 5

A company is migrating a large on-premises Oracle database to Amazon Aurora PostgreSQL using AWS DMS. The migration must be completed with minimal downtime, and the team needs to ensure that the target Aurora PostgreSQL cluster can handle the write load during the cutover. Which TWO actions should the team take to optimize the target for DMS replication? (Choose two.)

Accepted Answer

Set the target Aurora PostgreSQL parameter synchronous_commit to off during the migration. To optimize an Aurora PostgreSQL target for DMS replication during a large migration, disabling foreign keys and triggers reduces overhead and avoids constraint violations during initial load. Setting synchronous_commit to off improves write throughput by not waiting for WAL flushes. Both actions help the target handle the write load and minimize downtime during cutover.

Answer

Enable Multi-AZ on the Aurora PostgreSQL cluster to improve write performance

Answer

Use a larger instance class for the DMS replication instance instead of optimizing the target

Answer

Increase the value of max_connections on the target Aurora PostgreSQL cluster to allow more concurrent DMS tasks

Question 6

A company is migrating an on-premises Oracle database to Amazon RDS for Oracle. The database is 4 TB and the network link between the data center and AWS has limited bandwidth. The migration must be completed with minimal downtime. Which AWS service should be used to move the initial data load?

Accepted Answer

AWS Snowball Edge to transfer the initial database backup to Amazon S3, then restore to RDS for Oracle.. With limited bandwidth, transferring 4 TB over the network would be prohibitively slow. AWS Snowball Edge allows you to physically ship the data, bypassing bandwidth constraints. After the backup is loaded to Amazon S3, you can restore it to RDS for Oracle using native tools, achieving minimal downtime compared to a network-based transfer.

Answer

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

Answer

AWS DataSync to copy the database files directly to an Amazon EFS file system mounted on the RDS instance.

Answer

AWS Storage Gateway in volume gateway mode to present an iSCSI volume to the RDS instance.

Question 7

A company is deploying a new Amazon RDS for SQL Server database in a Multi-AZ configuration. The database must be encrypted at rest using AWS Key Management Service (AWS KMS). The company also needs to ensure that the encryption key is rotated annually. Which action should be taken to meet these requirements?

Accepted Answer

Enable encryption at rest when creating the RDS instance and use a customer managed key with automatic rotation enabled.. The correct action is to enable encryption at rest when creating the RDS instance and use a customer managed key with automatic rotation enabled. AWS KMS allows automatic annual rotation for customer managed keys. This satisfies both encryption and rotation requirements. The default AWS managed key does not support annual rotation. Encryption cannot be enabled after creation without snapshot restore. Manual rotation is unnecessary when automatic rotation is available.

Answer

Enable encryption at rest using a customer managed key and manually rotate the key every year using a Lambda function.

Answer

Enable encryption at rest after creating the RDS instance by modifying the instance and selecting a KMS key.

Answer

Enable encryption at rest when creating the RDS instance and use the default AWS managed key for RDS.

Question 8

A company is deploying a new Amazon Aurora PostgreSQL database cluster. They need to ensure that the database is highly available across multiple Availability Zones and that failover is automatic. They also want to minimize the risk of data loss during a failover. Which configuration should they use?

Accepted Answer

Create an Aurora cluster with a writer instance and at least one reader instance in different Availability Zones, and rely on Aurora's shared storage replication. Amazon Aurora stores data in a cluster volume that is synchronously replicated across three Availability Zones by default. This provides durability and minimizes data loss. To achieve automatic failover, you need at least one Aurora Replica in a different AZ from the writer. The combination of shared storage replication and a cross-AZ reader ensures high availability and automatic failover with minimal data loss.

Answer

Create an Aurora cluster with a writer instance in one AZ and a reader instance in a different AZ, and enable automatic failover

Answer

Create an Aurora cluster with a single writer instance and no reader instances in one Availability Zone

Answer

Create an Aurora cluster with a writer instance and enable Multi-AZ on the writer instance

Question 9

A company is migrating an on-premises Microsoft SQL Server database to Amazon RDS for SQL Server. They need to minimize downtime during the cutover. The database is 1 TB and has a high transaction rate. Which two actions should be taken to achieve minimal downtime? (Choose two.)

Accepted Answer

Use AWS Database Migration Service (AWS DMS) with ongoing replication to keep the target in sync until cutover.. To minimize downtime during a SQL Server migration to RDS, use AWS DMS with ongoing replication to continuously sync changes, and use AWS SCT to convert the schema if needed. DMS keeps the target up-to-date until cutover, and SCT ensures compatibility. Together, they enable a near-zero-downtime migration.

Answer

Take a full backup and restore it to RDS for SQL Server, then apply transaction log backups until cutover.

Answer

Configure RDS for SQL Server in Multi-AZ mode to ensure high availability during the migration.

Answer

Use AWS Snowball Edge to transfer the backup files to Amazon S3, then restore to RDS for SQL Server.

Question 10

A company is deploying a new Amazon DynamoDB table to support an application with unpredictable read and write patterns. The table must automatically scale capacity to handle traffic spikes while minimizing cost. Which two actions should be taken to meet these requirements? (Choose two.)

Accepted Answer

Use on-demand capacity mode for the table to automatically accommodate traffic spikes without capacity planning.. Both provisioned capacity with Application Auto Scaling and on-demand capacity mode allow DynamoDB to automatically adjust to traffic changes. Provisioned with auto scaling is suitable when you have some predictability and want to optimize cost, while on-demand is ideal for highly unpredictable workloads. Either meets the requirement to scale automatically and minimize cost, depending on the specific pattern.

Answer

Set the table's capacity mode to provisioned and manually adjust capacity using AWS Lambda based on CloudWatch alarms.

Answer

Enable DynamoDB Accelerator (DAX) to cache reads and reduce the required read capacity.

Answer

Create a global secondary index (GSI) with provisioned capacity and enable auto scaling on the index.

Question 11

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 has a high transaction rate. The company requires minimal downtime during the migration and wants to validate the data after cutover. Which two actions should be taken to meet these requirements? (Choose two.)

Accepted Answer

Use AWS Database Migration Service (AWS DMS) with ongoing replication to keep the target in sync until cutover.. To minimize downtime for a large, high-transaction SQL Server database, AWS DMS with ongoing replication is ideal because it keeps the target in sync until cutover. Additionally, using AWS DMS data validation ensures that the migrated data matches the source, satisfying the validation requirement. Multi-AZ and SCT are not relevant here, and native backup/restore would cause more downtime.

Answer

Use native backup and restore with the WITH NORECOVERY option to apply transaction log backups.

Answer

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

Answer

Enable Multi-AZ deployment on the target RDS for SQL Server instance for high availability during migration.

Question 12

A company is migrating an on-premises PostgreSQL database to Amazon RDS for PostgreSQL. The company wants to use AWS Database Migration Service (AWS DMS) for the migration. The database is 500 GB and the company can afford a downtime of 2 hours. The company wants to minimize the migration time. Which DMS task setting should be used to improve the performance of the full load?

Accepted Answer

Enable parallel load for the full load by setting the number of threads.. The correct DMS task setting to improve full load performance is enabling parallel load. This allows DMS to load multiple tables or partitions concurrently, utilizing more resources and reducing time. Other options like batch apply and CDC are for change data capture, not full load. A larger instance can help but is not a task setting. Parallel load is specifically designed to accelerate the full load phase.

Answer

Use a larger replication instance class with more memory.

Answer

Set the target endpoint to use 'Batch apply' mode.

Answer

Enable 'Change data capture' (CDC) for the task.

Question 13

A company is migrating an on-premises MySQL database to Amazon RDS for MySQL. The database is 1 TB and the company wants to use AWS Database Migration Service (AWS DMS) for the migration. The company needs to ensure that the migration is as fast as possible and that the target database is not overwhelmed during the full load. The source database has a high transaction rate. Which AWS DMS task setting should be adjusted to improve performance and reduce load on the target?

Accepted Answer

Adjust the MaxFullLoadSubTasks to a lower value to reduce concurrent load on the target. To reduce load on the target during the full load, you should limit the number of concurrent tasks. The MaxFullLoadSubTasks setting controls how many tables are loaded in parallel. Lowering this value reduces concurrency and thus the load on the target, at the cost of a longer migration time. Other options either do not affect the full load or increase load.

Answer

Enable parallel load by setting the number of full load sub-tasks (e.g., FullLoadSubTasks) to a higher value

Answer

Increase the CommitRate parameter to commit more transactions per batch

Answer

Use the BulkLoad option to perform a bulk load into the target

Question 14

A company is planning to migrate an on-premises Oracle database to Amazon RDS for Oracle. The database is 10 TB and the network link between the on-premises data center and AWS is 100 Mbps. The company wants to use AWS Database Migration Service (AWS DMS) but is concerned about the migration time. Which approach will MINIMIZE the data transfer time?

Accepted Answer

Use AWS Snowball Edge to transfer the data to Amazon S3, then use AWS DMS to load from S3 into Amazon RDS.. When network bandwidth is a constraint, physical data transfer using AWS Snowball Edge is the most efficient method for large datasets. The data is loaded onto the device and shipped to AWS, bypassing the slow network. Once in Amazon S3, AWS DMS can load it into Amazon RDS for Oracle. This minimizes the time required for the initial data transfer, which is critical for large databases.

Answer

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

Answer

Use AWS DMS with a large replication instance and full LOB mode to transfer the data directly over the network.

Answer

Set up a VPN connection with accelerated networking and use AWS DMS with change data capture (CDC) enabled.

Question 15

A company is deploying a new Amazon DynamoDB table for an application that requires strong read consistency and automatic scaling. The table will have a large number of read requests per second. The company wants to minimize costs while ensuring performance. Which action should the company take to configure the table appropriately?

Accepted Answer

Create the table with provisioned capacity mode, set the read capacity units (RCUs) based on expected load, and enable DynamoDB Auto Scaling.. For a workload with high, predictable read traffic and a requirement for strong consistency, provisioned capacity mode with DynamoDB Auto Scaling is the most cost-effective and performant choice. Auto Scaling adjusts RCUs based on utilization, ensuring performance while minimizing cost. Strongly consistent reads are supported in provisioned mode. On-demand mode is better for unpredictable traffic, and DAX does not support strongly consistent reads.

Answer

Create the table with on-demand capacity mode and use strongly consistent reads for all queries.

Answer

Create the table with provisioned capacity mode and use global secondary indexes (GSIs) for all read queries.

Answer

Create the table with on-demand capacity mode and enable DynamoDB Accelerator (DAX).