Database Specialty (Page 21)

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

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 →

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 →

A Database Specialist is designing a disaster recovery strategy for a production Amazon DynamoDB table.The table uses provisioned read/write capacity mode, global secondary indexes, and time to live (TTL).The Database Specialist has restored the latest backup to a new table.To prepare the new table with identical settings, which steps should be performed? (Choose two.)Read More →

A company has an on-premises system that tracks various database operations that occur over the lifetime of a database, including database shutdown, deletion, creation, and backup.The company recently moved two databases to Amazon RDS and is looking at a solution that would satisfy these requirements.The data could be used by other systems within the company.Which solution will meet these requirements with minimal effort?Read More →

A company uses an Amazon Redshift cluster to run its analytical workloads.Corporate policy requires that the company’s data be encrypted at rest with customer managed keys.The company’s disaster recovery plan requires that backups of the cluster be copied into another AWS Region on a regular basis.How should a database specialist automate the process of backing up the cluster data in compliance with these policies?Read More →

A company uses an Amazon RDS for PostgreSQL DB instance for its customer relationship management (CRM) system.New compliance requirements specify that the database must be encrypted at rest.Which action will meet these requirements?Read More →

A company developed an AWS CloudFormation template used to create all new Amazon DynamoDB tables in its AWS account.The template configures provisioned throughput capacity using hard-coded values.The company wants to change the template so that the tables it creates in the future have independently configurable read and write capacity units assigned.Which solution will enable this change?Read More →