DBS-C01 Exam Prep: Study Materials & Mock Tests, AWS Certified Database – Specialty

Question #1

52. A multi-national retail company uses separate AWS accounts for their business units. The finance team has an encrypted snapshot of an Amazon Relational Database Service (Amazon RDS) instance that uses the default AWS Key Management Service (AWS KMS) key. The finance team wants to share the encrypted snapshot with their Audit team that uses another AWS account. As a Database Specialist, which of the following solutions would you recommend to address the given use-case?

A. Add the target account to the default AWS KMS key

B. Add the target account to the default AWS KMS key

C. Copy the shared DB snapshot from the target account Add the target account to a customer managed key

D. Copy the shared DB snapshot from the target account Add the target account to a customer managed key

View answer

Correct Answer: D

Question #2

51. Ahead of the upcoming holiday sale season, a group of database administrators at an e-commerce company is analyzing performance issues for an RDS for PostgreSQL DB instance and is reviewing related metrics. The group wants to understand the database wait events in more detail. As a Database Specialist, which of the following steps would you suggest for the given use-case?

A. Use the Trusted Advisor dashboard to analyze the wait events

B. Enable Amazon RDS Performance Insights and review the appropriate dashboard to analyze the wait events

C. Configure the database logs to be pushed to Amazon CloudWatch Logs for detailed analysis for the wait events

D. Use Amazon RDS Enhanced Monitoring to analyze the wait events

View answer

Correct Answer: B

Question #3

8. As a Database Specialist, you have been asked to implement a disaster recovery strategy for all the Amazon RDS databases that a company owns. Which of the following points do you need to consider for creating a robust recovery plan (Select three)?

A. Automated backups are limited to a single AWS Region while manual snapshots and Read Replicas are supported across multiple Regions

B. Recovery time objective (RTO)

C. You can share automated Amazon RDS snapshots with up to 20 AWS accounts

D. Database snapshots are user-initiated backups of your complete DB instance that serve as full backups

E. Recovery time objective (RTO) represents the number of hours it takes, to return the Amazon RDS database to a working state after a disaster

F. Similar to an Amazon RDS Multi-AZ configuration, failover to a Read Replica is an automated process that requires no manual intervention after initial configurations

View answer

Correct Answer: ADE

Question #4

60. A global CRM company has recently migrated its technology infrastructure from its on-premises data center to AWS Cloud. The database administration team has provisioned an RDS PostGreSQL DB cluster for the company’s flagship CRM application. An analytics workload also runs on the same database which publishes near real-time reports for the senior management of the company. When the analytics workload runs, it slows down the CRM application as well, resulting in bad user experience. As a Database Special

A. Enable Multi-AZ for the RDS database and run the analytics workload on the standby database

B. For Disaster Recovery purposes, create a Read Replica in another Region as the Master database and point the analytics workload there

C. Create a Read Replica in the same Region as the Master database and point the analytics workload there

D. Migrate the analytics application to AWS Lambda

View answer

Correct Answer: C

Question #5

54. A multi-national retail company uses Amazon Aurora DB cluster as its primary database service. The company has now deployed 5 multi-AZ Read Replicas to increase the read throughput and for use as failover target. The replicas have been assigned the following failover priority tiers and corresponding sizes are given in parentheses: tier-1 (8TB). tier-1 (16TB). tier-10 (16TB). tier-15 (8TB). tier-15 (16TB). In the event of a failover, Amazon Aurora will promote which of the following Read Replicas?

A. Tier-10 (16TB)

B. Tier-1 (8TB)

C. Tier-15 (16TB)

D. Tier-1 (16TB)

View answer

Correct Answer: A

Question #6

6. An advertising technology startup in Silicon Valley captures browsing metadata to contextually display relevant images, pages, and links to targeted users. A single page load can generate multiple events that need to be stored individually. Each page load must query the user’s browsing history to provide targeting recommendations. The startup expects over 1 billion page visits per day. The startup now wants to add a caching layer to support high read volumes. As a Database Specialist, which of the follow

A. Elasticsearch

B. ElastiCache

C. RDS

D. DynamoDB Accelerator (DAX)

E. Redshift

View answer

Correct Answer: BD

Question #7

