Database Specialty (Page 4)

A global company is creating an application.The application must be highly available.The company requires an RTO and an RPO of less than 5 minutes.The company needs a database that will provide the ability to set up an active-active configuration and near real-time synchronization of data across tables in multiple AWS Regions.Which solution will meet these requirements?Read More →

A company has a reporting application that runs on an Amazon EC2 instance in an isolated developer account on AWS.The application needs to retrieve data during non-peak company hours from an Amazon Aurora PostgreSQL database that runs in the company’s production account.The company’s security team requires that access to production resources complies with AWS best security practices.A database administrator needs to provide the reporting application with access to the production database.The company has already configured VPC peering between the production account and developer account.The company has also updated the route tables in both accounts with the necessary entries to correctly set up VPC peering.What must the database administrator do to finish providing connectivity to the reporting application?Read More →

A company performs an audit on various data stores and discovers that an Amazon S3 bucket is storing a credit card number.The S3 bucket is the target of an AWS Database Migration Service (AWS DMS) continuous replication task that uses change data capture (CDC).The company determines that this field is not needed by anyone who uses the target data.The company has manually removed the existing credit card data from the S3 bucket.What is the MOST operationally efficient way to prevent new credit card data from being written to the S3 bucket?Read More →

A company is using an Amazon RDS Multi-AZ DB instance in its development environment.The DB instance uses General Purpose SSD storage.The DB instance provides data to an application that has I/O constraints and high online transaction processing (OLTP) workloads.The users report that the application is slow.A database specialist finds a high degree of latency in the database writes.The database specialist must decrease the database latency by designing a solution that minimizes operational overhead.Which solution will meet these requirements?Read More →

A company runs an ecommerce application on premises on Microsoft SQL Server.The company is planning to migrate the application to the AWS Cloud.The application code contains complex T-SQL queries and stored procedures.The company wants to minimize database server maintenance and operating costs after the migration is completed.The company also wants to minimize the need to rewrite code as part of the migration effort.Which solution will meet these requirements?Read More →

A company needs to troubleshoot its Amazon Aurora Serverless MySQL database.The company selected a db.t3, medium instance class for the database’s initial deployment.The database experienced light usage, and performance was normal.As the number of client connections increases, the application that is connected to the database is experiencing higher latency and occasional lost connections.A database specialist determines that the database needs to support a maximum of 2,000 simultaneous connections.Which solution will meet these requirements MOST cost-effectively?Read More →

An ecommerce company uses an Amazon Aurora MySQL DB cluster to process payments.The company’s database specialist notices that Aurora performs database maintenance actions periodically.The database specialist is concerned because the upcoming maintenance window conflicts with a company sales event.What should the database specialist do to address this concern with the LEAST operational effort?Read More →

A company has two separate AWS accounts: one for the business unit and another for corporate analytics.The company wants to replicate the business unit data stored in Amazon RDS for MySQL in us-east-1 to its corporate analytics Amazon Redshift environment in us-west-1.The company wants to use AWS DMS withAmazon RDS as the source endpoint and Amazon Redshift as the target endpoint.Which action will allow AVS DMS to perform the replication?Read More →

A startup company is building a new application to allow users to visualize their on-premises and cloud networking components.The company expects billions of components to be stored and requires responses in milliseconds.The application should be able to identify:✑ The networks and routes affected if a particular component fails.✑ The networks that have redundant routes between them.✑ The networks that do not have redundant routes between them.✑ The fastest path between two networks.Which database engine meets these requirements?Read More →

A healthcare company is running an application on Amazon EC2 in a public subnet and using Amazon DocumentDB (with MongoDB compatibility) as the storage layer.An audit reveals that the traffic between the application and Amazon DocumentDB is not encrypted and that the DocumentDB cluster is not encrypted at rest.A database specialist must correct these issues and ensure that the data in transit and the data at rest are encrypted.Which actions should the database specialist take to meet these requirements? (Choose two.)Read More →