Pass Your DBS-C01 Certification Questions & Practice Tests, AWS Certified Database – Specialty

Question #1

1. A company’s compliance requirements mandate regular backup of all their production databases. What should a Database Specialist consider when creating backups for DynamoDB tables? (Select three)

A. To delete backups marked with a “Backup type’ of AWS using the DynamoDB console, you need to have full access permissions on DynamoDB resources

B. All API and console actions of DynamoDB backup and restore are captured and recorded in AWS CloudTrail

C. When you restore a table, you only use the provisioned Read Capacity Units (RCUs) of the table and Write Capacity Units (WCUs) remain untouched

D. IAM policies as well as encryption settings have to be manually setup for the restored table

E. DynamoDB backup will preserve the Provisioned Read and Write capacities, Local Secondary Indexes (LSIs) and billing mode of the backed-up table

F. Auto-scaling policies, AWS Identity and Access Management (IAM) policies have to be manually setup for the restored table

View answer

Correct Answer: BEF

Question #2

30. An analytics company uses Aurora MySQL DB cluster for running online transaction processing (OLTP) transactions all through the day as well as running a reporting workload at certain times of the day. The reporting workload amounts to just 20% of the OLTP workload. A 10-node cluster is sufficient to meet the entire workload. The company wants to optimize the cluster size so that it pays the minimum charges while still maintaining a sufficient number of nodes to support any changes in the overall workloa

A. Use Aurora Auto Scaling to enable your Aurora DB cluster to handle variations in workload by provisioning Aurora Multi-AZ instances

B. Create two separate DB clusters use one for OLTP workload and the other for reporting workload

C. Use Aurora Auto Scaling to enable your Aurora DB cluster to handle variations in workload by provisioning Aurora Replicas

D. Use CloudWatch alarm to stop all the nodes of the DB cluster during times of minimal workload

View answer

Correct Answer: C

Question #3

26. The technology team at a Wall Street trading firm uses DynamoDB to facilitate high- frequency trading where multiple trades can try and update an item at the same time. As a Database Specialist, which of the following actions would you recommend to make sure that only the last updated value of any item is used in the application?

A. Use ConsistentRead – true while doing Getitem operation for any item

B. Use ConsistentRead – true while doing Putitem operation for any item

C. Use ConsistentRead – true while doing Updateltem operation for any item

D. Use ConsistentRead – false while doing Putitem operation for any item

View answer

Correct Answer: A

Question #4

33. The technology team at a retail organization is running batch workloads on AWS Cloud. The team has embedded RDS database connection strings within each web server hosting the flagship application. After failing a security audit, the team is looking at a different approach to store the database secrets securely and automatically rotate the database credentials. As a Database Specialist, which of the following solutions would you recommend to meet this requirement?

A. Secrets Manager

B. KMS

C. Systems Manager

D. SSM Parameter Store

View answer

Correct Answer: A

Question #5

25. Due to the COVID-19 pandemic, a large retail company is planning to close operations for a month. The technology team at the company needs to stop all applications along with all the RDS PostGreSQL DB instances to ensure employees do not have access to the systems during this time. The Team Lead has written and executed a script to stop all the RDS PostGreSQL DB instances. However, while reviewing the logs, the Team Lead finds that the RDS PostGreSQL DB instances with Read Replicas did not stop. As an A

A. Stop all Read Replicas before stopping the primary RDS DB instance

B. Use a schedule based CloudWatch Events rule to stop the Read Replicas and the primary RDS DB instance at the same time

C. Stop the primary RDS DB instance before stopping all Read Replicas

D. Delete all Read Replicas before stopping the corresponding primary RDS DB instance

View answer

Correct Answer: D

Question #6

12. You are a database administrator for an IT company that recently moved its production application to AWS and migrated data from PostGreSQL to AWS DynamoDB. You are adding new tables to AWS DynamoDB and need to allow your application to query your data by the primary key and an alternate key. This option must be added at the outset when you are first creating tables, otherwise, changes cannot be done once the table is created. As a Database Specialist, which of the following actions would you suggest?

A. Create an LSI

B. Migrate away from DynamoDB

C. Create a GSI

D. Create DynamoDB Streams

View answer

Correct Answer: A

Question #7

17. A Silicon Valley based startup is experimenting with DynamoDB in its new test environment. The database team has discovered that some of the write operations have been overwriting existing items which have that specific primary key. This has corrupted their data leading to data discrepancies. As a Database Specialist, which DynamoDB write option would you select to prevent this kind of overwriting?

A. Conditional writes

B. Atomic Counters

C. Batch writes

D. Use Scan operation

View answer

