Deployment and Migration

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 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?

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 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 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 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?

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 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 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 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?

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 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?

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

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 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 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 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 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 MySQL database to Amazon RDS for MySQL. The company wants to minimize application changes. Which endpoint type should the application use after migration?

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

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

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?

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 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 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 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 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 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 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?

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 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 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?

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 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 new web application and needs a fully managed relational database with automatic failover and read replicas. Which AWS service should they choose?

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 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 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 company is migrating a 2 TB MySQL database to Amazon Aurora MySQL. They need to minimize downtime and ensure data consistency. Which TWO actions should they take? (Choose two.)

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 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 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 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 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 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 deploying a new Amazon RDS for Oracle instance and needs to ensure high availability and automatic failover. Which configuration should be used?

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 developer deploys the CloudFormation stack. After testing, they delete the stack. What happens to the RDS instance?

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 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 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 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 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 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 company is migrating an on-premises MySQL database to Amazon RDS for MySQL. Which TWO AWS services can assist in assessing the source database for compatibility issues?

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 migrating a 500 GB Oracle database to Amazon Aurora PostgreSQL. Which THREE steps should be part of the migration plan?

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

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 MongoDB database to Amazon DocumentDB. The migration must be online with minimal downtime. Which AWS service should be used?

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?

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

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

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 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 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?

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 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 deploying a new application that requires a MySQL-compatible database with automatic scaling of compute and storage resources. Which AWS service 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 migrating a 2 TB MongoDB database to Amazon DocumentDB. Which TWO factors should be considered when planning the migration?

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 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 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 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 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?

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

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

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 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?

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 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 a MySQL database to Amazon Aurora MySQL. The migration must be completed with minimal downtime. Which TWO methods can achieve this? (Choose two.)

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 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?

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 wants to deploy a highly available Amazon RDS for MySQL database across two Availability Zones. Which feature should be enabled?

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

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 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?

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 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 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 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 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?

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 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?

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 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 migrating a 3 TB SQL Server database to Amazon RDS for SQL Server. They have limited network bandwidth (100 Mbps) and need to complete the migration within 3 days. Which two approaches could meet the requirements? (Choose TWO.)

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?

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 migrating a 2 TB Oracle database to Amazon Aurora PostgreSQL. They need to minimize downtime. Which AWS service should they use?

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 developer needs to migrate a 500 GB MongoDB database to Amazon DocumentDB. Which approach will minimize application downtime?

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 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?

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

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?

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?

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 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 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?

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 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 an on-premises MongoDB database to Amazon DocumentDB (with MongoDB compatibility). Which AWS service can perform the migration with minimal downtime using ongoing replication?

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

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 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?

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 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 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?

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 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 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?

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 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 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?

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?

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 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 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 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?

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 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 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 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?

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 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 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 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?

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

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

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?

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 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 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 MongoDB database to Amazon DocumentDB. The migration must have minimal downtime. Which strategy should be used?

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?

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

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 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?

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 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 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 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 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 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 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 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 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 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 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 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?

A company is migrating a 1 TB PostgreSQL database from on-premises to Amazon RDS for PostgreSQL. The migration must have minimal downtime. Which TWO steps should be taken to achieve this?

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 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 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 migrating an on-premises MongoDB cluster to Amazon DocumentDB (with MongoDB compatibility). The source cluster uses MongoDB 4.0 and contains 2 TB of data. The company requires minimal downtime during the migration. Which AWS service should be used to perform the migration?

A company is deploying a new Amazon Aurora MySQL cluster in a single AWS Region. They require that the cluster be able to survive an Availability Zone (AZ) failure with minimal downtime and no data loss. The application uses the cluster endpoint for writes. Which configuration should they choose?

A company is migrating a large on-premises MongoDB database to Amazon DocumentDB. They need to perform the migration with minimal downtime and ensure that the target database is continuously updated during the cutover. Which AWS service should they use?

A company is migrating a 10 TB Oracle database to Amazon Aurora PostgreSQL. They need to minimize downtime and ensure data consistency. Which TWO steps should be included in the migration plan? (Choose two.)