48. The database management team at a leading gaming company is evaluating multiple in-memory data stores with the ability to power its on-demand, live leaderboard. The company’s leaderboard requires high availability, low latency. and real-time processing to deliver customizable user data for the community of users working out together virtually from the comfort of their home. As a Database Specialist, which of the following solutions would you recommend?(Select two)

A. Develop the leaderboard using DynamoDB with DynamoDB

B. Develop the leaderboard using ElastiCache Redis as it meets the in-memory, high availability, low latency requirements

C. Develop the leaderboard using DynamoDB as it meets the in-memory, high availability, low latency requirements

D. Develop the leaderboard using AWS Neptune as it meets the in-memory, high availability, low latency requirements

E. Develop the leaderboard using RDS Aurora as it meets the in-memory, high availability, low latency requirements

View answer

Correct Answer: AB

Question #8

9. A data analytics company wants to deploy a global IoT solution in multiple AWS Regions. The company wants to store loT data in DynamoDB tables in each Region as per the user’s geographic location. The DevOps team at the company wants an automated solution that can deploy the database along with the rest of the application with an identical configuration in new Regions as per the business requirement. The solution should also propagate configuration updates across all Regions. As a Database Specialist, wh

A. Create DynamoDB tables using the AWS Console in multiple Regions and create a detailed guide for future updates to the deployment

B. Create DynamoDB global tables via AWS CLI

C. Create a CloudFormation template and deploy the template to multiple Regions via a stack set

D. Use a CloudFormation template to deploy the solution to multiple Regions

View answer

Correct Answer: C

Question #9

5. An in-home fitness company has recently transitioned to AWS Cloud from its on-premises data center. The CTO at the company wants to augment the existing application by adding a leaderboard that uses a complex proprietary algorithm based on the participating user’s health metrics to identify the top users on a real-time basis. The technical requirements mandate high elasticity. low latency. and real-time processing to deliver customizable rider data for the community of users riding together virtually fro

A. Use ElastiCache to run highly complex JOIN queries

B. Use ElastiCache to improve performance of compute-intensive workloads

C. Use ElastiCache to improve latency and throughput for read-heavy application workloads

D. Use ElastiCache to improve latency and throughput for write-heavy application workloads

E. Use ElastiCache to improve performance of Extract-Transform-Load (ETL)workloads

View answer

Correct Answer: BC

Question #10

42. An ad-tech company runs a leading ad targeting platform that captures various kinds of marketing data such as user profiles, user events, clicks, and visited links. The company is looking to migrate its IT infrastructure from the on-premises data center to AWS Cloud. The technical requirements for the advertising platform mandate a high request rate (millions of requests per second). low predictable latency and high reliability. The company also needs to deploy this ad targeting platform in more than on

A. DynamoDB Global Tables

B. DocumentDB

C. Aurora Serverless

D. Aurora Global Database

View answer

Correct Answer: A

Question #11

63. A retail company is migrating its infrastructure from the on-premises data-center to AWS Cloud. The company wants to deploy its two-tier application with the EC2 instance based web servers in a public subnet and PostGreSQL RDS based database layer in a private subnet. The company wants to ensure that the database access credentials used by the web servers are handled securely as well as these credentials are changed every 90 days in an automated way using an off-the-shelf solution. As a Database Special

A. Store the database access credentials in an SSE-S3 encrypted text file on S3

B. Store the database access credentials as the EC2 instance user data

C. Store the database access credentials in a KMS encrypted text file on EFS

D. Use AWS Secrets Manager to store the database access credentials with the rotation interval configured to 90 days

View answer

Correct Answer: D

Question #12

56. A social media company is setting up an Aurora DB cluster with one primary instance and four Aurora Replicas for its flagship application. The Aurora DB cluster has one medium-sized primary instance, one large-sized Replica, one small-sized Replica and two medium-sized Replicas. The database administrator has not assigned a promotion tier to the Replicas. In case the primary instance fails, which of the following events will occur?

A. One of the medium-sized Aurora Replicas will be chosen randomly for promotion

B. The small-sized Aurora Replica will be promoted

C. The large-sized Aurora Replica will be promoted

D. None of the Replicas will be promoted and Aurora will spin up a new primary instance

View answer

Correct Answer: C

Question #13

