DBS-C01 Practice Test 33 — 15 Questions

Question 1

A company is migrating a 1 TB on-premises SQL Server database to Amazon RDS for SQL Server. The migration must be completed within 24 hours and with minimal downtime. Which TWO approaches should be used? (Choose 2)

Accepted Answer

Use AWS DMS with ongoing replication (CDC).. Options A and D are correct because DMS with CDC provides near-zero downtime, and SCT can help with schema conversion. Option B is wrong because backup/restore requires downtime. Option C is wrong because it's not efficient. Option E is wrong because SSIS is not DMS.

Answer

Use AWS DMS with SSIS packages.

Answer

Use native backup and restore to S3.

Answer

Use AWS DMS full load only.

Question 2

A company is migrating a 5 TB SQL Server database to Amazon RDS for SQL Server. The migration must be completed within 48 hours with minimal downtime. The network bandwidth between on-premises and AWS is 500 Mbps. What is the MOST efficient migration strategy?

Accepted Answer

Use AWS Snowball to transfer the full database to an RDS instance, then use AWS DMS for ongoing replication. Given the bandwidth and time constraints, using AWS DMS with ongoing replication is the best approach for minimal downtime. However, the initial load may be slow. Using Snowball to transfer the full database and then using DMS for ongoing replication is more efficient, as it avoids the initial load over the network. Direct Connect doesn't solve bandwidth limitation. SCT is for schema conversion.

Answer

Upgrade network bandwidth to 10 Gbps using AWS Direct Connect

Answer

Use AWS Database Migration Service (AWS DMS) with ongoing replication

Answer

Use AWS Schema Conversion Tool (AWS SCT) to migrate the schema, then use bulk insert

Question 3

An administrator is deploying an Amazon RDS for MySQL DB instance and needs to ensure that all connections use SSL. Which parameter should be set on the RDS DB instance?

Accepted Answer

Set require_secure_transport=ON in the DB parameter group. Option A is correct because setting require_secure_transport to ON in the DB parameter group forces SSL connections. Option B is wrong because rds.force_ssl is not a valid parameter; the correct MySQL parameter is require_secure_transport. Option C is wrong because ssl_cipher is for specifying ciphers, not enforcing SSL. Option D is wrong because tls_version sets the minimum TLS version, but does not enforce SSL.

Answer

Set ssl_cipher in the DB parameter group

Answer

Set tls_version in the DB parameter group

Answer

Set rds.force_ssl=1 in the DB parameter group

Question 4

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

Accepted Answer

AWS DMS. Option C is correct because AWS Database Migration Service (DMS) supports ongoing replication from on-premises to RDS with minimal downtime. Option A is wrong because S3 is for storage, not database migration. Option B is wrong because Snowball is for large data transfer, not ongoing replication. Option D is wrong because RDS does not support native pglogical replication from on-premises easily.

Answer

AWS Snowball Edge

Answer

AWS S3

Answer

RDS native PostgreSQL logical replication

Question 5

Which THREE actions should be taken to prepare for a migration of an on-premises MySQL database to Amazon RDS for MySQL with minimal downtime using AWS DMS?

Accepted Answer

Enable binary logging on the source MySQL database. Correct: A (enable binary logging for CDC), B (create a user with replication privileges), and E (set up an SSH tunnel for secure connection). C is not required; D is not necessary for DMS.

Answer

Disable foreign key checks on the source database

Answer

Take a full backup of the source database

Question 6

A company is deploying a new application that requires a MySQL-compatible database with automatic scaling of compute and storage resources. Which AWS service should be used?

Accepted Answer

Amazon Aurora MySQL. Amazon Aurora with Auto Scaling capabilities (Aurora Auto Scaling for replicas, storage auto scaling). Option A: RDS MySQL has manual scaling only. Option C: DynamoDB is NoSQL. Option D: Redshift is data warehouse.

Answer

Amazon RDS for MySQL

Answer

Amazon DynamoDB

Answer

Amazon Redshift

Question 7

A company is migrating a 5 TB Oracle database to Amazon Aurora PostgreSQL. The database has a 4-hour maintenance window weekly. Which migration approach minimizes downtime?

Accepted Answer

Use AWS Database Migration Service (DMS) with change data capture (CDC).. Option B is correct because AWS DMS supports ongoing replication with minimal downtime. Option A is wrong because native export/import requires downtime. Option C is wrong because it adds unnecessary complexity. Option D is wrong because SCT is for schema conversion, not data migration.

Answer

Use Oracle Data Pump to export and pg_restore to import.

Answer

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

Answer

Use AWS DMS full load only and then manually sync.

Question 8

A company is migrating a 5 TB Oracle database to Amazon Aurora PostgreSQL. They have a 4-hour maintenance window weekly. Which THREE steps should be taken to minimize downtime? (Choose 3)

Accepted Answer

Use AWS Snowball to transfer the initial data load.. Options A, C, and D are correct because DMS with CDC provides near-zero downtime; SCT helps with schema conversion; Snowball can transfer initial load fast. Option B is wrong because it doesn't help with migration. Option E is wrong because it's not needed since DMS handles replication.

Answer

