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

Question 1

A company is migrating an on-premises Oracle database to Amazon RDS for Oracle. They want to use Oracle GoldenGate for replication. Which AWS service can be used to simplify the setup of GoldenGate on AWS?

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

Accepted Answer

AWS Marketplace. AWS Marketplace offers pre-configured Oracle GoldenGate AMIs that simplify the setup and deployment of GoldenGate on EC2, reducing the manual installation and configuration effort. This is the correct choice because the question asks for a service that simplifies the setup of GoldenGate itself, not the migration tool or infrastructure orchestration.

Answer

AWS DMS

Answer

Amazon RDS for Oracle with GoldenGate enabled

Answer

AWS CloudFormation

Question 2

A company is migrating an on-premises MySQL database to Amazon RDS for MySQL. Which TWO AWS services can assist in assessing the source database for compatibility issues?

Accepted Answer

AWS Database Migration Service (DMS). AWS Database Migration Service (DMS) is correct because it provides a premigration assessment capability that analyzes the source database for issues that could affect migration, including schema and object compatibility concerns, helping identify required actions before migration. AWS Schema Conversion Tool (SCT) is correct because it is specifically designed to assess source database schemas, convert them to a target engine, and produce an assessment report highlighting incompatibilities and required manual actions. AWS Trusted Advisor is not correct because it provides best-practice checks on cost, security, fault tolerance, and service limits, not database schema compatibility analysis. Amazon CloudWatch is not correct because it monitors metrics, logs, and alarms for running resources rather than assessing database compatibility. Amazon Inspector is not correct because it is a vulnerability management service that scans EC2 instances and container images for software vulnerabilities and unintended network exposure, not database migration compatibility.

Answer

AWS Trusted Advisor

Answer

Amazon CloudWatch

Answer

Amazon Inspector

Question 3

A company is deploying an Amazon Aurora MySQL database with read replicas. They need to ensure high availability and disaster recovery across AWS Regions. Which THREE components should be included?

Accepted Answer

Aurora Replicas in the same Region. Option A (Aurora Replicas in the same Region) is correct because Aurora Replicas provide in-Region high availability by enabling automatic failover to a replica if the primary writer instance fails, with typical failover times under 30 seconds. Option B (Aurora Global Database) is correct because it spans multiple AWS Regions with a primary Region and up to five secondary Regions, replicating data with typical latency under one second and enabling cross-Region disaster recovery via managed planned failover or unplanned failover. Option D (Amazon Route 53 with health checks and failover policy) is correct because Route 53 health checks monitor endpoint health and a failover routing policy directs client traffic to a healthy Region during a regional outage, completing the DR traffic-routing layer. Option C (Auto Scaling groups) is incorrect because Auto Scaling groups manage EC2 instance fleets, not Aurora database instances, and Aurora scaling is handled through Aurora Replicas and Aurora Auto Scaling rather than EC2 Auto Scaling groups. Option E (Amazon CloudFront) is incorrect because CloudFront is a content delivery network for caching and accelerating HTTP/HTTPS content at edge locations, and it does not provide database high availability or disaster recovery for Aurora MySQL.

Answer

Auto Scaling groups

Answer

Amazon CloudFront

Question 4

A company is migrating a 500 GB Oracle database to Amazon Aurora PostgreSQL. Which THREE steps should be part of the migration plan?

Accepted Answer

Use AWS DMS to perform a full load and ongoing replication from Oracle to Aurora.. Option C is correct because AWS Database Migration Service (DMS) is the standard tool for heterogeneous migrations, performing a full load of the 500 GB Oracle database and optionally ongoing replication (CDC) to keep Aurora PostgreSQL in sync until cutover. Option D is correct because AWS Schema Conversion Tool (SCT) is required to convert Oracle-specific schema objects, PL/SQL, and data types into PostgreSQL-compatible DDL before DMS can load the data. Option E is correct because a migration plan must include post-migration validation of row counts, data integrity, and application functional testing against Aurora PostgreSQL to confirm the cutover is safe. Option A is not appropriate because Snowball is for bulk physical data transfer, not for logical database migration into Aurora PostgreSQL. Option B is not required because Direct Connect is a network connectivity option and does not itself perform schema conversion or data migration for this scenario.

Answer

Use AWS Snowball to transfer the database files.

Answer

Set up AWS Direct Connect between on-premises and AWS.

Question 5

Refer to the exhibit. A developer wants to connect to the database. Which database engine is most likely being used?

Accepted Answer

