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

Question 1

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 wants to automate the deployment using AWS CloudFormation. Which CloudFormation resource property should be used to enable encryption?

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

Accepted Answer

StorageEncrypted: true. In AWS CloudFormation, the StorageEncrypted property of the AWS::RDS::DBInstance resource is used to enable encryption at rest. Setting it to true encrypts the underlying storage using AWS KMS. If a specific KMS key is required, you can also specify the KmsKeyId property. However, StorageEncrypted is the key property that enables encryption. Encryption must be enabled at instance creation and cannot be added later without recreating the instance.

Answer

Encrypted: true

Answer

EnableEncryption: true

Answer

KmsKeyId: arn:aws:kms:region:account:key/key-id

Question 2

A company is deploying a new Amazon DynamoDB table to support an application with unpredictable read patterns. The application requires consistent low-latency reads and the ability to handle sudden spikes in traffic without manual intervention. The database team wants to minimize operational overhead while ensuring cost-effectiveness. Which DynamoDB capacity mode should they choose?

Accepted Answer

On-demand capacity mode.. On-demand capacity mode is designed for unpredictable workloads, automatically scaling to handle traffic spikes without manual intervention. It eliminates the need for capacity planning and provides consistent low-latency performance. Provisioned modes require some level of planning and may not react quickly enough to sudden spikes, while DAX is a caching solution that does not address capacity management.

Answer

DynamoDB Accelerator (DAX) with provisioned capacity.

Answer

Provisioned capacity mode with reserved capacity.

Answer

Provisioned capacity mode with auto scaling enabled.

Question 3

A startup is deploying a new Amazon DynamoDB table for a web application. They need to ensure that the table can handle sudden spikes in read traffic without manual intervention. They also want to minimize costs during periods of low traffic. Which capacity mode should they choose?

Accepted Answer

On-demand capacity mode.. On-demand capacity mode automatically scales to handle sudden spikes in traffic and charges per request, so costs decrease during low traffic. Provisioned modes require capacity planning and may not respond instantly to spikes. Reserved capacity is for predictable workloads. Therefore, on-demand is the best fit for unpredictable traffic and cost minimization.

Answer

Provisioned capacity mode with auto scaling enabled.

Answer

Provisioned capacity mode with reserved capacity.

Answer

Provisioned capacity mode with global secondary indexes.

Question 4

A company is deploying a new Amazon Aurora MySQL database cluster in a production environment. The database must be highly available and able to survive an Availability Zone (AZ) failure with minimal downtime. The company also wants to ensure that read traffic is distributed across multiple reader instances to improve performance. Which configuration should be implemented?

Accepted Answer

Deploy an Aurora MySQL cluster with one writer instance and multiple reader instances across multiple AZs, and use the reader endpoint to distribute read traffic.. Aurora MySQL stores data redundantly across three AZs and allows up to 15 read replicas. The writer endpoint handles write operations, while the reader endpoint automatically load-balances read connections across all reader instances. Placing readers in different AZs ensures that if the writer's AZ fails, Aurora can promote a reader in another AZ to become the new writer, typically within 30 seconds. This design meets both high availability and read scaling requirements.

Answer

Deploy an Aurora MySQL cluster with one writer instance and one reader instance in different AZs, and use a custom endpoint to distribute read traffic.

Answer

Deploy an Aurora MySQL cluster with multiple writer instances across multiple AZs and use a custom endpoint for writes.

Answer

Deploy a single Aurora MySQL instance in one AZ and enable automatic backups.

Question 5

A company is migrating an on-premises MongoDB database to Amazon DocumentDB (with MongoDB compatibility). The database is 2 TB and the migration must be completed with minimal downtime. The company has an AWS Direct Connect connection with 1 Gbps bandwidth. They plan to use AWS Database Migration Service (AWS DMS). Which migration approach will meet these requirements?

Accepted Answer

Use AWS DMS with a change data capture (CDC) task to replicate ongoing changes after an initial full load.. AWS DMS supports MongoDB as a source and Amazon DocumentDB as a target. To achieve minimal downtime, you should use a CDC task that performs a full load and then replicates ongoing changes. This keeps the target synchronized until you are ready to cut over, which only requires a brief pause in writes. The Direct Connect bandwidth is sufficient for the initial load and ongoing replication of a 2 TB database.

Answer

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

Answer

Use AWS DMS with a full load only task and schedule it during a maintenance window.

Answer

Use the mongodump and mongorestore utilities to export and import the data, then enable change streams for ongoing replication.

Question 6

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 during the migration. They also need to ensure that the target database is continuously synchronized with the source until cutover. Which two steps should be included in the migration plan? (Choose two.)

