Amazon Amazon Certifications DBS-C01 Questions & Answers

• Question 131:

  A company is running critical applications on AWS. Most of the application deployments use Amazon Aurora MySQL for the database stack. The company uses AWS CloudFormation to deploy the DB instances.

  The company's application team recently implemented a CI/CD pipeline. A database engineer needs to integrate the database deployment CloudFormation stack with the newly built CllCD platform. Updates to the CloudFormation stack must not update existing production database resources.

  Which CloudFormation stack policy action should the database engineer implement to meet these requirements?

  A. Use a Deny statement for the Update:Modify action on the production database resources.

  B. Use a Deny statement for the action on the production database resources.

  C. Use a Deny statement for the Update:Delete action on the production database resources.

  D. Use a Deny statement for the Update:Replace action on the production database resources.

  Correct Answer: D

  Explanation:

• Question 132:

  A company is using AWS CloudFormation to provision and manage infrastructure resources, including a production database. During a recent CloudFormation stack update, a database specialist observed that changes were made to a database resource that is named ProductionDatabase. The company wants to prevent changes to only ProductionDatabase during future stack updates.

  Which stack policy will meet this requirement?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: A

• Question 133:

  A company is running an Amazon RDS for PostgeSQL DB instance and wants to migrate it to an Amazon Aurora PostgreSQL DB cluster. The current database is 1 TB in size. The migration needs to have minimal downtime. What is the FASTEST way to accomplish this?

  A. Create an Aurora PostgreSQL DB cluster. Set up replication from the source RDS for PostgreSQL DB instance using AWS DMS to the target DB cluster.

  B. Use the pg_dump and pg_restore utilities to extract and restore the RDS for PostgreSQL DB instance to the Aurora PostgreSQL DB cluster.

  C. Create a database snapshot of the RDS for PostgreSQL DB instance and use this snapshot to create the Aurora PostgreSQL DB cluster.

  D. Migrate data from the RDS for PostgreSQL DB instance to an Aurora PostgreSQL DB cluster using an Aurora Replica. Promote the replica during the cutover.

  Correct Answer: D

  https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.Mi grating.html Migrating data from an RDS PostgreSQL DB instance to an Aurora PostgreSQL DB cluster by using an Aurora read replica. https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.Mi grating.html#AuroraPostgreSQL.Migrating.RDSPostgreSQ https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.Mi grating.html#AuroraPostgreSQL.Migrating.RDSPostgreSQL.Replica

• Question 134:

  A bank intends to utilize Amazon RDS to host a MySQL database instance. The database should be able to handle high-volume read requests with extremely few repeated queries.

  Which solution satisfies these criteria?

  A. Create an Amazon ElastiCache cluster. Use a write-through strategy to populate the cache.

  B. Create an Amazon ElastiCache cluster. Use a lazy loading strategy to populate the cache.

  C. Change the DB instance to Multi-AZ with a standby instance in another AWS Region.

  D. Create a read replica of the DB instance. Use the read replica to distribute the read traffic.

  Correct Answer: D

• Question 135:

  A business need a data warehouse system that stores data consistently and in a highly organized fashion. The organization demands rapid response times for end-user inquiries including current-year data, and users must have access to the whole 15-year dataset when necessary. Additionally, this solution must be able to manage a variable volume of incoming inquiries. Costs associated with storing the 100 TB of data must be maintained to a minimum.

  Which solution satisfies these criteria?

  A. Leverage an Amazon Redshift data warehouse solution using a dense storage instance type while keeping all the data on local Amazon Redshift storage. Provision enough instances to support high demand.

  B. Leverage an Amazon Redshift data warehouse solution using a dense storage instance to store the most recent data. Keep historical data on Amazon S3 and access it using the Amazon Redshift Spectrum layer. Provision enough instances to support high demand.

  C. Leverage an Amazon Redshift data warehouse solution using a dense storage instance to store the most recent data. Keep historical data on Amazon S3 and access it using the Amazon Redshift Spectrum layer. Enable Amazon Redshift Concurrency Scaling.

  D. Leverage an Amazon Redshift data warehouse solution using a dense storage instance to store the most recent data. Keep historical data on Amazon S3 and access it using the Amazon Redshift Spectrum layer. Leverage Amazon Redshift elastic resize.

  Correct Answer: C

  Explanation: https://docs.aws.amazon.com/redshift/latest/dg/concurrency-scaling.html "With the Concurrency Scaling feature, you can support virtually unlimited concurrent users and concurrent queries, with consistently fast query performance. When concurrency scaling is enabled, Amazon Redshift automatically adds additional cluster capacity when you need it to process an increase in concurrent read queries. Write operations continue as normal on your main cluster. Users always see the most current data, whether the queries run on the main cluster or on a concurrency scaling cluster. You're charged for concurrency scaling clusters only for the time they're in use. For more information about pricing, see Amazon Redshift pricing. You manage which queries are sent to the concurrency scaling cluster by configuring WLM queues. When you enable concurrency scaling for a queue, eligible queries are sent to the concurrency scaling cluster instead of waiting in line."

