Free AWS Certified Database – Specialty Exam DBS-C01 Exam Practice Test

A company's development team needs to have production data restored in a staging AWS account. The production database is running on an Amazon RDS for PostgreSQL Multi-AZ DB instance, which has AWS KMS encryption enabled using the default KMS key. A database specialist planned to share the most recent automated snapshot with the staging account, but discovered that the option to share snapshots is disabled in the AWS Management Console. What should the database specialist do to resolve this?

• Disable automated backups in the DB instance. Share both the automated snapshot and the default KMS key with the staging account. Restore the snapshot in the staging account and enable automated backups.
• Copy the automated snapshot specifying a custom KMS encryption key. Share both the copied snapshot and the custom KMS encryption key with the staging account. Restore the snapshot to the staging account within the same Region.
• Modify the DB instance to use a custom KMS encryption key. Share both the automated snapshot and the custom KMS encryption key with the staging account. Restore the snapshot in the staging account.
• Copy the automated snapshot while keeping the default KMS key. Share both the snapshot and the default KMS key with the staging account. Restore the snapshot in the staging account.

A company has an Amazon RDS Multi-AZ DB instances that is 200 GB in size with an RPO of 6 hours. To meet the company’s disaster recovery policies, the database backup needs to be copied into another Region. The company requires the solution to be cost-effective and operationally efficient. What should a Database Specialist do to copy the database backup into a different Region?

• Use Amazon RDS automated snapshots and use AWS Lambda to copy the snapshot into another Region
• Use Amazon RDS automated snapshots every 6 hours and use Amazon S3 cross-Region replication to copy the snapshot into another Region
• Create an AWS Lambda function to take an Amazon RDS snapshot every 6 hours and use a second Lambda function to copy the snapshot into another Region
• Create a cross-Region read replica for Amazon RDS in another Region and take an automated snapshot of the read replica

An online shopping company has a large inflow of shopping requests daily. As a result, there is a consistent load on the company’s Amazon RDS database. A database specialist needs to ensure the database is up and running at all times. The database specialist wants an automatic notification system for issues that may cause database downtime or for configuration changes made to the database. What should the database specialist do to achieve this? (Choose two.)

• Create an Amazon CloudWatch Events event to send a notification using Amazon SNS on every API call logged in AWS CloudTrail.
• Subscribe to an RDS event subscription and configure it to use an Amazon SNS topic to send notifications.
• Use Amazon SES to send notifications based on configured Amazon CloudWatch Events events.
• Configure Amazon CloudWatch alarms on various metrics, such as FreeStorageSpace for the RDS instance.
• Enable email notifications for AWS Trusted Advisor.

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.)

• The new minor version has not yet been designated as preferred and requires a manual upgrade.
• Configuring automatic upgrades using the AWS CLI is not supported. This must be enabled expressly using the AWS Management Console.
• Applying minor version upgrades requires sufficient free space.
• The AWS CLI command did not include an apply-immediately parameter.
• Aurora has detected a breaking change in the new minor version and has automatically rejected the upgrade.

A development team asks a database specialist to create a copy of a production Amazon RDS for MySQL DB instance every morning. The development team will use the copied DB instance as a testing environment for development. The original DB instance and the copy will be hosted in different VPCs of the same AWS account. The development team wants the copy to be available by 6 AM each day and wants to use the same endpoint address each day. Which combination of steps should the database specialist take to meet these requirements MOST cost-effectively? (Choose three.)

• Create a snapshot of the production database each day before the 6 AM deadline.
• Create an RDS for MySQL DB instance from the snapshot. Select the desired DB instance size.
• Update a defined Amazon Route 53 CNAME record to point to the copied DB instance.
• Set up an AWS Database Migration Service (AWS DMS) migration task to copy the snapshot to the copied DB instance.
• Use the CopySnapshot action on the production DB instance to create a snapshot before 6 AM.
• Update a defined Amazon Route 53 alias record to point to the copied DB instance.