A company is deploying a new Amazon RDS for MySQL database. They want to ensure that the database is highly available and can automatically fail over to a standby instance in case of an Availability Zone failure. Which feature should they enable?

A company is deploying a new Amazon Aurora PostgreSQL database cluster. They require that the database be encrypted at rest using a customer managed key (CMK) in AWS KMS. They also need to ensure that snapshots of the database are encrypted with the same CMK. Which configuration should be used?

A company is deploying a new Amazon RDS for SQL Server database. They need to ensure that the database is encrypted at rest using a customer-managed AWS KMS key. Which action should be taken?

A company is planning to migrate an on-premises MySQL database to Amazon RDS for MySQL. The database is 500 GB and the company wants to minimize downtime. They have set up AWS DMS with a replication instance. During testing, they notice that the replication instance is not capturing changes from the source database. What is the most likely cause?

A company is migrating a large on-premises MongoDB database to Amazon DocumentDB. The database is 500 GB and the company wants to minimize downtime. They have a 1 Gbps AWS Direct Connect connection. Which migration strategy should be used?

A company is migrating a 10 TB on-premises Oracle database to Amazon RDS for Oracle. The network link to AWS is 100 Mbps. The database must remain fully operational during the migration, and the cutover must complete within a 30-minute window. Which migration strategy should be used?

A company is migrating an on-premises Oracle database to Amazon RDS for Oracle. The database uses a custom character set and requires a specific time zone. The migration must be completed with minimal downtime. Which approach should be used to meet these requirements?

A company is deploying an Amazon DynamoDB table for a new application. The table will store session data with a TTL attribute. The company wants to ensure that expired items are automatically deleted and that the deletion does not consume write capacity. Which configuration should they use?

A financial services company runs an Amazon Aurora MySQL cluster in us-east-1 that must be replicated to eu-west-1 for disaster recovery. The RPO requirement is under one second and the RTO requirement is under one minute. The database team wants a managed solution that does not require them to administer any replication instances. Which deployment approach meets these requirements?

A financial services firm is migrating a 4 TB on-premises Oracle database to Amazon RDS for Oracle. The migration window is 6 hours, and the source database can be taken offline only during that window. The firm wants to use AWS Database Migration Service (AWS DMS) to minimize cutover time. Which combination of tasks should be performed to meet the requirement?

A company is deploying a new Amazon DynamoDB table for a high-traffic web application. The application requires consistent single-digit millisecond latency at any scale. The company wants to minimize operational overhead and avoid capacity planning. Which DynamoDB capacity mode should a database specialist recommend?

A company is deploying an Amazon DynamoDB table that will be used by an application with unpredictable read traffic. The table must automatically scale read capacity to handle spikes while minimizing cost. Which solution should be used?

A company is migrating an on-premises Oracle database to Amazon RDS for Oracle. The database is 2 TB and the company requires a maximum downtime of 15 minutes during cutover. Which combination of AWS services should be used to achieve this?

A company is deploying a new Amazon Aurora MySQL cluster. They need to ensure that the database can be restored to any point in time within the last 35 days, and that automated backups are retained even if the cluster is deleted. The backup retention period must be set to 35 days. Which combination of actions should a database specialist take?

A company is deploying a new Amazon Aurora PostgreSQL cluster. The security team requires that all data in transit is encrypted and that the cluster is only accessible from within a specific VPC. Which combination of steps should be taken to meet these requirements?

A company is migrating a 2 TB on-premises Microsoft SQL Server database to Amazon RDS for SQL Server. The migration must be completed with minimal downtime and the source database must remain online during the migration. Which AWS service or feature should be used to achieve this?

A financial services company is migrating a 10 TB on-premises Microsoft SQL Server database to Amazon RDS for SQL Server. The migration must be completed within a 6-hour maintenance window with minimal downtime. The company requires that the cutover be as fast as possible. Which migration strategy should be used?

