Amazon DBS-C01 Exam Questions Instant Access

Question 1

A database specialist is responsible for an Amazon RDS for MySQL DB instance with one read replic

a. The DB instance and the read replica are assigned to the default parameter group. The database team currently runs test queries against a read replica. The database team wants to create additional tables in the read replica that will only be accessible from the read replica to benefit the tests.

Which should the database specialist do to allow the database team to create the test tables?

AContact AWS Support to disable read-only mode on the read replica. Reboot the read replica. Connect to the read replica and create the tables.

BChange the read_only parameter to false (read_only=0) in the default parameter group of the read replica. Perform a reboot without failover. Connect to the read replica and create the tables using the local_only MySQL option.

CChange the read_only parameter to false (read_only=0) in the default parameter group. Reboot the read replica. Connect to the read replica and create the tables.

DCreate a new DB parameter group. Change the read_only parameter to false (read_only=0). Associate the read replica with the new group. Reboot the read replica. Connect to the read replica and create the tables.

Answer : D

https://aws.amazon.com/premiumsupport/knowledge-center/rds-read-replica/

Question 2

A ride-hailing application stores bookings in a persistent Amazon RDS for MySQL DB instance. This program is very popular, and the corporation anticipates a tenfold rise in the application's user base over the next several months. The application receives a higher volume of traffic in the morning and evening.

This application is divided into two sections:

An internal booking component that takes online reservations in response to concurrent user queries.

A component of a third-party customer relationship management (CRM) system that customer service professionals utilize. Booking data is accessed using queries in the CRM.

To manage this workload effectively, a database professional must create a cost-effective database system.

Which solution satisfies these criteria?

AUse Amazon ElastiCache for Redis to accept the bookings. Associate an AWS Lambda function to capture changes and push the booking data to the RDS for MySQL DB instance used by the CRM.

BUse Amazon DynamoDB to accept the bookings. Enable DynamoDB Streams and associate an AWS Lambda function to capture changes and push the booking data to an Amazon SQS queue. This triggers another Lambda function that pulls data from Amazon SQS and writes it to the RDS for MySQL DB instance used by the CRM.

CUse Amazon ElastiCache for Redis to accept the bookings. Associate an AWS Lambda function to capture changes and push the booking data to an Amazon Redshift database used by the CRM.

DUse Amazon DynamoDB to accept the bookings. Enable DynamoDB Streams and associate an AWS Lambda function to capture changes and push the booking data to Amazon Athena, which is used by the CRM.

Answer : B

'AWS Lambda function to capture changes' capture changes to what? ElastiCache? The main use of ElastiCache is to cache frequently read data. Also 'the company expects a tenfold increase in the user base' and 'correspond to simultaneous requests from users'

Question 3

A Database Specialist is migrating a 2 TB Amazon RDS for Oracle DB instance to an RDS for PostgreSQL DB instance using AWS DMS. The source RDS Oracle DB instance is in a VPC in the us-east-1 Region. The target RDS for PostgreSQL DB instance is in a VPC in the use-west-2 Region.

Where should the AWS DMS replication instance be placed for the MOST optimal performance?

AIn the same Region and VPC of the source DB instance

BIn the same Region and VPC as the target DB instance

CIn the same VPC and Availability Zone as the target DB instance

DIn the same VPC and Availability Zone as the source DB instance

Answer : C

https://docs.aws.amazon.com/dms/latest/userguide/CHAP_ReplicationInstance.VPC.html#CHAP_ReplicationInstance.VPC.Configurations.ScenarioVPCPeer In fact, all the configurations list on above url prefer the replication instance putting into target vpc region / subnet / az.

https://docs.aws.amazon.com/dms/latest/sbs/CHAP_SQLServer2Aurora.Steps.CreateReplicationInstance.html

Question 4

A user has a non-relational key-value database. The user is looking for a fully managed AWS service that will offload the administrative burdens of operating and scaling distributed databases. The solution must be cost- effective and able to handle unpredictable application traffic.

What should a Database Specialist recommend for this user?

ACreate an Amazon DynamoDB table with provisioned capacity mode

BCreate an Amazon DocumentDB cluster

CCreate an Amazon DynamoDB table with on-demand capacity mode

DCreate an Amazon Aurora Serverless DB cluster

Answer : C

Key-value database -> DynamoDB Capable of dealing with unexpected application traffic -> on-demand capacity mode

A key-value database is a type of nonrelational database that uses a simple key-value method to store data. A key-value database stores data as a collection of key-value pairs in which a key serves as a unique identifier. On-demand mode is a good option to create new tables with unknown workloads. https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/HowItWorks.ReadWriteCapacityMode.html#HowItWorks.OnDemand

Question 5

A business is operating an on-premises application that is divided into three tiers: web, application, and MySQL database. The database is predominantly accessed during business hours, with occasional bursts of activity throughout the day. As part of the company's shift to AWS, a database expert wants to increase the availability and minimize the cost of the MySQL database tier.

Which MySQL database choice satisfies these criteria?

AAmazon RDS for MySQL with Multi-AZ

BAmazon Aurora Serverless MySQL cluster

CAmazon Aurora MySQL cluster

DAmazon RDS for MySQL with read replica

Answer : B

Amazon Aurora Serverless v1 is a simple, cost-effective option for infrequent, intermittent, or unpredictable workloads. https://aws.amazon.com/rds/aurora/serverless/

Question 6

Recently, a financial institution created a portfolio management service. The application's backend is powered by Amazon Aurora, which supports MySQL.

The firm demands a response time of five minutes and a response time of five minutes. A database professional must create a disaster recovery system that is both efficient and has a low replication latency.

How should the database professional tackle these requirements?

AConfigure AWS Database Migration Service (AWS DMS) and create a replica in a different AWS Region.

BConfigure an Amazon Aurora global database and add a different AWS Region.

CConfigure a binlog and create a replica in a different AWS Region.

DConfigure a cross-Region read replica.

Answer : B

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-global-database-disaster-recovery.html

https://aws.amazon.com/blogs/database/how-to-choose-the-best-disaster-recovery-option-for-your-amazon-aurora-mysql-cluster/

https://aws.amazon.com/about-aws/whats-new/2019/11/aurora-supports-in-place-conversion-to-global-database/

Question 7

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

AEnable in-transit and at-rest encryption on the ElastiCache cluster.

BEnsure that Amazon CloudWatch metrics are configured in the ElastiCache cluster.

CEnsure the security group for the ElastiCache cluster allows all inbound traffic from itself and inbound traffic on TCP port 6379 from trusted clients only.

DCreate an IAM policy to allow the application service roles to access all ElastiCache API actions.

EEnsure the security group for the ElastiCache clients authorize inbound TCP port 6379 and port 22 traffic from the trusted ElastiCache cluster's security group.

FEnsure the cluster is created with the auth-token parameter and that the parameter is used in all subsequent commands.

Answer : A, C, F

https://docs.aws.amazon.com/AmazonElastiCache/latest/red-ug/encryption.html

Amazon AWS Certified Database - Specialty DBS-C01 Exam Questions