Database Specialty (Page 14)

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 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 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 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 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 company is running a two-tier ecommerce application in one AWS account.The application is backed by an Amazon RDS for MySQL Multi-AZ DB instance.A developer mistakenly deleted the DB instance in the production environment.The company restores the database, but this event results in hours of downtime and lost revenue.Which combination of changes would minimize the risk of this mistake occurring in the future? (Choose three.)Read More →

A database specialist must create nightly backups of an Amazon DynamoDB table in a mission-critical workload as part of a disaster recovery strategy.Which backup methodology should the database specialist use to MINIMIZE management overhead?Read More →

A database administrator is reviewing the deployment of an application that uses Amazon DynamoDB.A fleet of Amazon EC2 application instances accesses the database.The database administrator notices that EC2 instances are using public IP addresses to access the database and that the database is available to the internet.Company policy requires that all corporate data must be accessed privately and that external access from the internet is not allowed.Which combination of steps will ensure that the DynamoDB database meets these requirements? (Choose two.)Read More →

A company has a 250 GB Amazon RDS Multi-AZ DB instance.The company’s disaster recovery policy requires an RPO of 6 hours in a second AWS Region.Which solution will meet these requirements MOST cost-effectively?Read More →

A company that is located in the United States wants to expand its operations in Asia.The company’s data in the us-west-2 Region is stored in an Amazon DynamoD8 table.The company’s development team in the ap-northeast-1 Region needs to perform user acceptance testing (UAT) and several other performance feasibility tests with a copy of production data from us-west-2.The feasibility tests do not need to be run on data that is updated in real time.Which solution will make data available from us-west-2 to ap-northeast-1 MOST cost-effectively?Read More →