ExamTopics Logo
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

Exam AWS Certified Database - Specialty All Questions

View all questions & answers for the AWS Certified Database - Specialty exam
Go to Exam

Exam AWS Certified Database - Specialty topic 1 question 300 discussion

Exam question from Amazon's AWS Certified Database - Specialty
Question #: 300
Topic #: 1
[All AWS Certified Database - Specialty Questions]

A database specialist is designing the database for a software-as-a-service (SaaS) version of an employee information application. In the current architecture, the change history of employee records is stored in a single table in an Amazon RDS for Oracle database. Triggers on the employee table populate the history table with historical records.

This architecture has two major challenges. First, there is no way to guarantee that the records have not been changed in the history table. Second, queries on the history table are slow because of the large size of the table and the need to run the queries against a large subset of data in the table.

The database specialist must design a solution that prevents modification of the historical records. The solution also must maximize the speed of the queries.

Which solution will meet these requirements?

  • A. Migrate the current solution to an Amazon DynamoDB table. Use DynamoDB Streams to keep track of changes. Use DynamoDB Accelerator (DAX) to improve query performance.
  • B. Write employee record history to Amazon Quantum Ledger Database (Amazon QLDB) for historical records and to an Amazon OpenSearch Service (Amazon Elasticsearch Service) domain for queries.
  • C. Use Amazon Aurora PostgreSQL to store employee record history in a single table. Use Aurora Auto Scaling to provision more capacity.
  • D. Build a solution that uses an Amazon Redshift cluster for historical records. Query the Redshift cluster directly as needed.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by rdiaz at March 26, 2023, 5:07 p.m.
Disclaimers:
  • - ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
  • - Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Pranava_GCP
1 year, 7 months ago
Selected Answer: B
B. Amazon QLDB and Amazon OpenSearch Service https://aws.amazon.com/qldb/faqs/ https://aws.amazon.com/opensearch-service/
upvoted 4 times
...
Windy
1 year, 9 months ago
It's B.
upvoted 2 times
...
Kodoma
1 year, 11 months ago
Selected Answer: B
"prevents modification of the historical records" automatically means QLDB, so B
upvoted 3 times
...
tsk9921
1 year, 11 months ago
B is right. Key is need for immutability of DB. Note the hint - one of major challenges - First, there is no way to guarantee that the records have not been changed in the history table
upvoted 1 times
...
rdiaz
2 years, 1 month ago
Selected Answer: B
Maybe b
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago