AWS Certified Database - Specialty
Access The Exact Questions for AWS Certified Database - Specialty
💯 100% Pass Rate guaranteed
🗓️ Unlock for 1 Month
Rated 4.8/5 from over 1000+ reviews
- Unlimited Exact Practice Test Questions
- Trusted By 200 Million Students and Professors
What’s Included:
- Unlock 200 + Actual Exam Questions and Answers for AWS Certified Database - Specialty on monthly basis
- Well-structured questions covering all topics, accompanied by organized images.
- Learn from mistakes with detailed answer explanations.
- Easy To understand explanations for all students.
Master your AWS Certified Database - Specialty certification journey with proven study materials and pass on your first try!
Free AWS Certified Database - Specialty Questions
A company enables SSL/TLS on an Oracle RDS DB instance. Users cannot connect using valid credentials. What is the most likely cause? [RDS Oracle]
- A. Application must use the latest CA root certificate and include SSL in the connection string
- B. Security group is misconfigured
- C. IAM authentication not enabled
- D. Database parameter group is incorrect
Explanation
SSL connections require the client to trust the server’s certificate using the current CA root. Without updating the connection string and CA, connections fail.
Correct Answer Is:
A
How do you rotate RDS DB credentials? [RDS]
- A. Manually reset in console
- B. Use Secrets Manager
- C. Modify DB parameter group
- D. Update CloudFormation template
Explanation
Secrets Manager allows automatic rotation of RDS credentials. This improves security and reduces operational overhead.
Correct Answer Is:
B
What is AWS QuickSight? [Analytics]
- A. SQL query engine
- B. Managed database
- C. BI tool for dashboards
- D. ETL service
Explanation
QuickSight is a business intelligence tool for creating dashboards and visualizations. It integrates with AWS data sources for reporting and analysis.
Correct Answer Is:
C
As a database administrator, you need to configure a new MySQL 5.6 compatible database in AWS. Its main cluster will be deployed in the Asia Pacific (Sydney) region. A secondary cluster is required in the US West (N. California) region to serve read traffic. The database must have high performance, and the latency of data replication between two regions should be within 1 second. Otherwise, there will be some application issues. Which method would you take to achieve this requirement? [Aurora]
- A. Create a Multi-AZ Aurora cluster
- B. Create an Aurora global database with the secondary cluster in the US West region
- C. Use standard RDS MySQL with read replicas in US West
- D. Use DynamoDB global tables
Explanation
The best approach is to create an Aurora global database with its primary cluster in the Asia Pacific region and a secondary read-only Aurora cluster in the US West region. An Aurora global database consists of one primary region and multiple read-only secondary regions, supporting low-latency replication (typically under 1 second), which ensures high performance and meets the application's latency requirement.
Correct Answer Is:
B
What happens to a source DB's read replicas if it is deleted for PostgreSQL vs. MySQL/MariaDB? [RDS]
- A. All replicas are deleted for both
- B. PostgreSQL: replicas promoted; MySQL/MariaDB: replicas remain active
- C. MySQL/MariaDB: replicas promoted; PostgreSQL: replicas deleted
- D. All replicas remain read-only
Explanation
For MySQL/MariaDB, read replicas continue to function even if the source DB is deleted. For PostgreSQL, read replicas are promoted to standalone DB instances and can handle both read and write traffic. This ensures continuity of service.
Correct Answer Is:
B
Several AWS Aurora MySQL databases exist in an organization with multiple IAM users and roles needing access. An authentication method is required to manage database access using IAM instead of database passwords. Which method should be used? [Aurora]
- A. Store IAM credentials in the database
- B. Use standard MySQL passwords only
- C. Enable IAM authentication for Aurora, create database users, and assign IAM policies with rds-db:connect action
- D. Use CloudWatch to authenticate IAM users
Explanation
IAM authentication should be enabled for Aurora DB clusters. Database users are created in the DB, and IAM policies granting the rds-db:connect action are assigned to IAM users and roles. This allows secure authentication without managing separate database passwords.
Correct Answer Is:
C
RDS MySQL uses PITR and read replicas. After recovery, the replica shows "incompatible database activity for restoring functionality." How should this be handled? [RDS]
- A. Ignore the error
- B. Re-create the read replica after restarting
- C. Enable Multi-AZ
- D. Use a snapshot
Explanation
If the replicated DB instance uses in-memory tables, the read replica may fail to restore data properly. The solution is to recreate the read replica after restarting. This ensures that the replica is consistent with the source database.
Correct Answer Is:
B
How do DB upgrades work for RDS read replicas, Multi-AZ, and Multi-Region? [RDS]
- A. RR: Synchronized; Multi-AZ: independent; Multi-Region: manual
- B. RR: Independent from source; Multi-AZ: upgrades applied to all instances together; Multi-Region: independent in each region
- C. RR: Manual; Multi-AZ: automatic; Multi-Region: synchronous
- D. RR: ASYNC; Multi-AZ: SYNC; Multi-Region: SYNC
Explanation
Read replicas upgrade independently from the source DB. Multi-AZ applies upgrades to the primary and all replicas together. Multi-Region upgrades must be handled independently in each region. This ensures minimal disruption and consistency.
Correct Answer Is:
B
A Database Specialist plans to migrate an on-premises key-value database to a fully-managed AWS service with unpredictable workloads. Which solution should be considered first? [DynamoDB]
- A. Amazon RDS
- B. Amazon Aurora
- C. Amazon DynamoDB with on-demand capacity mode
- D. Amazon ElastiCache
Explanation
Amazon DynamoDB on-demand automatically adjusts capacity based on workload demand. It provides cost-effective management for unknown or variable workloads and eliminates the need for manual scaling. This is ideal for applications with unpredictable traffic patterns.
Correct Answer Is:
C
A Database Specialist needs to migrate an on-premises MySQL database to Amazon RDS using AWS DMS with full load plus CDC for continuous replication. How should duplicate records on the target table be prevented? [DMS]
- A. Use transactional replication
- B. Ensure target tables have primary keys or unique indexes
- C. Disable CDC
- D. Filter out duplicate rows manually after migration
Explanation
Target tables must have primary keys or unique indexes to prevent duplicate records during migration. AWS DMS uses these constraints to enforce uniqueness while performing full load and change data capture replication.
Correct Answer Is:
B
How to Order
Select Your Exam
Click on your desired exam to open its dedicated page with resources like practice questions, flashcards, and study guides.Choose what to focus on, Your selected exam is saved for quick access Once you log in.
Subscribe
Hit the Subscribe button on the platform. With your subscription, you will enjoy unlimited access to all practice questions and resources for a full 1-month period. After the month has elapsed, you can choose to resubscribe to continue benefiting from our comprehensive exam preparation tools and resources.
Pay and unlock the practice Questions
Once your payment is processed, you’ll immediately unlock access to all practice questions tailored to your selected exam for 1 month .