Deployment and Migration

A company is migrating a 10 TB Oracle Data Warehouse to Amazon Redshift. The source database runs on premises with limited bandwidth (100 Mbps). The migration must complete within 5 days. Which approach is most cost-effective and meets the timeline?

Refer to the exhibit. An IAM policy is attached to a user who will manage AWS DMS tasks. When the user tries to start a replication task, they receive an access denied error. What is the most likely cause?

A company is migrating a 500 GB PostgreSQL database from on-premises to Amazon Aurora PostgreSQL. The migration must have a recovery point objective (RPO) of less than 5 minutes and a recovery time objective (RTO) of less than 30 minutes. Which migration strategy should the company use?

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

Refer to the exhibit. An IAM policy is attached to a user. The user attempts to create an RDS DB instance named 'new-prod-db' with Oracle Standard Edition Two engine. What will happen?

Match each database engine to its default port number.

A company is migrating a 2 TB SQL Server database to Amazon RDS for SQL Server. They need to minimize downtime and are using AWS DMS with CDC. The migration is taking longer than expected during the full load phase. Which change would most likely improve the full load performance?

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?

Arrange the steps to enable automated backups for an Amazon RDS for PostgreSQL DB instance in the correct order.

A company is migrating a 10 GB MySQL database to Amazon RDS for MySQL. They have a 1 Gbps connection to AWS. The migration must be completed in the least amount of time with minimal manual effort. Which tool should be used?

A company is migrating a 500 GB Oracle database to Amazon RDS for Oracle. They want to minimize downtime and use AWS DMS for ongoing replication. The source database is in a corporate data center behind a firewall. What is the recommended network setup for the DMS replication instance?

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?

A company is planning to migrate a 2 TB Oracle database to Amazon Aurora PostgreSQL. The database contains large objects (LOBs) and uses stored procedures. Which TWO steps should the company take as part of the migration? (Choose two.)

A company is migrating a 3 TB PostgreSQL database from on-premises to Amazon RDS for PostgreSQL. The migration must have minimal downtime. The on-premises network bandwidth to AWS is 1 Gbps. The database supports a critical application that cannot be stopped for more than 30 minutes. The migration team has set up AWS DMS with ongoing replication using CDC. The initial full load is expected to take 8 hours. During the migration, the DMS task fails with an error indicating that the source database's transaction log is being cleaned before DMS can capture changes. The source database has a transaction log retention period of 24 hours. The migration team notices that the CDC phase falls behind during peak hours. What should the team do to complete the migration successfully within the downtime window?

A company is migrating a 2 TB Oracle database to Amazon RDS for Oracle. The database has a large number of stored procedures, triggers, and functions. The company wants to minimize changes to the application code. Which AWS service should be used to assess and convert the database schema?

A company is migrating a 1 TB Microsoft SQL Server database from on-premises to Amazon RDS for SQL Server. The on-premises database uses TDE for encryption. The company must ensure that the migrated database in RDS also uses TDE. Which solution meets this requirement?

A developer is deploying an application that uses Amazon DynamoDB as its database. The application experiences sudden spikes in traffic. Which DynamoDB feature should the developer use to handle the spikes without manual intervention?

A company is migrating a PostgreSQL database to Amazon RDS for PostgreSQL. They want to automate the deployment of the RDS instance using infrastructure as code. Which AWS service should they use?

A company is migrating a 500 GB database from Amazon RDS for MySQL to Amazon Aurora MySQL. The migration must be completed with minimal downtime and no data loss. The RDS instance is Multi-AZ. Which approach should be used?

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?

A team is deploying a new Amazon Aurora MySQL database and needs to load 5 TB of data from an existing Amazon RDS for MySQL database with minimal downtime. The data is stored in InnoDB tables. Which approach is MOST efficient?

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?

A company is deploying a new application that requires a relational database with automatic failover and cross-Region disaster recovery. The application is read-heavy and expects up to 10 GB of data. Which combination of AWS services should be used?

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.)

A company wants to migrate a 2 TB PostgreSQL database from on-premises to Amazon Aurora PostgreSQL. The database has high write throughput and the migration must have minimal impact on source performance. Which solution is MOST appropriate?

A media company is migrating a 5 TB MongoDB database to Amazon DocumentDB. The migration must have minimal downtime. The source MongoDB uses sharding across 10 shards. Which migration strategy is MOST appropriate?

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?

A company is migrating an on-premises DynamoDB table to Amazon DynamoDB in another AWS region. What is the most efficient method to migrate the data?

A company is planning to migrate a MongoDB database to Amazon DocumentDB. The database has several sharded collections. Which migration strategy should be used?

An e-commerce company is migrating its PostgreSQL database to Amazon RDS for PostgreSQL. The database has multiple large tables (over 500 GB each) and the migration window is only 2 hours. Which strategy would be MOST effective to meet the time constraint?

A company is migrating a 5 TB Microsoft SQL Server database to Amazon RDS for SQL Server. The migration must have minimal downtime. The source database is hosted on an EC2 instance. Which combination of steps should be taken?

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?

A company is migrating a 5 TB Oracle database to Amazon Aurora PostgreSQL. The migration must be completed within a weekend. The on-premises network has a 1 Gbps connection to AWS. What is the MOST efficient migration strategy?

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?

A company is migrating a 500 GB PostgreSQL database from on-premises to Amazon Aurora PostgreSQL. The migration must be completed within 6 hours with minimal downtime. The on-premises network bandwidth is 500 Mbps. The team decides to use AWS DMS. During initial full load, DMS reports a 'Target metadata error: cannot write to Aurora' for a specific table. Investigation shows that the table has a trigger that tries to insert into an external web service. What should the team do to resolve this issue?

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?

A company is deploying a new application on Amazon RDS for PostgreSQL. The application requires a database with a specific parameter group that sets 'max_connections' to 500 and 'shared_buffers' to 25% of the instance memory. The company uses CloudFormation to deploy the RDS instance. The CloudFormation template creates a DBInstance with a DBParameterGroup. The deployment fails because the parameter group cannot be associated with the DB instance. What is the most likely cause?

A company is deploying an Amazon RDS for MySQL database in a VPC. The database must be accessible only from a specific set of application servers in the same VPC. Which configuration provides the most secure access?

A company is migrating an on-premises PostgreSQL database to Amazon RDS for PostgreSQL. The database is 2 TB in size and has a high write workload. The company needs to minimize downtime during the migration. Which AWS service or feature should the company use to achieve this?

A company is migrating an on-premises Oracle database to Amazon RDS for Oracle. The database is 5 TB in size and has a daily change rate of 2%. The migration must have minimal downtime. Which migration strategy should be used?

A company is migrating a 500 GB MySQL database from an on-premises server to Amazon RDS for MySQL. The company uses AWS DMS with ongoing replication. The initial full load completes successfully, and the target RDS instance is in sync. However, after a few hours, the replication task fails with an error: 'Last Error: Error executing source loop; The table 'orders' has a row size larger than the maximum payload size of the target endpoint.' The target RDS instance is configured with db.r5.large and the default parameter group. The company has already verified that the table does not have any BLOB or TEXT columns. What is the MOST likely cause of this error?

