{"id":690,"date":"2020-06-23T03:29:48","date_gmt":"2020-06-23T03:29:48","guid":{"rendered":"https:\/\/reviewnprep.com\/blog\/?p=690"},"modified":"2021-03-27T15:05:57","modified_gmt":"2021-03-27T15:05:57","slug":"how-to-prepare-for-aws-certified-database-specialty","status":"publish","type":"post","link":"https:\/\/reviewnprep.com\/blog\/how-to-prepare-for-aws-certified-database-specialty\/","title":{"rendered":"How to Prepare for AWS Certified Database Specialty"},"content":{"rendered":"\n<p class=\"has-very-dark-gray-color has-very-light-gray-background-color has-text-color has-background has-medium-font-size\"><strong>Prerequisites<\/strong><\/p>\n\n\n\n<p class=\"has-very-dark-gray-color has-text-color\">The AWS Database exam blueprint recommends that examinee\u2019s have at least 5 years\u2019 experience with database technologies and two years\u2019 experience working with AWS. You should be familiar with open source SQL and NoSQL databases.<\/p>\n\n\n\n<p class=\"has-very-dark-gray-color has-text-color\">In addition, I advise you have at least AWS Associate Developer or DevOps Professional certificate before taking the exam. This would make it easier to answer questions on deployments and monitoring.<\/p>\n\n\n\n<p class=\"has-very-dark-gray-color has-very-light-gray-background-color has-text-color has-background has-medium-font-size\"><strong>Preparation<\/strong><\/p>\n\n\n\n<p class=\"has-very-dark-gray-color has-text-color\">I went through all the material prescribed in the ramp up guide. These included courses on AWS training website, user guides for all AWS purpose built databases, whitepapers and AWS Databases blog posts. I also watched re: Invent videos on DynamoDB, Elasticache, QLDB, Redshift and DocumentDB.<\/p>\n\n\n\n<p class=\"has-very-dark-gray-color has-text-color\">As part of preparations, I also used practice tests and video courses on DynamoDB and Migration from Whizlabs. I wrapped it up with the practice exam from AWS (20 questions).<\/p>\n\n\n\n<p class=\"has-very-dark-gray-color has-very-light-gray-background-color has-text-color has-background has-medium-font-size\"><strong>General Overview<\/strong><\/p>\n\n\n\n<p class=\"has-very-dark-gray-color has-text-color\"><span style=\"text-decoration: underline;\"><strong>RDS and Aurora are the most tested products on the exam<\/strong><\/span>. These products account for 50-60% of questions on the exam. You should know the architectures of both RDS and Aurora. Features that both share and those that supported by only Aurora. DynamoDB and DocumentDB may account for about 20% of the questions. All other purpose built database products account for the remaining questions.<\/p>\n\n\n\n<p class=\"has-very-dark-gray-color has-text-color\"><span style=\"text-decoration: underline;\"><strong>Before you take the exam, you should know how the following services work on AWS: VPCs, Security groups, IAM, CloudWatch, Cloudformation, CloudTrail and S3.<\/strong><\/span><\/p>\n\n\n\n<p class=\"has-very-dark-gray-color has-text-color\">Even though the exam is theoretical, experience with the purpose built database services on AWS should guarantee success.<\/p>\n\n\n\n<p class=\"has-very-dark-gray-color has-very-light-gray-background-color has-text-color has-background has-medium-font-size\"><strong>Exam Domains<\/strong><\/p>\n\n\n\n<p class=\"has-very-dark-gray-color has-text-color has-medium-font-size\"><strong>Workload Specific Database design<\/strong><\/p>\n\n\n\n<p class=\"has-very-dark-gray-color has-text-color\">This section requires you to understand all AWS database offerings and their use cases.<\/p>\n\n\n\n<p class=\"has-very-dark-gray-color has-text-color\">You should consider the following for the exam:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>One size does not fit all. There is a database solution for every type of workload. The exam tests you on choosing the right database for the given scenario.<\/li><li>RDS (5 engines), (PostgreSQL and MySQL), Aurora, Redshift, Elasticache (Redis and Memcached), DynamoDB, DocumentDB, Keyspaces, Neptune, Timestream, QLDB are the Database offerings tested on the exam.<\/li><li>The architectures of all the database offerings. &nbsp;Understand how to implement disaster recovery and high availability when using these services.<\/li><li>Understand how these services are charged, their performance (latencies) and best practices in securing data.<\/li><\/ul>\n\n\n\n<p class=\"has-very-dark-gray-color has-pale-cyan-blue-background-color has-text-color has-background has-medium-font-size\"><strong>Pro tip:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>RDS and Neptune use the multi-AZ architecture.<\/li><li>Aurora and DocumentDB use the shared volume architecture. Aurora supports global databases, DocumentDB does not. Compute is separated from storage and hence both are scaled differently.<\/li><li>DynamoDB supports global multi-write (hence gives low latency reads and writes). Aurora Global databases support only one writer endpoint. Aurora Multi-Master databases are regional not global.<\/li><li>Aurora Serverless databases are best suited for development and can shut down when there are no reads or writes.<\/li><li>DynamoDB, Keyspaces and QLDB are serverless.<\/li><\/ul>\n\n\n\n<p class=\"has-very-dark-gray-color has-text-color has-medium-font-size\"><strong>2. Deployment and Migration<\/strong><\/p>\n\n\n\n<p class=\"has-very-dark-gray-color has-text-color\">&nbsp;Consider the following for the exam:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>How to use Cloud Formation for deployments. Understand drifts, stacks, stack sets and change sets.<\/li><li>You should be familiar with the roles DMS,SCT and WQF play in migration<\/li><li>You should know when to use native migration tools, their limitations and which tool to use for which migration task<\/li><li>How to migrate LOBs<\/li><li>You should know which databases support cloning and when to use Aurora read replica to migrate a database<\/li><li>You should be know how to validate migrated data.<\/li><li>When to use snowball or Direct connect<\/li><\/ul>\n\n\n\n<p class=\"has-very-dark-gray-color has-pale-cyan-blue-background-color has-text-color has-background has-medium-font-size\"><strong>Pro Tip:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Oracle handles null and time zones differently from PostgreSQL.<\/li><li>DMS is used for online migration (slow but minimizes downtime), native migration tools are used for offline migration (quick but causes downtime). You can combine both native tools and DMS (CDC) for the best of both worlds.<\/li><\/ul>\n\n\n\n<p class=\"has-very-dark-gray-color has-text-color has-medium-font-size\"><strong>3. Management and Operations<\/strong><\/p>\n\n\n\n<p class=\"has-very-dark-gray-color has-text-color\">This section tests your ability to perform everyday database management activities.<\/p>\n\n\n\n<p class=\"has-very-dark-gray-color has-text-color\">You should know the following for the exam:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Automatic\/continuous backups and manual backups<\/li><li>Backup and maintenance windows<\/li><li>Considerations for minor and major engine upgrades<\/li><li>How backups, copying\/sharing snapshots and read replicas meet RTO and RPO objectives<\/li><li>Parameter Groups and Option groups (permanent and persistent options)<\/li><li>How to Secrets Manager works with Databases<\/li><li>When changes are applied \u2013 rebooting instances or maintenance windows. How to applying changes immediately.<\/li><li>When to use DAX and Elasticache<\/li><li>When changes are applied \u2013 rebooting instances or maintenance windows. How to applying changes immediately.<\/li><\/ul>\n\n\n\n<p class=\"has-very-dark-gray-color has-text-color has-medium-font-size\"><strong>4. Monitoring and Troubleshooting<\/strong><\/p>\n\n\n\n<p class=\"has-very-dark-gray-color has-text-color\">This section tests your ability use AWS services to monitor workloads and troubleshooting common database issues.<\/p>\n\n\n\n<p class=\"has-very-dark-gray-color has-text-color\">You should know the following for the exam:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>CloudWatch, CloudWatch Logs, RDS Events, Performance Insights, CloudTrail , Enhanced Monitoring , CloudWatch Application Insights for .Net and SQL Server and Trusted Advisor<\/li><li>Basic troubleshooting for the database offerings<\/li><li>Best practices for each database engine.<\/li><li>Read about IOPS, Tuning queries, Secondary indexes, TTL, sharding, Read Replicas etc.<\/li><\/ul>\n\n\n\n<p class=\"has-very-dark-gray-color has-text-color has-medium-font-size\"><strong>5. Security<\/strong><\/p>\n\n\n\n<p class=\"has-very-dark-gray-color has-text-color\">You will find questions on securing database workloads on AWS.<\/p>\n\n\n\n<p class=\"has-very-dark-gray-color has-text-color\">You should know the following for the exam:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>KMS \u2013 which services use AWS managed keys and CMKs. Disabled\/Deleted keys and their impact on workloads. Key rotation<\/li><li>How IAM integrates with the various database products and how IAM DB Authentication works. Understand which services support fine-grained access control and those that do not<\/li><li>Data in Transit \u2013 How to enforce data encryption on each RDS engine. Data in transit for all other database offerings<\/li><li>VPC endpoints, VPN and Direct connect<\/li><li>Private subnets, NACLs and Security Groups<\/li><li>How to auditing works for different database products<\/li><li>Security controls supported by the different database engines<\/li><\/ul>\n\n\n\n<p class=\"has-very-dark-gray-color has-very-light-gray-background-color has-text-color has-background has-medium-font-size\"><strong>Links to Resources used<\/strong><\/p>\n\n\n\n<p class=\"has-very-dark-gray-color has-text-color\">AWS Ramp-Up Guide: Databases<\/p>\n\n\n\n<p class=\"has-very-dark-gray-color has-text-color\">Exam Readiness: <a href=\"https:\/\/www.aws.training\/Details\/eLearning?id=47245\" target=\"_blank\" rel=\"noreferrer noopener\">AWS Certified Database \u2013 Specialty<\/a><\/p>\n\n\n\n<p class=\"has-very-dark-gray-color has-text-color\">AWS DynamoDB Deepdive \u2013<a href=\"https:\/\/www.whizlabs.com\/learn\/course\/aws-dynamodb-deep-dive-begineer-to-intermediate\/\" target=\"_blank\" rel=\"noreferrer noopener\"> Beginner to Intermediate<\/a> ($5)<\/p>\n\n\n\n<p class=\"has-very-dark-gray-color has-text-color\"><a rel=\"noreferrer noopener\" href=\"https:\/\/www.whizlabs.com\/learn\/course\/database-migration-to-aws-master-class\/\" target=\"_blank\">Database Migration to AWS Masterclass<\/a> ($5)<\/p>\n\n\n\n<p class=\"has-very-dark-gray-color has-text-color\"><a rel=\"noreferrer noopener\" href=\"https:\/\/www.whizlabs.com\/learn\/course\/aws-certified-database-specialty\" target=\"_blank\">Practice Tests<\/a> &#8211; 145 questions ($20)<\/p>\n\n\n\n<p class=\"has-very-dark-gray-color has-text-color has-medium-font-size\"><strong>I did it in two weeks, you can do it too. All the best !!!<\/strong><\/p>\n\n\n\n<p class=\"has-vivid-cyan-blue-color has-text-color\" style=\"font-size:18px\"><strong>Have questions? Participate in AWS discussions on our Forums. <a href=\"https:\/\/reviewnprep.com\/forums\/\">Click here<\/a>.<\/strong><\/p>\n\n\n\n<p class=\"has-very-dark-gray-color has-text-color\" style=\"font-size:18px\">Author: Emmanuel Koomson is a Product Owner, Solution Architect, 9X AWS Certified and a life long learner. You can connect with him on <a rel=\"noreferrer noopener\" href=\"https:\/\/www.linkedin.com\/in\/opanion\/\" target=\"_blank\">LinkedIn<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Prerequisites The AWS Database exam blueprint recommends that examinee\u2019s have at least 5 years\u2019 experience with database technologies and two years\u2019 experience working with AWS. You should be familiar with open source SQL and NoSQL databases. In addition, I advise you have at least AWS Associate Developer or DevOps Professional certificate before taking the exam. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":699,"comment_status":"closed","ping_status":"closed","sticky":true,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,91],"tags":[18,8,92],"class_list":["post-690","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-aws","category-aws-database-specialty","tag-aws","tag-aws-certification","tag-aws-database-specialty"],"_links":{"self":[{"href":"https:\/\/reviewnprep.com\/blog\/wp-json\/wp\/v2\/posts\/690"}],"collection":[{"href":"https:\/\/reviewnprep.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/reviewnprep.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/reviewnprep.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/reviewnprep.com\/blog\/wp-json\/wp\/v2\/comments?post=690"}],"version-history":[{"count":16,"href":"https:\/\/reviewnprep.com\/blog\/wp-json\/wp\/v2\/posts\/690\/revisions"}],"predecessor-version":[{"id":1959,"href":"https:\/\/reviewnprep.com\/blog\/wp-json\/wp\/v2\/posts\/690\/revisions\/1959"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/reviewnprep.com\/blog\/wp-json\/wp\/v2\/media\/699"}],"wp:attachment":[{"href":"https:\/\/reviewnprep.com\/blog\/wp-json\/wp\/v2\/media?parent=690"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/reviewnprep.com\/blog\/wp-json\/wp\/v2\/categories?post=690"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/reviewnprep.com\/blog\/wp-json\/wp\/v2\/tags?post=690"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}