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

Question 1

An IAM role with the above trust policy is created. The role is then attached to an EC2 instance. The application on the EC2 instance tries to create an RDS DB instance using the AWS SDK. What will happen?

Accepted Answer

The call will fail because the role's permissions policy does not allow rds:CreateDBInstance. The trust policy allows the EC2 service to assume the role, but the IAM policy attached to the role (not shown) must also allow rds:CreateDBInstance. The trust policy alone does not grant permissions; it only allows the service to assume the role. The actual permissions come from the role's permissions policy. Without that, the call will fail. Option B is incorrect because the trust policy is valid for EC2. Option C is incorrect because trust policy does not grant permissions. Option D is incorrect because the trust policy is correct.

Answer

The call will succeed because the trust policy grants permissions to EC2

Answer

The call will succeed because the trust policy allows EC2 to create RDS instances

Answer

The call will fail because the trust policy does not include the RDS service

Question 2

An administrator runs the above AWS CLI command to create an RDS MySQL instance. The command completes successfully. What is the status of the new DB instance immediately after the command returns?

Accepted Answer

creating. When the create-db-instance command returns, the DB instance state is 'creating'. It takes several minutes for the instance to become 'available'. Option A (available) is incorrect because creation is not instant. Option C (stopped) is incorrect. Option D (deleting) is incorrect.

Answer

available

Answer

stopped

Answer

deleting

Question 3

A company is migrating an on-premises MySQL database to Amazon RDS for MySQL. The database is 2 TB in size and the network bandwidth is 100 Mbps. The company needs to minimize downtime. Which migration strategy should be used?

Accepted Answer

Use AWS Database Migration Service (DMS) with ongoing replication.. Option B is correct because AWS DMS can replicate ongoing changes after an initial full load, minimizing downtime. Option A is wrong because mysqldump would be slow and cause more downtime. Option C is wrong because S3 is not directly used for live migration. Option D is wrong because RDS does not support direct restore of physical backups from on-premises.

Answer

Copy database files to Amazon S3, then restore to RDS using native restore.

Answer

Use mysqldump to export the database and import it into RDS.

Answer

Use AWS Server Migration Service to migrate the database server.

Question 4

A company is deploying a new multi-AZ Aurora MySQL database. The application requires read-heavy workloads and low latency. Which configuration will best meet these requirements?

Accepted Answer

Enable Aurora Auto Scaling with a target metric of average CPU utilization.. Option C is correct because Aurora Auto Scaling dynamically adds reader instances based on the average CPU utilization metric, which directly addresses the read-heavy workload requirement by distributing read traffic across multiple replicas. This configuration ensures low latency by scaling out read capacity automatically as demand increases, without manual intervention.

Answer

Enable Multi-AZ and use the secondary for read traffic.

Answer

Deploy a single instance with one read replica in the same AZ.

Answer

Use an RDS Proxy in front of the database.

Question 5

A company is migrating a 5 TB Oracle database to Amazon RDS for Oracle. The database has several large tables with LOB columns. The migration must have minimal downtime. Which approach should be taken?

Accepted Answer

Use AWS DMS with LOB support and ongoing replication from Oracle to RDS.. AWS DMS with LOB support and ongoing replication (change data capture, CDC) is the correct approach because it enables a near-zero downtime migration by continuously replicating changes from the source Oracle database to Amazon RDS for Oracle after an initial full load. DMS handles large LOB columns efficiently using its 'Full LOB mode' or 'Limited LOB mode' settings, which are critical for tables with LOB data. The combination of full load + CDC ensures minimal downtime, as the target remains synchronized until cutover.

Answer

Use Oracle GoldenGate to replicate data to RDS.

Answer

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

Answer

Copy the database files to Amazon S3 and use the rdsadmin.rds_restore_from_s3 procedure.

Question 6

A company needs to migrate a SQL Server database to Amazon RDS for SQL Server. The database uses stored procedures with xp_cmdshell. What should the company do?

Accepted Answer

Rewrite the stored procedures to remove dependency on xp_cmdshell before migration.. Amazon RDS for SQL Server does not support the xp_cmdshell extended stored procedure because it allows execution of operating system commands, which violates the managed service model where AWS controls the host OS. The correct approach is to rewrite the stored procedures to remove dependency on xp_cmdshell before migration, using alternatives such as SQL Server Agent jobs, CLR integration, or external scripting via AWS Lambda or EC2.

Answer

Use RDS Custom for SQL Server to retain full control.

Answer

Enable xp_cmdshell in the RDS parameter group.

Answer

Disable xp_cmdshell in the stored procedures and migrate as-is.

Question 7

A company is deploying a new DynamoDB table for a global application. The table must have low latency reads and writes across multiple AWS regions. Which configuration should be used?

Accepted Answer

Use DynamoDB global tables with replicate streams.. Option C is correct because DynamoDB global tables provide multi-region replication. Option A is wrong because DAX only caches in one region. Option B is wrong because a single table in one region does not provide global low latency. Option D is wrong because DynamoDB Accelerator is for in-memory caching, not replication.

Answer

Enable DynamoDB Accelerator (DAX) in each region.

Answer

Use DynamoDB Accelerator (DAX) with cross-region replication.

Answer

Create a single table in the primary region and use Amazon CloudFront for reads.

Question 8

A company is migrating a PostgreSQL database to Amazon RDS for PostgreSQL. The source database uses custom functions written in PL/Python. What should the company consider?

Accepted Answer

