Free DBS-C01 Exam Braindumps (page: 47)

Page 47 of 82

A database specialist is designing an application to answer one-time queries. The application will query complex customer data and provide reports to end users. These reports can include many fields. The database specialist wants to give users the ability to query the database by using any of the provided fields.

The database’s traffic volume will be high but variable during peak times. However, the database will not have much traffic at other times during the day.

Which solution will meet these requirements MOST cost-effectively?

  1. Amazon DynamoDB with provisioned capacity mode and auto scaling
  2. Amazon DynamoDB with on-demand capacity mode
  3. Amazon Aurora with auto scaling enabled
  4. Amazon Aurora in a serverless mode

Answer(s): D


Reference:

https://aws.amazon.com/about-aws/whats-new/2020/03/amazon-dynamodb-on-demand-capacitymode-is-now-available-in-the-asia-pacific-osaka-local-region/#:~:text=On%2Ddemand%20is%20a%20flexible,to%20balance%20cost%20and%20performance20flexible,to%20balance%20cost%20and%20performance



A financial services company runs an on-premises MySQL database for a critical application. The company is dissatisfied with its current database disaster recovery (DR) solution. The application experiences a significant amount of downtime whenever the database fails over to its DR facility. The application also experiences slower response times when reports are processed on the same database. To minimize the downtime in DR situations, the company has decided to migrate the database to AWS. The company requires a solution that is highly available and the most cost-effective.

Which solution meets these requirements?

  1. Create an Amazon RDS for MySQL Multi-AZ DB instance and configure a read replica in a different Availability Zone. Configure the application to reference the replica instance endpoint and report queries to reference the primary DB instance endpoint.
  2. Create an Amazon RDS for MySQL Multi-AZ DB instance and configure a read replica in a different Availability Zone. Configure the application to reference the primary DB instance endpoint and report queries to reference the replica instance endpoint.
  3. Create an Amazon Aurora DB cluster and configure an Aurora Replica in a different Availability Zone. Configure the application to reference the cluster endpoint and report queries to reference the reader endpoint.
  4. Create an Amazon Aurora DB cluster and configure an Aurora Replica in a different Availability Zone. Configure the application to reference the primary DB instance endpoint and report queries to reference the replica instance endpoint.

Answer(s): C


Reference:

https://aws.amazon.com/rds/features/multi-az/



A company with 500,000 employees needs to supply its employee list to an application used by human resources. Every 30 minutes, the data is exported using the LDAP service to load into a new Amazon DynamoDB table. The data model has a base table with Employee ID for the partition key and a global secondary index with Organization ID as the partition key.

While importing the data, a database specialist receives ProvisionedThroughputExceededException errors. After increasing the provisioned write capacity units (WCUs) to 50,000, the specialist receives the same errors. Amazon CloudWatch metrics show a consumption of 1,500 WCUs.

What should the database specialist do to address the issue?

  1. Change the data model to avoid hot partitions in the global secondary index.
  2. Enable auto scaling for the table to automatically increase write capacity during bulk imports.
  3. Modify the table to use on-demand capacity instead of provisioned capacity.
  4. Increase the number of retries on the bulk loading application.

Answer(s): A


Reference:

https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/AutoScaling.html



A company has an application that uses an Amazon DynamoDB table as its data store. During normal business days, the throughput requirements from the application are uniform and consist of 5 standard write calls per second to the DynamoDB table. Each write call has 2 KB of data.

For 1 hour each day, the company runs an additional automated job on the DynamoDB table that makes 20 write requests per second. No other application writes to the DynamoDB table. The DynamoDB table does not have to meet any additional capacity requirements.

How should a database specialist configure the DynamoDB table’s capacity to meet these requirements MOST cost-effectively?

  1. Use DynamoDB provisioned capacity with 5 WCUs and auto scaling.
  2. Use DynamoDB provisioned capacity with 5 WCUs and a write-through cache that DynamoDB Accelerator (DAX) provides.
  3. Use DynamoDB provisioned capacity with 10 WCUs and auto scaling.
  4. Use DynamoDB provisioned capacity with 10 WCUs and no auto scaling.

Answer(s): C


Reference:

https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/AutoScaling.html



Page 47 of 82



Post your Comments and Discuss Amazon DBS-C01 exam with other Community members:

Pedro commented on April 27, 2024
Thanks for the dumps. It was an easy pass.
UNITED STATES
upvote

Keran commented on April 26, 2024
All of these questions are in the real exam. I just wrote my test yesterday. This is a valid exam dumps.
Anonymous
upvote

Mungara commented on March 14, 2023
thanks to this exam dumps, i felt confident and passed my exam with ease.
UNITED STATES
upvote

Mungara commented on March 14, 2023
Thanks to this exam dumps, I felt confident and passed my exam with ease.
UNITED STATES
upvote

otaku commented on August 11, 2022
just passed my dbs-c01 exam this site is really helped a lot.
Anonymous
upvote

Erik commented on March 02, 2022
These braindumps questions make passing very easy.
UNITED KINGDOM
upvote

Sanjev commented on January 12, 2022
This is the easiest way to get a 90%. Perfect exam dumps.
UNITED STATES
upvote

Abigail commented on September 20, 2021
I know using prep course are not ethical but I had to do this as this exam is way too hard to pass on your own. Thid prep course got me out of trouble.
UNITED STATES
upvote