44. A media company has recently migrated their technology infrastructure to AWS Cloud. The database team is centralizing database access credentials to align with IAM based authentication. Which of the following AWS database engines can be configured with IAM Database Authentication?

A. RDS SQL Server

B. RDS MySQL

C. RDS Oracle

D. RDS Maria DB

E. RDS PostGreSQL

View answer

Correct Answer: BE

Question #14

7. A multi-national retail company wants to migrate its on-premises Oracle database to Aurora MySQL. The company has hired an AWS Certified Database Specialist to carry out the migration with minimal downtime using AWS DMS. The company has mandated that the migration must have minimal impact on the performance of the source database and the Database Specialist must validate that the data was migrated accurately from the source to the target before the cutover. Which of the following solutions will MOST effe

A. Configure DMS premigration assessment on the migration task so the assessment can compare the source and target data and report any mismatches

B. Use AWS Schema Conversion Tool for the migration task so it can compare the source and target data and report any mismatches

C. Configure DMS data validation on the migration task so it can compare the source and target data for the DMS task and report any mismatches

D. Use the table metrics of the DMS task to verify the statistics for tables being migrated including the DDL statements completed

View answer

Correct Answer: C

Question #15

49. The database administration team at a leading social media company uses Amazon MySQL RDS DB cluster because it simplifies much of the time-consuming administrative tasks typically associated with databases. The team uses Multi-Availability Zone (Multi-AZ) deployment to further automate its database replication and augment data durability. The current cluster configuration also uses Read Replicas. An intern has joined the team and wants to understand the replication capabilities for Multi-AZ as well as R

A. Multi-AZ follows asynchronous replication and spans at least two Availability Zones within a single region

B. Multi-AZ follows asynchronous replication and spans one Availability Zone within a single region

C. Multi-AZ follows synchronous replication and spans at least two Availability Zones within a single region

D. Multi-AZ follows asynchronous replication and spans at least two Availability Zones within a single region

View answer

Correct Answer: C

Question #16

45. The database team at an e-commerce company wants to connect to the RDS PostGreSQL Multi-AZ DB instance using Secure Socket Layer or Transport Layer Security (SSL/TLS). The Team Lead has set the value of the static parameter rds.force_ssl as 1 in the custom parameter group currently associated with the production RDS PostGreSQL Multi-AZ DB instance. This change has been approved for a specific maintenance window to help minimize the impact on users. As a Database Specialist, which of the following steps

A. Propagate the parameter group update manually by rebooting the DB instance during the approved maintenance window

B. Use the “Apply Immediately” setting to enforce the parameter update

C. Let the approved maintenance window automatically apply the change for the static parameter

D. Go to the AWS RDS console and reboot the instance immediately

View answer

Correct Answer: A

Question #17

65. A health-care company has just migrated its IT infrastructure from the on-premises data-center to AWS Cloud. The company is using Aurora PostGreSQL DB cluster as its data store and the CTO at the company now wants to build the caching layer of the current architecture for its PostGreSQL DB cluster. He wants the caching layer to have replication and archival support built into the architecture. Most importantly, the solution needs to be end-to-end HIPAA compliant. Which of the following AWS service offer

A. DocumentDB

B. DynamoDB Accelerator (DAX)

C. ElastiCache for Redis

D. ElastiCache for Memcached

View answer

Correct Answer: C

Question #18

40. The data analytics team at a multi-national retail company has been running ad-hoc queries on Oracle and PostgreSQL services on Amazon RDS to prepare daily reports for senior management. To facilitate the data analytics reporting. the database administration team now wants to replicate this data with high availability and consolidate these databases into a petabyte-scale data warehouse by streaming data to Amazon Redshift. As a Database Specialist, which of the following would you recommend as the MOST

A. Use AWS EMR to replicate the data from the databases into Amazon Redshift

B. Use AWS Database Migration Service to replicate the data from the databases into Amazon Redshift

C. Use Amazon Kinesis Data Streams to replicate the data from the databases into Amazon Redshift

D. Use AWS Glue to replicate the data from the databases into Amazon Redshift

View answer

Correct Answer: B

Question #19

2. 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 #20

61. A media company is planning to move their on-premises database to Amazon RDS. As part of disaster recovery planning. the team is looking into the various database backup options available with RDS. As a Database Specialist, you have been roped in to understand and weigh-in on the RDS automated backups and snapshot features. Which of the following statements would you identify as correct for the given context? (Select three)

