DON'T WANT TO MISS A THING?

Certification Exam Passing Tips

Latest exam news and discount info

Curated and up-to-date by our experts

Yes, send me the newsletter

Boost Your Certification Prep with DBS-C01 Mock Tests, AWS Certified Database – Specialty | SPOTO

Enhance your certification preparation with DBS-C01 Mock Tests for AWS Certified Database – Specialty at SPOTO. This exam focuses on validating your extensive knowledge of database concepts, covering design, migration, deployment, access, maintenance, automation, monitoring, security, and troubleshooting. Our mock tests are designed to simulate real exam scenarios, helping you familiarize yourself with the exam format and assess your readiness. Access exam questions, practice tests, and exam dumps to reinforce your understanding and improve exam performance. Benefit from sample questions, exam materials, and answers to enhance your exam practice and preparation. Utilize our exam simulator for realistic testing experiences and gain confidence to excel in the AWS Certified Database – Specialty (DBS-C01) exam. SPOTO provides the resources and support necessary to boost your certification journey and succeed in database specialization.
Take other online exams
Question #1
A marketing company is using Amazon DocumentDB and requires that database audit logs be enabled. A Database Specialist needs to configure monitoring so that all data definition language (DDL) statements performed are visible to the Administrator. The Database Specialist has set the audit_logs parameter to enabled in the cluster parameter group. What should the Database Specialist do to automatically collect the database logs for the Administrator?
A. Enable DocumentDB to export the logs to Amazon CloudWatch Logs
B. Enable DocumentDB to export the logs to AWS CloudTrail
C. Enable DocumentDB Events to export the logs to Amazon CloudWatch Logs
D. Configure an AWS Lambda function to download the logs using the download-db-log-file-portion operationand store the logs in Amazon S3
View answer
Correct Answer: D
Question #2
A financial services company is developing a shared data service that supports different applications from throughout the company. A Database Specialist designed a solution to leverage Amazon ElastiCache for Redis with cluster mode enabled to enhance performance and scalability. The cluster is configured to listen on port 6379. Which combination of steps should the Database Specialist take to secure the cache data and protect it from unauthorized access? (Choose three.)
A. Enable in-transit and at-rest encryption on the ElastiCache cluster
B. Ensure that Amazon CloudWatch metrics are configured in the ElastiCache cluster
C. Ensure the security group for the ElastiCache cluster allows all inbound traffic from itself and inbound traffic on TCP port 6379 from trusted clients only
D. Create an IAM policy to allow the application service roles to access all ElastiCache API actions
E. Ensure the security group for the ElastiCache clients authorize inbound TCP port 6379 and port 22 traffic from the trusted ElastiCache cluster’s security group
F. Ensure the cluster is created with the auth-token parameter and that the parameter is used in all subsequent commands
View answer
Correct Answer: D
Question #3
A company with branch offices in Portland, New York, and Singapore has a three-tier web application that leverages a shared database. The database runs on Amazon RDS for MySQL and is hosted in the us-west-2 Region. The application has a distributed front end deployed in the us-west-2, ap-southheast-1, and us- east-2 Regions. This front end is used as a dashboard for Sales Managers in each branch office to see current sales statistics. There are complaints that the dashboard performs more slowly in the Singa
A. Take a snapshot of the instance in the us-west-2 Regio
B. Create a new instance from the snapshot in the ap-southeast-1 Regio
C. Reconfigure the ap-southeast-1 front-end dashboard to access this instance
D. Create an RDS read replica in the ap-southeast-1 Region from the primary RDS DB instance in the uswest- 2 Regio
E. Reconfigure the ap-southeast-1 front-end dashboard to access this instance
F. Create a new RDS instance in the ap-southeast-1 Regio G
View answer
Correct Answer: A
Question #4
A company is closing one of its remote data centers. This site runs a 100 TB on-premises data warehouse solution. The company plans to use the AWS Schema Conversion Tool (AWS SCT) and AWS DMS for the migration to AWS. The site network bandwidth is 500 Mbps. A Database Specialist wants to migrate the on- premises data using Amazon S3 as the data lake and Amazon Redshift as the data warehouse. This move must take place during a 2-week period when source systems are shut down for maintenance. The data should s
A. Set up a VPN tunnel for encrypting data over the network from the data center to AW
B. Leverage AWSSCT and apply the converted schema to Amazon Redshif
C. Once complete, start an AWS DMS task tomove the data from the source to Amazon S3
D. Leverage AWS SCT and apply the converted schema to Amazon Redshif
E. Start an AWS DMS task withtwo AWS Snowball Edge devices to copy data from on-premises to Amazon S3 with AWS KMS encryption
F. Leverage AWS SCT and apply the converted schema to Amazon Redshif G
View answer
Correct Answer: D
Question #5
An AWS CloudFormation stack that included an Amazon RDS DB instance was accidentally deleted and recent data was lost. A Database Specialist needs to add RDS settings to the CloudFormation template to reduce the chance of accidental instance data loss in the future. Which settings will meet this requirement? (Choose three.)
A. Set DeletionProtection to True
B. Set MultiAZ to True
C. Set TerminationProtection to True
D. Set DeleteAutomatedBackups to False
E. Set DeletionPolicy to Delete
F. Set DeletionPolicy to Retain
View answer
Correct Answer: ACF
Question #6
A company is developing a multi-tier web application hosted on AWS using Amazon Aurora as the database. The application needs to be deployed to production and other non-production environments. A Database Specialist needs to specify different MasterUsername and MasterUserPassword properties in the AWS CloudFormation templates used for automated deployment. The CloudFormation templates are version controlled in the company’s code repository. The company also needs to meet compliance requirement by routinely
A. Store the master password in a parameter file in each environmen
B. Reference the environment-specific parameter file in the CloudFormation template
C. Encrypt the master password using an AWS KMS ke
D. Store the encrypted master password in theCloudFormation template
E. Use the secretsmanager dynamic reference to retrieve the master password stored in AWS SecretsManager and enable automatic rotation
F. Use the ssm dynamic reference to retrieve the master password stored in the AWS Systems ManagerParameter Store and enable automatic rotation
View answer
Correct Answer: DEF
Question #7
A Database Specialist is troubleshooting an application connection failure on an Amazon Aurora DB cluster with multiple Aurora Replicas that had been running with no issues for the past 2 months. The connection failure lasted for 5 minutes and corrected itself after that. The Database Specialist reviewed the Amazon RDS events and determined a failover event occurred at that time. The failover process took around 15 seconds to complete. What is the MOST likely cause of the 5-minute connection outage?
A. After a database crash, Aurora needed to replay the redo log from the last database checkpoint
B. The client-side application is caching the DNS data and its TTL is set too high
C. After failover, the Aurora DB cluster needs time to warm up before accepting client connections
D. There were no active Aurora Replicas in the Aurora DB cluster
View answer
Correct Answer: C
Question #8
A retail company is about to migrate its online and mobile store to AWS. The company’s CEO has strategic plans to grow the brand globally. A Database Specialist has been challenged to provide predictable read and write database performance with minimal operational overhead. What should the Database Specialist do to meet these requirements?
A. Use Amazon DynamoDB global tables to synchronize transactions
B. Use Amazon EMR to copy the orders table data across Regions
C. Use Amazon Aurora Global Database to synchronize all transactions
D. Use Amazon DynamoDB Streams to replicate all DynamoDB transactions and sync them
View answer
Correct Answer: A

View Answers after Submission

Please submit your email and WhatsApp to get the answers of questions.

Note: Please make sure your email ID and Whatsapp are valid so that you can get the correct exam results.

Email:
Whatsapp/phone number:


Copyright © 2024. Designer by SPOTO Official Website. All Rights Reserved.