DBS-C01 (Page 10)

The Amazon CloudWatch metric for FreeLocalStorage on an Amazon Aurora MySQL DB instance shows that the amount of local storage is below 10 MB.A database engineer must increase the local storage available in the Aurora DB instance.How should the database engineer meet this requirement?Read More →

A database specialist needs to configure an Amazon RDS for MySQL DB instance to close non-interactive connections that are inactive after 900 seconds.What should the database specialist do to accomplish this task?Read More →

A database specialist is responsible for designing a highly available solution for online transaction processing (OLTP) using Amazon RDS for MySQL production databases.Disaster recovery requirements include a cross-Region deployment along with an RPO of 5 minutes and RTO of 30 minutes.What should the database specialist do to align to the high availability and disaster recovery requirements?Read More →

A company is using Amazon Neptune as the graph database for one of its products.The company’s data science team accidentally created large amounts of temporary information during an ETL process.The Neptune DB cluster automatically increased the storage space to accommodate the new data, but the data science team deleted the unused information.What should a database specialist do to avoid unnecessary charges for the unused cluster volume space?Read More →

A company runs a MySQL database for its ecommerce application on a single Amazon RDS DB instance.Application purchases are automatically saved to the database, which causes intensive writes.Company employees frequently generate purchase reports.The company needs to improve database performance and reduce downtime due to patching for upgrades.Which approach will meet these requirements with the LEAST amount of operational overhead?Read More →

A company has a database monitoring solution that uses Amazon CloudWatch for its Amazon RDS for SQL Server environment.The cause of a recent spike inCPU utilization was not determined using the standard metrics that were collected.The CPU spike caused the application to perform poorly, impacting users.ADatabase Specialist needs to determine what caused the CPU spike.Which combination of steps should be taken to provide more visibility into the processes and queries running during an increase in CPU load? (Choose two.)Read More →

A database specialist has a fleet of Amazon RDS DB instances that use the default DB parameter group.The database specialist needs to associate a custom parameter group with some of the DB instances.After the database specialist makes this change, when will the instances be assigned to this new parameter group?Read More →

A database administrator needs to save a particular automated database snapshot from an Amazon RDS for Microsoft SQL Server DB instance for longer than the maximum number of days.Which solution will meet these requirements in the MOST operationally efficient way?Read More →

A company needs to deploy an Amazon Aurora PostgreSQL DB instance into multiple accounts.The company will initiate each DB instance from an existing Aurora PostgreSQL DB instance that runs in a shared account.The company wants the process to be repeatable in case the company adds additional accounts in the future.The company also wants to be able to verify if manual changes have been made to the DB instance configurations after the company deploys the DB instances.A database specialist has determined that the company needs to create an AWS CloudFormation template with the necessary configuration to create a DB instance in an account by using a snapshot of the existing DB instance to initialize the DB instance.The company will also use the CloudFormation template’s parameters to provide key values for the DB instance creation (account ID, etc.).Which final step will meet these requirements in the MOST operationally efficient way?Read More →

A company is using Amazon Aurora MySQL as the database for its retail application on AWS.The company receives a notification of a pending database upgrade and wants to ensure upgrades do not occur before or during the most critical time of year.Company leadership is concerned that an Amazon RDS maintenance window will cause an outage during data ingestion.Which step can be taken to ensure that the application is not interrupted?Read More →