Correct Answer: A

Question #8

13. A global CRM company uses Amazon RDS for MySQL DB cluster for its flagship application but it is running into performance issues despite using Read Replicas. The company has hired you as an AWS Certified Database Specialist to address these performance-related challenges on an urgent basis without moving away from the underlying relational database schema. The company has branch offices across the world and it needs the solution to work on a global scale. Which of the following will you recommend as the

A. Use Amazon Aurora Global Database to enable fast local reads with low latency in each region

B. Spin up a Redshift cluster in each AWS region

C. Spin up EC2 instances in each AWS region, install MySQL databases and migrate the existing data into these new databases

D. Use Amazon DynamoDB Global Tables to provide fast, local, read and write performance in each region

View answer

Correct Answer: A

Question #9

11. A sports analytics firm uses AWS DynamoDB to store information about user’s favorite sports teams and allows the information to be searchable from their home page. There is a daily requirement that all 10 million records in the table should be deleted then re-loaded at 3:00 AM each night. Which option is an efficient way to delete with minimal costs?

A. Scan and delete items using batch mode

B. Delete then re-create the table

C. Scan and delete items individually

D. Use the purge table option

View answer

Correct Answer: B

Question #10

31. An advertising technology company is looking at moving their on-premises infrastructure to AWS Cloud. Their flagship application uses a massive PostgreSQL database and the database administration team would like to retain control over managing the patches, version upgrades for the database, and consistent performance with high IOPS. The team wants to install the database on an EC2 instance with the optimal storage type on the attached EBS volume. As a Database Specialist, which of the following configur

A. Amazon EC2 with EBS volume of Throughput Optimized HDD (st1) type

B. Amazon EC2 with EBS volume of Provisioned IOPS SSD (io1) type

C. Amazon EC2 with EBS volume of cold HDD (sc1) type

D. Amazon EC2 with EBS volume of General Purpose SSD (gp2) type

View answer

Correct Answer: B

Question #11

21. The engineering team at a Big Data Analytics company has set up a workflow to ingest the clickstream data into the raw zone of the S3 data lake. The team wants to run some SQL based data sanity checks on the raw zone of the data lake. The company has hired you as an AWS Certified Database Specialist to build a serverless solution that involves the least amount of development effort so that is cost-effective and easy to maintain. Which of the following solutions would you build for this use-case?

A. Load the incremental raw zone data into RDS on an hourly basis and run the SQL based sanity checks

B. Load the incremental raw zone data into DynamoDB on an hourly basis and run the SQL based sanity checks

C. Use Athena to run SQL based analytics against S3 data

D. Load the incremental raw zone data into Redshift on an hourly basis and run the SQL based sanity checks

View answer

Correct Answer: C

Question #12

16. You are a Database Specialist working for an analytics company. You have been tasked with building a reporting application that includes dashboards for data visualization. You are provisioning your AWS DynamoDB table and need to perform 10 strongly consistent reads per second of 8 KB in size each. How many Read Capacity Units (RCUs) are needed?

A. 20

B. 10

C. 40

D. 5

View answer

Correct Answer: A

Question #13

A Database Specialist is creating Amazon DynamoDB tables, Amazon CloudWatch alarms, and associated infrastructure for an Application team using a development AWS account. The team wants a deployment method that will standardize the core solution components while managing environment-specific settings separately, and wants to minimize rework due to configuration errors. Which process should the Database Specialist recommend to meet these requirements?

A. Organize common and environmental-specific parameters hierarchically in the AWS Systems ManagerParameter Store, then reference the parameters dynamically from an AWS CloudFormation template

B. Create a parameterized AWS CloudFormation template that builds the required object

C. Keep separateenvironment parameter files in separate Amazon S3 bucket

D. Provide an AWS CLI command that deploysthe CloudFormation stack directly referencing the appropriate parameter bucket

E. Create a parameterized AWS CloudFormation template that builds the required object

F. Import thetemplate into the CloudFormation interface in the AWS Management Consol G

View answer

Correct Answer: AD

Question #14

2. The database administration team at a major health-care company uses Multi-Availability Zone (Multi-AZ) deployment for its RDS MySQL DB cluster to automate its database replication and augment data durability. The database administration team has scheduled a maintenance window for a database engine level upgrade for the next weekend. As an AWS Certified Database Specialist, which of the following would you identify as the correct outcome during the maintenance window?

A. Any database engine level upgrade for an RDS DB instance with Multi-AZ deployment triggers the standby DB instance to be upgraded which is then followed by the upgrade of the primary DB instance

B. Any database engine level upgrade for an RDS DB instance with Multi-AZ deployment triggers both the primary and standby DB instances to be upgraded at the same time