Accepted Answer

Enable and configure MS-CDC on the source SQL Server database.. To minimize downtime when migrating to Amazon RDS for SQL Server, use AWS DMS with full load and change data capture (CDC) to continuously replicate changes. Additionally, MS-CDC must be enabled on the source SQL Server database for DMS to capture ongoing changes. These two steps ensure that the target remains synchronized until cutover, allowing for a quick switchover with minimal downtime.

Answer

Use AWS Database Migration Service (AWS DMS) with only a full load, and then manually apply changes after cutover.

Answer

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

Answer

Set up a VPN connection between on-premises and AWS to facilitate data transfer.

Question 7

A company is planning to migrate an on-premises Oracle database to Amazon RDS for Oracle. They want to use AWS Database Migration Service (AWS DMS) for the migration. Which two tasks must be performed to ensure that AWS DMS can replicate ongoing changes from the source to the target? (Choose two.)

Accepted Answer

Enable supplemental logging on the source Oracle database.. To enable AWS DMS to replicate ongoing changes from an Oracle source, you must enable supplemental logging on the source database and grant the DMS user the necessary privileges to read the redo logs. These two tasks are critical for CDC. Other tasks like character set matching, automatic backups, and VPN setup are not directly required for CDC functionality.

Answer

Configure the target RDS for Oracle instance with the same character set as the source.

Answer

Enable automatic backups on the target RDS for Oracle instance.

Answer

Set up a VPN connection between the source and AWS.

Question 8

A company is deploying a new Amazon DynamoDB table for a high-traffic application. The table must be able to handle sudden spikes in read and write traffic without manual intervention. The company wants to minimize operational overhead. Which capacity mode should be used?

Accepted Answer

On-demand capacity mode. DynamoDB on-demand capacity mode is designed for workloads with unknown or variable traffic patterns. It instantly accommodates sudden spikes in read and write activity without requiring you to specify capacity or configure auto scaling. You are charged per request, so you only pay for what you use. This mode eliminates the need for capacity planning and reduces operational overhead, making it the best choice for high-traffic applications with unpredictable spikes.

Answer

Provisioned capacity mode with global secondary indexes

Answer

Provisioned capacity mode with reserved capacity

Answer

Provisioned capacity mode with auto scaling enabled

Question 9

A company is deploying a new Amazon DynamoDB table. The table will store user session data that must be automatically deleted after 30 days. The company wants to minimize costs and administrative overhead. Which feature should be used?

Accepted Answer

Configure a DynamoDB TTL attribute and set it to the session expiration timestamp.. DynamoDB TTL is the ideal feature for automatically deleting expired items. It requires only setting an attribute with an expiration timestamp, and DynamoDB deletes items after that time without additional cost or administrative effort. Other methods involve custom code, scans, or manual restores, which increase complexity and cost. TTL is designed exactly for this use case.

Answer

Use a scheduled Amazon EventBridge rule to invoke a Lambda function that scans and deletes old items.

Answer

Enable point-in-time recovery and restore the table without expired items.

Answer

Enable DynamoDB Streams and use AWS Lambda to delete expired items.

Question 10

A company is migrating an on-premises MySQL database to Amazon Aurora MySQL. The database is 1 TB and the company wants to use AWS DMS for the migration. They need to ensure that the target Aurora cluster is highly available and can survive an Availability Zone failure. Which configuration should be used for the Aurora cluster?

Accepted Answer

Create an Aurora MySQL cluster with a writer instance and at least one reader instance in a different Availability Zone.. To ensure high availability and survive an Availability Zone failure, an Aurora MySQL cluster should have at least one reader instance in a different Availability Zone from the writer. Aurora automatically fails over to a reader if the writer becomes unavailable, providing minimal downtime. The storage layer is already replicated across three AZs, but the compute endpoint requires a reader for failover. Other options do not provide the necessary fault tolerance.

Answer

Create an Aurora MySQL cluster with a single writer instance and no reader instances.

Answer

Create an Aurora MySQL cluster with a writer instance and enable Aurora Backtrack.

Answer

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

Question 11

A company is planning to migrate an on-premises MySQL database to Amazon Aurora MySQL. The database is 1 TB and has a high write load. The company wants to minimize downtime during the migration. They have set up AWS DMS with a replication instance and are using change data capture (CDC). During testing, they notice that the replication instance is experiencing high CPU utilization and the CDC lag is increasing. Which action should be taken to improve replication performance?

Accepted Answer

