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

Question 1

A company is migrating an on-premises PostgreSQL database to Amazon RDS for PostgreSQL. They need to minimize downtime and ensure data consistency. Which TWO methods can be used together to achieve this?

Accepted Answer

Use AWS DMS with full load and CDC. AWS DMS with full load and Change Data Capture (CDC) enables a zero-downtime migration by first copying the existing data (full load) and then continuously replicating ongoing changes from the on-premises PostgreSQL source to the Amazon RDS for PostgreSQL target. This ensures data consistency because CDC captures transactions in near real-time using the PostgreSQL logical replication slot mechanism, allowing the target to stay synchronized until the cutover.

Answer

Take a file system snapshot and copy to Amazon EBS

Answer

Use pg_dump and pg_restore

Answer

Export data to Amazon S3 and import using COPY

Question 2

A company is migrating a 2 TB PostgreSQL database from on-premises to Amazon RDS for PostgreSQL with minimal downtime. The database is continuously updated. Which migration strategy should be used?

Accepted Answer

Use AWS Database Migration Service (DMS) with ongoing replication from an on-premises source.. Option B (AWS DMS with ongoing replication) is correct because it supports minimal downtime by continuously replicating changes. Option A (native pg_dump/pg_restore) requires downtime. Option C (AWS Database Migration Service with full load only) does not replicate ongoing changes. Option D (SCT with Snowball) is for large-scale schema conversion, not minimal-downtime migration.

Answer

Use AWS Schema Conversion Tool (SCT) and AWS Snowball to transfer data.

Answer

Use AWS Database Migration Service with a full load only, then cut over.

Answer

Use pg_dump and pg_restore during a maintenance window.

Question 3

A company is migrating a 500 GB Oracle database to Amazon Aurora PostgreSQL. They need to convert the schema and migrate the data. The application uses Oracle-specific features like hierarchical queries and stored procedures. Which combination of services should they use?

Accepted Answer

Use AWS Schema Conversion Tool (SCT) to convert the schema and AWS Database Migration Service (DMS) to migrate the data.. Option D (SCT for schema conversion, DMS for data migration) is correct because SCT converts Oracle schema including stored procedures and hierarchical queries, and DMS migrates the data. Option A (DMS only) does not convert schema. Option B (SCT only) does not migrate data. Option C (Snowball with SCT) is for large data transfers but not for ongoing replication or schema conversion of complex features.

Answer

Use AWS Snowball Edge to transfer the database files and then use SCT to convert the schema.

Answer

Use AWS Database Migration Service (DMS) with the Oracle as source and Aurora PostgreSQL as target.

Answer

Use AWS Schema Conversion Tool (SCT) to convert the schema and then manually export/import data.

Question 4

A company is deploying a new web application and needs a fully managed relational database with automatic failover and read replicas. Which AWS service should they choose?

Accepted Answer

Amazon RDS for MySQL with Multi-AZ deployment. Amazon RDS for MySQL with Multi-AZ deployment provides a fully managed relational database service that automatically provisions and maintains a synchronous standby replica in a different Availability Zone. In the event of a failure, Amazon RDS automatically fails over to the standby, ensuring high availability. Additionally, RDS for MySQL supports read replicas for offloading read traffic, which meets the requirement for both automatic failover and read replicas.

Answer

Amazon DynamoDB

Answer

Amazon EC2 with self-managed MySQL

Answer

Amazon Redshift

Question 5

A company is migrating a self-hosted MongoDB database to Amazon DocumentDB. They need to ensure that indexes are created after the data load to improve migration performance. Which migration strategy should they use?

Accepted Answer

Use AWS Database Migration Service (DMS) with the 'lob' mode set to 'Don't include LOB columns' and create indexes after the full load.. Option A (Use AWS DMS with 'lob' mode disabled and create indexes after load) is correct because creating indexes after data load improves migration speed. Option B (Use native mongodump/mongorestore) does not defer index creation. Option C (Use DMS with 'create indexes before load') slows down migration. Option D (Use SCT for schema conversion) is not necessary for MongoDB to DocumentDB.

Answer

Use AWS Schema Conversion Tool (SCT) to convert the schema and then load data with DMS.

