AWS (Amazon Web Services) Certification
61 practice questions with correct answers and detailed explanations. Use this guide to review concepts before taking the practice exam.
The AWS (Amazon Web Services) AWS Certified Database – Specialty (DBS-C01) certification validates professional expertise in AWS (Amazon Web Services) technologies. This study guide covers all 61 practice questions from our DBS-C01 practice test, complete with correct answers and explanations to help you understand each concept thoroughly.
Review each question and explanation below, then test yourself with the full interactive practice exam to measure your readiness.
You are designing a multi-region Amazon RDS deployment for a globally distributed application. Which of the following approaches provides the lowest read latency for users across multiple geographic regions?
RDS Global Database provides the lowest read latency by maintaining synchronized read-only copies in secondary regions that users can query locally. This eliminates cross-region network latency for read operations.
Your team is migrating a legacy on-premises Oracle database to Amazon RDS for Oracle. During the assessment phase, you discover the database uses Oracle-specific features like Advanced Security Option (ASO) for encryption. What should you consider?
Oracle Advanced Security Option must be licensed separately and is available in the BYOL licensing model for RDS for Oracle. Standard RDS license includes only basic encryption via AWS KMS.
You need to analyze slow query logs in Amazon RDS for MySQL to identify performance bottlenecks. Which AWS service should you use to correlate database metrics with application logs?
RDS Performance Insights provides database load monitoring while Enhanced Monitoring offers OS-level metrics. Together they correlate database activity with system resource utilization to identify bottlenecks. CloudWatch Logs Insights is primarily for log analysis, not real-time correlation.
Your company runs a MySQL database on RDS with automated backups enabled. A developer accidentally deletes critical data at 14:00 UTC. You need to recover the database to 13:50 UTC. What is the fastest recovery method?
Point-in-time restore allows you to recover the database to any specific time within the backup retention period (up to 35 days). This is the fastest and most straightforward method for recovering to 13:50 UTC without manual intervention.
You are designing a database solution for an IoT application that ingests millions of sensor readings per second. Traditional relational databases are showing performance degradation. Which AWS database service is most suitable?
DynamoDB is purpose-built for handling massive write throughput (millions of requests/second) with on-demand scaling. The partition key design ensures even distribution across partitions for IoT sensor data ingestion patterns.
Your organization requires encryption of data in transit for all database connections to comply with regulatory requirements. Which database service option provides transparent TLS encryption enforcement?
Aurora PostgreSQL uses the rds.force_ssl parameter in the cluster parameter group to enforce SSL/TLS encryption for all client connections. This ensures transparent encryption without application changes.
You discover that your RDS PostgreSQL database is experiencing connection pool exhaustion during peak traffic. The application uses a standard PostgreSQL JDBC driver. What is the most appropriate solution?
RDS Proxy is an AWS-managed database proxy that provides connection pooling, reducing the number of database connections needed. It improves scalability without increasing the DB parameter group's max_connections setting.
Your DynamoDB table experiences sudden spikes in traffic that cause throttling during certain times of the day. You want to avoid capacity planning delays. Which billing and auto-scaling strategy should you implement?
On-demand billing mode is ideal for unpredictable traffic spikes as it automatically scales read and write capacity without delays or configuration. You pay per request rather than provisioning capacity in advance.
You are migrating a large SQL Server database from on-premises to AWS. The source database has full-text search (FTS) indexes that are heavily used. What is the recommended approach?
RDS for SQL Server supports full-text search indexes. AWS DMS will migrate the database, but FTS indexes need to be reconfigured since they may reference system catalogs differently in the RDS environment.
Your analytics team requires ad-hoc SQL queries against data stored in Amazon S3 without maintaining a separate data warehouse. Which AWS service provides the best balance of performance and cost?
Amazon Athena is purpose-built for ad-hoc SQL queries against S3 data without requiring infrastructure management. It provides excellent cost-effectiveness for sporadic query patterns and is easier to set up than Redshift Spectrum.
You need to ensure that your Amazon Aurora database can tolerate an entire AWS region failure. Which combination of features should you implement?
Aurora Global Database is specifically designed for region-level disaster recovery. It maintains a read-only secondary database in another region with near-zero RPO and enables fast failover if the primary region fails.
Your DynamoDB table uses a composite primary key (partition key + sort key) and you need to query items where the sort key begins with a specific prefix. What is the most efficient query operation?
The Query operation with begins_with() in the KeyConditionExpression is the most efficient approach. It directly uses the sort key condition to retrieve only matching items without scanning the entire table or using filters.
You are implementing cross-region replication for a production DynamoDB table. During testing, you notice replication latency of 2-3 seconds between regions. Your application requires near-instantaneous consistency. What should you do?
DynamoDB Global Tables have inherent replication latency (typically under 1 second, but can reach 2-3 seconds during peak load). Applications requiring stronger consistency should implement local caching or read-your-writes patterns.
Your company runs a multi-tenant SaaS application using RDS for PostgreSQL. Each customer's data must be isolated and encrypted separately. What is the recommended approach?
PostgreSQL row-level security (RLS) provides tenant isolation at the database level while application-level encryption ensures per-customer data protection. This is more cost-effective than separate instances while maintaining security.
You need to migrate a large MongoDB database to Amazon DocumentDB. The migration requires zero downtime. Which AWS service should you use?
AWS DMS supports zero-downtime MongoDB to DocumentDB migrations using continuous replication and Change Data Capture. This keeps the databases synchronized throughout the migration process.
Your application frequently performs complex joins across multiple DynamoDB tables. You are experiencing performance issues and high costs. What architectural change should you consider?
DynamoDB is optimized for single-item operations and queries on a single table. Complex multi-table joins are a sign that a relational database like RDS is better suited for the workload.
You configure automated backups for your RDS for MySQL database with a 7-day retention period. However, you need to retain a specific backup for compliance purposes beyond the retention window. What is the appropriate action?
Manual snapshots are retained indefinitely until explicitly deleted, independent of the automated backup retention period. Creating a manual snapshot from an automated backup preserves it beyond the retention window.
Your Neptune graph database is used for recommendation engine queries that require traversing relationships across millions of nodes. Queries are running slowly. What optimization strategy should you implement?
Property indexes on frequently queried attributes significantly improve Neptune traversal performance by reducing the number of nodes that must be scanned during graph queries. This is more efficient than scaling instance size.
You are designing a database solution for a real-time analytics dashboard that processes streaming IoT data. The dashboard must display results with sub-second latency. Which combination of services is most appropriate?
Amazon Timestream is optimized for time-series data with high-speed ingestion and sub-second query latency. It integrates well with Kinesis Data Streams for IoT data processing and CloudWatch for visualization.
Your RDS for PostgreSQL database experiences high memory usage causing Out-Of-Memory (OOM) errors. The issue is traced to inefficient query plans. What is the best remediation approach?
EXPLAIN ANALYZE provides insight into query execution plans. Adding indexes or rewriting queries to use better plans is the proper solution rather than increasing memory, which masks the underlying issue.
You need to audit all data modifications in your DynamoDB table for compliance purposes. Which approach provides a complete audit trail?
DynamoDB Streams capture item-level modifications and can be processed by Lambda to create an audit trail in S3. This provides a complete record of data changes. CloudTrail only logs API calls, not actual data modifications.
Your Aurora MySQL cluster experiences a spike in read latency during peak hours even with read replicas. You have already optimized indexes and query plans. What should you investigate?
High read latency during peak hours with read replicas often indicates that the primary instance cannot keep up with replication throughput, causing replica lag. This reduces data freshness on replicas and increases read latency.
You are implementing a distributed ledger application on Amazon QLDB. The application requires long-term retention of the complete transaction history. What is the recommended approach for archival?
QLDB Ledger Export automatically exports all committed journal entries to S3, providing a complete and verifiable transaction history. This is the recommended approach for long-term archival of QLDB data.
Your organization runs a PostgreSQL database with extensions like PostGIS for spatial queries. You plan to migrate to RDS for PostgreSQL. What should you verify?
RDS for PostgreSQL supports a curated list of approved extensions. PostGIS is among the supported extensions and installation requires rds_superuser privilege. RDS Custom may be needed for unsupported extensions.
You need to implement disaster recovery for a critical MySQL database with RPO of 1 hour and RTO of 30 minutes. Which approach best meets these requirements?
Multi-AZ provides near-instantaneous failover (typically under 1 minute) within the same region, while hourly automated backups provide a 1-hour RPO. Cross-region failover (option D) has longer RTO due to replication lag.
Your DynamoDB table has a very large partition due to a non-uniform distribution of data across partition keys. This causes hot partitions and throttling. Which immediate remediation should you implement?
Adding a random suffix (sharding) to the partition key distributes requests across multiple partitions, eliminating the hot partition issue. This is more effective than capacity increases which don't solve the distribution problem.
You are designing a database solution for a financial services company that requires sub-millisecond latency and high throughput. The application needs to perform complex joins across multiple tables. Which AWS database service would be most appropriate?
Aurora MySQL provides ACID compliance, complex join support, and sub-millisecond latency through its distributed architecture and read replicas for scaling read operations.
What is the maximum number of read replicas that can be created for an Amazon RDS MySQL instance in a single region?
Amazon RDS allows up to 15 read replicas per database instance within the same region, providing flexibility for scaling read-heavy workloads.
You are migrating a 50 GB on-premises PostgreSQL database to AWS. The network has limited bandwidth, and the database cannot be offline for more than 2 hours. Which migration approach would be most suitable?
AWS DMS with CDC enables continuous replication of changes after the initial full load, minimizing downtime while respecting bandwidth constraints through configurable parallel task settings.
Your application uses Amazon DynamoDB with strongly consistent reads. You notice that read capacity is becoming a bottleneck. What is the most cost-effective solution to improve read performance without changing application code?
DAX provides microsecond-level latency and reduces read traffic to DynamoDB tables, making it cost-effective by reducing actual RCU consumption while improving performance.
You are configuring high availability for a mission-critical Amazon Aurora PostgreSQL cluster spanning three availability zones. Which configuration provides the highest availability with automatic failover?
An Aurora cluster with one primary and two read replicas across three AZs ensures automatic failover capability, data redundancy, and read scaling while maintaining a single write endpoint.
A compliance requirement mandates that your RDS database must be encrypted at rest using a customer-managed KMS key. Your database is currently running on an unencrypted RDS instance. How should you implement this requirement?
RDS encryption cannot be enabled on an existing unencrypted instance. The most practical approaches are snapshot restore (option B) or migration via DMS. Option C (DMS) allows minimal downtime with CDC for a live production database.
You need to design a database for a real-time analytics application that ingests 100,000 events per second. The data model requires complex aggregations and time-series analysis. Which AWS database is most suitable?
Amazon Redshift with RA3 nodes excels at high-volume data ingestion and complex analytical queries, providing better columnar performance and cost efficiency for time-series analytics compared to transactional databases.
Your organization is experiencing unexpected billing increases from Amazon RDS. Upon investigation, you notice a significant spike in CPU usage during off-peak hours. Which approach would help identify the root cause?
Performance Insights provides a visual breakdown of active sessions and wait events correlated with CPU utilization, making it the best tool to identify which queries are causing the spike during off-peak hours.
You are designing a multi-tenant SaaS application with 500 customers, each requiring isolated databases. What is the most operationally efficient approach for managing these databases on AWS?
A single RDS instance with schema-per-tenant and row-level security provides operational efficiency, cost optimization, and easier management while maintaining logical isolation and compliance requirements.
When restoring an Amazon RDS MySQL database from a snapshot to a point-in-time that occurred 5 days ago, what factor most significantly affects the time required for restoration?
Point-in-time recovery requires applying binary logs sequentially from the snapshot to reach the target time. The number of logs and their size directly impact restoration duration, while snapshot size matters less for the recovery process itself.
You need to implement cross-region disaster recovery for an Amazon Aurora PostgreSQL cluster. The recovery time objective (RTO) is 1 minute, and recovery point objective (RPO) is 1 second. Which solution meets these requirements?
Aurora global database replicates data with sub-second latency (meeting RPO) and enables failover to a read-only secondary in under 1 minute (meeting RTO), making it the purpose-built solution for these requirements.
Your application requires sub-second response times for queries but generates unpredictable traffic patterns ranging from 100 to 10,000 requests per second. Which RDS configuration best handles this scenario?
Aurora Auto Scaling automatically adjusts read and write capacity within seconds based on traffic patterns, and Aurora Serverless can handle unpredictable workloads without manual intervention or cold starts.
You are implementing a backup strategy for a critical Amazon RDS database. The business requires the ability to restore to any point within the last 30 days. What is the recommended approach?
RDS automated backups with extended retention (35 days) combined with binary logging enable point-in-time recovery for any moment within 30 days, with the extra 5 days as a safety buffer. Regular integrity testing ensures reliability.
A developer has created an application that performs 10,000 queries per second against a DynamoDB table using a single partition key. The table is throttling despite adequate provisioned capacity. What is the most likely cause?
If all 10,000 queries per second use the same partition key value, DynamoDB cannot distribute the load across partitions. This hot partition problem causes throttling even with adequate overall capacity because each partition has limits.
What is the primary benefit of using Amazon RDS Proxy for a web application with connection pooling challenges?
RDS Proxy acts as a connection pooler, allowing many application connections to share a smaller number of database connections, reducing memory overhead and improving performance under high connection volume.
You are migrating a large SQL Server database (2 TB) from on-premises to RDS for SQL Server. The network bandwidth between your data center and AWS is 100 Mbps. Using AWS DMS with full load replication, approximately how long would the initial full load take (assuming 80% network utilization)?
2 TB = 2,000,000 MB. With 100 Mbps bandwidth at 80% utilization = 80 Mbps effective throughput = 10 MB/s. Transfer time = 2,000,000 MB / 10 MB/s = 200,000 seconds ≈ 56 hours. However, with parallel tasks and compression, realistic time is 20-25 hours.
Your application uses Amazon DynamoDB with a write throttle occurring during peak hours. You have already verified that your application code is efficient. What is the most direct solution to eliminate throttling?
Write throttling occurs when provisioned WCUs are insufficient. The direct solution is to increase provisioned WCUs or switch to on-demand mode for automatic capacity adjustment. DAX caches reads, not writes.
You need to replicate a PostgreSQL database from on-premises to Amazon Aurora PostgreSQL for real-time analytics. The source database cannot tolerate significant performance impact. Which replication method is most suitable?
AWS DMS with CDC using logical replication slots minimizes source impact by asynchronously capturing changes and replicating them to Aurora, allowing the source database to continue normal operations.
Your organization's compliance policy requires encryption in transit for all database connections. You are using RDS for MySQL. How can you enforce SSL/TLS encryption for all client connections?
Setting the 'require_secure_transport' parameter to ON forces all connections to use SSL/TLS, rejecting unencrypted connections at the database level.
You are designing a database solution for a mobile application that must work both online and offline. When online, data must synchronize with a central database. Which AWS service combination is most appropriate?
AWS AppSync with DynamoDB provides built-in offline data synchronization, automatic conflict resolution, and real-time updates when the application comes online, making it purpose-built for mobile app scenarios.
When using Amazon Aurora with Read Replicas, how is the write throughput of the database affected by adding more read replicas?
Read replicas do not directly handle writes, but there is minimal replication overhead on the primary instance to propagate changes. In Aurora, this overhead is negligible due to its distributed architecture.
You are implementing a solution to prevent accidental deletion of critical data in Amazon RDS. What is the most comprehensive protection strategy?
A comprehensive approach combines AWS Backup with compliance policies that prevent modification, RDS deletion protection at the instance level, and IAM policies that restrict who can perform delete operations, providing multiple layers of protection.
Your organization is consolidating 50 MySQL databases from different business units into a single RDS instance using separate schemas. What is the primary consideration for monitoring performance in this scenario?
Performance Insights can correlate resource consumption with specific schemas, revealing if one schema is consuming excessive resources and impacting others. This is critical in a consolidated multi-schema environment for identifying noisy neighbors.
When using AWS DMS to migrate from Oracle to Amazon Aurora PostgreSQL, what is the primary challenge related to data type compatibility?
Oracle's NUMBER type with variable precision/scale can map to Aurora PostgreSQL in multiple ways (numeric, float, double), and DMS may choose a mapping that loses precision. This requires careful schema review and custom conversion rules.
You need to implement automatic failover for a mission-critical RDS database with an RTO of 30 seconds. Which configuration provides this capability?
RDS Multi-AZ with automatic failover provides synchronous replication to a standby instance in another AZ and automatic failover within 30-120 seconds when the primary fails, meeting the RTO requirement.
You are managing an Amazon RDS Multi-AZ deployment with synchronous replication. A network partition occurs between the primary and secondary instances. What happens to write operations on the primary database?
In RDS Multi-AZ, the primary database continues to accept writes during a network partition. The synchronous replication may lag or fail, but the primary does not block writes; this is by design to maintain availability. A failover is only triggered if the primary becomes unavailable.
Your company requires encryption of data at rest for all Amazon DynamoDB tables containing personally identifiable information (PII). Which encryption option provides the most control over key management?
Customer managed keys in AWS KMS provide the highest level of control, allowing you to manage key rotation, access policies, and audit key usage. AWS owned and managed keys offer less control and audit visibility.
You are optimizing an Amazon Aurora MySQL cluster for read-heavy workloads. Currently, you have one primary instance and two read replicas. Query performance is still suboptimal. What should you investigate first?
Query optimization through execution plan analysis and proper indexing is the most cost-effective first step before scaling horizontally or vertically. Adding more replicas without addressing inefficient queries wastes resources.
An application using Amazon DocumentDB requires guaranteed consistency across all reads. Which read preference should be configured?
The 'primary' read preference ensures strong consistency by reading exclusively from the primary instance. All other preferences may return stale data from replicas, which have eventual consistency.
You are migrating a legacy SQL Server database to AWS. The source database uses SQL Server Agent jobs for scheduled maintenance tasks. How should you replicate this functionality in AWS?
Amazon RDS for SQL Server supports SQL Server Agent jobs, allowing native job scheduling. However, the most flexible cloud-native approach is using Lambda with EventBridge, which works across all RDS database engines.
Your Amazon RDS PostgreSQL database is experiencing connection pool exhaustion during peak hours. The application uses a connection per thread approach. What is the recommended solution?
Amazon RDS Proxy manages database connections efficiently by multiplexing application connections, reducing the number of actual database connections needed. This is the recommended AWS solution for connection pool exhaustion.
You need to migrate data from an on-premises Oracle database to Amazon Aurora PostgreSQL using AWS Database Migration Service (DMS). The source database contains PL/SQL stored procedures. What should you plan for?
While DMS can migrate some PL/SQL code, complex procedures often require manual conversion to PostgreSQL's PL/pgSQL due to syntax and functional differences. Aurora PostgreSQL does not have full PL/SQL compatibility.
An Amazon RDS MySQL instance is approaching its storage limit. Which action can be performed without downtime?
Amazon RDS for MySQL supports automatic storage scaling without downtime, automatically increasing storage when needed. Snapshots and restoration cause downtime, and modifying the parameter group alone does not expand storage.
You are designing a multi-region active-active database architecture on AWS for disaster recovery. Which database service is most suitable for this requirement?
DynamoDB Global Tables provide true active-active multi-region replication where applications can read and write in any region. Aurora Global Database is read-only in secondary regions. RDS and DocumentDB do not provide built-in active-active support.
A company runs batch analytics queries on an Amazon Redshift cluster during off-peak hours. Current costs are high due to continuous cluster availability. How can costs be optimized while maintaining query performance for batch workloads?
Redshift supports pause and resume functionality for RA3 node types, allowing you to stop clusters when not needed and resume them for batch jobs, significantly reducing costs. Spectrum and Athena have different use cases, and Reserved Instances do not reduce costs as much as pausing.
You've reviewed all 61 questions. Take the interactive practice exam to simulate the real test environment.
▶ Start Practice Exam — Free