DBS-C01 Practice Test 6 — 10 Questions

Question 1

A database specialist is analyzing an Aurora MySQL error log and finds the above deadlock error. The application performs an update on the orders table and then updates the inventory table within the same transaction. The deadlock occurs when two concurrent transactions try to update orders and inventory in different orders. Which design change should the database specialist recommend to reduce deadlocks?

Accepted Answer

Ensure all transactions update tables in the same order (e.g., always update inventory first, then orders). Option B is correct because deadlocks in Aurora MySQL often occur when concurrent transactions acquire row-level locks on tables in different orders. By enforcing a consistent lock order (e.g., always updating inventory first, then orders), the database can avoid circular wait conditions, which are a necessary condition for deadlocks. This is a standard best practice for reducing deadlocks in InnoDB, which uses row-level locking and two-phase locking.

Answer

Combine the orders and inventory tables into a single table to avoid multiple table locks

Answer

Use SELECT ... FOR UPDATE on both tables before updating

Answer

Change the transaction isolation level to READ UNCOMMITTED

Question 2

A company is using Amazon DynamoDB for a shopping cart application. The table has a partition key of `user_id` and a sort key of `item_id`. The application performs frequent updates to the `quantity` attribute. The company notices that write requests are being throttled during peak hours. Which TWO actions would help reduce throttling? (Choose two.)

Accepted Answer

Increase the provisioned write capacity for the table.. Option A is correct because increasing the provisioned write capacity directly raises the number of write capacity units (WCUs) available per second, allowing more write requests to succeed without being throttled. Since the application performs frequent updates to the `quantity` attribute, which consumes write capacity, adding more capacity alleviates throttling during peak hours.

Answer

Use conditional writes to prevent overwrites.

Answer

Enable DynamoDB Streams to process writes asynchronously.

Answer

Enable DynamoDB Accelerator (DAX) for the table.

Question 3

A company is running a MySQL database on Amazon RDS and needs to store JSON documents that are frequently queried by fields within the JSON. The company wants to reduce development complexity and improve query performance. Which RDS MySQL feature should the database specialist recommend?

Accepted Answer

Use the JSON data type in MySQL 8.0 and utilize JSON path expressions in queries. Option B is correct because MySQL 8.0's native JSON data type stores JSON documents in an optimized binary format, enabling efficient indexing and querying via JSON path expressions (e.g., `JSON_EXTRACT`, `->`, `->>`). This reduces development complexity by allowing direct SQL access to JSON fields without application-level parsing, and improves query performance through generated columns and virtual indexes.

Answer

Migrate the JSON data to Amazon DynamoDB and use DynamoDB's document model

Answer

Store JSON documents in a VARCHAR(MAX) column and use LIKE operations for queries

Answer

Store JSON documents as BLOBs and parse them in application code

Question 4

A company is migrating a MySQL database to Amazon Aurora MySQL. The current database uses multi-statement transactions with read committed isolation level. The application frequently encounters deadlocks on the source database. Which Aurora MySQL feature can help reduce deadlocks without application changes?

Accepted Answer

Use Amazon RDS Proxy to pool and share database connections.. RDS Proxy helps reduce deadlocks by pooling and reusing database connections, which minimizes the overhead of establishing new connections and reduces contention on database resources. In MySQL, deadlocks often occur when multiple transactions compete for the same resources under high connection churn; by maintaining a stable pool of connections, RDS Proxy lowers the probability of concurrent conflicting locks. Since the proxy is transparent to the application, no code changes are required to benefit from this behavior.

Answer

Use Amazon Aurora Auto Scaling to automatically adjust the number of replicas.

Answer

Use Amazon Aurora Global Database to replicate data to multiple regions.

Answer

Use Amazon Aurora Backtrack to quickly revert transactions.

Question 5

A company is migrating an on-premises MongoDB database to Amazon DocumentDB. The database stores IoT sensor data with time-series characteristics. The application performs range queries on timestamp fields and updates recent documents frequently. Which THREE aspects of DocumentDB should the company consider to optimize performance for this workload? (Choose three.)

Accepted Answer

Implement sharding to distribute write load across multiple instances.. Option B is correct because DocumentDB does not support native sharding like MongoDB; however, for workloads with high write throughput, you can distribute writes by using multiple DocumentDB instances and routing writes based on a shard key in the application layer. This helps avoid write bottlenecks on a single instance and scales write capacity horizontally.

Answer

Use global secondary indexes to speed up queries on the timestamp field.

Answer

Use a single large instance class to avoid sharding complexity.

Question 6