A. Disabling automatic backups for a DB instance deletes all existing automated backups for the instance

B. DB Snapshots can be created with the AWS Management Console, CreateDBSnapshot API, or create-db-snapshot command

C. The total number of automated backups and manual snapshots put together, should not exceed 100 per Region

D. The default backup retention period is one day if you create the DB instance using the Amazon RDS API

E. DB Snapshots can be created with the AWS Management Console and create-db-snapshot command only

F. When a DB instance is deleted manually created DB snapshots as well as automated backups are deleted

View answer

Correct Answer: ABD

Question #21

38. An analytics company is using an Aurora DB cluster with Read Replicas for specialized read-only workloads. The database administration team at the company needs to spin up three read-only reporting applications for the Sales, HR and Finance departments at the company. Each application needs to connect to its own set of dedicated Read Replicas. The company has hired you as an AWS Certified Database Specialist to implement a load balanced and highly available solution for this reporting application. Which

A. Create three reader endpoints and use one reader endpoint for each of the read-only reporting applications

B. Use one custom endpoint for all three read-only reporting applications

C. Use one reader endpoint for all three read-only reporting applications

D. Create three custom endpoints and use one custom endpoint for each of the read-only reporting applications

View answer

Correct Answer: D

Question #22

53. A retail company recently migrated its IT infrastructure from the on-premises data center to AWS Cloud. After a security review by an external auditor, the CTO at the company has mandated that the RDS for PostGreSQL DB cluster should be encrypted at rest using AWS KMS. Due to the high volume of data, it is not possible to develop a custom Extract Transform Load (ETL) solution to reload the data into another encrypted database because of the time constraints involved in developing Testing and deploying t

A. Create a snapshot of the unencrypted RDS DB instance

B. Create an encrypted Read Replica of the RDS DB instance and then promote the Read Replica to its own standalone DB instance

C. Use AWS CLI to activate the AWS KMS encryption setting on the existing RDS DB instance

D. Create a snapshot of the unencrypted RDS DB instance Create an encrypted snapshot via an encrypted copy of the unencrypted snapshot Restore this new encrypted snapshot into the existing DB instance

View answer

Correct Answer: A

Question #23

57. An e-commerce application is facing user experience issues with users reporting frequent sign-in requests from the application. The application is currently hosted on multiple EC2 instances. The development team has identified the root cause as unhealthy servers causing session data to be lost. The Lead Developer has asked the database management team to implement a distributed in-memory cache-based session management solution. As a Database Specialist, which of the following solutions would you recomme

A. Use Elasticache for distributed in-memory cache based session management

B. Use RDS for distributed in-memory cache based session management

C. Use DynamoDB for distributed in-memory cache based session management

D. Continue with application-based sticky sessions

View answer

Correct Answer: A

Question #24

43. The DevOps team at an IT company created an AWS CloudFormation stack with an RDS DB instance. An intern has accidentally deleted the stack and most of the recent data has been lost. You have been hired as an AWS Certified Database Specialist to configure RDS settings to the CloudFormation template to mitigate such accidental instance data loss in the future. Which of the following settings will address this use-case? (Select three)

A. Configure Multi-AZ to True

B. Configure DeletionPolicy to Retain

C. Configure Read Replica to True

D. Enable Termination Protection section of the CloudFormation stack via the AWS Management Console

E. Enable Deletion Protection section of the CloudFormation stack via the AWS Management Console

F. Configure DeleteAutomatedBackups to False

View answer

Correct Answer: BDF

Question #25

50. The database team at an e-commerce company has been grappling with an issue on its Amazon Aurora MySQL DB cluster where the Read Replicas are lagging behind the master node with a huge deficit. On further investigation, the team has come across the error message “Read Replica has fallen behind the master too much. Restarting MySQL”. As a Database Specialist, what steps and configuration checks will you undertake to resolve the issue? (Select two)

A. A sudden surge of write activity in an already write-heavy production cluster can cause an overload on the writer DB instance

B. Check all instances in the cluster have the same specification A reader node should not have a weaker DB instance class configuration than that of a writer DB instance

