Database Specialty (Page 12)

An ecommerce company uses a backend application that stores data in an Amazon DynamoDB table.The backend application runs in a private subnet in a VPC and must connect to this table.The company must minimize any network latency that results from network connectivity issues, even during periods of heavy application usage.A database administrator also needs the ability to use a private connection to connect to the DynamoDB table from the application.Which solution will meet these requirements?Read More →

To meet new data compliance requirements, a company needs to keep critical data durably stored and readily accessible for 7 years.Data that is more than 1 year old is considered archival data and must automatically be moved out of the Amazon Aurora MySQL DB cluster every week.On average, around 10 GB of new data is added to the database every month.A database specialist must choose the most operationally efficient solution to migrate the archival data toAmazon S3.Which solution meets these requirements?Read More →

A company has an ecommerce web application with an Amazon RDS for MySQL DB instance.The marketing team has noticed some unexpected updates to the product and pricing information on the website, which is impacting sales targets.The marketing team wants a database specialist to audit future database activity to help identify how and when the changes are being made.What should the database specialist do to meet these requirements? (Choose two.)Read More →

A database specialist is building a system that uses a static vendor dataset of postal codes and related territory information that is less than 1 GB in size.The dataset is loaded into the application’s cache at start up.The company needs to store this data in a way that provides the lowest cost with a low application startup time.Which approach will meet these requirements?Read More →

A company has a heterogeneous six-node production Amazon Aurora DB cluster that handles online transaction processing (OLTP) for the core business andOLAP reports for the human resources department.To match compute resources to the use case, the company has decided to have the reporting workload for the human resources department be directed to two small nodes in the Aurora DB cluster, while every other workload goes to four large nodes in the same DB cluster.Which option would ensure that the correct nodes are always available for the appropriate workload while meeting these requirements?Read More →

A company’s development team needs to have production data restored in a staging AWS account.The production database is running on an Amazon RDS forPostgreSQL Multi-AZ DB instance, which has AWS KMS encryption enabled using the default KMS key.A database specialist planned to share the most recent automated snapshot with the staging account, but discovered that the option to share snapshots is disabled in the AWS Management Console.What should the database specialist do to resolve this?Read More →

An IT consulting company wants to reduce costs when operating its development environment databases.The company’s workflow creates multiple AmazonAurora MySQL DB clusters for each development group.The Aurora DB clusters are only used for 8 hours a day.The DB clusters can then be deleted at the end of the development cycle, which lasts 2 weeks.Which of the following provides the MOST cost-effective solution?Read More →

A company has a 4 ׀¢׀’ on-premises Oracle Real Application Clusters (RAC) database.The company wants to migrate the database to AWS and reduce licensing costs.The company’s application team wants to store JSON payloads that expire after 28 hours.The company has development capacity if code changes are required.Which solution meets these requirements?Read More →

A database specialist is planning to migrate a 4 TB Microsoft SQL Server DB instance from on premises to Amazon RDS for SQL Server.The database is primarily used for nightly batch processing.Which RDS storage option meets these requirements MOST cost-effectively?Read More →

A coffee machine manufacturer is equipping all of its coffee machines with IoT sensors.The IoT core application is writing measurements for each record to Amazon Timestream.The records have multiple dimensions and measures.The measures include multiple measure names and values.An analysis application is running queries against the Timestream database and is focusing on data from the current week.A database specialist needs to optimize the query costs of the analysis application.Which solution will meet these requirements?Read More →