A company is migrating a 500 GB Oracle database to Amazon RDS for Oracle. They need to validate the migration and ensure data consistency. Which TWO methods should they use?

A company is migrating a 3 TB Oracle database from on-premises to Amazon RDS for Oracle. The migration must have zero downtime. The on-premises server uses Oracle Data Guard for disaster recovery. The network bandwidth is 200 Mbps. The team plans to use AWS DMS with CDC from Oracle redo logs. During the initial full load, DMS reports that the source table 'ORDERS' has a table-level supplemental log missing. The migration fails. What should the team do first to resolve this issue?

A company is migrating an on-premises MySQL database to Amazon RDS for MySQL. The database uses InnoDB tables and is 500 GB in size. The migration must be completed within a 2-hour maintenance window. Which approach is MOST likely to meet the requirement?

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?

A company is deploying a globally distributed application that requires a low-latency, highly available database with multi-region write support. The application needs to handle conflicts automatically. Which AWS database solution meets these requirements?

A company is migrating an on-premises SQL Server database to Amazon RDS for SQL Server. They need to minimize downtime and have a limited network bandwidth of 50 Mbps. The database size is 1 TB. What is the MOST effective approach?

A company is migrating an on-premises PostgreSQL database to Amazon RDS for PostgreSQL. The migration must have minimal downtime. Which TWO AWS services should be used together to achieve this?

A company is migrating an on-premises PostgreSQL database to Amazon RDS for PostgreSQL. The database is 2 TB in size and has a sustained write rate of 50 MB/s. The migration must have minimal downtime. Which migration approach should be used?

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

A company is planning to deploy an Amazon RDS for PostgreSQL instance. Which of the following is a required step to enable automated backups?

A company is migrating a 500 GB MySQL database to Amazon Aurora MySQL. The migration must have minimal downtime and the source database is already using binary logging. Which migration approach should be used?

A company is migrating a 10 TB Oracle database to Amazon RDS for Oracle. The migration window is limited to 24 hours. The source database is running on-premises with a 500 Mbps network connection. Which migration approach should be used?

A company is migrating a MySQL database to Amazon Aurora MySQL. The migration must be completed with minimal downtime. Which TWO methods can achieve this? (Choose two.)

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?

A company is migrating a 2 TB MySQL database to Amazon Aurora MySQL. They need to minimize downtime and ensure data consistency. Which approach should be used?

A company is migrating an on-premises MySQL database to Amazon RDS for MySQL. The company wants to minimize application changes. Which endpoint type should the application use after migration?

A company is planning to migrate a 5 TB Oracle data warehouse to Amazon Redshift. The migration must be completed within a 2-day maintenance window. The source database is heavily normalized and uses complex joins. Which strategy is most appropriate?

A company is migrating a 100 GB Microsoft SQL Server database from an on-premises data center to Amazon RDS for SQL Server. The migration uses AWS DMS with full load only (no ongoing replication). The full load completes successfully, but the company's application team reports that some data in the target database is missing. The source database was not modified during the migration. The DMS task logs show no errors. What is the MOST likely cause of the missing data?

A company is deploying a new application on AWS that requires a highly available relational database with automatic failover and read scaling. The database size is 100 GB and the workload is balanced between reads and writes. Which THREE AWS services or features should be used?

A company is migrating a 2 TB PostgreSQL database from on-premises to Amazon RDS for PostgreSQL. The database has a 4-hour downtime window. The company requires minimal data loss and wants to use AWS DMS. The on-premises network has a 100 Mbps internet connection. Which migration method should the company use?

A company has an Amazon RDS for MySQL database with Multi-AZ deployment. The database is experiencing high CPU utilization due to a reporting workload. The company wants to migrate to Amazon Aurora MySQL to improve performance and scalability. The migration must have minimal downtime. Which migration strategy meets these requirements?

A company wants to test an application against an Amazon RDS for MySQL database with a recent set of production data without impacting the production database. The test database must be available quickly and be refreshed regularly. Which solution should be used?

A company is migrating a database using AWS DMS. The IAM policy shown is attached to the DMS replication instance role. When the DMS replication task is created in the us-west-2 region, it fails. What is the most likely cause?

A company is migrating a MySQL database to Amazon RDS for MySQL. They want to use AWS DMS for continuous replication. Which TWO prerequisites must be met before starting the migration?

A company is migrating a 2 TB Oracle database from on-premises to Amazon RDS for Oracle. The network bandwidth is 100 Mbps. The migration must be completed within 3 days. Which approach is MOST efficient?

A company is migrating an on-premises Oracle database to Amazon RDS for Oracle. The database is 1 TB and has a large number of stored procedures and triggers. The migration must minimize application changes. Which migration approach should be used?

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?

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?

A company is migrating an on-premises MongoDB database to Amazon DocumentDB. They need to ensure that the migration is completed with minimal downtime and that data remains consistent. Which tool should they use?

Refer to the exhibit. A database administrator is trying to use AWS DMS to migrate data from an on-premises Oracle database to Amazon RDS for Oracle. The DMS replication instance is in the same VPC as the RDS instance. The administrator receives an access denied error when starting the replication task. The IAM policy attached to the DMS replication instance is shown. What is the MOST likely cause of the error?

A company is deploying a MySQL database on Amazon RDS and needs to enforce encryption at rest. Which configuration step is required?

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

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

A company is migrating a self-managed PostgreSQL database with extensions (PostGIS, pg_stat_statements) to Amazon RDS for PostgreSQL. After migration, they find that the extensions are not available. What is the most likely cause?

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?

A company is migrating a 2 TB Oracle database to Amazon Aurora PostgreSQL using AWS SCT and DMS. After migration, the application reports that some queries are significantly slower than before. The database schema was converted automatically. What is the most likely cause?

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)

A company is deploying a new Amazon Aurora MySQL database. The development team requires a separate database instance for testing that is a clone of the production database but does not require the same level of performance. What is the MOST cost-effective way to create this test database?

A financial services company is migrating a 2 TB Oracle database to Amazon Aurora PostgreSQL. The database uses Oracle-specific features like hierarchical queries and stored procedures. The company wants to minimize manual code changes. Which service should be used to automate schema conversion?

A user has the IAM policy shown in the exhibit. When attempting to create a DMS replication task, they receive an authorization error. What is the most likely missing permission?

A company is planning to migrate a 1 TB MySQL database from on-premises to Amazon RDS for MySQL. The migration must have minimal downtime and support ongoing replication. Which THREE steps should the company include in the migration plan? (Choose THREE.)

A company wants to migrate an on-premises SQL Server database to Amazon RDS for SQL Server. They need to convert stored procedures and functions. Which AWS service should they use?

A database administrator runs the above CLI command. The output shows that 'mydb' is a read replica of 'mydb-source'. The administrator wants to promote 'mydb' to a standalone instance with no downtime. Which action should be taken?

Refer to the exhibit. A developer runs the command against an RDS MySQL instance. The application team reports that the database is experiencing high read latency during peak hours. The database is not currently in Multi-AZ. What is the MOST cost-effective way to reduce read latency?

A company is deploying a new web application on AWS. The application uses Amazon RDS for MySQL with a Multi-AZ deployment. The application team wants to reduce latency for read-heavy workloads. Which action should be taken?

