Database Specialty (Page 2)

A Database Specialist modified an existing parameter group currently associated with a production Amazon RDS for SQL Server Multi-AZ DB instance.The change is associated with a static parameter type, which controls the number of user connections allowed on the most critical RDS SQL Server DB instance for the company.This change has been approved for a specific maintenance window to help minimize the impact on users.How should the Database Specialist apply the parameter group change for the DB instance?Read More →

A company is using Amazon Aurora with Aurora Replicas.A database specialist needs to split up two read-only applications so that each application connects to a different set of DB instances.The database specialist wants to implement load balancing and high availability for the read-only applications.Which solution meets these requirements?Read More →

A software development company is using Amazon Aurora MySQL DB clusters for several use cases, including development and reporting.These use cases place unpredictable and varying demands on the Aurora DB clusters, and can cause momentary spikes in latency.System users run ad-hoc queries sporadically throughout the week.Cost is a primary concern for the company, and a solution that does not require significant rework is needed.Which solution meets these requirements?Read More →

A Database Specialist is creating a new Amazon Neptune DB cluster, and is attempting to load data from Amazon S3 into the Neptune DB cluster using theNeptune bulk loader API.The Database Specialist receives the following error:`Unable to connect to s3 endpoint.Provided source = s3://mybucket/graphdata/ and region = us-east-1.Please verify yourS3 configuration.`Which combination of actions should the Database Specialist take to troubleshoot the problem? (Choose two.)Read More →

A company is running Amazon RDS for MySQL for its workloads.There is downtime when AWS operating system patches are applied during the Amazon RDS- specified maintenance window.What is the MOST cost-effective action that should be taken to avoid downtime?Read More →

A large financial services company requires that all data be encrypted in transit.A Developer is attempting to connect to an Amazon RDS DB instance using the company VPC for the first time with credentials provided by a Database Specialist.Other members of the Development team can connect, but this user is consistently receiving an error indicating a communications link failure.The Developer asked the Database Specialist to reset the password a number of times, but the error persists.Which step should be taken to troubleshoot this issue?Read More →

An ecommerce company migrates an on-premises MongoDB database to Amazon DocumentDB (with MongoDB compatibility).After the migration, a database specialist realizes that encryption at rest has not been turned on for the Amazon DocumentDB cluster.What should the database specialist do to enable encryption at rest for the Amazon DocumentDB cluster?Read More →

A company is using Amazon RDS for PostgreSQL.The Security team wants all database connection requests to be logged and retained for 180 days.The RDS for PostgreSQL DB instance is currently using the default parameter group.A Database Specialist has identified that setting the log_connections parameter to 1 will enable connections logging.Which combination of steps should the Database Specialist take to meet the logging and retention requirements? (Choose two.)Read More →

A company has a 20 TB production Amazon Aurora DB cluster.The company runs a large batch job overnight to load data into the Aurora DB cluster.To ensure the company’s development team has the most up-to-date data for testing, a copy of the DB cluster must be available in the shortest possible time after the batch job completes.How should this be accomplished?Read More →

A company is migrating a mission-critical 2-TB Oracle database from on premises to Amazon Aurora.The cost for the database migration must be kept to a minimum, and both the on-premises Oracle database and the Aurora DB cluster must remain open for write traffic until the company is ready to completely cut over to Aurora.Which combination of actions should a database specialist take to accomplish this migration as quickly as possible? (Choose two.)Read More →