C. Any database engine level upgrade for an RDS DB instance with Multi-AZ deployment triggers the primary DB instance to be upgraded which is then followed by the upgrade of the standby DB instance

D. Any database engine level upgrade for an RDS DB instance with Muiti-AZ deployment triggers both the primary and standby DB instances to be upgraded at the same time

View answer

Correct Answer: D

Question #15

10. A health-care company has just migrated its IT infrastructure from the on-premises data-center to AWS Cloud. The company is using Aurora MySQL DB cluster as its data store and the HIPAA compliance guidelines mandate that the company must produce audit logs from the production Amazon Aurora MySQL cluster and push the encrypted logs into a third-party compliance management application. The solution should allow the security team to carry out real-time alerting and monitoring outside the Aurora DB cluster.

A. Activate Aurora Event Notifications and then push the notifications into a compliance management application via Kinesis Data Streams

B. Set up AWS CloudTrail to capture the audit logs for the DB cluster and the security team can ingest the data from Amazon S3 into the compliance management application

C. Activate database activity streams and then push the streams into a compliance management application via Kinesis Data Streams

D. Enable Aurora Enhanced Monitoring and then push the metrics into a compliance management application via AWS Lambda

View answer

Correct Answer: C

Question #16

15. The database administration team at a gaming company is planning to create a Read Replica of an existing Amazon RDS for PostGreSQL Multi-AZ DB instance. However, while using the AWS Management Console to set up the Read Replica, the Team Lead discovers that the source RDS DB instance does not show in the Read Replica source field. As a Database Specialist, which of the following would you recommend as a solution for this issue?

A. Enable database cloning on the source RDS DB instance

B. Enable Enhanced Monitoring on the source RDS DB instance

C. Enable database replication on the source RDS DB instance

D. Enable automatic backups on the source RDS DB instance

View answer

Correct Answer: D

Question #17

23. A gaming company maintains a staging environment for its flagship application which uses a DynamoDB table to keep track of gaming history for the players. This data needs to be kept for only a week and then it can be deleted. The IT manager has noticed that the table has several months of data in the table. The company wants to implement a cost-effective solution to keep only the latest week’s data in the table. Which of the following solutions requires the MINIMUM development effort and on-going mainte

A. Add a new attribute in the table to track the expiration time and set up a Glue job to delete items that are more than a week old

B. Add a created_at attribute in the table and then use a cron job on EC2 instance to invoke a Python script daily

C. Add a new attribute in the table to track the expiration time and enable time to live (TTL) on the table

D. Add a created_at attribute in the table and then use a CloudWatch Events rule to invoke a Lambda function daily

View answer

Correct Answer: C

Question #18

19. An ed-tech company is doing pre-launch testing for its new product. The company runs its production database on an Aurora MySQL DB cluster and the performance testing team wants access to multiple test databases that must be re-created from production data. The company has hired an AWS Certified Database Specialist to deploy a solution to create test databases quickly with the LEAST required effort for database administration. What should the Database Specialist do to address this use-case?

A. Use database cloning to create multiple clones of the production

B. Create additional Read Replicas of the Aurora MySQL production DB and use the Read Replicas for testing by promoting each Replica to be its own independent standalone instance

C. Enable database Backtracking on the production DB and let the testing team use the production DB

D. Take a backup of the Aurora MySQL DB instance using the mysqidump utility, create multiple new test DB instances and restore each test DB from the backup

View answer

Correct Answer: A

Question #19

27. An IT company has a three-year contract with a health-care provider. The contract states that monthly database backups must be retained for the duration of the contract for compliance purposes. Currently. the limit for backup retention for automated backups on Amazon Relational Database Service (RDS) does not meet your requirements. Which of the following solutions can help you meet your requirements?

A. Enable RDS Multi-AZ

B. Enable RDS automatic backups

C. Create a schedule based CloudWatch Events rule that invokes an AWS Lambda function that further triggers the database snapshot

D. Enable RDS Read replicas

View answer

Correct Answer: C

Question #20

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

A. Re-create global secondary indexes in the new table

B. Define IAM policies for access to the new table

C. Define the TTL settings

D. Encrypt the table from the AWS Management Console or use the update-table command

E. Set the provisioned read and write capacity

View answer

Correct Answer: D

Question #21

34. A gaming company is using RDS MySQL DB to re-engineer its flagship application. The development team needs to restore its MySQL database whenever a developer makes a mistake in the schema updates. As a result, the entire development team needs to wait hours for the DB restore to complete. The issue is further compounded as multiple team members are collaborating on the same project, thereby making it hard to find the right restore point for each mistake. As a Database Specialist, which of the following