Which THREE considerations are important when deploying Amazon Aurora Global Database? (Choose 3.)

Refer to the exhibit. An IAM policy is attached to a user. The user tries to delete a database instance named 'prod-mydb' in us-east-1. What will happen?

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?

A company wants to migrate a 1 TB MySQL database to Amazon Aurora MySQL with minimal downtime. The database has a high write load. Which TWO options are valid approaches? (Choose two.)

A company wants to deploy a highly available Amazon RDS for MySQL database across two Availability Zones. Which feature should be enabled?

A developer is configuring an RDS for PostgreSQL instance for a new application. The application requires automatic failover to a standby instance in a different Availability Zone. Which deployment option should be selected?

A company is migrating an on-premises Oracle database to Amazon RDS for Oracle. The database is 2 TB in size and has a high transaction rate. The migration must have minimal downtime and support ongoing replication. Which AWS service should be used for the migration?

After migrating a database to Amazon RDS, an application on an EC2 instance in the same VPC cannot connect. The command in the exhibit shows the endpoint. What is the most likely cause?

A company is deploying a new application that requires a globally distributed database with low latency reads. They choose Amazon DynamoDB global tables. What is a key consideration for this deployment?

Which TWO of the following are valid considerations when migrating an on-premises Oracle database to Amazon RDS for Oracle using AWS DMS? (Select TWO.)

A company is migrating a 1 TB SQL Server database to Amazon RDS for SQL Server. The migration requires minimal downtime and must support ongoing changes. Which TWO AWS services should be used together to achieve this? (Choose two.)

A company wants to migrate an on-premises MySQL database to Amazon RDS for MySQL with minimal downtime. The database is 500 GB and has moderate write activity. Which approach is MOST suitable?

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?

A database administrator runs the command shown in the exhibit to create a read replica in us-west-2 from a source DB instance in us-east-1. The command fails. What is the most likely cause?

A company is migrating an on-premises MySQL database to Amazon RDS for MySQL. The database is 500 GB in size and has a 24-hour maintenance window. Which AWS service or tool should be used for the initial data transfer with minimal downtime?

A company is deploying a new Amazon RDS for SQL Server DB instance with Multi-AZ. The database will be used by a critical application that requires minimal downtime during failover. The application uses a single connection string with the CNAME of the RDS endpoint. During a recent failover test, the application experienced a 3-minute timeout. The DBA wants to reduce the failover time. The current RDS instance is db.r5.large with 100 GB gp2 storage. The application is hosted on EC2 in the same VPC. Which change would MOST effectively reduce the failover time?

A company is migrating a 3 TB on-premises Oracle database to Amazon Aurora PostgreSQL. The source database runs Oracle 12c on a Linux server with a 1 Gbps network connection to AWS via Direct Connect. The migration must have minimal downtime and be completed within a 2-day window. The database is heavily used during business hours (9 AM - 5 PM) and has low activity overnight. The company has a test environment on AWS already. The migration team plans to use AWS DMS with CDC for ongoing replication. They also plan to use AWS SCT for schema conversion. They start the migration on a Friday evening. On Saturday morning, the CDC replication lag is increasing, and the target Aurora instance is struggling to keep up. The team notices that the source database has a high number of write transactions even during the weekend, and the DMS replication instance is a small instance type. Which action should the team take to complete the migration on time?

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?

A company has a 100 GB MySQL database on an EC2 instance. They want to migrate to Amazon RDS for MySQL with minimal downtime. They have set up replication from the source to the target using MySQL native replication. After enabling replication, the 'Seconds_Behind_Master' value is increasing. The source database is write-heavy. What should the team do to reduce replication lag?

A company is running a production PostgreSQL database on an EC2 instance (db.m5.xlarge) with 500 GB of gp2 EBS storage. The database is used by a customer-facing application that requires low latency. The company plans to migrate this database to Amazon RDS for PostgreSQL with minimal downtime. The current database has a high write load with frequent updates and deletes, and the table sizes are growing. The company also wants to enable Multi-AZ for high availability and use read replicas for reporting workloads. During migration planning, they discover that the source database has several large unlogged tables and uses custom PostgreSQL extensions that are not available in RDS. Which migration strategy should the company use to minimize downtime and meet all requirements?

A company wants to deploy an Amazon RDS for MySQL database for a new application. The database must be highly available with automatic failover. Which configuration should they choose?

A company is migrating a 200 GB PostgreSQL database to Amazon Aurora PostgreSQL. They want to use the AWS DMS console to create a migration task. The source database is in a VPC and the target Aurora cluster is in the same VPC. The DMS replication instance is also in the same VPC. The source database is publicly accessible. What additional configuration is required to enable connectivity between DMS and the source database?

A company is deploying a new multi-AZ Amazon RDS for PostgreSQL database. The security team requires that all traffic to the database be encrypted in transit. Which configuration ensures this?

Refer to the exhibit. A company is creating an Aurora MySQL cluster using the AWS CLI. The command fails with an error. The company has a default KMS key but the command specifies a customer-managed KMS key. What is the most likely cause of the failure?

A financial services company is migrating a 10 TB Oracle data warehouse to Amazon Redshift. The source database uses a combination of partitioned tables, indexes, and materialized views. The migration team plans to use AWS SCT and DMS. Which approach should the team take to optimize query performance after migration?

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

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?

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?

A company is deploying a new web application on AWS. The application uses Amazon RDS for MySQL as its database. The database must be highly available and automatically failover in the event of an AZ outage. The company also needs to offload read traffic from the primary database to improve performance. The application read-to-write ratio is 80:20. The database workload is variable, with occasional spikes. The company wants a cost-effective solution that scales read capacity automatically. The operations team has limited experience with AWS. Which solution should the company implement?

A company is migrating a 200 GB Oracle database to Amazon Aurora MySQL. They want to minimize downtime and ensure data consistency. Which two services should they use together? (Choose TWO.)

A company is deploying a new web application using Amazon RDS for PostgreSQL. The application requires read-heavy workloads and automatic failover. Which configuration should be used?

A company is deploying a new Amazon RDS for Oracle database in a VPC. The database must be accessed by an application running on an EC2 instance in a different subnet. Which THREE steps are required to allow this access?

A company needs to migrate a 1 TB Oracle database to Amazon RDS for Oracle. The migration must have minimal downtime and the source database is running on-premises. Which TWO AWS services should be used together to achieve this?

A company wants to deploy a DynamoDB table that requires consistent single-digit millisecond latency regardless of traffic spikes. Which DynamoDB capacity mode should be selected?

Refer to the exhibit. An IAM policy is attached to an IAM user that performs database migrations. When the user tries to start an AWS DMS replication task that writes to the RDS instance 'targetdb', the task fails with an access denied error. Which additional permission is required?

A company is migrating a 2 TB Oracle database to Amazon Aurora PostgreSQL. They need to minimize downtime and ensure data consistency. Which migration strategy should they use?

A company is planning to migrate a 5 TB Oracle data warehouse to Amazon Redshift. They need to transform the data during migration. Which AWS service should they use to perform the transformation?