Answer

Use AWS DMS with 'create indexes before data load' option enabled.

Answer

Use mongodump and mongorestore with the --writeConcern option set to 0.

Question 6

A company is deploying a multi-region application with Amazon Aurora Global Database. They need to ensure that the secondary region can be promoted to primary with minimal data loss in the event of a regional failure. Which configuration should they use?

Accepted Answer

Deploy Amazon Aurora Global Database with one primary Region and up to five secondary Regions.. Option B (Aurora Global Database with one primary and up to five secondary regions) is correct because it provides failover with typically less than 1 second of data loss. Option A (Cross-Region Read Replicas) is not Aurora Global Database. Option C (Multi-AZ) is within a region. Option D (Aurora Serverless) does not support global databases.

Answer

Deploy Amazon Aurora Serverless with cross-Region replication.

Answer

Deploy Amazon RDS for MySQL with cross-Region read replicas.

Answer

Deploy Amazon RDS for PostgreSQL with Multi-AZ and cross-Region snapshot copy.

Question 7

A company is migrating a 100 GB SQL Server database to Amazon RDS for SQL Server. They need to minimize downtime and ensure that only the schema is converted. Which tool should they use?

Accepted Answer

AWS Schema Conversion Tool (SCT). AWS Schema Conversion Tool (SCT) is the correct choice because it is specifically designed to convert database schemas (including stored procedures, functions, and data types) from one engine to another, such as SQL Server to Amazon RDS for SQL Server. Since the requirement is to minimize downtime and only convert the schema (not migrate data), SCT can perform an offline schema conversion without impacting the source database, whereas DMS is a continuous data replication tool that would incur downtime for schema changes.

Answer

AWS Database Migration Service (DMS)

Answer

AWS DMS with schema conversion enabled

Answer

SQL Server Management Studio (SSMS)

Question 8

A company is deploying a new application that requires low-latency reads from a relational database across multiple AWS Regions. The application is read-heavy and can tolerate eventual consistency. Which deployment option meets these requirements?

Accepted Answer

Deploy Amazon Aurora Global Database with a primary Region and read replicas in secondary Regions.. Option D (Aurora Global Database with read replicas in secondary Regions) is correct because it provides low-latency reads and eventual consistency. Option A (Single RDS instance with cross-Region read replicas) is possible but read replicas are asynchronous and may have more lag. Option B (DynamoDB Global Tables) is NoSQL. Option C (RDS Multi-AZ) is within a single region.

Answer

Deploy Amazon RDS for PostgreSQL with Multi-AZ and read replicas in the same Region.

Answer

Deploy a single Amazon RDS for MySQL instance with cross-Region read replicas.

Answer

Deploy Amazon DynamoDB Global Tables in multiple Regions.

Question 9

A company is migrating an on-premises Oracle database to Amazon RDS for Oracle. The database uses Oracle Data Pump for export/import. The migration must be completed within a short maintenance window. Which migration approach should they use?

Accepted Answer

Use AWS Database Migration Service with full load and change data capture (CDC).. Option A (Use AWS DMS with a full load + CDC) is correct because it minimizes downtime by capturing changes. Option B (Use Oracle Data Pump export/import) requires significant downtime. Option C (Use AWS SCT to convert schema and then use DMS) is unnecessary if staying on Oracle. Option D (Use AWS Snowball) is for large data transfers, not for minimal downtime.

Answer

Use AWS Snowball to transfer the database files to AWS and then restore to RDS.

Answer

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

Answer

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

Question 10

A company wants to deploy a MySQL database that automatically scales read capacity based on traffic without manual intervention. Which AWS database offering should they use?

Accepted Answer

Amazon Aurora with Auto Scaling for read replicas. Amazon Aurora with Auto Scaling for read replicas is correct because it automatically adjusts the number of Aurora Replicas based on changes in read workload, scaling read capacity without manual intervention. Aurora's Auto Scaling monitors the average CPU utilization or connections of the reader fleet and adds or removes replicas to maintain a target metric, providing seamless read scaling for MySQL-compatible databases.

Answer

Amazon DynamoDB with auto scaling

Answer

