Database Specialty (Page 7)

A company recently created a snapshot of an Amazon RDS for PostgreSQL DB instance that hosts a production database.The company created a new DB instance from the snapshot to test a new application feature while providing isolation from the production database.During testing of the new application feature, the company noticed that read latency on the new database was higher than normal.A database specialist needs to resolve the latency issue.Which solution will meet these requirements with the MOST operational efficiency?Read More →

A company stores critical data for a department in Amazon RDS for MySQL DB instances.The department was closed for 3 weeks and notified a database specialist that access to the RDS DB instances should not be granted to anyone during this time.To meet this requirement, the database specialist stopped all theDB instances used by the department but did not select the option to create a snapshot.Before the 3 weeks expired, the database specialist discovered that users could connect to the database successfully.What could be the reason for this?Read More →

A company is running its critical production workload on a 500 GB Amazon Aurora MySQL DB cluster.A database engineer must move the workload to a newAmazon Aurora Serverless MySQL DB cluster without data loss.Which solution will accomplish the move with the LEAST downtime and the LEAST application impact?Read More →

A company’s application team needs to select an AWS managed database service to store application and user data.The application team is familiar with MySQL but is open to new solutions.The application and user data is stored in 10 tables and is de-normalized.The application will access this data through an API layer using a unique ID in each table.The company expects the traffic to be light at first, but the traffic will increase to thousands of transactions each second within the first year.The database service must support active reads and writes in multiple AWS Regions at the same time.Query response times need to be less than 100 ms.Which AWS database solution will meet these requirements?Read More →

A database specialist needs to review and optimize an Amazon DynamoDB table that is experiencing performance issues.A thorough investigation by the database specialist reveals that the partition key is causing hot partitions, so a new partition key is created.The database specialist must effectively apply this new partition key to all existing and new data.How can this solution be implemented?Read More →

An online advertising company uses an Amazon DynamoDb table as its data store.The table has Amazon DynamoDB Streams enabled and has a global secondary index on one of the keys.The table is encrypted using an AWS Key Management Service (AWS KMS) customer managed key.The company has decided to expand its operations globally and wants to replicate the database in a different AWS Region by using DynamoDB global tables.Upon review, an administrator notices the following:✑ No role with the dynamodb: CreateGlobalTable permission exists in the account.✑ An empty table with the same name exists in the new Region where replication is desired.✑ A global secondary index with the same partition key but a different sort key exists in the new Region where replication is desired.Which configurations will block the creation of a global table or the creation of a replica in the new Region? (Choose two.)Read More →

A Database Specialist is creating Amazon DynamoDB tables, Amazon CloudWatch alarms, and associated infrastructure for an Application team using a development AWS account.The team wants a deployment method that will standardize the core solution components while managing environment-specific settings separately, and wants to minimize rework due to configuration errors.Which process should the Database Specialist recommend to meet these requirements?Read More →

A Database Specialist must create a read replica to isolate read-only queries for an Amazon RDS for MySQL DB instance.Immediately after creating the read replica, users that query it report slow response times.What could be causing these slow response times?Read More →

A Database Specialist is migrating an on-premises Microsoft SQL Server application database to Amazon RDS for PostgreSQL using AWS DMS.The application requires minimal downtime when the RDS DB instance goes live.What change should the Database Specialist make to enable the migration?Read More →

A company needs a data warehouse solution that keeps data in a consistent, highly structured format.The company requires fast responses for end-user queries when looking at data from the current year, and users must have access to the full 15-year dataset, when needed.This solution also needs to handle a fluctuating number incoming queries.Storage costs for the 100 TB of data must be kept low.Which solution meets these requirements?Read More →