Home
Amazon
DBS-C01: AWS Certified Database - Specialty

Amazon DBS-C01 Exam Questions

Name: Amazon DBS-C01 Exam
Brand: Pass4Success
SKU: DBS-C01
Price: 69.00 USD
Availability: InStock
Rating: 4.8 (115 reviews)

Status: RETIRED

Exam Name: Amazon AWS Certified Database - Specialty Exam

Exam Code: DBS-C01

Related Certification(s): Amazon Specialty Certification

Certification Provider: Amazon

Number of DBS-C01 practice questions in our database: 322 (updated: 30-07-2024)

Disscuss Amazon DBS-C01 Topics, Questions or Ask Anything Related

0/2000 characters

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!

Free Amazon DBS-C01 Exam Actual Questions

Note: Premium Questions for DBS-C01 were last updated On 30-07-2024 (see below)

Question #1

A company is deploying a solution in Amazon Aurora by migrating from an on-premises system. The IT department has established an AWS Direct Connect link from the company's data center. The company's Database Specialist has selected the option to require SSL/TLS for connectivity to prevent plaintext data from being set over the network. The migration appears to be working successfully, and the data can be queried from a desktop machine.

Two Data Analysts have been asked to query and validate the data in the new Aurora DB cluster. Both Analysts are unable to connect to Auror

a. Their user names and passwords have been verified as valid and the Database Specialist can connect to the DB cluster using their accounts. The Database Specialist also verified that the security group configuration allows network from all corporate IP addresses.

What should the Database Specialist do to correct the Data Analysts' inability to connect?

ARestart the DB cluster to apply the SSL change.

BInstruct the Data Analysts to download the root certificate and use the SSL certificate on the connection string to connect.

CAdd explicit mappings between the Data Analysts' IP addresses and the instance in the security group assigned to the DB cluster.

DModify the Data Analysts' local client firewall to allow network traffic to AWS.

Reveal Solution Hide Solution

Correct Answer: B

* To connect using SSL:

* Provide the SSLTrust certificate (can be downloaded from AWS)

* Provide SSL options when connecting to database

* Not using SSL on a DB that enforces SSL would result in error

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/ssl-certificate-rotation-aurora-postgresql.html

Question #2

A company wants to migrate its on-premises MySQL databases to Amazon RDS for MySQL. To comply with the company's security policy, all databases must be encrypted at rest. RDS DB instance snapshots must also be shared across various accounts to provision testing and staging environments.

Which solution meets these requirements?

ACreate an RDS for MySQL DB instance with an AWS Key Management Service (AWS KMS) customer managed CMK. Update the key policy to include the Amazon Resource Name (ARN) of the other AWS accounts as a principal, and then allow the kms:CreateGrant action.

BCreate an RDS for MySQL DB instance with an AWS managed CMK. Create a new key policy to include the Amazon Resource Name (ARN) of the other AWS accounts as a principal, and then allow the kms:CreateGrant action.

CCreate an RDS for MySQL DB instance with an AWS owned CMK. Create a new key policy to include the administrator user name of the other AWS accounts as a principal, and then allow the kms:CreateGrant action.

DCreate an RDS for MySQL DB instance with an AWS CloudHSM key. Update the key policy to include the Amazon Resource Name (ARN) of the other AWS accounts as a principal, and then allow the kms:CreateGrant action.

Reveal Solution Hide Solution

Correct Answer: A

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ShareSnapshot.html

Question #3

A Database Specialist is designing a disaster recovery strategy for a production Amazon DynamoDB table. The table uses provisioned read/write capacity mode, global secondary indexes, and time to live (TTL). The Database Specialist has restored the latest backup to a new table.

To prepare the new table with identical settings, which steps should be performed? (Choose two.)

ARe-create global secondary indexes in the new table

BDefine IAM policies for access to the new table

CDefine the TTL settings

DEncrypt the table from the AWS Management Console or use the update-table command

ESet the provisioned read and write capacity

Reveal Solution Hide Solution

Correct Answer: B, C

The following items need to be reconfigured after restoring the DynamoDB table.

--AutoScaling policy

--IAM policy

--CloudWatch settings

--Tags

--Stream settings

--TTL

https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/backuprestore_HowItWorks.html

Question #4

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?

AMigrate the workloads from Amazon RDS for MySQL to Amazon DynamoDB

BEnable cross-Region read replicas and direct read traffic to then when Amazon RDS is down

CEnable a read replicas and direct read traffic to it when Amazon RDS is down

DEnable an Amazon RDS for MySQL Multi-AZ configuration

Reveal Solution Hide Solution

Correct Answer: D

https://aws.amazon.com/premiumsupport/knowledge-center/rds-required-maintenance/

To minimize downtime, modify the Amazon RDS DB instance to a Multi-AZ deployment. For Multi-AZ deployments, OS maintenance is applied to the secondary instance first, then the instance fails over, and then the primary instance is updated. The downtime is during failover. For more information, see Maintenance for Multi-AZ Deployments. https://aws.amazon.com/rds/faqs/ The availability benefits of Multi-AZ also extend to planned maintenance. For example, with automated backups, I/O activity is no longer suspended on your primary during your preferred backup window, since backups are taken from the standby. In the case of patching or DB instance class scaling, these operations occur first on the standby, prior to automatic fail over. As a result, your availability impact is limited to the time required for automatic failover to complete.

Question #5

A Database Specialist needs to speed up any failover that might occur on an Amazon Aurora PostgreSQL DB cluster. The Aurora DB cluster currently includes the primary instance and three Aurora Replicas.

How can the Database Specialist ensure that failovers occur with the least amount of downtime for the application?

ASet the TCP keepalive parameters low

BCall the AWS CLI failover-db-cluster command

CEnable Enhanced Monitoring on the DB cluster

DStart a database activity stream on the DB cluster

Reveal Solution Hide Solution

Correct Answer: A

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.BestPractices.html#AuroraPostgreSQL.BestPractices.FastFailover.TCPKeepalives

Explore Other Amazon Exams

Unlock Premium DBS-C01 Exam Questions with Advanced Practice Test Features:

Select Question Types you want
Set your Desired Pass Percentage
Allocate Time (Hours : Minutes)
Create Multiple Practice tests with Limited Questions
Customer Support

Get Full Access Now

Unlock all DBS-C01 features

Just for $59 you get

Select Question Types you want
Set your Desired Pass Percentage
Allocate Time (Hours : Minutes)
Create Multiple Practice tests with Limited Questions
Customer Support

Get Full Access Now

Login First To Buy This Product

Password

Questions and Answers Demo

Web-Based Practice Test Demo

Start Demo