DBS-C01 · Question #309
DBS-C01 Question #309: Real Exam Question with Answer & Explanation
Sign in or unlock DBS-C01 to reveal the answer and full explanation for question #309. The question stem and answer options stay visible for context.
Question
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?
Options
- AMigrate the current solution to an Amazon DynamoDB table. Use DynamoDB Streams to keep
- BWrite employee record history to Amazon Quantum Ledger Database (Amazon QLDB) for
- CUse Amazon Aurora PostgreSQL to store employee record history in a single table. Use Aurora
- DBuild a solution that uses an Amazon Redshift cluster for historical records. Query the Redshift
Unlock DBS-C01 to see the answer
You've previewed enough free DBS-C01 questions. Unlock DBS-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.