Database Specialty (Page 19)

A Database Specialist is designing a new database infrastructure for a ride hailing application.The application data includes a ride tracking system that storesGPS coordinates for all rides.Real-time statistics and metadata lookups must be performed with high throughput and microsecond latency.The database should be fault tolerant with minimal operational overhead and development effort.Which solution meets these requirements in the MOST efficient way?Read More →

A large automobile company is migrating the database of a critical financial application to Amazon DynamoDB.The company’s risk and compliance policy requires that every change in the database be recorded as a log entry for audits.The system is anticipating more than 500,000 log entries each minute.Log entries should be stored in batches of at least 100,000 records in each file in Apache Parquet format.How should a database specialist implement these requirements with DynamoDB?Read More →

A development team at an international gaming company is experimenting with Amazon DynamoDB to store in-game events for three mobile games.The most popular game hosts a maximum of 500,000 concurrent users, and the least popular game hosts a maximum of 10,000 concurrent users.The average size of an event is 20 KB, and the average user session produces one event each second.Each event is tagged with a time in milliseconds and a globally unique identifier.The lead developer created a single DynamoDB table for the events with the following schema:✑ Partition key: game name✑ Sort key: event identifier✑ Local secondary index: player identifier✑ Event timeThe tests were successful in a small-scale development environment.However, when deployed to production, new events stopped being added to the table and the logs show DynamoDB failures with the ItemCollectionSizeLimitExceededException error code.Which design change should a database specialist recommend to the development team?Read More →

A financial services company uses Amazon RDS for Oracle with Transparent Data Encryption (TDE).The company is required to encrypt its data at rest at all times.The key required to decrypt the data has to be highly available, and access to the key must be limited.As a regulatory requirement, the company must have the ability to rotate the encryption key on demand.The company must be able to make the key unusable if any potential security breaches are spotted.The company also needs to accomplish these tasks with minimum overhead.What should the database administrator use to set up the encryption to meet these requirements?Read More →

A financial services company has an application deployed on AWS that uses an Amazon Aurora PostgreSQL DB cluster.A recent audit showed that no log files contained database administrator activity.A database specialist needs to recommend a solution to provide database access and activity logs.The solution should use the least amount of effort and have a minimal impact on performance.Which solution should the database specialist recommend?Read More →

A company is running its production databases in a 3 TB Amazon Aurora MySQL DB cluster.The DB cluster is deployed to the us-east-1 Region.For disaster recovery (DR) purposes, the company’s database specialist needs to make the DB cluster rapidly available in another AWS Region to cover the production load with an RTO of less than 2 hours.What is the MOST operationally efficient solution to meet these requirements?Read More →

A manufacturing company’s website uses an Amazon Aurora PostgreSQL DB cluster.Which configurations will result in the LEAST application downtime during a failover? (Choose three.)Read More →

A company is load testing its three-tier production web application deployed with an AWS CloudFormation template on AWS.The Application team is making changes to deploy additional Amazon EC2 and AWS Lambda resources to expand the load testing capacity.A Database Specialist wants to ensure that the changes made by the Application team will not change the Amazon RDS database resources already deployed.Which combination of steps would allow the Database Specialist to accomplish this? (Choose two.)Read More →

A media company wants to use zero-downtime patching (ZDP) for its Amazon Aurora MySQL database.Multiple processing applications are using SSL certificates to connect to database endpoints and the read replicas.Which factor will have the LEAST impact on the success of ZDP?Read More →

An application reads and writes data to an Amazon RDS for MySQL DB instance.A new reporting dashboard needs read-only access to the database.When the application and reports are both under heavy load, the database experiences performance degradation.A database specialist needs to improve the database performance.What should the database specialist do to meet these requirements?Read More →