A. Enable the RDS for MySQL Clone feature and then the developers can make changes to their own cloned instances

B. Enable the RDS for MySQL Backtrack feature and then the developers can backtrack to a pre-defined checkpoint

C. Set up multiple read replicas and then the developers can make changes to their own promoted replica instances

D. Migrate to Amazon Aurora MySQL and enable the Aurora Backtrack feature

View answer

Correct Answer: C

Question #22

A company is using an Amazon Aurora PostgreSQL DB cluster with an xlarge primary instance master and two large Aurora Replicas for high availability and read- only workload scaling. A failover event occurs and application performance is poor for several minutes. During this time, application servers in all Availability Zones are healthy and responding normally. What should the company do to eliminate this application performance issue?

A. Configure both of the Aurora Replicas to the same instance class as the primary DB instance

B. Deploy an AWS Lambda function that calls the DescribeDBInstances action to establish which instancehas failed, and then use the PromoteReadReplica operation to promote one Aurora Replica to be theprimary DB instanc

C. Configure an Amazon RDS event subscription to send a notification to an AmazonSNS topic to which the Lambda function is subscribed

D. Configure one Aurora Replica to have the same instance class as the primary DB instance

E. Set the failover priority to tier-0 for the primary DBinstance and one replica with the same instance clas

F. Set the failover priority to tier-1 for the otherreplicas

View answer

Correct Answer: AE

Question #23

24. An analytics company is looking to migrate its RDS PostGreSQL DB instance to Aurora PostGreSQL DB cluster. The company wants the fastest possible solution with minimum downtime and least effort for the migration of its current database which is 2TB in size. As a Database Specialist, which of the following solutions would you recommend for this use-case?

A. Use AWS Database Migration Service (AWS DMS) to migrate the RDS PostGreSQL DB instance to Aurora PostGreSQL DB cluster

B. Create a DB snapshot for the Aurora PostgreSQL DB instance and then migrate data directly from this DB snapshot to the Aurora PostgreSQL DB cluster

C. Create an Aurora PostgreSQL Read Replica of the PostgreSQL DB instance and migrate data to the Aurora PostgreSQL DB cluster using this Read Replica

D. Use AWS Glue to create an ETL job for the data migration from RDS PostGreSQL DB instance to Aurora PostGreSQL DB cluster

View answer

Correct Answer: D

Question #24

29. A financial services company has recently transitioned its technology infrastructure from the on-premises data center to AWS Cloud. The security team at the company is evaluating the security features offered by RDS MySQL. You have been hired as an AWS Certified Database Specialist to provide guidance on RDS MySQL security offerings. Which of the following statements would you identify as correct for the given use-case? (Select three)

A. You can map multiple IAM users or roles to the same database user account

B. IAM database authentication tokens are generated using AWS access keys

C. All data transmitted to and from RDS DB instance for IAM Database Authentication is encrypted using KMS service

D. IAM database authentication should only be used if your application requires no more than 200 new connections per second

E. If your application is running on Amazon Elastic Compute Cloud (Amazon EC2)

F. IAM user/role and database user hold a one to one relationship

View answer

Correct Answer: ADE

Question #25

A company is running a two-tier ecommerce application in one AWS account. The web server is deployed using an Amazon RDS for MySQL Multi-AZ DB instance. A Developer mistakenly deleted the database in the production environment. The database has been restored, but this resulted in hours of downtime and lost revenue. Which combination of changes in existing IAM policies should a Database Specialist make to prevent an error like this from happening in the future? (Choose three.)

A. Grant least privilege to groups, users, and roles

B. Allow all users to restore a database from a backup that will reduce the overall downtime to restore thedatabase

C. Enable multi-factor authentication for sensitive operations to access sensitive resources and APIoperations

D. Use policy conditions to restrict access to selective IP addresses

E. Use AccessList Controls policy type to restrict users for database instance deletion

F. Enable AWS CloudTrail logging and Enhanced Monitoring

View answer

Correct Answer: C

Question #26

18. As part of its disaster recovery testing. an IT company would like to simulate an Availability Zone failure for its RDS for MySQL Multi-AZ DB instance. The testing team wants to record how the application reacts during the DB instance failover activity. The company does not want to make any configuration or code changes for this testing. As a Database Specialist, which of the following solutions would you outline for the company to test this use-case in the SHORTEST time?

A. Use the RDS SQL injection query to simulate the primary instance failure

B. Use the RDS fault injection query to simulate the primary instance failure

C. Initiate a manual failover of the RDS DB primary instance by terminating the instance

