DBS-C01 (Page 22)

A large retail company recently migrated its three-tier ecommerce applications to AWS.The company’s backend database is hosted on Amazon AuroraPostgreSQL.During peak times, users complain about longer page load times.A database specialist reviewed Amazon RDS Performance Insights and found a spike in IO:XactSync wait events.The SQL attached to the wait events are all single INSERT statements.How should this issue be resolved?Read More →

A database specialist must load 25 GB of data files from a company’s on-premises storage to an Amazon Neptune database.Which approach to load the data is FASTEST?Read More →

A company recently migrated its line-of-business (LOB) application to AWS.The application uses an Amazon RDS for SQL Server DB instance as its database engine.The company must set up cross-Region disaster recovery for the application.The company needs a solution with the lowest possible RPO and RTO.Which solution will meet these requirements?Read More →

A company hosts an internal file-sharing application running on Amazon EC2 instances in VPC_A.This application is backed by an Amazon ElastiCache cluster, which is in VPC_B and peered with VPC_A.The company migrates its application instances from VPC_A to VPC_B.Logs indicate that the file-sharing application no longer can connect to the ElastiCache cluster.What should a database specialist do to resolve this issue?Read More →

A security team is conducting an audit for a financial company.The security team discovers that the database credentials of an Amazon RDS for MySQL DB instance are hardcoded in the source code.The source code is stored in a shared location for automatic deployment and is exposed to all users who can access the location.A database specialist must use encryption to ensure that the credentials are not visible in the source code.Which solution will meet these requirements?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 →

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 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 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 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 →