A company is migrating a 1 TB MySQL database from an on-premises data center to Amazon Aurora MySQL. The migration must be completed with minimal downtime, and the team wants to use AWS DMS for ongoing replication. After the initial load, they notice that some tables are not replicating changes. The DMS task logs show errors related to binary logging. Which action should the team take to resolve the issue?

A company is deploying a new Amazon Aurora MySQL cluster. The security team requires that all data in the cluster's storage volume be encrypted at rest with a customer-managed AWS KMS key, and that the key be rotated annually. Which deployment approach meets these requirements?

A company is migrating its on-premises MySQL database to Amazon Aurora MySQL. The database is 1 TB and has a high write workload. The company wants to minimize downtime and ensure data consistency. They plan to use AWS DMS. During testing, they notice that the replication instance is experiencing high CPU utilization and the migration is slower than expected. Which action should they take to improve performance?

A company is planning to migrate an on-premises Microsoft SQL Server database to Amazon RDS for SQL Server. The database is 1 TB and the company wants to minimize downtime. The migration must also ensure that the target database is highly available. Which TWO steps should be taken to meet these requirements? (Choose two.)

A startup is deploying a new Amazon DynamoDB table for an order-processing application. The team expects highly unpredictable read and write traffic with long idle periods and occasional sharp bursts. They want to avoid capacity planning and minimize cost. Which DynamoDB capacity mode should they choose?

A solutions architect is deploying a new Amazon Aurora MySQL DB cluster that will use a custom parameter group. The architect creates the parameter group with the default settings and associates it with the DB cluster. After the cluster is running, the architect modifies a dynamic parameter in the parameter group and wants the change to take effect immediately without rebooting the cluster. Which action should the architect take?

A company is deploying a new Amazon Aurora PostgreSQL cluster that must be encrypted at rest using a customer managed key in AWS Key Management Service (AWS KMS). The company also requires that all connections to the database use SSL/TLS. They have created the KMS key and an Aurora cluster with encryption enabled. However, they find that some applications are connecting without SSL. Which action should the company take to enforce SSL/TLS for all connections?

A company is deploying a new Amazon RDS for MySQL database. They need to ensure that the database can be restored to any point in time within the last 7 days. Which feature should be enabled?

A company is deploying Amazon DynamoDB for a new application that requires a recovery point objective (RPO) of 5 minutes and a recovery time objective (RTO) of 1 hour across two AWS Regions. The application must continue to serve reads and writes in the secondary Region if the primary Region fails. Which deployment strategy should a database specialist recommend?

A company is migrating a small on-premises PostgreSQL database to Amazon RDS for PostgreSQL. The database is 50 GB and the company can afford a short downtime window. They want to use AWS DMS for the migration. Which DMS task type should they choose to perform the migration with the least complexity?

A logistics company is migrating an on-premises MongoDB 4.4 replica set to Amazon DocumentDB. The dataset is 800 GB and the company requires the cutover to complete with less than five minutes of application downtime. The source database can accept a brief read-only period. Which migration approach should the team use?

A company is migrating an on-premises Oracle database to Amazon RDS for Oracle. The database uses a non-standard character set that is not supported by RDS for Oracle. The migration must preserve the data with minimal transformation. Which approach should the company take?

A company is planning to migrate an on-premises Microsoft SQL Server database to Amazon RDS for SQL Server. The database is 2 TB and the company wants to minimize downtime. They intend to use AWS Database Migration Service (AWS DMS) with ongoing replication. Which TWO actions should the company take to ensure that the migration captures ongoing changes efficiently? (Choose two.)

A company is migrating its on-premises Oracle database to Amazon RDS for Oracle. The database uses a non-standard block size of 16 KB and the company wants to use Oracle Data Pump for the migration. They have created an RDS for Oracle instance with the default block size. During the import, they encounter errors indicating that the data pump file cannot be imported due to block size mismatch. What should the company do to resolve this issue?

A company is deploying a new Amazon DynamoDB table for a high-traffic application. They need to ensure that the table can handle sudden spikes in read and write traffic without manual intervention. Which DynamoDB capacity mode should they choose?