C. The Amazon Aurora DB instance is undergoing instance recovery or failover, forcing the Read Replica to act as Primary node and this resulted in a restart of the Read Replica

D. The storage volume that Read Replica is connected to could have crashed

E. An instance in Aurora clusters might have run out of cluster volume and forced a restart on Read Replica

View answer

Correct Answer: AB

Question #26

64. A multi-national retail company is planning to move their on-premises database to Amazon RDS. As an AWS Certified Database Specialist, you have been roped in to understand and weigh-in on the replication features of RDS. Which of the following statements would you identify as correct for the given context? (Select two)

A. If you delete an Amazon RDS for MySQL DB Instance that has Read Replicas, all Read Replicas will be promoted to standalone DB Instances

B. Amazon RDS for MySQL allows you to create a second-tier read replica from an existing first-tier Read Replica

C. Amazon RDS for PostgreSQL allows you to create a second-tier Read Replica from an existing first-tier Read Replica

D. You can configure RDS source DB instance as a Multi-AZ deployment to avoid I/O suspension that occurs when a Read Replica is initiated

E. When running an RDS DB instance as a Multi-AZ deployment the standby DB can be used for read or write operations

View answer

Correct Answer: BD

Question #27

39. A Database Specialist is working on modeling data for a DynamoDB production database. To address certain access patterns for the application, he is in the process of creating secondary indexes. Which of the following options should the database specialist consider for these requirements? (Select three)

A. A Global Secondary Index contains a selection of attributes from the base table which are organized by a primary key that is different from that of the table

B. A Local Secondary Index maintains an alternate primary key for a given partition key value

C. For greater query or scan flexibility

D. If the writes are throttled on the Global Secondary Indexes, then the main table will be throttled, even though the Write Capacity Units on the main tables are fine

E. Applications that need to perform many kinds of queries, using a variety of different attributes for their query criteria should use Global Secondary Indexes

F. Global secondary indexes support both data models eventually consistent or strongly consistent reads

View answer

Correct Answer: ADE

Question #28

37. The database management team at a Big Data consultancy is working on the Disaster Recovery (DR) plans for a Redshift cluster deployed in the us-east-1 Region. The existing cluster is encrypted via AWS KMS and the team wants to copy the Redshift snapshots to another Region to meet the DR requirements. As a Database Specialist, which of the following solutions would you suggest to address the given use-case?

A. Create a snapshot copy grant in the source Region for a KMS key in the source Region

B. Create a snapshot copy grant in the destination Region for a KMS key in the destination Region

C. Create an IAM role in destination Region with access to the KMS key in the source Region Create a snapshot copy grant in the destination Region for this KMS key in the source Region Configure Redshift cross-Region snapshots in the source Region

D. Create a snapshot copy grant in the destination Region for a KMS key in the destination Region Configure Redshift cross-Region replication in the source Region

View answer

Correct Answer: B

Question #29

4. A CRM company uses a two-tier architecture with application servers in the public subnet and an RDS based database in a private subnet. The database management team is able to use a bastion host in the public subnet to log in to MySQL and run queries from the bastion host. However, end-users are reporting application errors. Upon inspecting application logs, the database team notices several “could not connect to server: connection timed out” error messages. As a Database Specialist, which of the followi

A. The security group configuration for the application servers does not have the correct rules to allow inbound connections from the DB instance

B. The database user credentials (username and password) configured for the application are incorrect

C. The database user credentials (username and password) configured for the application do not have the required privilege for the given database

D. The security group configuration for the DB instance does not have the correct rules to allow inbound connections from the application servers

View answer

Correct Answer: D

Question #30

3. 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: B

Question #31

41. As part of a new release, the DevOps team at an IT company executed a database migration script that ended up breaking the application because the script had a bug that deleted several records from one of the main tables. An AWS Certified Database Specialist was brought in to assess the event that happened about 8 hours ago. The Specialist noted that the Aurora DB cluster had the “Backtrack” feature enabled with a 24 hour backtrack window. In addition, the DevOps team had also taken a manual DB cluster

A. Backtrack the DB cluster to a point in time just before the release

B. Restore the DB cluster using the pre-release manual snapshot to a new DB cluster and update the application configuration to use the new DB cluster