Increase the size of the replication instance.. The replication instance is experiencing high CPU utilization, which is a clear indicator that it lacks sufficient compute resources for the CDC workload. Increasing the instance size provides more CPU and memory, allowing DMS to process changes faster and reduce lag. Other options either do not affect performance or could worsen it. Multi-AZ is for availability, more tasks increase contention, and binary logging configuration is a prerequisite already met.

Answer

Increase the number of tasks per replication instance.

Answer

Enable Multi-AZ for the replication instance.

Answer

Configure the source database to use binary logging with row-based replication.

Question 12

A retailer is deploying an Amazon RDS for SQL Server Multi-AZ instance in a private subnet group. The database must be reachable only from application servers in the same VPC, and DBAs on the corporate network must connect through a bastion host. Which combination of settings should be used?

Accepted Answer

Set Publicly accessible to No, attach a security group that allows the database port from the application server security group and from the bastion host security group.. A non-publicly accessible instance in a private subnet group has only private addressing, satisfying the isolation requirement. Security groups that reference the application and bastion security groups as sources restrict access to exactly those instances on the database port, without hard-coding subnet ranges that could drift as the environment changes. This is the least-privilege connectivity pattern for the described topology.

Answer

Set Publicly accessible to Yes, attach a security group allowing the application subnet CIDR, and add an inbound rule for the bastion host's private IP address.

Answer

Set Publicly accessible to No and attach a network ACL that denies all inbound traffic except from the corporate network's public IP range.

Answer

Set Publicly accessible to Yes and place the instance in a public subnet, then rely on the DB subnet group to restrict which hosts can resolve the endpoint.

Question 13

A startup is deploying a new Amazon Aurora PostgreSQL cluster for a development environment. The team wants the cluster to be created reproducibly from a version-controlled template, including the DB subnet group, parameter group, and cluster settings, rather than through console clicks. Which approach should be used?

Accepted Answer

Write an AWS CloudFormation template that declares the DB subnet group, DB cluster parameter group, and Aurora cluster resources, and deploy it through a stack.. Declaring the Aurora cluster, DB subnet group, and cluster parameter group as resources in an AWS CloudFormation template makes the deployment declarative and reproducible. The template lives in version control, changes are reviewed before deployment, and stacks can be recreated identically across environments, which is exactly the infrastructure-as-code outcome the team needs for a development environment.

Answer

Take a manual snapshot of a configured cluster and restore it whenever a new development environment is needed.

Answer

Use AWS Trusted Advisor to check the Aurora cluster configuration and export the recommended settings as a script.

Answer

Create the cluster in the console, then use AWS Config to record the resulting resource configuration as a reusable template.

Question 14

A company runs an on-premises Oracle database that must be migrated to Amazon Aurora PostgreSQL within a tight window. The database contains large BLOB columns and several proprietary Oracle data types. The team needs to convert the schema and stored procedures to PostgreSQL-compatible code before the cutover. Which AWS service should be used to perform the schema conversion?

Accepted Answer

AWS Schema Conversion Tool (AWS SCT). AWS Schema Conversion Tool is purpose-built to convert database schemas and procedural code from one engine to another, including Oracle to Aurora PostgreSQL. It handles tables, indexes, views, stored procedures, functions, and data type mappings, and it reports objects requiring manual intervention. AWS DMS then moves the data into the converted schema. DataSync and DMS task settings do not perform schema conversion.

Answer

AWS DataSync with an S3 bucket as the target

Answer

AWS Database Migration Service (AWS DMS) with a full-load plus change data capture task

Answer

AWS Database Migration Service (AWS DMS) with the Schema Conversion action enabled in the task settings

Question 15

A company is migrating an on-premises MySQL 8.0 database to Amazon Aurora MySQL. The database is 8 TB, and the business requires less than 15 minutes of downtime during cutover. The network link between the data center and AWS has 500 Mbps of available bandwidth. Which TWO steps should the team take to meet the downtime requirement? (Choose two.)

Accepted Answer

Enable binary logging on the source MySQL database and configure the AWS DMS source endpoint with the correct log position.. Meeting a 15-minute cutover for an 8 TB on-premises MySQL database requires continuous replication so the target stays current. AWS DMS full-load plus CDC copies the data once and then applies ongoing changes, and CDC requires binary logging on the source plus a valid log position in the DMS source endpoint. Together these allow a short final switchover rather than a bulk copy during the maintenance window.

Answer

Use AWS Snowball Edge to ship the 8 TB of data to Amazon S3 and then load it into Aurora MySQL with LOAD DATA FROM S3.

Answer

Create an Aurora MySQL read replica in the same AWS Region and promote it during the maintenance window.

Answer

Export the database with mysqldump and restore it into Aurora MySQL during the maintenance window.