A company runs a customer relationship management (CRM) application on Amazon RDS for PostgreSQL. The application has a table 'customers' with columns: id (primary key), name, email, signup_date, and status. The table has 10 million rows. The application frequently queries by email address. The company also needs to run analytical queries that aggregate customers by signup_date and status. The DBA notices that the index on email is heavily used and causes high write latency. The company wants to improve write performance without sacrificing read performance for email queries. Which THREE actions should the database specialist take? (Choose THREE.)

Accepted Answer

Create a BRIN index on signup_date.. Option A is correct because a BRIN (Block Range INdex) index on signup_date is ideal for large tables where data is naturally ordered by insertion time. BRIN indexes are much smaller and have lower write overhead than B-tree indexes, making them suitable for analytical queries on signup_date without significantly impacting write performance.

Answer

Remove the index on email to reduce write latency.

Answer

Create a GIN index on email.

Question 7

A social media startup is using Amazon ElastiCache for Redis to cache user profiles. The cache currently has a 24-hour TTL. The application experiences a sudden spike in traffic after a celebrity mentions the service, causing the cache to be flooded with requests for uncached profiles. This results in high latency and database load. Which design pattern should the company implement to prevent this in the future?

Accepted Answer

Implement a local cache in each application instance to reduce load on the centralized Redis cluster.. Option B is correct because implementing a local cache (e.g., using a library like Caffeine or Guava) in each application instance reduces the number of requests hitting the centralized Redis cluster during a traffic spike. This pattern, often called a multi-tier or near-cache, absorbs repeated reads for the same uncached profiles locally, preventing cache flooding and database overload without relying solely on Redis TTL adjustments.

Answer

Use a read-through cache with a longer TTL (e.g., 48 hours).

Answer

Use a write-through cache with a longer TTL (e.g., 48 hours).

Answer

Use a write-through cache with a shorter TTL (e.g., 1 hour).

Question 8

A company is implementing fine-grained access control for a DynamoDB table named UserSessions. The table has a partition key of 'user_id'. The above IAM policy is attached to an IAM role assumed by the application. What does this policy achieve?

Accepted Answer

Restricts the application to access only items where the partition key matches the user's AWS user ID. The IAM policy uses a condition key `dynamodb:LeadingKeys` with a value of `${aws:userid}`. This restricts access to items in the DynamoDB table where the partition key (`user_id`) matches the unique identifier of the IAM user or role that is making the request. This implements fine-grained access control, ensuring the application can only read or write items belonging to the authenticated user.

Answer

Allows the application to perform all operations on the UserSessions table without restrictions

Answer

Allows the application to read but not write items in the UserSessions table

Answer

Allows the application to access only the UserSessions table but not other tables

Question 9

A financial services company is designing a ledger system using Amazon QLDB. The application records transactions that must never be modified or deleted. The company expects high write throughput and needs to ensure that the ledger can handle the load without throttling. Which design consideration is MOST important to achieve this?

Accepted Answer

Batch multiple document inserts into a single transaction to reduce the number of transactions.. Option D is correct because Amazon QLDB charges per transaction (document insert, update, or delete) and has a maximum throughput limit of 1,000 transactions per second per ledger. By batching multiple document inserts into a single transaction, you reduce the number of transactions, thereby staying within the throughput limit while still achieving high write throughput. This approach directly addresses the need to avoid throttling without sacrificing the immutability requirements of the ledger system.

Answer

Partition the ledger table by transaction date to distribute write load.

Answer

Create multiple ledgers and distribute writes across them.

Answer

Enable auto-scaling on the ledger to handle bursts of traffic.

Question 10

A social media company uses Amazon DynamoDB to store user posts. The table has a partition key of 'user_id' and a sort key of 'post_timestamp'. Each item is about 10 KB. The application needs to retrieve all posts for a given user within a date range. The company recently added a new feature that allows users to 'like' posts, and they store the like count as an attribute in the post item. The like count is updated frequently. The application experiences high write throttling on the table. The table has 1000 WCUs provisioned. The write pattern is bursty. Which design change would MOST effectively reduce write throttling?

Accepted Answer

Add a random suffix to the user_id partition key to distribute writes across multiple partitions.. Option C is correct because the write throttling is caused by a 'hot partition' — all writes for a given user_id go to the same partition, and the bursty write pattern (e.g., many likes on a single post) exceeds the partition's 1,000 WCU limit (1,000 write capacity units per partition). Adding a random suffix to the user_id partition key distributes writes across multiple partitions, effectively increasing the write throughput for that logical user's data. This is a common design pattern for DynamoDB to handle high-traffic items without increasing provisioned capacity.

Answer

Increase the WCUs to 5000.

Answer

Enable DynamoDB Accelerator (DAX) to cache writes.

Answer

Create a Global Secondary Index (GSI) on the like count attribute.

DBS-C01 Practice Test 6 — 10 Questions

Exhibit

DBS-C01 Practice Test 6 — 10 Questions

Exhibit