C. Use the cloned DB cluster with the Backtrack feature enabled and then rewind the cloned cluster to a point in time just before the release

D. Restore the DB cluster using the point in time recovery method to a new DB cluster

View answer

Correct Answer: C

Question #32

62. A Database Specialist is working on the throughput capacity of a newly provisioned table in Amazon DynamoDB. The database specialist has provisioned 20 Read Capacity Units for the table. Which of the following options represents the correct throughput that the table will support for the various read modes?

A. Read throughput of 80KB/sec with strong consistency

B. Read throughput of 80KB/sec with strong consistency

C. Read throughput of 40KB/sec with strong consistency

D. Read throughput of 40KB/sec with strong consistency

View answer

Correct Answer: A

Question #33

59. An IT company is using AWS DMS to migrate its Amazon RDS for Oracle DB instance configured in a VPC in the us-east-1 Region to another VPC in the us-west-1 Region. As a Database Specialist, where would you place the DMS replication instance for the MOST optimal performance?

A. Create the replication instance in the same Region and VPC as the target DB instance

B. Create the replication instance in the same Availability Zone and VPC as the source DB instance

C. Create the replication instance in the same Availability Zone and VPC as the target DB instance

D. Create the replication instance in the same Region and VPC as the source DB instance

View answer

Correct Answer: C

Question #34

47. A multi-national company has just floated their latest security policy. As per this policy. data needs to be stored in encrypted form only. The company uses different Amazon RDS solutions for their various products. As a Database Specialist, you are roped in to facilitate the learning of RDS encryption features and configurations. Which of the following statements would you identify as correct for the given context? (Select three)

A. You can enable encryption for an Amazon RDS DB instance when you create it or when you pull it down for maintenance Encryption settings cannot be changed when the database is up and running

B. An unencrypted RDS DB instance will only result in unencrypted Read Replicas

C. You can restore an unencrypted Aurora DB cluster snapshot to an encrypted Aurora DB cluster

D. You can restore an unencrypted backup or snapshot of an Amazon RDS DB instance to an encrypted DB instance by specifying the KMS key identifier

E. Since Read Replica of an Amazon RDS encrypted instance is also encrypted using the same key as the primary DB instance creating Read Replicas in a different Region is not possible

F. To copy an encrypted snapshot from one AWS Region to another, you must specify the KMS key identifier of the destination AWS Region

View answer

Correct Answer: BCF

Question #35

1. A company has deployed an e-commerce web application in a new AWS account. An Amazon RDS for MySQL Multi-AZ DB instance is part of this deployment with a database-1.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com endpoint listening on port 3306. The company’s Database Specialist is able to log in to MySQL and run queries from the bastion host using these details. When users try to utilize the application hosted in the AWS account, they are presented with a generic error message. The application servers are logg

A. The username and password the application is using are incorrect

B. The security group assigned to the application servers does not have the necessary rules to allow inbound connections from the DB instance

C. The security group assigned to the DB instance does not have the necessary rules to allow inbound connections from the application servers

D. The user name and password are correct, but the user is not authorized to use the DB instance

View answer

Correct Answer: C

Question #36

35. A Silicon Valley based unicorn startup is moving its IT operations from an on-premises data center to AWS Cloud. The database team at the startup is evaluating the Multi-AZ and Read Replica capabilities of RDS MySQL vs Aurora MySQL before they implement the solution in their production environment. The startup has hired you as an AWS Certified Database Specialist to provide a detailed report on this technical requirement. Which of the following would you identify as correct regarding the given use-case?

A. Database engine version upgrades happen on primary for Aurora MySQL whereas all instances are updated together for RDS MySQL

B. The primary and standby DB instances are upgraded at the same time for RDS MySQL Multi-AZ

C. Multi-AZ deployments for RDS MySQL follow synchronous replication whereas Multi-AZ deployments for Aurora MySQL follow asynchronous replication

D. Multi-AZ deployments for Aurora MySQL follow synchronous replication whereas Multi-AZ deployments for RDS MySQL follow asynchronous replication

E. Read Replicas can be manually promoted to a standalone database instance for RDS MySQL whereas Read Replicas for Aurora MySQL can be promoted to the primary instance

F. Read Replicas can be manually promoted to a standalone database instance for Aurora MySQL whereas Read Replicas for RDS MySQL can be promoted to the primary instance

