Amazon DBS-C01 Exam Questions Instant Access

Question 1

A company has two separate AWS accounts: one for the business unit and another for corporate analytics. The company wants to replicate the business unit data stored in Amazon RDS for MySQL in us-east-1 to its corporate analytics Amazon Redshift environment in us-west-1. The company wants to use AWS DMS with Amazon RDS as the source endpoint and Amazon Redshift as the target endpoint.

Which action will allow AVS DMS to perform the replication?

AConfigure the AWS DMS replication instance in the same account and Region as Amazon Redshift.

BConfigure the AWS DMS replication instance in the same account as Amazon Redshift and in the same Region as Amazon RDS.

CConfigure the AWS DMS replication instance in its own account and in the same Region as Amazon Redshift.

DConfigure the AWS DMS replication instance in the same account and Region as Amazon RDS.

Answer : A

https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Target.Redshift.html

Question 2

A company stores critical data for a department in Amazon RDS for MySQL DB instances. The department was closed for 3 weeks and notified a database specialist that access to the RDS DB instances should not be granted to anyone during this time. To meet this requirement, the database specialist stopped all the

DB instances used by the department but did not select the option to create a snapshot. Before the 3 weeks expired, the database specialist discovered that users could connect to the database successfully.

What could be the reason for this?

AWhen stopping the DB instance, the option to create a snapshot should have been selected.

BWhen stopping the DB instance, the duration for stopping the DB instance should have been selected.

CStopped DB instances will automatically restart if the number of attempted connections exceeds the threshold set.

DStopped DB instances will automatically restart if the instance is not manually started after 7 days.

Answer : D

https://aws.amazon.com/premiumsupport/knowledge-center/rds-stop-seven-days/

Question 3

A company uses Amazon Aurora for secure financial transactions. The data must always be encrypted at rest and in transit to meet compliance requirements.

Which combination of actions should a database specialist take to meet these requirements? (Choose two.)

ACreate an Aurora Replica with encryption enabled using AWS Key Management Service (AWS KMS). Then promote the replica to master.

BUse SSL/TLS to secure the in-transit connection between the financial application and the Aurora DB cluster.

CModify the existing Aurora DB cluster and enable encryption using an AWS Key Management Service (AWS KMS) encryption key. Apply the changes immediately.

DTake a snapshot of the Aurora DB cluster and encrypt the snapshot using an AWS Key Management Service (AWS KMS) encryption key. Restore the snapshot to a new DB cluster and update the financial application database endpoints.

EUse AWS Key Management Service (AWS KMS) to secure the in-transit connection between the financial application and the Aurora DB cluster.

Answer : A, B

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-replicas-adding.html

Question 4

A database specialist at a large multi-national financial company is in charge of designing the disaster recovery strategy for a highly available application that is in development. The application uses an Amazon DynamoDB table as its data store. The application requires a recovery time objective (RTO) of 1 minute and a recovery point objective (RPO) of 2 minutes.

Which operationally efficient disaster recovery strategy should the database specialist recommend for the DynamoDB table?

ACreate a DynamoDB stream that is processed by an AWS Lambda function that copies the data to a DynamoDB table in another Region.

BUse a DynamoDB global table replica in another Region. Enable point-in-time recovery for both tables.

CUse a DynamoDB Accelerator table in another Region. Enable point-in-time recovery for the table.

DCreate an AWS Backup plan and assign the DynamoDB table as a resource.

Answer : C

Question 5

An IT consulting company wants to reduce costs when operating its development environment databases. The company's workflow creates multiple Amazon Aurora MySQL DB clusters for each development group. The Aurora DB clusters are only used for 8 hours a day. The DB clusters can then be deleted at the end of the development cycle, which lasts 2 weeks.

Which of the following provides the MOST cost-effective solution?

AUse AWS CloudFormation templates. Deploy a stack with the DB cluster for each development group. Delete the stack at the end of the development cycle.

BUse the Aurora DB cloning feature. Deploy a single development and test Aurora DB instance, and create clone instances for the development groups. Delete the clones at the end of the development cycle.

CUse Aurora Replicas. From the master automatic pause compute capacity option, create replicas for each development group, and promote each replica to master. Delete the replicas at the end of the development cycle.

DUse Aurora Serverless. Restore current Aurora snapshot and deploy to a serverless cluster for each development group. Enable the option to pause the compute capacity on the cluster and set an appropriate timeout.

Answer : B

Aurora Serverless is not compatible to all Aurora provisioned engine version. However, you can do clone with most engine version. Meanwhile, I also consider the performance while restoring snapshot to Aurora Serverless.

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-serverless.how-it-works.html#aurora-serverless.how-it-works.pause-resume

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-serverless.html#aurora-serverless.use-cases

Question 6

A company migrated one of its business-critical database workloads to an Amazon Aurora Multi-AZ DB cluster. The company requires a very low RTO and needs to improve the application recovery time after database failovers.

Which approach meets these requirements?

ASet the max_connections parameter to 16,000 in the instance-level parameter group.

BModify the client connection timeout to 300 seconds.

CCreate an Amazon RDS Proxy database proxy and update client connections to point to the proxy endpoint.

DEnable the query cache at the instance level.

Answer : C

Amazon RDS Proxy allows applications to pool and share connections established with the database, improving database efficiency and application scalability. With RDS Proxy, failover times for Aurora and RDS databases are reduced by up to 66% and database credentials, authentication, and access can be managed through integration with AWS Secrets Manager and AWS Identity and Access Management (IAM).

https://aws.amazon.com/rds/proxy/

Question 7

A Database Specialist is performing a proof of concept with Amazon Aurora using a small instance to confirm a simple database behavior. When loading a large dataset and creating the index, the Database Specialist encounters the following error message from Aurora:

ERROR: cloud not write block 7507718 of temporary file: No space left on device

What is the cause of this error and what should the Database Specialist do to resolve this issue?

AThe scaling of Aurora storage cannot catch up with the data loading. The Database Specialist needs to modify the workload to load the data slowly.

BThe scaling of Aurora storage cannot catch up with the data loading. The Database Specialist needs to enable Aurora storage scaling.

CThe local storage used to store temporary tables is full. The Database Specialist needs to scale up the instance.

DThe local storage used to store temporary tables is full. The Database Specialist needs to enable local storage scaling.

Answer : C

Amazon AWS Certified Database - Specialty DBS-C01 Exam Questions