Create an Aurora read replica for testing.

Answer

Use AWS Direct Connect for network connectivity.

Question 9

A company is deploying a new application that uses Amazon RDS for PostgreSQL. The application must be highly available with automatic failover in the event of a database failure. Which configuration should be used?

Accepted Answer

Deploy a Multi-AZ RDS instance with a standby in a different Availability Zone. Multi-AZ deployment with a standby instance in a different Availability Zone provides automatic failover. Read replicas are for read scaling, not failover. Single-AZ has no automatic failover. Cross-Region replication is for disaster recovery, not automatic failover.

Answer

Use a read replica in a different Availability Zone

Answer

Deploy the RDS instance in a single Availability Zone with automated backups

Answer

Deploy the RDS instance in a Cross-Region replication configuration

Question 10

A company is migrating a 2 TB PostgreSQL database from on-premises to Amazon RDS for PostgreSQL. The migration must have minimal downtime and support ongoing replication. Which AWS service should be used for the migration?

Accepted Answer

AWS Database Migration Service (DMS) with change data capture. Option A is correct because AWS DMS supports ongoing replication from on-premises PostgreSQL to RDS for PostgreSQL using logical replication. Option B is wrong because S3 is for storage, not database migration. Option C is wrong because Snowball is for large data transfer offline, not minimal downtime replication. Option D is wrong because Database Migration Service is the correct name, not Data Migration Service.

Answer

AWS S3 Transfer Acceleration for direct database export

Answer

AWS Data Migration Service with AWS Glue

Answer

AWS Snowball Edge for offline data transfer

Question 11

A company needs to deploy a globally distributed application with a database that supports multi-region writes and automatic conflict resolution. Which AWS database service should be used?

Accepted Answer

Amazon DynamoDB Global Tables. Option D is correct because Amazon DynamoDB Global Tables supports multi-region writes and automatic conflict resolution. Option A is wrong because RDS for MySQL Multi-AZ is single-region. Option B is wrong because Aurora Global Database is for reads, not writes in multiple regions. Option C is wrong because ElastiCache is a cache, not a primary database.

Answer

Amazon Aurora Global Database

Answer

Amazon RDS for MySQL with Multi-AZ

Answer

Amazon ElastiCache for Redis

Question 12

A company needs to migrate a 100 GB on-premises SQL Server database to Amazon RDS for SQL Server. The migration must be completed within a 4-hour maintenance window. The network link has 500 Mbps throughput. Which approach should be used?

Accepted Answer

Use native SQL Server backup to S3, then restore to RDS. Option A is correct because native backup to S3 and restore to RDS is the fastest method for this size, and the network can transfer 100 GB in ~30 minutes. Option B is wrong because DMS with CDC adds complexity and is not needed. Option C is wrong because Snowball is unnecessary. Option D is wrong because EC2 is not needed.

Answer

Use AWS DMS with full load and CDC

Answer

Use AWS Snowball Edge to transfer the backup

Answer

Launch an EC2 instance with SQL Server, copy the database, and then migrate to RDS

Question 13

A company wants to migrate a 2 TB Amazon RDS for MySQL DB instance to Amazon Aurora MySQL. The migration must have zero downtime and must be reversible for 48 hours. Which strategy meets these requirements?

Accepted Answer

Create an Aurora MySQL Read Replica from the RDS MySQL instance, then promote the replica to a standalone Aurora cluster.. Creating an Aurora read replica from the RDS MySQL instance and then promoting it provides zero downtime and allows fallback by deleting the Aurora cluster. Option A (DMS with CDC) has potential downtime. Option C (snapshot restore) is irreversible. Option D (mysqldump) causes downtime.

Answer

Take a snapshot of the RDS MySQL instance, restore it to Aurora MySQL, and update the DNS.

Answer

Export the database using mysqldump, import into Aurora, and switch DNS.

Answer

Use AWS DMS with ongoing change data capture (CDC) to migrate to Aurora.

Question 14

A company is migrating a 2 TB MongoDB database to Amazon DocumentDB. Which TWO factors should be considered when planning the migration?

Accepted Answer

Source MongoDB version compatibility with DocumentDB.. DocumentDB does not support all MongoDB features (e.g., some index types), so compatibility check is needed. Network bandwidth impacts migration speed. Option C: DocumentDB supports TLS. Option D: DocumentDB uses IAM for auth, not LDAP. Option E: DocumentDB uses its own backup, not S3.

Answer

DocumentDB stores backups in Amazon S3 automatically.

Answer

DocumentDB requires LDAP for authentication.

Answer

DocumentDB does not support encryption in transit.

Question 15

A company needs to migrate an on-premises PostgreSQL database to Amazon Aurora PostgreSQL with minimal downtime. Which AWS service should be used for the ongoing replication?

Accepted Answer

AWS Database Migration Service (DMS).. Option A is correct because AWS DMS supports ongoing replication from PostgreSQL to Aurora. Option B is wrong because it's for schema conversion. Option C is wrong because it's a general ETL tool. Option D is wrong because it's a backup service.

Answer

AWS Glue.

Answer

AWS Backup.

Answer

AWS Schema Conversion Tool (SCT).