MySQL. The exhibit shows a connection string using the format `jdbc:mysql://...`, which is the standard JDBC URL prefix for MySQL databases. This indicates the developer is connecting to a MySQL database engine, as Oracle, SQL Server, and PostgreSQL use different JDBC URL prefixes (`jdbc:oracle:thin:`, `jdbc:sqlserver://`, and `jdbc:postgresql://` respectively).

Answer

Oracle

Answer

SQL Server

Answer

PostgreSQL

Question 6

A company wants to migrate a 500 GB SQL Server database to Amazon RDS for SQL Server with the least amount of downtime. The on-premises network has a 1 Gbps connection to AWS. Which approach should be used?

Accepted Answer

Use AWS DMS with ongoing replication from on-premises to RDS. AWS DMS with ongoing replication (change data capture, CDC) allows you to perform a full load of the 500 GB database while continuously replicating ongoing changes from the on-premises SQL Server to Amazon RDS for SQL Server. This minimizes downtime to a brief cutover window when you stop writes on the source and redirect traffic to the target. The 1 Gbps connection is sufficient for the initial load and ongoing replication, making this the most effective approach for minimal downtime.

Answer

Use AWS Snowball to transfer the database backup, then restore to RDS

Answer

Copy database files to S3 and then use RDS import

Answer

Use native SQL Server backup to S3, then restore to RDS

Question 7

A company is migrating an on-premises MongoDB database to Amazon DocumentDB. The migration must be online with minimal downtime. Which AWS service should be used?

Accepted Answer

AWS DMS. AWS Database Migration Service (DMS) is the correct choice because it supports ongoing replication (change data capture) from MongoDB to Amazon DocumentDB, enabling an online migration with minimal downtime. DMS can perform a full load of existing data and then continuously replicate changes from the source MongoDB oplog to keep the target DocumentDB synchronized until cutover.

Answer

AWS DataSync

Answer

AWS S3

Answer

AWS Snowball Edge

Question 8

A company is migrating a 10 TB Oracle database to Amazon Aurora PostgreSQL. The migration uses AWS DMS with CDC. After the full load, the CDC phase is falling behind by several minutes. The source Oracle database generates 500 MB of redo logs per minute. Which action will most likely improve CDC performance?

Accepted Answer

Increase the number of parallel apply threads on the DMS task. Increasing the number of parallel apply threads on the DMS task allows the target Aurora PostgreSQL database to apply changes concurrently, reducing the bottleneck caused by sequential apply. With 500 MB/min of redo logs, the single-threaded default apply cannot keep pace, so parallel apply directly addresses the lag by distributing the load across multiple threads.

Answer

Disable CDC and perform a full load only

Answer

Reduce the batch size in the DMS task settings

Answer

Increase the source Oracle redo log size

Question 9

Which TWO factors should be considered when selecting a migration method from on-premises Oracle to Amazon RDS for Oracle?

Accepted Answer

The size of the database and available network bandwidth. Option A is correct because the database size combined with available network bandwidth directly determines how long a network-based migration (for example, Oracle Data Pump over a VPN or AWS Direct Connect, or AWS DMS) will take, which drives the choice between methods such as Data Pump, DMS, or physical/logical approaches. Option C is correct because the acceptable downtime window dictates whether you can use a simple offline export/import or need a minimal-downtime approach like AWS DMS with ongoing replication or Oracle Data Guard/Active Data Guard. Option B is not a primary selection factor because the Oracle client version affects application connectivity compatibility, not the migration method itself. Option D is not a primary factor because stored procedure count does not determine the migration mechanism, though it may influence post-migration validation effort. Option E is not a primary factor because the number of indexes affects migration performance and post-load index rebuild time, but not the fundamental choice of migration method.

Answer

The version of the Oracle client used by applications

Answer

The number of stored procedures in the database

Answer

The number of indexes on the source database

Question 10

Which TWO AWS services can be used to migrate an on-premises SQL Server database to Amazon RDS for SQL Server?

Accepted Answer

AWS DMS. AWS DMS (B) is correct because it is a managed migration service that supports SQL Server as a source and Amazon RDS for SQL Server as a target, using change data capture for minimal-downtime migrations. Native SQL Server backup to S3 and restore to RDS (C) is also correct because RDS for SQL Server natively supports restoring native .bak backups uploaded to Amazon S3, which is a documented migration path. AWS DataSync (A) is for moving files between storage systems, not for database-level migration to RDS. AWS Storage Gateway (D) provides hybrid storage access (file, volume, tape) and does not migrate SQL Server databases into RDS. AWS DynamoDB (E) is a NoSQL database service and cannot serve as a target for SQL Server migration.