D. Initiate a manual failover of the RDS DB primary instance by using reboot with failover

View answer

Correct Answer: D

Question #27

22. A global e-commerce company has just migrated its technology infrastructure from the on-premises data center to AWS Cloud. The database management team at the e-commerce company wants to deploy an Online Transactional Processing (OLTP) application with support for relational queries which will have unpredictable spikes in the usage pattern that they do not know in advance. As a Database Specialist, which of the following database solutions would you recommend for this use-case?

A. DynamoDB with On-Demand Capacity

B. Aurora Serverless

C. Aurora Global Database

D. DynamoDB with Provisioned Capacity and Auto Scaling

View answer

Correct Answer: B

Question #28

28. An IT company manages its technology infrastructure on the AWS Cloud. The Database administration team at the company wants to migrate its RDS MySQL database to Aurora MySQL database. As a Database Specialist, which of the following solutions would you suggest so that it does not require any custom development and there is minimum downtime when the company migrates the database?

A. Create a clone of the RDS MySQL DB instance and then promote the clone into a standalone Aurora DB cluster

B. Create a DB snapshot of the RDS MySQL DB and then migrate this snapshot to create an Aurora MySQL DB cluster

C. Use AWS Glue to create an ETL job to migrate the RDS MySQL database to Aurora MySQL database

D. Create an Aurora Replica from the RDS MySQL DB instance and then promote the Replica into a standalone Aurora DB cluster

View answer

Correct Answer: D

Question #29

14. A big data analytics company wants to process loT data from the field devices of an agricultural sciences company. The database team at the analytics company is designing a new database infrastructure for capturing this loT data. The database should be resilient with minimal operational overhead and require the least development effort. The application includes a device tracking system that stores the GPS data for all devices. Real-time loT data, as well as metadata lookups, must be performed with high

A. Use DocumentDB as the database with API Gateway

B. Use DynamoDB as the database with DynamoDB Accelerator (DAX)

C. Use Aurora MySQL as the database with Aurora cluster cache

D. Use RDS MySQL as the database with ElastiCache

View answer

Correct Answer: B

Question #30

3. A database administrator is provisioning a DynamoDB table for an e-commerce application. The development team has given a requirement of 500 Write Capacity Units and 5000 Read Capacity Units for this DynamoDB table. The database administrator is planning to allocate 50GB of space to this table. How many partitions will be created in the table for this requirement?

A. 3 partitions

B. 8 partitions

C. 6 partitions

D. 5 partitions

View answer

Correct Answer: D

Question #31

32. An Internet-of-Things (IoT) solutions company is looking to migrate its on-premises infrastructure into the AWS Cloud. The database management team is looking for a fully managed NoSQL persistent data store with in-memory caching to maintain low latency that is critical for real-time scenarios such as video streaming and interactive content. The team is well versed with the expected access patterns for the underlying database and expects the number of concurrent users to touch up to a million so the dat

A. DocumentDB

B. RDS

C. DynamoDB

D. ElastiCache

View answer

Correct Answer: C

Question #32

20. The development team at an e-commerce company manages 5 Amazon EC2 instances that make read-heavy database requests to the Amazon RDS for PostgreSQL DB instance. As a Database Specialist, you have been asked to make the database instance resilient from a disaster recovery perspective. Which of the following features will help you prepare for database disaster recovery? (Select two)

A. Use cross-Region Read Replicas

B. Use RDS Provisioned IOPS (SSD) Storage in place of General Purpose (SSD) Storage

C. Enable the automated backup feature of Amazon RDS in a multi-AZ deployment that creates backups across multiple Regions

D. Enable the automated backup feature of Amazon RDS in a multi-AZ deployment that creates backups in a single AWS Region

E. Use database cloning feature of the RDS DB cluster

View answer

Correct Answer: AD

DON'T WANT TO MISS A THING?

100% Pass Cisco, PMP, CISA, CISM, AWS Practice test on SALE!
Get Now

Pass Your DBS-C01 Certification Questions & Practice Tests, AWS Certified Database – Specialty | SPOTO

View The Updated DBS-C01 Exam Questions

View The Updated AWS Exam Questions

View Answers after Submission

DON'T WANT TO MISS A THING?

100% Pass Cisco, PMP, CISA, CISM, AWS Practice test on SALE! Get Now

Pass Your DBS-C01 Certification Questions & Practice Tests, AWS Certified Database – Specialty | SPOTO

View The Updated DBS-C01 Exam Questions

View The Updated AWS Exam Questions

View Answers after Submission

100% Pass Cisco, PMP, CISA, CISM, AWS Practice test on SALE!
Get Now