A company is planning to migrate a large on-premises MySQL database to Amazon Aurora MySQL. The database is 10 TB in size and the company wants to minimize downtime during the migration. They decide to use AWS Database Migration Service (AWS DMS) with a full load plus change data capture (CDC). Which of the following must be configured on the source MySQL database to support CDC?

A logistics company is migrating its on-premises Oracle database to Amazon RDS for Oracle. The database is 4 TB and must be migrated with less than 10 minutes of downtime. The company has set up an AWS Direct Connect connection and wants to use AWS DMS. Which combination of source endpoint settings and AWS DMS task configuration will achieve the required minimal downtime?

A company is deploying a new Amazon DynamoDB table that will be used by an application with unpredictable read and write patterns. The company wants to ensure that the table can automatically scale its throughput capacity based on the workload, while minimizing manual intervention and cost. Which action should be taken?

A company is migrating an on-premises Microsoft SQL Server database to Amazon RDS for SQL Server. The database uses SQL Server Agent jobs and linked servers. After migration, the jobs and linked servers must continue to function. Which action should be taken to meet these requirements?

A company is migrating a large on-premises MongoDB database to Amazon DocumentDB. The migration must be completed with minimal downtime. The database is 500 GB and has a high write throughput. Which AWS service should be used to perform the migration?

A company is migrating a large on-premises MySQL database to Amazon Aurora MySQL. They want to minimize downtime and ensure data consistency. They have set up an AWS Database Migration Service (AWS DMS) task with ongoing replication. During the migration, they notice that the target Aurora cluster is experiencing high write latency. Which action should the company take to improve write performance on the target?

A financial services company is deploying a new Amazon Aurora PostgreSQL database cluster. They require that the database be encrypted at rest using a customer managed AWS KMS key and that encryption cannot be changed after creation. They also need to ensure that snapshots and automated backups are encrypted. Which action should be taken to meet these requirements?

A company is migrating a large on-premises Oracle database to Amazon Aurora PostgreSQL using AWS Schema Conversion Tool (AWS SCT) and AWS Database Migration Service (AWS DMS). During the migration, they encounter issues with stored procedures and functions. The company needs to ensure that the converted code is functionally equivalent and performs well. Which action should they take to validate and optimize the converted code?

A company is migrating a large on-premises MySQL database to Amazon Aurora MySQL. The migration must be completed with minimal downtime, and the cutover should be quick. The company plans to use AWS DMS with a replication instance. Which TWO actions should be taken to achieve minimal downtime during the cutover? (Choose two.)

A company is migrating an on-premises Oracle database to Amazon RDS for Oracle. The database is 8 TB and the network link between the data center and AWS has a bandwidth of 100 Mbps. The company needs to complete the migration within a 5-day maintenance window and wants to use AWS DMS for the cutover. Which approach should be used to meet these requirements with minimal downtime?

A company is deploying an Amazon RDS for MySQL Multi-AZ DB cluster. The company wants to ensure that the cluster can survive an Availability Zone failure with minimal downtime and that the data is durably stored. Which statement describes the replication and failover behavior of this deployment?

A company is planning to migrate a large on-premises MySQL database to Amazon Aurora MySQL. They want to minimize downtime and ensure data consistency. They will use AWS DMS. Which TWO actions should be taken to meet these requirements? (Choose two.)

A company is deploying a new Amazon RDS for SQL Server database in a Multi-AZ configuration. The database must be encrypted at rest using AWS Key Management Service (AWS KMS). The company wants to automate the deployment using AWS CloudFormation. Which CloudFormation resource property should be used to enable encryption?

A company is deploying a new Amazon DynamoDB table to support an application with unpredictable read patterns. The application requires consistent low-latency reads and the ability to handle sudden spikes in traffic without manual intervention. The database team wants to minimize operational overhead while ensuring cost-effectiveness. Which DynamoDB capacity mode should they choose?