A company wants to migrate an on-premises MongoDB database to Amazon DocumentDB. The migration should be performed with minimal application changes. Which AWS service should be used?

A company is migrating a 2 TB Oracle database running on an on-premises Linux server to Amazon RDS for Oracle. The migration must have minimal downtime and must be fully reversible if any issues arise. The DBA has configured AWS DMS with a full load and ongoing replication task. The full load completes successfully, and CDC is replicating changes. During the cutover window, the DBA stops the source database and promotes the target RDS instance. However, after cutover, the application team reports that some recent transactions are missing from the target database. The DBA confirms that the DMS task showed a 'healthy' status before stopping. Which action should the DBA take to resolve the issue and prevent recurrence?

A company is deploying a new application that requires a highly available DynamoDB table with eventual consistency. The table will be accessed from multiple AWS Regions. What is the most appropriate deployment strategy?

A company is migrating a 2 TB Oracle database from on-premises to Amazon RDS for Oracle. The database has a 4-hour maintenance window and the migration must have minimal downtime. Which AWS service should be used for the migration?

A company needs to migrate a 2 TB PostgreSQL database from an on-premises data center to Amazon Aurora PostgreSQL. The network bandwidth is limited to 100 Mbps. The migration window is 5 days. Which approach is most cost-effective and likely to succeed?

A company is migrating a 500 GB Oracle database to Amazon RDS for Oracle. The migration must be completed within 24 hours with minimal downtime. The on-premises network bandwidth is 1 Gbps. The migration team plans to use AWS DMS with ongoing replication. During the initial load, the DMS task fails with an error indicating that the source database is experiencing high CPU utilization. The source database is a production system serving live traffic. The team needs to reduce the impact on the source database while still meeting the migration deadline. Which approach should the team take?

A company is migrating a 1 TB Amazon RDS for Oracle database to Amazon RDS for PostgreSQL. The migration must be completed within a 4-hour maintenance window. The database has a high volume of transactions. Which migration method minimizes risk of data loss?

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?

A financial services company is migrating a 500 GB Oracle database to Amazon Aurora MySQL-Compatible Edition. The migration must have minimal downtime and support bidirectional replication for a test-and-cutover approach. The company currently uses Oracle GoldenGate for replication. Which migration strategy should be used?

A company wants to migrate an on-premises MongoDB database to Amazon DocumentDB. The migration must be performed with minimal downtime and should support live data synchronization. Which AWS service should be used?

Refer to the exhibit. A company is creating an IAM policy for a migration engineer who needs to perform a database migration from an on-premises SQL Server to Amazon RDS for SQL Server using AWS DMS. The policy is attached to the engineer's IAM user. Which additional permission is required for the engineer to create a DMS replication instance?

A company is migrating an on-premises MySQL database to Amazon RDS for MySQL. The database has a table with 100 million rows. During the migration using AWS DMS, the full load phase is taking too long. What change can speed up the full load?

A company wants to migrate an on-premises Oracle database to Amazon RDS for Oracle with minimal downtime. Which AWS service should be used for the initial data load and ongoing replication?

A company is migrating a 3 TB SQL Server database to Amazon RDS for SQL Server. The migration must be completed with less than 15 minutes of downtime. The company has set up AWS DMS with ongoing replication. During the final cutover, the DMS task fails with a 'Target error: Cannot insert duplicate key' error. What is the most likely cause?

A company is deploying a new Amazon RDS for Oracle instance and needs to ensure high availability and automatic failover. Which configuration should be used?

A company is migrating a 1 TB Microsoft SQL Server database to Amazon RDS for SQL Server using native backup and restore. The DBA has taken a full backup of the source database and uploaded it to an S3 bucket. The DBA then uses the 'aws rds restore-db-instance-from-db-snapshot' CLI command to restore the backup to an RDS instance. The restore fails with an error: 'Could not find the specified backup file in the S3 bucket.' The DBA verifies that the backup file exists in the correct S3 bucket and that the IAM role used by RDS has permissions to access the bucket. What is the most likely cause of the failure?

A company is migrating an on-premises MySQL database to Amazon RDS for MySQL. The database is 500 GB and the migration must have minimal downtime. Which TWO AWS services should be used together to accomplish this?

A company is migrating a 10 TB PostgreSQL database from on-premises to Amazon RDS for PostgreSQL. They need to minimize downtime and have limited network bandwidth. Which approach is most appropriate?

A company is migrating a 5 TB MySQL database to Amazon RDS for MySQL. They need to minimize downtime. Which approach should they use?

A company is migrating a 1 TB SQL Server database from on-premises to Amazon RDS for SQL Server. The database has a large table with a LOB column. The network bandwidth between the on-premises data center and AWS is limited to 50 Mbps. The migration must be completed within a week. Which approach should the company use?

A company is migrating a 2 TB Oracle database to Amazon RDS for Oracle. The migration requires minimal downtime. They use AWS SCT to convert the schema and AWS DMS for data migration. After the full load, DMS ongoing replication is unable to capture changes because the archived redo logs are being deleted on the source before DMS can read them. The source database has a log retention setting of 2 hours. The team cannot increase the retention due to storage constraints. What should they do?

An administrator runs the CLI command shown in the exhibit and sees the output. The DB instance 'mydb' is currently running MySQL 5.7.22. What does the output indicate?

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?

A company has a self-managed Redis cluster that needs to be migrated to Amazon ElastiCache for Redis. The cluster is 100 GB in size and has a high write throughput. The migration must have minimal downtime. Which steps should be taken?

A company wants to migrate its on-premises Oracle database to Amazon Aurora PostgreSQL. The company needs to convert the database schema and code from Oracle to PostgreSQL. Which AWS service should they use for schema conversion?

A company needs to migrate a 100 GB MongoDB database to Amazon DocumentDB (with MongoDB compatibility). The migration must have minimal impact on the source database performance. Which approach should the company take?

A company is migrating a PostgreSQL database to Amazon Aurora PostgreSQL. They want to use the AWS DMS for the migration. Which THREE resources need to be created in the AWS account?

A company is migrating a PostgreSQL database to Amazon Aurora PostgreSQL. To minimize downtime, they plan to use the AWS DMS with change data capture (CDC). During the full load phase, DMS reports an error: 'Failed to add foreign key constraint'. What is the most likely cause?

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

Arrange the steps to configure a read replica for an Amazon RDS for PostgreSQL DB instance in a different AWS Region in the correct order.

A company wants to migrate its Oracle data warehouse to Amazon Redshift. The source database is 10 TB and has many complex stored procedures. Which AWS service should be used primarily for converting the stored procedures to Amazon Redshift compatible code?

A company is migrating an on-premises Oracle database to Amazon RDS for Oracle. They need to minimize downtime. Which TWO actions should they take?

A company is migrating an on-premises PostgreSQL database to Amazon RDS for PostgreSQL. The database is 2 TB and the migration must have minimal downtime. Which TWO AWS services should be used together to accomplish this?

A developer is migrating a self-managed MongoDB database to Amazon DocumentDB. The database contains 500 GB of data. What is the most efficient method to perform the initial data load?

A company is migrating a 5 TB MongoDB database to Amazon DocumentDB. They have a short maintenance window and need to minimize downtime. Which migration strategy should be used?

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?

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?