• Question 136:

  A database specialist manages a critical Amazon RDS for MySQL DB instance for a company. The data stored daily could vary from .01% to 10% of the current database size. The database specialist needs to ensure that the DB instance storage grows as needed.

  What is the MOST operationally efficient and cost-effective solution?

  A. Configure RDS Storage Auto Scaling.

  B. Configure RDS instance Auto Scaling.

  C. Modify the DB instance allocated storage to meet the forecasted requirements.

  D. Monitor the Amazon CloudWatch FreeStorageSpace metric daily and add storage as required.

  Correct Answer: A

  Explanation: If your workload is unpredictable, you can enable storage autoscaling for an Amazon RDS DB instance. With storage autoscaling enabled, when Amazon RDS detects that you are running out of free database space it automatically scales up your storage. https://aws.amazon.com/about-aws/whats-new/2019/06/rds-storage-auto-scaling/ https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PIOPS.StorageTypes. html#USER_PIOPS.Autoscaling

• Question 137:

  A company maintains several databases using Amazon RDS for MySQL and PostgreSQL. Each RDS database generates log files with retention periods set to their default values. The company has now mandated that database logs be maintained for up to 90 days in a centralized repository to facilitate real-time and after- the-fact analyses.

  What should a Database Specialist do to meet these requirements with minimal effort?

  A. Create an AWS Lambda function to pull logs from the RDS databases and consolidate the log files in an Amazon S3 bucket. Set a lifecycle policy to expire the objects after 90 days.

  B. Modify the RDS databases to publish log to Amazon CloudWatch Logs. Change the log retention policy for each log group to expire the events after 90 days.

  C. Write a stored procedure in each RDS database to download the logs and consolidate the log files in an Amazon S3 bucket. Set a lifecycle policy to expire the objects after 90 days.

  D. Create an AWS Lambda function to download the logs from the RDS databases and publish the logs to Amazon CloudWatch Logs. Change the log retention policy for the log group to expire the events after 90 days.

  Correct Answer: B

  https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_LogAccess.html https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_LogAccess.Procedura l.UploadtoCloudWatch.htm https://aws.amazon.com/premiumsupport/knowledge-center/rds-aurora-mysql-logs- cloudwatch/ https://docs.aws.amazon.com/AmazonCloudWatchLogs/latest/APIReference/API_PutRete ntionPolicy.html

• Question 138:

  An application reads and writes data to an Amazon RDS for MySQL DB instance. A new reporting dashboard needs read-only access to the database. When the application and reports are both under heavy load, the database experiences performance degradation. A database specialist needs to improve the database performance.

  What should the database specialist do to meet these requirements?

  A. Create a read replica of the DB instance. Configure the reports to connect to the replication instance endpoint.

  B. Create a read replica of the DB instance. Configure the application and reports to connect to the cluster endpoint.

  C. Enable Multi-AZ deployment. Configure the reports to connect to the standby replica.

  D. Enable Multi-AZ deployment. Configure the application and reports to connect to the cluster endpoint.

  Correct Answer: A

  https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ReadRepl.html

• Question 139:

  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?

  A. Amazon RDS for MySQL with Multi-AZ

  B. Amazon Aurora Serverless MySQL cluster

  C. Amazon Aurora MySQL cluster

  D. Amazon RDS for MySQL with read replica

  Correct Answer: B

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

• Question 140:

  A pharmaceutical company's drug search API is using an Amazon Neptune DB cluster. A bulk uploader process automatically updates the information in the database a few times each week. A few weeks ago during a bulk upload, a database specialist noticed that the database started to respond frequently with a ThrottlingException error. The problem also occurred with subsequent uploads.

  The database specialist must create a solution to prevent ThrottlingException errors for the database. The solution must minimize the downtime of the cluster.

  Which solution meets these requirements?

  A. Create a read replica that uses a larger instance size than the primary DB instance. Fail over the primary DB instance to the read replica.

  B. Add a read replica to each Availability Zone. Use an instance for the read replica that is the same size as the primary DB instance. Keep the traffic between the API and the database within the Availability Zone.

  C. Create a read replica that uses a larger instance size than the primary DB instance. Offload the reads from the primary DB instance.

  D. Take the latest backup, and restore it in a DB cluster of a larger size. Point the application to the newly created DB cluster.

  Correct Answer: C

  Explanation: https://docs.aws.amazon.com/neptune/latest/userguide/manage-console- add-replicas.html

  Neptune replicas connect to the same storage volume as the primary DB instance and support only read operations. Neptune replicas can offload read workloads from the primary DB instance.