Rewrite the functions in PL/pgSQL or another supported language.. Amazon RDS for PostgreSQL does not support PL/Python because it requires the installation of an untrusted procedural language, which poses security risks in a managed database environment. The correct approach is to rewrite the custom functions in a supported language such as PL/pgSQL, PL/Perl, or PL/Tcl, which are trusted languages available in RDS for PostgreSQL.

Answer

Modify the DB parameter group to enable PL/Python.

Answer

Use RDS Custom for PostgreSQL to install PL/Python.

Answer

Migrate to Aurora PostgreSQL which supports PL/Python.

Question 9

A company is migrating a 10 TB MongoDB database to Amazon DocumentDB. The migration must have minimal downtime. Which strategy should be used?

Accepted Answer

Use AWS DMS with MongoDB as source and DocumentDB as target, with change data capture.. AWS DMS with MongoDB as source and DocumentDB as target, using change data capture (CDC), is the correct strategy because it enables a live migration with minimal downtime. DMS performs an initial full load of the 10 TB database and then continuously replicates ongoing changes from the MongoDB oplog, allowing you to cut over to DocumentDB with only a brief pause.

Answer

Use mongodump to export the database and mongorestore to import into DocumentDB.

Answer

Use AWS CloudEndure to replicate the MongoDB server to DocumentDB.

Answer

Copy the database files to Amazon S3 and restore to DocumentDB.

Question 10

A company is deploying a new RDS for MySQL database and needs to ensure that connections are encrypted using TLS. Which parameter should be configured?

Accepted Answer

Set the rds.force_ssl parameter to 1 in the DB parameter group.. Option D is correct because rds.force_ssl=1 enforces TLS connections. Option A is wrong because ssl_ca is a certificate authority, not an enforcement parameter. Option B is wrong because require_secure_transport is for MySQL, not RDS. Option C is wrong because tls_version sets the TLS version, not enforce encryption.

Answer

Set the ssl_ca parameter to the RDS CA certificate.

Answer

Set the require_secure_transport parameter to ON.

Answer

Set the tls_version parameter to TLSv1.2.

Question 11

A company is migrating an on-premises Oracle database to Amazon RDS for Oracle using AWS DMS. The migration fails with an error indicating that DMS cannot capture changes from the source because the archive log mode is not enabled. What should be done?

Accepted Answer

Enable archive log mode on the source Oracle database.. Option B is correct because DMS requires archive log mode for ongoing replication. Option A is wrong because DMS can use full load without archive logs, but for ongoing replication it needs them. Option C is wrong because setting up a standby does not help DMS. Option D is wrong because SCT does not affect capture.

Answer

Disable ongoing replication and perform a full load only.

Answer

Set up an Oracle Data Guard standby and use it as the source.

Answer

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

Question 12

Which TWO options are valid methods for migrating an on-premises SQL Server database to Amazon RDS for SQL Server with minimal downtime? (Choose TWO.)

Accepted Answer

Use AWS DMS with ongoing replication from the source.. Options B and D are correct because AWS DMS with ongoing replication and native backup/restore with log shipping can minimize downtime. Option A is wrong because import/export is offline. Option C is wrong because S3 is not used for direct migration. Option E is wrong because CloudEndure is for servers.

Answer

Use AWS CloudEndure to replicate the entire server.

Answer

Copy the database files to Amazon S3 and restore to RDS.

Answer

Use SQL Server Import/Export Wizard.

Question 13

Which THREE factors should be considered when choosing between Amazon RDS and Amazon DynamoDB for a new application? (Choose THREE.)

Accepted Answer

The query patterns and access methods required by the application.. Option C is correct because the choice between Amazon RDS (relational) and DynamoDB (NoSQL) hinges on the application's data access patterns. RDS supports complex SQL queries with joins, aggregations, and secondary indexes, while DynamoDB is optimized for key-value and document queries with predictable, low-latency access patterns. If the application requires flexible querying with ad-hoc filters, RDS is appropriate; if it needs high-throughput, single-key lookups or simple query patterns, DynamoDB is better suited.

Answer

The requirement for encryption at rest.

Answer

The need for multi-AZ high availability.

Question 14

Which TWO steps are required when migrating an Oracle database to Amazon RDS for Oracle using AWS DMS with ongoing replication? (Choose TWO.)

Accepted Answer

Enable archive logging on the source Oracle database.. Option C is correct because AWS DMS requires archive logging on the source Oracle database to capture ongoing changes for continuous replication. Archive logging ensures that redo logs are retained and available for DMS to read transaction changes after a log switch, enabling Change Data Capture (CDC) without data loss.

Answer

Run AWS Schema Conversion Tool (SCT) to convert the schema.

Answer

Enable minimal supplemental logging.

Answer

Create a VPC endpoint for the DMS replication instance.

Question 15

Refer to the exhibit. A company wants to migrate this RDS MySQL instance to an Aurora MySQL cluster with encryption at rest. What is the most efficient approach?

Accepted Answer

Create a snapshot of the RDS instance, copy the snapshot with encryption, then restore to an Aurora cluster.. Option D is correct because creating a snapshot, copying it with encryption, and restoring to Aurora is the most efficient. Option A is wrong because DMS is not needed for a simple migration. Option B is wrong because you cannot directly restore an unencrypted snapshot to Aurora. Option C is wrong because creating an Aurora replica from an encrypted instance is not possible.

Answer

Use AWS DMS to migrate the database to an encrypted Aurora cluster.

Answer

Create a snapshot of the RDS instance and restore it directly to an Aurora cluster.

Answer

Create an encrypted read replica in Aurora and promote it.

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

Exhibit

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

Exhibit