A company is planning to migrate a 1 TB SQL Server database to Amazon RDS for SQL Server. Which TWO factors should be considered when choosing the migration approach?

An IAM policy is attached to a user who is deploying an RDS database. The user attempts to create a DB instance named 'my-database' using the AWS CLI. Which statement is true?

A company wants to migrate an on-premises Oracle database to Amazon RDS for Oracle with minimal downtime. Which AWS service should be used for the migration?

A company is migrating a 10 TB Oracle data warehouse to Amazon Redshift. The migration must minimize data transfer costs and ensure data integrity. Which TWO steps should the company take?

A company is migrating a 3 TB SQL Server database to Amazon RDS for SQL Server. The migration must have minimal downtime and support point-in-time recovery after migration. Which THREE steps should be included in the migration plan? (Choose three.)

A company is using AWS Database Migration Service (AWS DMS) to migrate a 5 TB MySQL database to Amazon RDS for MySQL. The migration is taking longer than expected. The company notices that the source database has a high volume of write operations. Which configuration change would MOST likely improve the migration performance?

A company is migrating a 500 GB on-premises Oracle database to Amazon RDS for Oracle. The migration must have minimal downtime. Which AWS service should be used for the initial data load and ongoing replication?

A company is deploying a global application that requires a database with sub-millisecond read latency across multiple regions. Which AWS database service should they use?

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?

A company is migrating a 5 TB Oracle database to Amazon RDS for Oracle. The database contains large BFILEs stored in a file system. The company needs to migrate the data with minimal downtime and ensure the BFILEs are migrated. Which THREE steps should the company take?

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.)

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?

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?

A company is migrating a self-hosted Cassandra cluster to Amazon Keyspaces (for Apache Cassandra). The cluster has 10 nodes and handles 50,000 writes per second. Which migration strategy is MOST efficient?

A company uses a self-hosted MySQL database on EC2. They want to migrate to Amazon RDS for MySQL with minimal downtime and automated failover. Which migration strategy should be used?

A company is deploying a new application that uses Amazon RDS for MySQL. The database must be highly available with automatic failover. Which deployment configuration meets these requirements?

A company has a 200 GB PostgreSQL database on-premises and wants to migrate to Amazon RDS for PostgreSQL. The company requires encrypted data transfer and wants to minimize downtime. Which combination of services should be used?

A company is deploying a new Amazon RDS for MySQL database. The security team requires that all data at rest be encrypted. What is the simplest way to meet this requirement?

A company is migrating an on-premises Oracle database to Amazon Aurora PostgreSQL. They used AWS SCT to convert the schema, but some stored procedures failed to convert automatically. What is the best course of action?

An administrator needs to migrate an on-premises MongoDB database to Amazon DocumentDB. The migration must have near-zero downtime. Which approach should the administrator use?

A company is migrating a 500 GB MySQL database from on-premises to Amazon RDS for MySQL. The database is critical and must have minimal downtime. Which approach should be used to migrate the database with the least downtime?

A company is deploying a new Amazon RDS for MariaDB instance. The database must be accessible from a specific set of EC2 instances in a VPC. How should the company configure security to allow access?

A company is migrating a 500 GB SQL Server database to Amazon RDS for SQL Server. The database has a large number of stored procedures and triggers. The migration must have minimal downtime. Which approach should be used?

A company is migrating a 3 TB Oracle database to Amazon RDS for Oracle. The migration uses AWS DMS with ongoing replication. The source database is actively used by applications. After the initial full load, the target RDS instance is in sync. However, during the ongoing replication phase, the replication task fails with an error: 'ORA-1555: snapshot too old.' The DMS task has been set up with a source endpoint that uses the 'Oracle TNS' connection method. The company needs to resolve the issue without stopping the source database. Which action should be taken?

A company is migrating a 2 TB MySQL database from on-premises to Amazon RDS for MySQL. They need to minimize downtime and ensure data consistency. They plan to use AWS DMS. What is the first step they should take before starting the migration task?

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

A company is planning to deploy a new Amazon RDS for Oracle database in a Multi-AZ configuration. The database must be highly available and fault-tolerant. Which THREE actions should the company take to meet these requirements? (Choose three.)

A company wants to migrate a self-hosted MongoDB database to Amazon DocumentDB. They need to convert the schema. Which AWS service should they use?

A company is migrating a 3 TB on-premises Oracle database to Amazon Aurora PostgreSQL using AWS DMS. The migration task is failing with an error indicating insufficient memory. Which TWO actions should the company take to resolve this issue? (Choose TWO.)

A company is deploying a new Amazon RDS for PostgreSQL DB instance. Which THREE actions are recommended for a secure deployment?

An administrator is setting up an AWS DMS replication instance and attaches the IAM policy shown in the exhibit. The administrator receives an error that the replication instance cannot be created. Which missing permission is the MOST likely cause?

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?

A company is migrating a 2 TB SQL Server database to Amazon RDS for SQL Server. They have a limited maintenance window and need to minimize downtime. Which TWO strategies should they combine?

A company is migrating a 500 GB on-premises PostgreSQL database to Amazon RDS for PostgreSQL. The migration must have minimal downtime and support ongoing replication after the initial load. The network link has limited bandwidth, and the company wants to avoid costly data transfer fees. Which approach should be used?

Which TWO actions are recommended when deploying an Amazon RDS for MySQL instance in a production environment to ensure high availability and durability? (Choose two.)

A developer needs to deploy an Amazon RDS for MySQL DB instance that is accessible only from a specific EC2 instance in a VPC. Which configuration ensures this?

Which TWO of the following are valid methods to migrate an on-premises MySQL database to Amazon RDS for MySQL? (Select TWO.)

A company is deploying a new web application that uses Amazon RDS for MySQL. The application must be highly available across three Availability Zones with automatic failover. Which deployment configuration should be used?

A company has a 50 GB MariaDB database on an on-premises server. They want to migrate to Amazon RDS for MariaDB. They have a 100 Mbps network connection. The migration window is 2 hours. The database can be offline for up to 30 minutes. Which migration approach is most appropriate?

A company is migrating a self-managed PostgreSQL database to Amazon Aurora PostgreSQL. They want to use the pglogical extension for logical replication to minimize downtime. Which THREE prerequisites must be met before setting up pglogical?

A company is migrating a 3 TB MySQL database to Amazon Aurora MySQL. They need to validate data consistency after migration. Which approach should they use?

A company is migrating a 500 GB SQL Server database to Amazon RDS for SQL Server. They need to minimize downtime and support ongoing changes during migration. Which approach should they take?

Match each AWS security feature to its purpose for databases.

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?

A company is deploying a new Amazon DynamoDB table with on-demand capacity. The table will store session data for a web application. Which THREE features should be enabled to improve performance and durability?

A company is moving a self-hosted MySQL database to Amazon Aurora MySQL. The current database uses InnoDB with full-text indexes and triggers. The migration must be done with zero downtime. Which approach meets these requirements?

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?

A database administrator is trying to delete the RDS instance named 'prod-critical' using the AWS CLI. The IAM policy shown is attached to the user. What will happen?

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?

