The new flashcard feature is useful to memorize questions.
?Change your study mode
At any time, you can change the study mode, and alternate between the practice mode and the exam mode. In practice mode, you can configure for example the number of questions or tests, and other parameters to help you study.
Randomized | 10 Questions per Test | 20 Minutes | 70% to pass|
To re-configure your study mode again and change - for example - the number of tests, whether you have random questions and all other configuration parameters.
?Simulator Configuration
Auto-scroll: You can use the automatic scrolling of the questionnaire that occurs as soon as you answer one or all of the answers to a question correctly. Auto scrolling is activated if you answer a single answer, or as soon as you answer all the mandatory answers. Learning Mode: During learning mode you can get a real time result for your answer.
Free Test
Question: / 10
20:00Min. left
?Restart the current test
To restart the current test by clearing all your answers and the time used up to now. Warning: all answers will be lost.
Question: / 10
4.9(617 Votes)
Quiz
Question 1/101/10
Workload-Specific Database Design
Workload-Specific Database Design
Workload-Specific Database Design
A manufacturing company needs to store real-time sensor data from 50,000 IoT devices, with timestamps and numerical measurements. They need sub-second query performance for time-range queries and expect to store trillions of data points. Which AWS database service is the best fit?
Select the answer:Select the answer
1 correct answer
A.
Amazon Aurora with time-series optimized tables
B.
Amazon Timestream for time-series data
C.
Amazon DynamoDB with TTL
D.
Amazon RDS for PostgreSQL with TimescaleDB extension
Explanation: Amazon Timestream is a purpose-built time-series database service designed specifically for IoT and metrics use cases. It automatically scales to handle trillions of data points and provides optimized query performance for time-range queries. Timestream includes built-in time-series analytics, automatic data tiering to reduce costs, and is optimized for write-heavy workloads typical of sensor data. While Aurora and PostgreSQL with extensions can store time-series data, they require manual partitioning and are not optimized for the extreme scale and throughput needed for this scenario. DynamoDB is not ideal for complex time-range analytical queries. ---
Right Answer: B
Quiz
Question 2/102/10
Deployment and Migration
Deployment and Migration
Deployment and Migration
Your company needs to migrate a 2TB Oracle database to AWS RDS for PostgreSQL. The source database is on-premises with limited bandwidth connectivity. Which combination of AWS services would be most appropriate for this heterogeneous migration?
Select the answer:Select the answer
1 correct answer
A.
AWS DMS with AWS Snowball for data transfer and SCT for schema conversion
B.
AWS Database Migration Service alone with direct network connectivity
C.
Manual export/import using AWS DataPipeline
D.
AWS Glue ETL with S3 intermediate storage
Explanation: For large heterogeneous migrations with bandwidth constraints, AWS DMS combined with Snowball provides efficient data transfer, while SCT handles the complex schema conversion from Oracle to PostgreSQL. Snowball is ideal for transferring large volumes when network bandwidth is limited. SCT analyzes the source database schema and generates equivalent DDL statements for the target platform, handling Oracle-specific features like sequences, triggers, and packages. DMS would then handle the ongoing data synchronization and change data capture if needed. Direct network connectivity in option B would be impractical for 2TB over limited bandwidth. DataPipeline and Glue are general-purpose tools not optimized for database migration scenarios. ---
Right Answer: A
Quiz
Question 3/103/10
Management and Operations
Management and Operations
Management and Operations
A company runs a critical RDS database that experiences regular maintenance updates. The team needs to ensure that maintenance windows don't conflict with peak business hours between 9 AM and 5 PM EST. Which of the following is the most appropriate strategy?
Select the answer:Select the answer
1 correct answer
A.
Schedule the RDS maintenance window to occur between 10 PM and 2 AM EST to avoid peak hours
B.
Disable automatic maintenance and manually apply patches whenever convenient during off-peak hours
C.
Enable Multi-AZ deployment and schedule maintenance during business hours since failover will be automatic
D.
Configure RDS to apply critical security patches immediately and defer minor updates to scheduled maintenance windows
Explanation: RDS maintenance windows should be scheduled during off-peak hours to minimize business impact. The maintenance window represents a specific timeframe when AWS can apply updates, patches, and maintenance tasks to the database instance. Scheduling it outside business hours (9 AM to 5 PM EST) is the standard best practice. Option B is problematic because disabling automatic maintenance introduces security risks and operational burden. Option C is incorrect because even with Multi-AZ, the primary instance will experience downtime during maintenance. Option D misses the point about scheduling preference, as both critical and non-critical updates occur during maintenance windows, though critical security patches may be applied outside the window if necessary. ---
Right Answer: A
Quiz
Question 4/104/10
Monitoring and Troubleshooting
Monitoring and Troubleshooting
Monitoring and Troubleshooting
Your RDS MySQL database is experiencing intermittent slow query performance. You need to identify which queries are taking the longest time to execute and analyze their execution patterns. Which combination of monitoring tools would be most effective for this scenario?
Select the answer:Select the answer
1 correct answer
A.
Enable the general log and analyze query execution times in CloudWatch Logs
B.
Enable Performance Insights and slow query logs, then correlate data with Enhanced Monitoring metrics
C.
Use CloudTrail to track all database API calls and filter by query duration
D.
Enable binary logging and use AWS DMS to track query execution
Explanation: Performance Insights provides database load diagnostics and shows which queries are consuming the most database resources, making it ideal for identifying slow queries. Slow query logs capture queries exceeding a threshold duration. Enhanced Monitoring metrics provide host-level statistics like CPU, memory, and I/O. Together, these tools give comprehensive visibility into query performance and system resource constraints. The general log captures all queries but creates significant overhead. CloudTrail tracks API calls, not query execution. Binary logging and DMS are for replication and migration, not performance analysis.
Right Answer: B
Quiz
Question 5/105/10
Database Security
Database Security
Database Security
A company has deployed an RDS MySQL database and needs to ensure that all data at rest is encrypted using AWS-managed keys. Currently, database backups are unencrypted. Which configuration change will encrypt the backup data?
Select the answer:Select the answer
1 correct answer
A.
Enable encryption using RDS default encryption settings without specifying a KMS key
B.
Enable RDS encryption at the time of DB instance creation with a specific KMS key
C.
Apply encryption only to snapshots through the AWS Backup service
D.
Modify the RDS parameter group to enable binary logging with encryption
Explanation: RDS backups inherit encryption settings from the parent DB instance. When you enable encryption at instance creation time and specify a KMS key, all backups created from that instance are automatically encrypted with the same key. It's critical to enable encryption at instance creation because encrypted instances require restoration into an encrypted instance. Default encryption settings may use AWS-managed keys (aws/rds), but explicitly specifying a customer-managed KMS key provides better control for compliance scenarios. Applying encryption only through AWS Backup service does not encrypt the RDS-native snapshots. Parameter group modifications affect database behavior but not encryption state. ---
Right Answer: B
Quiz
Question 6/106/10
Workload-Specific Database Design
Workload-Specific Database Design
Workload-Specific Database Design
Your application requires ACID transactions, complex SQL queries, and strict data consistency. You also need automatic failover within seconds and read replicas for reporting. The database should scale vertically with minimal operational overhead. Which service should you choose?
Select the answer:Select the answer
1 correct answer
A.
Amazon DynamoDB with global tables
B.
Amazon Neptune for relationship queries
C.
Amazon DocumentDB with sharding
D.
Amazon Aurora with multi-AZ deployment
Explanation: Amazon Aurora is the best choice for applications requiring ACID transactions, complex SQL queries, and strict consistency. Aurora provides automatic failover with recovery time objectives under one minute, automatic read replica creation for scaling read operations, and minimal operational overhead through managed backups and patching. Aurora scales vertically through larger instance types and can handle complex analytical queries that DynamoDB and DocumentDB would struggle with. While DynamoDB provides eventual consistency and multi-region replication, it lacks true ACID transactions and complex query support. Neptune is designed for graph data, not traditional relational workloads. ---
Right Answer: D
Quiz
Question 7/107/10
Deployment and Migration
Deployment and Migration
Deployment and Migration
You are implementing a blue-green deployment strategy for a critical MySQL database migration to RDS. What is the primary advantage of this approach?
Select the answer:Select the answer
1 correct answer
A.
It eliminates the need for database backups during migration
B.
It allows instant rollback to the previous version with zero downtime if issues occur
C.
It automatically duplicates all user data to both environments
D.
It removes the requirement for application code changes
Explanation: Blue-green deployment maintains two identical production environments where one (blue) is currently active while the other (green) is updated with the new version. This strategy enables instant switching between environments if the migration encounters critical issues, providing a rapid rollback mechanism with minimal downtime. The approach requires careful planning for data consistency, particularly handling transactions that occur during the cutover period. Application changes are still necessary to redirect traffic from blue to green. Backups remain essential for disaster recovery regardless of deployment strategy. User data is not automatically duplicated; the green environment must be synchronized with production data before cutover through DMS or similar replication mechanisms. ---
Right Answer: B
Quiz
Question 8/108/10
Management and Operations
Management and Operations
Management and Operations
Your organization has an RDS MySQL database with automated backups enabled and a backup retention period of 7 days. A database corruption is discovered on day 8, requiring recovery to a point 6 days ago. What should you do?
Select the answer:Select the answer
1 correct answer
A.
Use point-in-time recovery to restore to the exact time before corruption occurred
B.
Restore from the last automated snapshot before the corruption window
C.
Manually create a new snapshot and restore from it
D.
Contact AWS Support to extend the backup retention period retroactively
Explanation: With a 7-day retention period and corruption discovered on day 8, the automated backups from 6 days ago are still available. Point-in-time recovery (PITR) requires current backups and transaction logs; since the issue is discovered after the 7-day window for a recovery 6 days ago, you would restore from the last available automated snapshot. Option A sounds correct but the timing is critical—PITR works within the automated backup retention window. Option C creates unnecessary overhead when automated backups already exist. Option D is incorrect because AWS cannot retroactively extend backups that have already been deleted. Understanding the backup retention window and PITR limitations is crucial for recovery planning. ---
Right Answer: B
Quiz
Question 9/109/10
Monitoring and Troubleshooting
Monitoring and Troubleshooting
Monitoring and Troubleshooting
You are troubleshooting a DynamoDB table that is experiencing intermittent throttling. The application logs show RequestLimitExceeded errors occurring at specific times of day. What should you examine first to understand the throttling pattern?
Select the answer:Select the answer
1 correct answer
A.
DynamoDB consumed capacity metrics in CloudWatch and the request rate pattern
B.
DynamoDB stream records to identify the operations causing throttling
C.
The application connection pool settings to ensure proper connection reuse
D.
AWS CloudTrail logs filtered for DynamoDB API calls
Explanation: DynamoDB consumed capacity metrics in CloudWatch show read and write units consumed relative to provisioned capacity. By examining these metrics alongside the timing of RequestLimitExceeded errors, you can identify whether throttling is caused by insufficient provisioned capacity or by capacity spikes that exceed provisioned levels. This reveals whether you need to increase provisioned capacity, enable auto-scaling, or switch to on-demand billing. DynamoDB streams don't track throttling. Application connection settings affect connection management, not throttling. CloudTrail logs API calls but don't show consumed capacity metrics.
Right Answer: A
Quiz
Question 10/1010/10
Database Security
Database Security
Database Security
An organization uses RDS Proxy to manage connections to an Aurora PostgreSQL database. The Proxy is configured to use Secrets Manager for credential rotation. During a security audit, you need to verify that SSL/TLS encryption is enforced for all connections between the application and the Proxy. What is the best approach to enforce this requirement?
Select the answer:Select the answer
1 correct answer
A.
Set the Proxy client authentication type to "MYSQL_NATIVE_PASSWORD" in the connection string
B.
Configure the RDS Proxy with "require_secure_transport" parameter in the target group
C.
Enable TLS requirement in RDS Proxy by using the "force-ssl" connection option
D.
Set the RDS Proxy connection authentication protocol to "TLS" and enforce at the DB instance level
Explanation: RDS Proxy enforces TLS encryption for client connections using the "require_secure_transport" parameter, which can be set in the proxy configuration to require SSL/TLS connections. This setting ensures all connections between the application and the Proxy are encrypted. The MYSQL_NATIVE_PASSWORD authentication method is unrelated to encryption protocol enforcement. While database instances also support SSL/TLS enforcement through parameters like "require_secure_transport" at the database level, the proxy-level setting takes precedence for connections coming through the Proxy. The "force-ssl" option is not a standard RDS Proxy connection parameter; instead, the proxy configuration enforces this requirement directly. ---
DBS-C01: Amazon AWS Certified Database - Specialty Exam Practice test unlocks all online simulator questions
Thank you for choosing the free version of the DBS-C01: Amazon AWS Certified Database - Specialty Exam practice test! Further deepen your knowledge on Amazon Simulator; by unlocking the full version of our DBS-C01: Amazon AWS Certified Database - Specialty Exam Simulator you will be able to take tests with over 200 constantly updated questions and easily pass your exam. 98% of people pass the exam in the first attempt after preparing with our 200 questions.
What to expect from our DBS-C01: Amazon AWS Certified Database - Specialty Exam practice tests and how to prepare for any exam?
The DBS-C01: Amazon AWS Certified Database - Specialty Exam Simulator Practice Tests are part of the Amazon Database and are the best way to prepare for any DBS-C01: Amazon AWS Certified Database - Specialty Exam exam. The DBS-C01: Amazon AWS Certified Database - Specialty Exam practice tests consist of 200 questions and are written by experts to help you and prepare you to pass the exam on the first attempt. The DBS-C01: Amazon AWS Certified Database - Specialty Exam database includes questions from previous and other exams, which means you will be able to practice simulating past and future questions. Preparation with DBS-C01: Amazon AWS Certified Database - Specialty Exam Simulator will also give you an idea of the time it will take to complete each section of the DBS-C01: Amazon AWS Certified Database - Specialty Exam practice test . It is important to note that the DBS-C01: Amazon AWS Certified Database - Specialty Exam Simulator does not replace the classic DBS-C01: Amazon AWS Certified Database - Specialty Exam study guides; however, the Simulator provides valuable insights into what to expect and how much work needs to be done to prepare for the DBS-C01: Amazon AWS Certified Database - Specialty Exam exam.
DBS-C01: Amazon AWS Certified Database - Specialty Exam Practice test therefore represents an excellent tool to prepare for the actual exam together with our Amazon practice test . Our DBS-C01: Amazon AWS Certified Database - Specialty Exam Simulator will help you assess your level of preparation and understand your strengths and weaknesses. Below you can read all the quizzes you will find in our DBS-C01: Amazon AWS Certified Database - Specialty Exam Simulator and how our unique DBS-C01: Amazon AWS Certified Database - Specialty Exam Database made up of real questions:
You can prepare for the DBS-C01: Amazon AWS Certified Database - Specialty Exam exams with our mobile app. It is very easy to use and even works offline in case of network failure, with all the functions you need to study and practice with our DBS-C01: Amazon AWS Certified Database - Specialty Exam Simulator.
Use our Mobile App, available for both Android and iOS devices, with our DBS-C01: Amazon AWS Certified Database - Specialty Exam Simulator . You can use it anywhere and always remember that our mobile app is free and available on all stores.
Our Mobile App contains all DBS-C01: Amazon AWS Certified Database - Specialty Exam practice tests which consist of 200 questions and also provide study material to pass the final DBS-C01: Amazon AWS Certified Database - Specialty Exam exam with guaranteed success.
Our DBS-C01: Amazon AWS Certified Database - Specialty Exam database contain hundreds of questions and Amazon Tests related to DBS-C01: Amazon AWS Certified Database - Specialty Exam Exam. This way you can practice anywhere you want, even offline without the internet.