Database Specialty (Page 19)

A company has an application environment that deploys Amazon Aurora PostgreSQL databases as part of its CI/CD process that uses AWS CloudFormation.The company’s database administrator has received reports of performance issues from the resulting database but has no way to investigate the issues.Which combination of changes must the database administrator make to the database deployment to automate the collection of performance data? (Choose two.)Read More →

A company uses a large, growing, and high performance on-premises Microsoft SQL Server instance with an Always On availability group cluster size of 120 TiB.The company uses a third-party backup product that requires system-level access to the databases.The company will continue to use this third-party backup product in the future.The company wants to move the DB cluster to AWS with the least possible downtime and data loss.The company needs a 2 Gbps connection to sustain Always On asynchronous data replication between the company’s data center and AWS.Which combination of actions should a database specialist take to meet these requirements? (Choose three.)Read More →

A marketing company is developing an application to track responses to email message campaigns.The company needs a database storage solution that is optimized to work with highly connected data.The database needs to limit connections and programmatic access to the data by using IAM policies.Which solution will meet these requirements?Read More →

A web-based application uses Amazon DocumentDB (with MongoDB compatibility) as its underlying data store.Sufficient access control is in place, but a database specialist wants to be able to review logs if the primary DocumentDB database is deleted.Which combination of steps should the database specialist take to meet this requirement? (Choose two.)Read More →

A company has a hybrid environment in which a VPC connects to an on-premises network through an AWS Site-to-Site VPN connection.The VPC contains an application that is hosted on Amazon EC2 instances.The EC2 instances run in private subnets behind an Application Load Balancer (ALB) that is associated with multiple public subnets.The EC2 instances need to securely access an Amazon DynamoDB table.Which solution will meet these requirements?Read More →

A company is planning to use Amazon RDS for SQL Server for one of its critical applications.The company’s security team requires that the users of the RDS forSQL Server DB instance are authenticated with on-premises Microsoft Active Directory credentials.Which combination of steps should a database specialist take to meet this requirement? (Choose three.)Read More →

A company released a mobile game that quickly grew to 10 million daily active users in North America.The game’s backend is hosted on AWS and makes extensive use of an Amazon DynamoDB table that is configured with a TTL attribute.When an item is added or updated, its TTL is set to the current epoch time plus 600 seconds.The game logic relies on old data being purged so that it can calculate rewards points accurately.Occasionally, items are read from the table that are several hours past their TTL expiry.How should a database specialist fix this issue?Read More →

A company is using Amazon Redshift as its data warehouse solution.The Redshift cluster handles the following types of workloads:✑ Real-time inserts through Amazon Kinesis Data Firehose✑ Bulk inserts through COPY commands from Amazon S3✑ Analytics through SQL queriesRecently, the cluster has started to experience performance issues.Which combination of actions should a database specialist take to improve the cluster’s performance? (Choose three.)Read More →

A database specialist is planning to migrate a MySQL database to Amazon Aurora.The database specialist wants to configure the primary DB cluster in the us-west-2 Region and the secondary DB cluster in the eu-west-1 Region.In the event of a disaster recovery scenario, the database must be available in eu-west-1 with an RPO of a few seconds.Which solution will meet these requirements?Read More →

A company is using an Amazon Aurora PostgreSQL DB cluster for the backend of its mobile application.The application is running continuously and a database specialist is satisfied with high availability and fast failover, but is concerned about performance degradation after failover.How can the database specialist minimize the performance degradation after failover?Read More →