Database Specialty (Page 26)

A company uses Amazon Aurora MySQL as the primary database engine for many of its applications.A database specialist must create a dashboard to provide the company with information about user connections to databases.According to compliance requirements, the company must retain all connection logs for at least 7 years.Which solution will meet these requirements MOST cost-effectively?Read More →

A company is running a business-critical application on premises by using Microsoft SQL Server.A database specialist is planning to migrate the instance with several databases to the AWS Cloud.The database specialist will use SQL Server Standard edition hosted on Amazon EC2 Windows instances.The solution must provide high availability and must avoid a single point of failure in the SQL Server deployment architecture.Which solution will meet these requirements?Read More →

A company stores session history for its users in an Amazon DynamoDB table.The company has a large user base and generates large amounts of session data.Teams analyze the session data for 1 week, and then the data is no longer needed.A database specialist needs to design an automated solution to purge session data that is more than 1 week old.Which strategy meets these requirements with the MOST operational efficiency?Read More →

An ecommerce company uses Amazon DynamoDB as the backend for its payments system.A new regulation requires the company to log all data access requests for financial audits.For this purpose, the company plans to use AWS logging and save logs to Amazon S3How can a database specialist activate logging on the database?Read More →

A company is loading sensitive data into an Amazon Aurora MySQL database.To meet compliance requirements, the company needs to enable audit logging on the Aurora MySQL DB cluster to audit database activity.This logging will include events such as connections, disconnections, queries, and tables queried.The company also needs to publish the DB logs to Amazon CloudWatch to perform real-time data analysis.Which solution meets these requirements?Read More →

A database specialist is designing a disaster recovery (DR) strategy for a highly available application that is in development.The application uses an Amazon DynamoDB table as its data store.The application requires an RTO of 1 minute and an RPO of 2 minutes.Which DR strategy for the DynamoDB table will meet these requirements with the MOST operational efficiency?Read More →

A database specialist wants to ensure that an Amazon Aurora DB cluster is always automatically upgraded to the most recent minor version available.Noticing that there is a new minor version available, the database specialist has issues an AWS CLI command to enable automatic minor version updates.The command runs successfully, but checking the Aurora DB cluster indicates that no update to the Aurora version has been made.What might account for this? (Choose two.)Read More →

A company has an Amazon Redshift cluster with database audit logging enabled.A security audit shows that raw SQL statements that run against the Redshift cluster are being logged to an Amazon S3 bucket.The security team requires that authentication logs are generated for use in an intrusion detection system (IDS), but the security team does not require SQL queries.What should a database specialist do to remediate this issue?Read More →

An online bookstore uses Amazon Aurora MySQL as its backend database.After the online bookstore added a popular book to the online catalog, customers began reporting intermittent timeouts on the checkout page.A database specialist determined that increased load was causing locking contention on the database.The database specialist wants to automatically detect and diagnose database performance issues and to resolve bottlenecks faster.Which solution will meet these requirements?Read More →

A company is running critical applications on AWS.Most of the application deployments use Amazon Aurora MySQL for the database stack.The company uses AWS CloudFormation to deploy the DB instances.The company’s application team recently implemented a CI/CD pipeline.A database engineer needs to integrate the database deployment CloudFormation stack with the newly built CI/CD platform.Updates to the CloudFormation stack must not update existing production database resources.Which CloudFormation stack policy action should the database engineer implement to meet these requirements?Read More →