Most Recent Amazon DBS-C01 Exam Questions & Answers

Prepare for the Amazon AWS Certified Database - Specialty exam with our extensive collection of questions and answers. These practice Q&A are updated according to the latest syllabus, providing you with the tools needed to review and test your knowledge.

QA4Exam focus on the latest syllabus and exam objectives, our practice Q&A are designed to help you identify key topics and solidify your understanding. By focusing on the core curriculum, These Questions & Answers helps you cover all the essential topics, ensuring you're well-prepared for every section of the exam. Each question comes with a detailed explanation, offering valuable insights and helping you to learn from your mistakes. Whether you're looking to assess your progress or dive deeper into complex topics, our updated Q&A will provide the support you need to confidently approach the Amazon DBS-C01 exam and achieve success.

The questions for DBS-C01 were last updated on Dec 21, 2024.

Viewing page 1 out of 64 pages.
Viewing questions 1-5 out of 322 questions

Get All 322 Questions & Answers

Question No. 1

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?

AUse a Multi-AZ deployment in each Region.

BUse read replica deployments in all Availability Zones of the secondary Region.

CUse Multi-AZ and read replica deployments within a Region.

DUse Multi-AZ and deploy a read replica in a secondary Region.

Show Answer

Correct Answer: D

Question No. 2

Amazon RDS for Oracle with Transparent Data Encryption is used by a financial services organization (TDE). At all times, the organization is obligated to encrypt its data at rest. The decryption key must be widely distributed, and access to the key must be restricted. The organization must be able to rotate the encryption key on demand to comply with regulatory requirements. If any possible security vulnerabilities are discovered, the organization must be able to disable the key. Additionally, the company's overhead must be kept to a minimal.

What method should the database administrator use to configure the encryption to fulfill these specifications?

AAWS CloudHSM

BAWS Key Management Service (AWS KMS) with an AWS managed key

CAWS Key Management Service (AWS KMS) with server-side encryption

DAWS Key Management Service (AWS KMS) CMK with customer-provided material

Show Answer

Correct Answer: D

https://docs.aws.amazon.com/whitepapers/latest/kms-best-practices/aws-managed-and-customer-managed-cmks.html

Question No. 3

A business's mission-critical production workload is being operated on a 500 GB Amazon Aurora MySQL DB cluster. A database engineer must migrate the workload without causing data loss to a new Amazon Aurora Serverless MySQL DB cluster.

Which approach will result in the LEAST amount of downtime and the LEAST amount of application impact?

AModify the existing DB cluster and update the Aurora configuration to Serverless.

BCreate a snapshot of the existing DB cluster and restore it to a new Aurora Serverless DB cluster.

CCreate an Aurora Serverless replica from the existing DB cluster and promote it to primary when the replica lag is minimal.

DReplicate the data between the existing DB cluster and a new Aurora Serverless DB cluster by using AWS Database Migration Service (AWS DMS) with change data capture (CDC) enabled.

Show Answer

Correct Answer: D

https://medium.com/@souri29/how-to-migrate-from-amazon-rds-aurora-or-mysql-to-amazon-aurora-serverless-55f9a4a74078

Question No. 4

An electric utility company wants to store power plant sensor data in an Amazon DynamoDB table. The utility company has over 100 power plants and each power plant has over 200 sensors that send data every 2 seconds. The sensor data includes time with milliseconds precision, a value, and a fault attribute if the sensor is malfunctioning. Power plants are identified by a globally unique identifier. Sensors are identified by a unique identifier within each power plant. A database specialist needs to design the table to support an efficient method of finding all faulty sensors within a given power plant.

Which schema should the database specialist use when creating the DynamoDB table to achieve the fastest query time when looking for faulty sensors?

AUse the plant identifier as the partition key and the measurement time as the sort key. Create a global secondary index (GSI) with the plant identifier as the partition key and the fault attribute as the sort key.

BCreate a composite of the plant identifier and sensor identifier as the partition key. Use the measurement time as the sort key. Create a local secondary index (LSI) on the fault attribute.

CCreate a composite of the plant identifier and sensor identifier as the partition key. Use the measurement time as the sort key. Create a global secondary index (GSI) with the plant identifier as the partition key and the fault attribute as the sort key.

DUse the plant identifier as the partition key and the sensor identifier as the sort key. Create a local secondary index (LSI) on the fault attribute.

Show Answer

Correct Answer: D

Plant id as partition key and Sensor id as a sort key. Fault can be identified quickly using the local secondary index and associated plant and sensor can be identified easily.

Question No. 5

A company is using Amazon RDS for PostgreSQL. The Security team wants all database connection requests to be logged and retained for 180 days. The RDS for PostgreSQL DB instance is currently using the default parameter group. A Database Specialist has identified that setting the log_connections parameter to 1 will enable connections logging.

Which combination of steps should the Database Specialist take to meet the logging and retention requirements? (Choose two.)

AUpdate the log_connections parameter in the default parameter group

BCreate a custom parameter group, update the log_connections parameter, and associate the parameter with the DB instance

CEnable publishing of database engine logs to Amazon CloudWatch Logs and set the event expiration to 180 days

DEnable publishing of database engine logs to an Amazon S3 bucket and set the lifecycle policy to 180 days

EConnect to the RDS PostgreSQL host and update the log_connections parameter in the postgresql.conf file

Show Answer

Correct Answer: A, E

Unlock All Questions for Amazon DBS-C01 Exam

Full Exam Access, Actual Exam Questions, Validated Answers, Anytime Anywhere, No Download Limits, No Practice Limits

Get All 322 Questions & Answers