Note! Following DBS-C01 Exam is Retired now. Please select the alternative replacement for your Exam Certification.

DBS-C01 Exam Dumps - AWS Certified Database - Specialty

Go to page:

<< First
Prev
1
2
3
4
5
6
7
8
9
10
Next
Last >>

Question # 9

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 TIE. 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? (Select THREE.)

Establish an AWS Direct Connect hosted connection between the companfs data center and AWS

Create an AWS Site-to-Site VPN connection between the companVs data center and AWS over the internet

Use AWS Database Migration Service (AWS DMS) to migrate the on-premises SQL Server databases to Amazon RDS for SQL Server Configure Always On availability groups for SQL Server.

Deploy a new SQL Server Always On availability group DB cluster on Amazon EC2 Configure Always On distributed availability groups between the on-premises DB cluster and the AWS DB cluster_ Fail over to the AWS DB cluster when it is time to migrate.

Grant system-level access to the third-party backup product to perform backups of the Amazon RDS for SQL Server DB instance.

Configure the third-party backup product to perform backups of the DB cluster on Amazon EC2.

Full Access

Question # 10

A company conducted a security audit of its AWS infrastructure. The audit identified that data was not encrypted in transit between application servers and a

MySQL database that is hosted in Amazon RDS.

After the audit, the company updated the application to use an encrypted connection. To prevent this problem from occurring again, the company's database team needs to configure the database to require in-transit encryption for all connections.

Which solution will meet this requirement?

Update the parameter group in use by the DB instance, and set the require_secure_transport parameter to ON.

Connect to the database, and use ALTER USER to enable the REQUIRE SSL option on the database user.

Update the security group in use by the DB instance, and remove port 80 to prevent unencrypted connections from being established.

Update the DB instance, and enable the Require Transport Layer Security option.

Full Access

Question # 11

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? (Select TWO_)

Set the audit_logs cluster parameter to enabled

Enable DocumentDB log export to Amazon CloudWatch Logs.

Enable Enhanced Monitoring tor DocumentDB.

Enable AWS CloudTrail for DocumentDB.

use AWS Config to monitor the state of DocumentDB.

Full Access

Question # 12

A company is using 5 TB Amazon RDS DB instances and needs to maintain 5 years of monthly database backups for compliance purposes. A Database Administrator must provide Auditors with data within 24 hours. Which solution will meet these requirements and is the MOST operationally efficient?

Create an AWS Lambda function to run on the first day of every month to take a manual RDS snapshot. Move the snapshot to the companyâ€™s Amazon S3 bucket.

Create an AWS Lambda function to run on the first day of every month to take a manual RDS snapshot.

Create an RDS snapshot schedule from the AWS Management Console to take a snapshot every 30 days.

Create an AWS Lambda function to run on the first day of every month to create an automated RDS snapshot.

Full Access

Question # 13

On AWS, a business is developing a web application. The application needs that the database supports concurrent read and write activities in several AWS Regions. Additionally, the database must communicate data changes across Regions as they occur. The application must be highly available and have a latency of less than a few hundred milliseconds.

Which solution satisfies these criteria?

Amazon DynamoDB global tables

Amazon DynamoDB streams with AWS Lambda to replicate the data

An Amazon ElastiCache for Redis cluster with cluster mode enabled and multiple shards

An Amazon Aurora global database

Full Access

Question # 14

A company uses Amazon DynamoDB as the data store for its ecommerce website. The website receives little to no traffic at night, and the majority of the traffic occurs during the day. The traffic growth during peak hours is gradual and predictable on a daily basis, but it can be orders of magnitude higher than during off-peak hours.

The company initially provisioned capacity based on its average volume during the day without accounting for the variability in traffic patterns. However, the website is experiencing a significant amount of throttling during peak hours. The company wants to reduce the amount of throttling while minimizing costs.

What should a database specialist do to meet these requirements?

Use reserved capacity. Set it to the capacity levels required for peak daytime throughput.

Use provisioned capacity. Set it to the capacity levels required for peak daytime throughput.

Use provisioned capacity. Create an AWS Application Auto Scaling policy to update capacity based on consumption.

Use on-demand capacity.

Full Access

Question # 15

AWS CloudFormation stack including an Amazon RDS database instance was mistakenly removed, resulting in the loss of recent data. A Database Specialist must apply RDS parameters to the CloudFormation template in order to minimize the possibility of future inadvertent instance data loss.

Which settings will satisfy this criterion? (Select three.)

Set DeletionProtection to True

Set MultiAZ to True

Set TerminationProtection to True

Set DeleteAutomatedBackups to False

Set DeletionPolicy to Delete

Set DeletionPolicy to Retain

Full Access

Question # 16

A company runs a customer relationship management (CRM) system that is hosted on-premises with a MySQL database as the backend. A custom stored procedure is used to send email notifications to another system when data is inserted into a table. The company has noticed that the performance of the CRM system has decreased due to database reporting applications used by various teams. The company requires an AWS solution that would reduce maintenance, improve performance, and accommodate the email notification feature.

Which AWS solution meets these requirements?

Use MySQL running on an Amazon EC2 instance with Auto Scaling to accommodate the reporting applications. Configure a stored procedure and an AWS Lambda function that uses Amazon SES to send email notifications to the other system.

Use Amazon Aurora MySQL in a multi-master cluster to accommodate the reporting applications. Configure Amazon RDS event subscriptions to publish a message to an Amazon SNS topic and subscribe the other system's email address to the topic.

Use MySQL running on an Amazon EC2 instance with a read replica to accommodate the reporting applications. Configure Amazon SES integration to send email notifications to the other system.

Use Amazon Aurora MySQL with a read replica for the reporting applications. Configure a stored procedure and an AWS Lambda function to publish a message to an Amazon SNS topic. Subscribe the other system's email address to the topic.

Full Access