View answer

Correct Answer: BCE

Question #37

55. The database administration team at an e-commerce company is doing a root-cause analysis for a recent spike in CPU utilization for an RDS MySQL DB instance that caused the application to perform poorly. The standard metrics available in Amazon CloudWatch are not enough to guide the investigation. The company has hired you as an AWS Certified Database Specialist to determine what caused the CPU spike. Which of the following steps would you recommend to provide more details about the underlying processes

A. Use Amazon Athena to analyze the SQL statements being run on the RDS instance

B. Enable RDS Performance Insights and review the appropriate dashboard to visualize the database load and filter the load by waits, SQL statements, hosts or users

C. Implement ElastiCache in front of the RDS DB instance to reduce the CPU load on the RDS instance

D. Activate Amazon CloudWatch Events and review the event data that has the SQL statements behind the CPU spikes

E. Activate Enhanced Monitoring to view CPU utilization information for the RDS MySQL DB instance

View answer

Correct Answer: BE

Question #38

36. A financial services company uses AWS Cloud to manage its technology infrastructure. The company has deployed its consumer-focused web-application on EC2 based web servers and uses RDS PostGreSQL DB as the data store. The PostGreSQL DB is set up in a private subnet that allows inbound traffic from selected EC2 instances. The DB also uses AWS KMS for encrypting data at rest. As a Database Specialist, which of the following steps would you suggest to facilitate secure access to the database?

A. Create a new Network Access Control List (NACL) that blocks SSH from the entire EC2 subnet into the DB

B. Create a new security group that blocks SSH from the selected EC2 instances into the DB

C. Use IAM authentication to access the DB instead of the database user’s access credentials

D. Configure RDS to use SSL for data in transit

View answer

Correct Answer: D

Question #39

58. A health-care startup wants to leverage ElastiCache for Redis in cluster mode to enhance the performance and scalability of its existing two-tier application architecture. The ElastiCache cluster is configured to listen on port 6379. The company has hired you as an AWS Certified Database Specialist to make sure that the cache data is secure and protected from unauthorized access so that the solution is HIPAA compliant. Which of the following steps would address the given use-case? (Select three)

A. Create the cluster with auth-token parameter and make sure that the parameter is included in all subsequent commands to the cluster

B. Enable CloudTrail to monitor the API Calls for the ElastiCache cluster

C. Configure the security group for the ElastiCache cluster with the required rules to allow outbound traffic to the cluster’s clients on port 6379

D. Configure the security group for the ElastiCache cluster with the required rules to allow inbound traffic from the cluster itself as well as from the cluster’s clients on port 6379

E. Configure the ElastiCache cluster to have both in-transit as well as at-rest encryption

F. Enable CloudWatch Logs to monitor the security credentials for the ElastiCache cluster

View answer

Correct Answer: ADE

Question #40

46. A social networking application supports the transfer of gift vouchers between users. When a user reaches a certain number of followers on the application, that user earns a gift voucher that can be redeemed or transferred to another user. The database administration team wants to ensure that this transfer is captured in the database such that the records for both users are either written successfully with the new gift vouchers or the status quo is maintained. As a Database Specialist, which of the foll

A. Complete both operations on RDS MySQL in a single transaction block

B. Complete both operations on Amazon RedShift in a single transaction block

C. Use the DynamoDB transactional read and write APIs on the table items as a single, all-or-nothing operation

D. Use the Amazon Athena transactional read and write APIs on the table items as a single, all-or-nothing operation

E. Perform DynamoDB read and write operations with ConsistentRead parameter set to true

View answer

Correct Answer: AC

DON'T WANT TO MISS A THING?

Latest Cisco, PMP, AWS, CompTIA, Microsoft Materials on SALE
Get Now

DBS-C01 Exam Prep: Study Materials & Mock 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?

Latest Cisco, PMP, AWS, CompTIA, Microsoft Materials on SALE Get Now

DBS-C01 Exam Prep: Study Materials & Mock Tests, AWS Certified Database – Specialty | SPOTO

View The Updated DBS-C01 Exam Questions

View The Updated AWS Exam Questions

View Answers after Submission

Latest Cisco, PMP, AWS, CompTIA, Microsoft Materials on SALE
Get Now