A team is using AWS DMS to migrate a 3 TB Oracle database to Amazon Aurora PostgreSQL. They configured the task as shown. After the full load completes, they notice that the target tables have no indexes, primary keys, or foreign keys. What is the most likely cause?

A company is deploying an Amazon DynamoDB table with on-demand capacity mode. The table will be accessed from multiple AWS Regions and requires strong consistency. Which THREE steps should be taken to meet these requirements?

A company is deploying a new MySQL database on Amazon RDS. They need to ensure that the database is automatically backed up daily and retained for 30 days. Which TWO configurations should be set? (Choose 2)

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?

A company is migrating a 200 GB MySQL database to Amazon Aurora MySQL. The migration must be completed within a 1-hour downtime window. Which TWO methods can achieve this?

A company is migrating a 200 GB Oracle database to Amazon RDS for Oracle. Which TWO steps should be taken to ensure a successful migration? (Choose two.)

A company is migrating a 2 TB Oracle database to Amazon Aurora PostgreSQL. The migration requires ongoing replication for minimal downtime. Which THREE AWS services should be used?

A company wants to deploy a globally distributed application with a DynamoDB table that uses optimistic locking. Which DynamoDB feature should be used to implement this?

A company is deploying a new application that uses Amazon RDS for PostgreSQL. The database must be highly available and fault-tolerant. Which deployment option meets these requirements?

Which TWO of the following are required when migrating an on-premises Oracle database to Amazon RDS for Oracle using AWS DMS with change data capture (CDC)? (Select TWO.)

A company is deploying a new application using Amazon DynamoDB. They need to ensure data durability and availability. Which THREE steps should they take? (Choose three.)

A company is planning to migrate a 3 TB PostgreSQL database from an on-premises data center to Amazon Aurora PostgreSQL. The migration must have near-zero downtime. The on-premises database is using a custom pg_hba.conf that restricts access to specific IP ranges. Which combination of steps will meet the requirements?

A company is migrating a 1 TB SQL Server database to Amazon RDS for SQL Server. They use AWS DMS with full load and ongoing replication. After the full load completes, they observe that the ongoing replication is falling behind and the target database is not consistent. The source database has high transaction volume. What is the most effective way to improve replication performance?

A company wants to migrate an on-premises MySQL database to Amazon RDS for MySQL with minimal downtime. They plan to use AWS DMS. Which source database configuration is required to enable ongoing replication (CDC)?

A company is migrating a 5 TB Oracle database to Amazon RDS for Oracle. The migration must have minimal downtime and support a cutover window of less than 30 minutes. The company is using AWS DMS with ongoing CDC. Which THREE steps should be taken to minimize cutover time? (Choose three.)

A company is deploying a new web application that uses Amazon RDS for MySQL. To improve read performance, they add a read replica. However, the application reports stale data. What is the most likely cause?

A company is deploying a multi-AZ Aurora MySQL database. They need to ensure that failover happens automatically with minimal data loss. Which configuration should be used?

A company is using an Amazon RDS for SQL Server database with Multi-AZ deployment. They need to migrate to Amazon RDS for SQL Server in a different AWS region. The database is 1 TB and cannot tolerate more than 15 minutes of downtime. Which strategy minimizes downtime?

A company is deploying a MySQL RDS instance using this CloudFormation template. After deployment, they notice that the database is not automatically backed up at the scheduled time. What is the most likely cause?

A company is migrating a 5 TB MySQL database to Amazon Aurora MySQL. The migration must have zero downtime and the source database is continuously written to. The team plans to use AWS DMS with ongoing replication. However, they notice that the target Aurora instance is not receiving all changes from the source. Which configuration change is most likely required to resolve this?

Refer to the exhibit. A company's production RDS MySQL instance 'mydb' is configured as shown. The application experiences write latency spikes during peak hours. Which action would most effectively reduce write latency?

A company is migrating an on-premises PostgreSQL database to Amazon RDS for PostgreSQL. Which TWO AWS services can be used to assess the source database for compatibility and migration readiness?

A company is migrating a 500 GB SQL Server database to Amazon RDS for SQL Server. The migration must minimize downtime and support ongoing replication. Which TWO AWS services should be used together?

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

A company is migrating an on-premises Oracle database to Amazon RDS for Oracle. The database has a large table with a BLOB column storing PDF files. Which migration approach minimizes downtime?

A company is deploying a new web application that requires a highly available MariaDB database. The application is read-heavy and needs to scale read traffic. Which deployment approach meets these requirements?

A developer is connecting to an RDS for MySQL instance. What is the endpoint address that should be used in the database connection string?

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?

A company is migrating a PostgreSQL database to Amazon Aurora PostgreSQL. They have set up AWS DMS with change data capture (CDC). However, after the initial load, the CDC replication is experiencing high latency. What is the MOST likely cause?

A company is deploying a new web application that uses Amazon RDS for MySQL. To meet high availability requirements, the database must automatically failover to a standby in a different Availability Zone with minimal downtime. Which deployment configuration should be used?

A company is migrating a 2 TB Oracle database to Amazon Aurora PostgreSQL using AWS DMS. The migration is taking longer than expected, and the ongoing replication lag is increasing. Which action would MOST likely improve the migration speed?

A company is migrating a 1 TB SQL Server database to Amazon RDS for SQL Server. They want to use the native backup and restore feature. What must they do first?

Refer to the exhibit. An IAM policy is attached to a user who needs to deploy an RDS MySQL instance. After creating the instance, the user tries to modify it to enable deletion protection, but the action fails. What is the most likely reason?

A company is migrating an on-premises Oracle database to Amazon RDS for Oracle. The migration uses AWS DMS with ongoing replication (CDC). Which TWO tasks must be completed before starting the migration?

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

A company wants to migrate a 10 TB Microsoft SQL Server database from on-premises to Amazon RDS for SQL Server. The migration must be completed within a week and minimize network bandwidth usage. Which approach is most suitable?

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

A company is migrating a MySQL database from on-premises to Amazon RDS for MySQL. They want to use native MySQL replication to minimize downtime. Which configuration is required in the on-premises MySQL server?

A company is migrating a 10 TB Amazon RDS for MySQL database to Amazon Aurora MySQL. The migration must have minimal downtime and must support point-in-time recovery for the source during migration. Which approach meets these requirements?

A company is migrating a MySQL database to Amazon Aurora MySQL. The database has several stored procedures and triggers. During the migration, some stored procedures fail to execute. What is the most likely cause?

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

A company is migrating a 5 TB PostgreSQL database to Amazon Aurora PostgreSQL. The database has complex stored procedures and triggers. The migration must be completed within a 30-minute downtime window. Which approach would meet the requirement?

An organization wants to migrate a 200 GB MySQL database from an on-premises server to Amazon Aurora MySQL. They have a 50 Mbps network connection. The database is 8 hours of downtime. The migration must be completed within 24 hours and costs must be minimized. The team decides to use AWS Database Migration Service (DMS). Which approach best meets the requirements?

A company is migrating a 4 TB Oracle database to Amazon Aurora PostgreSQL using AWS DMS. The migration completes successfully but the application experiences high latency on the Aurora cluster. The DMS task used LOB mode 'full LOB mode'. What is the most likely cause of the latency?

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?

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?

