Database Specialty (Page 8)

A financial company wants to store sensitive user data in an Amazon Aurora PostgreSQL DB cluster.The database will be accessed by multiple applications across the company.The company has mandated that all communications to the database be encrypted and the server identity must be validated.Any non-SSL- based connections should be disallowed access to the database.Which solution addresses these requirements?Read More →

A database specialist is responsible for an Amazon RDS for MySQL DB instance with one read replica.The DB instance and the read replica are assigned to the default parameter group.The database team currently runs test queries against a read replica.The database team wants to create additional tables in the read replica that will only be accessible from the read replica to benefit the tests.Which should the database specialist do to allow the database team to create the test tables?Read More →

A company just migrated to Amazon Aurora PostgreSQL from an on-premises Oracle database.After the migration, the company discovered there is a period of time every day around 3:00 PM where the response time of the application is noticeably slower.The company has narrowed down the cause of this issue to the database and not the application.Which set of steps should the Database Specialist take to most efficiently find the problematic PostgreSQL query?Read More →

A company is due for renewing its database license.The company wants to migrate its 80 TB transactional database system from on-premises to the AWS Cloud.The migration should incur the least possible downtime on the downstream database applications.The company’s network infrastructure has limited network bandwidth that is shared with other applications.Which solution should a database specialist use for a timely migration?Read More →

A company conducted a security audit of its AWS infrastructure. The audit identified that data was not encrypted in transit between application servers and aMySQL database that is hosted in Amazon RDS.After the audit, the company updated the application to use an encrypted connection. To prevent this problem from occurring again, the company’s database team needs to configure the database to require in-transit encryption for all connections.Which solution will meet this requirement?Read More →

A vehicle insurance company needs to choose a highly available database to track vehicle owners and their insurance details.The persisted data should be immutable in the database, including the complete and sequenced history of changes over time with all the owners and insurance transfer details for a vehicle.The data should be easily verifiable for the data lineage of an insurance claim.Which approach meets these requirements with MINIMAL effort?Read More →

A company is using an Amazon RDS for MySQL DB instance for its internal applications.A security audit shows that the DB instance is not encrypted at rest.The company’s application team needs to encrypt the DB instance.What should the team do to meet this requirement?Read More →

A company migrated one of its business-critical database workloads to an Amazon Aurora Multi-AZ DB cluster.The company requires a very low RTO and needs to improve the application recovery time after database failovers.Which approach meets these requirements?Read More →

A company is building a web application on AWS.The application requires the database to support read and write operations in multiple AWS Regions simultaneously.The database also needs to propagate data changes between Regions as the changes occur.The application must be highly available and must provide latency of single-digit milliseconds.Which solution meets these requirements?Read More →

An online advertising website uses an Amazon DynamoDB table with on-demand capacity mode as its data store.The website also has a DynamoDB Accelerator(DAX) cluster in the same VPC as its web application server.The application needs to perform infrequent writes and many strongly consistent reads from the data store by querying the DAX cluster.During a performance audit, a systems administrator notices that the application can look up items by using the DAX cluster.However, the QueryCacheHits metric for the DAX cluster consistently shows 0 while the QueryCacheMisses metric continuously keeps growing in Amazon CloudWatch.What is the MOST likely reason for this occurrence?Read More →