A startup is deploying a new Amazon DynamoDB table for a web application. They need to ensure that the table can handle sudden spikes in read traffic without manual intervention. They also want to minimize costs during periods of low traffic. Which capacity mode should they choose?

A company is deploying a new Amazon Aurora MySQL database cluster in a production environment. The database must be highly available and able to survive an Availability Zone (AZ) failure with minimal downtime. The company also wants to ensure that read traffic is distributed across multiple reader instances to improve performance. Which configuration should be implemented?

A company is migrating an on-premises MongoDB database to Amazon DocumentDB (with MongoDB compatibility). The database is 2 TB and the migration must be completed with minimal downtime. The company has an AWS Direct Connect connection with 1 Gbps bandwidth. They plan to use AWS Database Migration Service (AWS DMS). Which migration approach will meet these requirements?

A company is planning to migrate an on-premises Microsoft SQL Server database to Amazon RDS for SQL Server. The database is 2 TB and the company wants to minimize downtime during the migration. They also need to ensure that the target database is continuously synchronized with the source until cutover. Which two steps should be included in the migration plan? (Choose two.)

A company is planning to migrate an on-premises Oracle database to Amazon RDS for Oracle. They want to use AWS Database Migration Service (AWS DMS) for the migration. Which two tasks must be performed to ensure that AWS DMS can replicate ongoing changes from the source to the target? (Choose two.)

A company is deploying a new Amazon DynamoDB table for a high-traffic application. The table must be able to handle sudden spikes in read and write traffic without manual intervention. The company wants to minimize operational overhead. Which capacity mode should be used?

A company is deploying a new Amazon DynamoDB table. The table will store user session data that must be automatically deleted after 30 days. The company wants to minimize costs and administrative overhead. Which feature should be used?

A company is migrating an on-premises MySQL database to Amazon Aurora MySQL. The database is 1 TB and the company wants to use AWS DMS for the migration. They need to ensure that the target Aurora cluster is highly available and can survive an Availability Zone failure. Which configuration should be used for the Aurora cluster?

A company is planning to migrate an on-premises MySQL database to Amazon Aurora MySQL. The database is 1 TB and has a high write load. The company wants to minimize downtime during the migration. They have set up AWS DMS with a replication instance and are using change data capture (CDC). During testing, they notice that the replication instance is experiencing high CPU utilization and the CDC lag is increasing. Which action should be taken to improve replication performance?

A retailer is deploying an Amazon RDS for SQL Server Multi-AZ instance in a private subnet group. The database must be reachable only from application servers in the same VPC, and DBAs on the corporate network must connect through a bastion host. Which combination of settings should be used?

A startup is deploying a new Amazon Aurora PostgreSQL cluster for a development environment. The team wants the cluster to be created reproducibly from a version-controlled template, including the DB subnet group, parameter group, and cluster settings, rather than through console clicks. Which approach should be used?

A company runs an on-premises Oracle database that must be migrated to Amazon Aurora PostgreSQL within a tight window. The database contains large BLOB columns and several proprietary Oracle data types. The team needs to convert the schema and stored procedures to PostgreSQL-compatible code before the cutover. Which AWS service should be used to perform the schema conversion?

A company is migrating an on-premises MySQL 8.0 database to Amazon Aurora MySQL. The database is 8 TB, and the business requires less than 15 minutes of downtime during cutover. The network link between the data center and AWS has 500 Mbps of available bandwidth. Which TWO steps should the team take to meet the downtime requirement? (Choose two.)

A company is migrating a 4 TB Oracle database to Amazon RDS for Oracle. The database contains several large tables with LOB columns. The team wants to minimize downtime and avoid impacting the production source during the initial data transfer. They have set up AWS DMS with a full-load plus CDC task. Which target endpoint setting should they configure to improve full-load performance for tables with LOB columns?

A company is deploying a new Amazon Aurora PostgreSQL cluster for a production workload. The security team requires that all data at rest and all data in transit be encrypted, and that the cluster be isolated from the public internet. The application servers run in private subnets of the same VPC. Which combination of actions should be taken to meet these requirements?