A company is deploying a new web application on Amazon RDS for MySQL and expects read-heavy traffic. The database must be highly available. Which deployment approach meets these requirements?

A company is migrating a 50 GB PostgreSQL database from on-premises to Amazon RDS for PostgreSQL. The network bandwidth between on-premises and AWS is 50 Mbps. The migration must complete within 24 hours. What is the most efficient way to transfer the initial data?

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?

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?

A company wants to migrate an on-premises MySQL database to Amazon RDS for MySQL. The database is 500 GB and experiences heavy write traffic. They need to minimize downtime and ensure no data loss. Which approach should they take?

Refer to the exhibit. A database administrator runs the AWS CLI command and gets the following output: {"Engine":"mysql","DBInstanceStatus":"available","MultiAZ":true,"SecondaryAvailabilityZone":"us-east-1b"}. What can be concluded about the database deployment?

A company is deploying a new web application that uses Amazon RDS for MySQL. The application has unpredictable read traffic spikes. The company wants to minimize read latency and automatically scale read capacity. What is the MOST cost-effective solution?

Refer to the exhibit. A developer deploys this CloudFormation template. An application on the EC2 instance cannot connect to the RDS MySQL database. What is the MOST likely cause?

Refer to the exhibit. A database specialist is taking a final snapshot of an RDS DB instance before deletion. The command returns the output shown. The snapshot is at 75% progress. What should the specialist do next?

A company is deploying a new Amazon DynamoDB table with global tables for a multi-region application. The application requires strongly consistent reads in the primary region and eventual consistency in secondary regions. Which write strategy should they use?

Refer to the exhibit. An IAM policy allows creation of a DMS replication task only if the source database engine is Oracle. A user attempts to create a replication task with a MySQL source. What will happen?

A company is migrating a 3 TB PostgreSQL database to Amazon Aurora PostgreSQL. The migration must have minimal downtime. Which THREE steps should be taken?

A company is deploying a MongoDB-compatible database using Amazon DocumentDB. The application requires the ability to perform ad-hoc queries on nested fields within documents. Which DocumentDB feature should be enabled to meet this requirement?

A company is migrating an on-premises PostgreSQL database to Amazon RDS for PostgreSQL. The migration must be completed with minimal downtime. Which TWO AWS services should be used together?

A company wants to migrate a 1 TB on-premises PostgreSQL database to Amazon RDS for PostgreSQL. They have a limited internet bandwidth. Which service should they use to accelerate the migration?

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?

A company is migrating a 3 TB Oracle database to Amazon RDS for Oracle. They want to use Oracle Data Pump to export the data and then import it into RDS. What is the most efficient way to transfer the dump files to AWS?

A company is migrating a self-managed MongoDB database to Amazon DocumentDB (with MongoDB compatibility). Which TWO actions should the company take to ensure a successful migration? (Choose two.)

A company is deploying Amazon DynamoDB for a new application. The application requires single-digit millisecond latency for read operations. Which DynamoDB feature should be configured to meet this requirement?

A company wants to migrate a 200 GB SQL Server database to Amazon RDS for SQL Server with minimal downtime. The database is used by a critical application. Which service should be used for the migration?

A company wants to migrate its on-premises Oracle database to Amazon Aurora PostgreSQL. The company needs to automatically convert the Oracle schema to PostgreSQL-compatible format. Which AWS service should the company use?

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?

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?

Refer to the exhibit. A database administrator has this IAM policy attached to their user. They attempt to delete the database instance 'prod-mydb' but receive an 'AccessDenied' error. Why?

A company is deploying Amazon RDS for PostgreSQL and needs to ensure that all data at rest is encrypted. Which action should be taken to enable encryption?

A company is deploying a new multi-AZ application that requires a relational database. The database must be highly available and must automatically failover to a standby in another Availability Zone within minutes. The database size is 500 GB and the workload is read-heavy. Which AWS RDS configuration meets these requirements?

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

A company is migrating a MongoDB database to Amazon DocumentDB. They have a 200 GB database and need to minimize downtime. Which migration approach is most appropriate?

A company is migrating an on-premises MongoDB database to Amazon DocumentDB (with MongoDB compatibility). They want to validate that the data is consistent after migration. Which tool should they use?

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)

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

A company is migrating an on-premises MongoDB database to Amazon DocumentDB. The migration must be online with minimal downtime. The source MongoDB is version 4.0 and uses replica sets. Which tool should the company use?

A company is migrating a 500 GB Oracle database to Amazon RDS for Oracle. The migration must complete within a 4-hour downtime window. The network bandwidth is 1 Gbps. Which migration approach minimizes the migration time?

A company is migrating a 1 TB Oracle database to Amazon RDS for Oracle. The source database has a high volume of small transactions. The migration must minimize source database impact. Which AWS DMS configuration should be used?

A company is migrating a 100 GB MySQL database to Amazon Aurora MySQL. The migration must have minimal downtime and the source database is currently in use. Which approach should the company take?

Refer to the exhibit. A DBA is monitoring a DMS migration task from on-premises Oracle to Amazon RDS for Oracle. The full load completed successfully with 50 tables. However, the DBA notices that the CDC phase has not started. What is the most likely reason?

A developer needs to migrate a 500 GB MongoDB database to Amazon DocumentDB. Which approach will minimize application downtime?

A company is migrating a 2 TB Oracle database to Amazon Aurora PostgreSQL. The on-premises database is 2 TB and the network link is 1 Gbps. The migration must complete within 48 hours with minimal data loss. The DBA has extracted the schema using AWS SCT and created an Aurora cluster. The DBA now needs to transfer the data. The DBA tried using AWS DMS over the network but estimates it will take 72 hours due to network overhead. The DBA also considered using an AWS Snowball Edge device but is concerned about the time to order and ship the device. Which approach should the DBA take to meet the deadline?

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?

A company is migrating a 10 TB SQL Server database to Amazon RDS for SQL Server. They need to minimize the migration time and cost. Which approach should they use?

A company is migrating an on-premises MongoDB database to Amazon DocumentDB (with MongoDB compatibility). Which AWS service can perform the migration with minimal downtime using ongoing replication?

A company is migrating an on-premises PostgreSQL database to Amazon RDS for PostgreSQL. The database is 2 TB and has a sustained write rate of 150 MB/s. The migration must have minimal downtime. Which AWS service or tool should be used for the initial data load and ongoing replication?

An IAM policy is attached to a user who is deploying a new RDS instance. What is the effect of this policy on the user's ability to modify an existing production database instance with the identifier 'prod-mydb'?

Refer to the exhibit. A company is migrating an on-premises database to Amazon RDS for MySQL. During a test migration, the DMS task fails with the error shown. The source database is 500 GB and the target RDS instance has 500 GB allocated storage. What should be done to resolve this error and complete the migration?

A company is migrating a 3 TB PostgreSQL database from on-premises to Amazon Aurora PostgreSQL. They need to minimize downtime and ensure that the migration is completed within a maintenance window. Which approach should they use?