Amazon RDS for MySQL with Multi-AZ deployment

Answer

Amazon RDS for MySQL with a Single-AZ deployment

Question 11

A company is migrating a 2 TB MySQL database to Amazon Aurora MySQL. They need to minimize downtime and ensure data consistency. Which TWO actions should they take? (Choose two.)

Accepted Answer

Create an Amazon Aurora MySQL read replica from an Amazon RDS MySQL DB instance.. Options A and C are correct. A: Creating an Aurora read replica from an RDS MySQL snapshot is a common migration approach with minimal downtime. C: Enabling binlog replication from RDS MySQL to Aurora allows continuous replication. Option B (DMS with CDC) is also valid but not listed as correct? Actually DMS is also valid, but the question expects A and C. Option D (SCT) is for schema conversion, not needed for MySQL to Aurora. Option E (Snowball) is for large data, but not minimal downtime.

Answer

Export data using mysqldump and import into Aurora during a maintenance window.

Answer

Use AWS Schema Conversion Tool (SCT) to convert the schema to Aurora MySQL.

Answer

Use AWS Database Migration Service (DMS) with change data capture (CDC) to migrate data.

Question 12

A company is migrating a 500 GB Oracle database to Amazon Aurora PostgreSQL. They need to convert the schema and migrate the data with minimal downtime. Which THREE actions should they take? (Choose three.)

Accepted Answer

Use AWS Schema Conversion Tool (SCT) to assess and convert Oracle-specific features like hierarchical queries.. Options A, B, and D are correct. A: SCT converts the schema. B: DMS with CDC provides minimal downtime. D: Use SCT to assess and convert Oracle-specific features. Option C (modify application to use Aurora-specific features) is not necessary. Option E (Snowball) is not for minimal downtime.

Answer

Modify the application to use Aurora PostgreSQL-specific SQL syntax before migration.

Answer

Use AWS Snowball Edge to transfer the data to AWS and then load into Aurora.

Question 13

A company is deploying a new application using Amazon RDS for PostgreSQL. They require high availability with automatic failover and the ability to offload read traffic. Which TWO features should they enable? (Choose two.)

Accepted Answer

Multi-AZ deployment. Multi-AZ deployment (Option A) provides high availability by automatically provisioning and maintaining a synchronous standby replica in a different Availability Zone. If the primary DB instance fails, Amazon RDS automatically fails over to the standby, ensuring minimal downtime. Read replicas (Option B) offload read traffic by creating asynchronous copies of the database that can serve read queries, reducing load on the primary instance.

Answer

Performance Insights

Answer

Global Database

Answer

Auto Scaling for read replicas

Question 14

A company is migrating a 2 TB Oracle database to Amazon Aurora PostgreSQL. The migration must have minimal downtime and support ongoing replication. Which AWS service should be used?

Accepted Answer

AWS Database Migration Service (AWS DMS). AWS Database Migration Service (AWS DMS) is the correct choice because it supports ongoing replication (change data capture, CDC) from an Oracle source to an Amazon Aurora PostgreSQL target, enabling a migration with minimal downtime. DMS can handle a 2 TB database by using a large replication instance and tuning task settings, and it continuously replicates changes until the cutover is complete.

Answer

AWS DataSync

Answer

Amazon S3 Glacier

Answer

AWS Schema Conversion Tool (AWS SCT)

Question 15

A company needs to migrate a 10 TB SQL Server database from on-premises to Amazon RDS for SQL Server with minimal downtime. The database is heavily used with frequent write operations. Which migration strategy should be used?

Accepted Answer

Use AWS DMS with ongoing replication from the on-premises database to RDS until cutover.. Option C is correct because AWS DMS with ongoing replication allows minimal downtime by keeping the target in sync until cutover. Option A is wrong because native backup/restore would require downtime and is not designed for minimal downtime. Option B is wrong because SCT is for schema conversion, not data migration. Option D is wrong because exporting to CSV and using COPY is not suitable for large databases with minimal downtime.

Answer

Use native SQL Server backup and restore to Amazon S3, then restore to RDS.

Answer

Export the database to CSV files, upload to S3, and use the COPY command in RDS.

Answer

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