A gaming company has implemented a leaderboard in AWS using a Sorted Set data structure within Amazon ElastiCache for Redis. The ElastiCache cluster has been deployed with cluster mode disabled and has a replication group deployed with two additional replicas. The company is planning for a worldwide gaming event and is anticipating a higher write load than what the current cluster can handle. Which method should a Database Specialist use to scale the ElastiCache cluster ahead of the upcoming event?

• Enable cluster mode on the existing ElastiCache cluster and configure separate shards for the Sorted Set across all nodes in the cluster.
• Increase the size of the ElastiCache cluster nodes to a larger instance size.
• Create an additional ElastiCache cluster and load-balance traffic between the two clusters.
• Use the EXPIRE command and set a higher time to live (TTL) after each call to increment a given key.

A database expert is responsible for building a highly available online transaction processing (OLTP) solution that makes use of Amazon RDS for MySQL production databases. Disaster recovery criteria include a cross-regional deployment and an RPO and RTO of 5 and 30 minutes, respectively. What should the database professional do to ensure that the database meets the criteria for high availability and disaster recovery?

• Use a Multi-AZ deployment in each Region.
• Use read replica deployments in all Availability Zones of the secondary Region.
• Use Multi-AZ and read replica deployments within a Region.
• Use Multi-AZ and deploy a read replica in a secondary Region.

A gaming company uses Amazon Aurora Serverless for one of its internal applications. The company's developers use Amazon RDS Data API to work with the Aurora Serverless DB cluster. After a recent security review, the company is mandating security enhancements. A database specialist must ensure that access to RDS Data API is private and never passes through the public internet. What should the database specialist do to meet this requirement?

• Modify the Aurora Serverless cluster by selecting a VPC with private subnets.
• Modify the Aurora Serverless cluster by unchecking the publicly accessible option.
• Create an interface VPC endpoint that uses AWS PrivateLink for RDS Data API.
• Create a gateway VPC endpoint for RDS Data API.

A business is transferring a database from one AWS Region to another using an Amazon RDS for SQL Server DB instance. The organization wishes to keep database downtime to a minimum throughout the transfer. Which migration strategy should the organization use for this cross-regional move?

• Back up the source database using native backup to an Amazon S3 bucket in the same Region. Then restore the backup in the target Region.
• Back up the source database using native backup to an Amazon S3 bucket in the same Region. Use Amazon S3 Cross-Region Replication to copy the backup to an S3 bucket in the target Region. Then restore the backup in the target Region.
• Configure AWS Database Migration Service (AWS DMS) to replicate data between the source and the target databases. Once the replication is in sync, terminate the DMS task.
• Add an RDS for SQL Server cross-Region read replica in the target Region. Once the replication is in sync, promote the read replica to master.

A company is moving its fraud detection application from on premises to the AWS Cloud and is using Amazon Neptune for data storage. The company has set up a 1 Gbps AWS Direct Connect connection to migrate 25 TB of fraud detection data from the on-premises data center to a Neptune DB instance. The company already has an Amazon S3 bucket and an S3 VPC endpoint, and 80% of the company’s network bandwidth is available. How should the company perform this data load?

• Use an AWS SDK with a multipart upload to transfer the data from on premises to the S3 bucket. Use the Copy command for Neptune to move the data in bulk from the S3 bucket to the Neptune DB instance.
• Use AWS Database Migration Service (AWS DMS) to transfer the data from on premises to the S3 bucket. Use the Loader command for Neptune to move the data in bulk from the S3 bucket to the Neptune DB instance.
• Use AWS DataSync to transfer the data from on premises to the S3 bucket. Use the Loader command for Neptune to move the data in bulk from the S3 bucket to the Neptune DB instance.
• Use the AWS CLI to transfer the data from on premises to the S3 bucket. Use the Copy command for Neptune to move the data in bulk from the S3 bucket to the Neptune DB instance.