Answer

AWS DataSync

Answer

AWS Storage Gateway

Answer

AWS DynamoDB

Question 11

Refer to the exhibit. A company is migrating from an on-premises MySQL database to Amazon RDS for MySQL. The DBA wants to connect to the RDS instance using the endpoint shown. What additional step is required to allow the DBA's client to connect?

Accepted Answer

Modify the security group to allow inbound traffic on port 3306 from the client IP. Amazon RDS security groups act as a virtual firewall controlling inbound and outbound traffic. By default, no inbound traffic is allowed on port 3306 (MySQL). To permit the DBA's client to connect, you must modify the security group associated with the RDS instance to add an inbound rule that allows TCP traffic on port 3306 from the client's IP address (or a range that includes it). Without this rule, the connection is blocked at the network level regardless of other configurations.

Answer

Create a Route 53 record for the endpoint

Answer

Create a MySQL user that matches the client's IP

Answer

Change the RDS instance to be publicly accessible

Question 12

A company is migrating an on-premises Oracle database to Amazon RDS for Oracle. They want to use Oracle GoldenGate for replication. Which AWS service can be used to simplify the setup of GoldenGate on AWS?

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

Accepted Answer

Use AWS Database Migration Service (DMS) with ongoing replication from the source database.. AWS DMS with ongoing replication (change data capture, CDC) allows a full load of the 5 TB database followed by continuous replication of the 2% daily changes, minimizing downtime by keeping the target RDS instance nearly synchronized until cutover. This approach handles large databases and high change rates without requiring a lengthy final export/import window.

Answer

Use AWS Schema Conversion Tool (SCT) to convert the schema, then use AWS DMS for full load only.

Answer

Create an RDS read replica in the same region and promote it.

Answer

Export the database to a dump file using Oracle Data Pump, upload to S3, and restore to RDS.

Question 13

A company is deploying a new web application that uses Amazon RDS for PostgreSQL. The database must be highly available with automatic failover across two Availability Zones. Which deployment option meets this requirement?

Accepted Answer

Deploy RDS PostgreSQL with Multi-AZ configuration.. Amazon RDS Multi-AZ deployment automatically provisions and maintains a synchronous standby replica in a different Availability Zone. If the primary DB instance fails, Amazon RDS automatically fails over to the standby, providing high availability with automatic failover across two AZs. This meets the requirement without manual intervention or application changes.

Answer

Deploy RDS PostgreSQL in a cross-region replication setup.

Answer

Deploy RDS PostgreSQL in a single Availability Zone.

Answer

Deploy RDS PostgreSQL with a read replica in another AZ.

Question 14

A company is migrating a 500 GB MongoDB database to Amazon DocumentDB. The migration must have minimal impact on the source database. Which approach should the company take?

Accepted Answer

Use AWS Database Migration Service (DMS) with MongoDB as source and DocumentDB as target.. AWS DMS supports ongoing replication from MongoDB to Amazon DocumentDB, enabling a live migration with minimal impact on the source database. DMS uses the MongoDB oplog to capture changes continuously, so the source is only read during the initial load and then tailed for CDC, avoiding heavy locks or performance degradation.

Answer

Use mongodump to export the data, then use mongorestore to import into DocumentDB.

Answer

Use mongoexport to export CSV, then use the DocumentDB import tool.

Answer

Use AWS Schema Conversion Tool (SCT) to convert schema, then copy data.

Question 15

A company needs to migrate a 3 TB Amazon RDS for SQL Server database to Amazon RDS for PostgreSQL. The migration must be automated and repeatable with minimal manual intervention. Which combination of services should be used?

Accepted Answer

Use AWS Schema Conversion Tool (SCT) to convert the schema, then use AWS DMS to migrate the data.. AWS Schema Conversion Tool (SCT) handles the schema conversion from SQL Server to PostgreSQL, which is necessary due to incompatible data types, stored procedures, and indexes. AWS Database Migration Service (DMS) then performs the continuous data migration with minimal downtime, supporting both full load and ongoing replication. This combination automates the migration process and makes it repeatable via AWS CloudFormation or DMS task templates.

Answer

Use AWS SCT to convert the schema and export data to PostgreSQL-compatible format, then import.

Answer

Use AWS DMS with native SQL Server CDC to migrate directly to PostgreSQL.

Answer

Use Microsoft Data Migration Assistant to assess and migrate to PostgreSQL.