DBS-C01 Practice Test 5 — 10 Questions

Question 1

A company is deploying a multi-AZ Aurora MySQL database. They need to ensure that failover happens automatically with minimal data loss. Which configuration should be used?

Accepted Answer

Create an Aurora cluster with one primary and two readers in different Availability Zones.. An Aurora cluster with one primary and two readers in different Availability Zones provides automatic failover with minimal data loss. Aurora uses a shared cluster volume that is replicated six ways across three AZs, ensuring that during a failover, the promoted reader has access to all committed transactions with no data loss. This configuration meets the requirement for multi-AZ high availability and automatic failover within a single region.

Answer

Deploy an Aurora Global Database with a primary in one region and a secondary in another region.

Answer

Use a Multi-AZ RDS for MySQL deployment.

Answer

Configure a single-AZ Aurora instance and enable cross-Region replication.

Question 2

A company is migrating an on-premises Oracle data warehouse to AWS. The warehouse contains 20 TB of data and supports complex SQL queries with joins and aggregations. The migration should minimize downtime and require minimal changes to existing SQL queries. Which database service is MOST appropriate?

Accepted Answer

Amazon Redshift. Amazon Redshift is the most appropriate choice because it is a fully managed, petabyte-scale data warehouse service designed for complex SQL queries with joins and aggregations. It supports standard SQL with minimal changes to existing queries, and its columnar storage and massively parallel processing (MPP) architecture are optimized for analytical workloads. The 20 TB data size and requirement to minimize downtime align with Redshift's ability to perform online resizing and use features like RA3 nodes with managed storage for elastic scaling.

Answer

Amazon RDS for Oracle

Answer

Amazon DynamoDB

Answer

Amazon ElastiCache for Redis

Question 3

Which TWO of the following are recommended best practices for designing a relational database on Amazon RDS? (Select TWO.)

Accepted Answer

Use read replicas to scale read-heavy workloads. Amazon RDS read replicas offload read traffic from the primary DB instance, improving performance for read-heavy workloads by providing additional read-only endpoints. This is a core best practice for scaling read capacity without increasing load on the source instance.

Answer

Use LOB data types to store large text fields

Answer

Use non-EBS-optimized instances to reduce costs

Answer

Store large binary objects (BLOBs) in the database

Question 4

A company uses Amazon RDS for PostgreSQL with Multi-AZ. The primary instance fails and a failover occurs. After failover, the application reports elevated write latency. Which TWO are possible causes?

Accepted Answer

The buffer pool is not warm on the new primary. After a Multi-AZ failover, the new primary instance starts with a cold buffer pool (no cached data blocks). PostgreSQL relies on shared buffers to cache frequently accessed data; without a warm cache, every read request must fetch data from disk, which increases I/O and write latency because writes often require reading the affected pages first. This is a known behavior in RDS for PostgreSQL after failover, and it resolves as the buffer pool warms up over time.

Answer

A read replica is now promoting to primary

Answer

The new primary has a smaller instance size

Answer

Automated backups are running on the new primary

Question 5

A company is migrating an on-premises Oracle database to Amazon RDS for Oracle. The database size is 500 GB. The migration must have minimal downtime. Which AWS service should be used to perform the migration?

Accepted Answer

AWS Database Migration Service (DMS). AWS Database Migration Service (DMS) is the correct choice because it supports heterogeneous migrations from Oracle to Amazon RDS for Oracle with minimal downtime. DMS can perform continuous replication using Oracle's change data capture (CDC) via LogMiner or binary reader, allowing the source database to remain operational during the migration. This makes it ideal for a 500 GB database where downtime must be minimized.

Answer

AWS Snowball Edge

Answer

AWS DataSync

Answer

Amazon RDS for Oracle snapshot copy

Question 6

A company is building a document management system where each document can have multiple attributes (tags) that need to be queried efficiently. The workload is write-heavy with occasional reads. Which database is best suited?

Accepted Answer

Amazon DynamoDB. Amazon DynamoDB is the best choice for a write-heavy, document management system with tag-based queries because it is a fully managed NoSQL key-value and document database that delivers single-digit millisecond performance at any scale. Its flexible schema allows each document to have multiple attributes (tags) without predefined schemas, and its secondary indexes (LSI/GSI) enable efficient querying on those tags. DynamoDB's auto-scaling and provisioned throughput are designed to handle high write volumes, while occasional reads benefit from its consistent low-latency access.

Answer

Amazon QLDB

Answer

Amazon ElastiCache for Redis

Answer

Amazon RDS for MySQL

Question 7

A company needs to store and query time-series data from IoT devices. The data arrives in high volume and requires efficient range queries over time. Which database is most appropriate?

Accepted Answer

Amazon Timestream. Amazon Timestream is a purpose-built time-series database that automatically scales to handle high-volume IoT data and is optimized for efficient range queries over time. It separates storage into a memory store for recent data and a magnetic store for historical data, enabling fast queries across time ranges with built-in time-series functions.

Answer

Amazon RDS for MySQL

Answer

Amazon DynamoDB

Answer

Amazon Redshift

Question 8

Which TWO database services are most suitable for workloads that require ACID transactions?

Accepted Answer

Amazon Aurora. Amazon Aurora is correct because it is a MySQL- and PostgreSQL-compatible relational database engine that provides full ACID (Atomicity, Consistency, Isolation, Durability) transaction support, including multi-statement transactions with commit and rollback. Aurora uses a distributed, fault-tolerant storage subsystem that replicates data across three Availability Zones, ensuring durability and consistency for transactional workloads.

Answer

Amazon Neptune

Answer

Amazon Timestream

Answer

Amazon DynamoDB

Question 9

A company is migrating a 100 GB SQL Server database to Amazon RDS for SQL Server. They need to minimize downtime and ensure that only the schema is converted. Which tool should they use?

Accepted Answer

AWS Schema Conversion Tool (SCT). AWS Schema Conversion Tool (SCT) is the correct choice because it is specifically designed to convert database schemas (including stored procedures, functions, and data types) from one engine to another, such as SQL Server to Amazon RDS for SQL Server. Since the requirement is to minimize downtime and only convert the schema (not migrate data), SCT can perform an offline schema conversion without impacting the source database, whereas DMS is a continuous data replication tool that would incur downtime for schema changes.

Answer

AWS Database Migration Service (DMS)

Answer

AWS DMS with schema conversion enabled

Answer

SQL Server Management Studio (SSMS)

Question 10

A company is building a social network application that needs to store user profiles, friend relationships, and a feed of posts. The feed queries are complex, involving graph traversals (e.g., friends of friends). Which database is best suited for the relationship data?

Accepted Answer

Amazon Neptune. Amazon Neptune is a fully managed graph database service optimized for storing and querying highly connected data. It supports both property graph and RDF models, and it uses graph traversal languages like Gremlin and SPARQL, making it ideal for complex friend-of-friend queries and social network relationship data.

Answer

Amazon DynamoDB

Answer

Amazon RDS for MySQL

Answer

Amazon ElastiCache for Redis