A company wants to migrate a 10 GB PostgreSQL database from an on-premises server to Amazon RDS for PostgreSQL. The migration can tolerate several hours of downtime. Which migration method is the MOST straightforward?

A company is migrating a 5 TB SQL Server database to Amazon RDS for SQL Server using AWS DMS. They are using Full LOB mode. The migration is failing with an error about memory allocation. What should they do to resolve this?

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?

A company is migrating a 2 TB Oracle database from on-premises to Amazon RDS for Oracle using AWS DMS. The migration completes successfully, but the new RDS instance shows higher CPU utilization than the on-premises database for the same workload. Which action is MOST likely to reduce CPU utilization on RDS?

A company is migrating an on-premises PostgreSQL database to Amazon RDS for PostgreSQL. The database is 2 TB in size and has a high write volume. The migration window is limited to 4 hours. Which migration approach provides the fastest initial load with minimal downtime?

A company is deploying Amazon RDS for MySQL in a Multi-AZ configuration for high availability. The database must be able to automatically failover to a standby in another Availability Zone. Which RDS feature enables this?

A company is migrating a 1 TB SQL Server database to Amazon RDS for SQL Server. They need to minimize downtime and support ongoing replication. Which combination of AWS services should they use?

A company wants to migrate a 500 GB MySQL database from an on-premises server to Amazon RDS for MySQL. The migration must be completed within a 2-hour downtime window. Which migration approach is MOST suitable?

Which THREE factors should be considered when choosing between a native database migration tool (e.g., pg_dump) and AWS DMS for migrating a database to Amazon RDS? (Choose three.)

Refer to the exhibit. You run the command and get the output shown. The database is an RDS for MySQL instance. You need to connect to it from an EC2 instance in the same VPC. Which connection string should be used?

A company is migrating a 5 TB PostgreSQL database from on-premises to Amazon RDS for PostgreSQL. The database has a 24/7 uptime requirement and must be migrated with minimal downtime. The on-premises network bandwidth is 100 Mbps. The migration must be completed within 48 hours. The team has chosen to use AWS Database Migration Service (DMS) with ongoing replication from a change data capture (CDC) source. After setting up the source endpoint, target endpoint, and replication instance, the initial full load takes 30 hours. However, during the CDC phase, the target falls behind by over 2 hours and continues to lag. The replication instance is a dms.c5.large (2 vCPUs, 4 GB memory). The source database is heavily utilized with frequent updates. What should the team do to reduce the CDC lag and meet the migration deadline?

A company is migrating a 1 TB Oracle database to Amazon Aurora PostgreSQL using AWS DMS. They need to ensure minimal downtime and data consistency. Which TWO actions should the company take?

A company is migrating a 10 TB Oracle data warehouse to Amazon Redshift. They want to use AWS DMS for continuous replication. However, the migration is taking longer than expected due to LOB columns. What optimization should be applied?

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?

A company is migrating a 1 TB SQL Server database to Amazon RDS for SQL Server using backup and restore. The database has high transaction volume. Which backup type should be used to minimize downtime?

A team is setting up a DMS migration task. The IAM policy above is attached to the DMS replication instance's IAM role. The team is unable to modify the target RDS instance's maintenance window during the migration. Which additional permission is missing?

A company is migrating a 100 GB Oracle database to Amazon RDS for Oracle. They want to use AWS DMS. The source database is in a different AWS account. What is required to allow DMS to connect to the source?

A company is migrating a 2 TB Oracle database to Amazon Aurora PostgreSQL. They need to minimize downtime. Which AWS service should they use?

A company is migrating a 500 GB MongoDB database to Amazon DocumentDB. The migration is done using AWS DMS with full load and ongoing replication. The full load completes successfully, but during CDC, the DMS task logs show 'Memory limit exceeded' errors and the task fails repeatedly. The DMS replication instance is a dms.r5.large. The source MongoDB has a write-heavy workload with many small updates. The DBA needs to fix the migration without restarting from scratch. Which action should the DBA take?

A company is deploying a DynamoDB table for a global application that requires low-latency reads and writes in multiple AWS Regions. Which THREE features should be enabled? (Choose three.)

A company has an Aurora MySQL cluster with three instances. The current writer instance is 'mycluster-instance-1'. The company wants to failover to 'mycluster-instance-2' for maintenance. What is the most direct way to achieve this?

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

A company is migrating a self-managed Oracle database to Amazon Aurora PostgreSQL using AWS DMS. The source database has a large number of tables with foreign key constraints. During the full load phase, some tables fail to load due to foreign key violations. What is the most efficient way to resolve this?

A team is migrating an on-premises database to Amazon RDS using AWS DMS. After the full load completed, the task stopped. The team needs to perform ongoing replication to minimize downtime. What change should the team make to the DMS task?

A company is migrating a 5 TB Microsoft SQL Server database to Amazon Aurora MySQL. The migration must be completed with minimal downtime. Which THREE steps should the company take? (Select THREE.)

Which TWO steps are required when migrating an on-premises Microsoft SQL Server database to Amazon RDS for SQL Server using AWS DMS with ongoing replication?

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?

Which TWO AWS services can be used together to migrate an on-premises MySQL database to Amazon Aurora MySQL with minimal downtime? (Select TWO.)

A startup is deploying a new web application on AWS. The application uses Amazon RDS for PostgreSQL as its database. The developers need to create the initial schema and load test data. They have a SQL script file that creates tables and inserts 10,000 rows. The DB instance is a db.t3.micro with 20 GB gp2 storage. The developers connect to the RDS instance using pgAdmin from their local machine and run the script. The script fails with a 'connection reset' error after inserting 5,000 rows. What is the MOST likely cause?

A company is migrating a 500 GB PostgreSQL database from on-premises to Amazon Aurora PostgreSQL. They need to minimize downtime and ensure that all data changes made during migration are synchronized. Which three components are required for this migration? (Choose THREE.)

Which THREE factors should be considered when choosing between a homogeneous migration and a heterogeneous migration to Amazon RDS? (Select THREE.)

A company is migrating a 1 TB SQL Server database to Amazon RDS for SQL Server. The migration window is 4 hours. The on-premises network bandwidth is 1 Gbps. The database is not actively used during the migration window. The team wants to minimize migration time and cost. Which migration strategy is most appropriate?

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?

A company is deploying a new MySQL database on Amazon RDS. The database must be highly available and support cross-Region disaster recovery. Which TWO actions should be taken? (Choose two.)

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.)

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?

Which TWO AWS services can be used to migrate a MongoDB database to Amazon DocumentDB? (Choose 2.)

A company is migrating an on-premises MySQL database to Amazon RDS for MySQL. They need to validate that the schema is compatible. Which AWS service should they use?

A company is deploying a new microservices application on Amazon ECS. Each microservice needs its own database. Which AWS database service should be used to minimize operational overhead?

A company is migrating a 5 TB Oracle database to Amazon Aurora MySQL using AWS DMS. The full load completes successfully, but the CDC phase is slow and the target Aurora cluster is consuming high CPU. The DMS instance type is dms.c4.2xlarge. Which change will most likely improve CDC performance?

A company wants to migrate an on-premises Oracle database to Amazon Aurora PostgreSQL. They need to convert the schema and code. Which AWS service should they use?