DP-300 Exam Study Guide (Administering Relational Databases on Azure)

Dp-300 Administering Relational Databases on Azure certificate Study Guide

Preparing for the DP-300 Administering Relational Databases on Azure exam? Don't know where to start? This post is the DP-300 Certificate Study Guide (with links to each exam objective).

I have curated a list of articles from Microsoft documentation for each objective of the DP-300 exam. Please share the post within your circles so it helps them to prepare for the exam.

DP-300 Administer Relational Databases Course

DP-300 Azure DB Administrator Practice Test

To view other Azure certificate study guides, click here

Full Disclosure: Some of the links in this post are affiliate links. I receive a commission when you purchase through them.

Looking for DP-300 dumps? Read This!

Using dp-300 exam dumps can get you permanently banned from taking any future Microsoft certificate exam. Read the FAQ page for more information. However, I strongly suggest you validate your understanding with practice questions.

Plan and Implement Data Platform Resources (15-20%)

Deploy Resources by Using Manual Methods

Recommend an Appropriate Database Offering Based on Specific Requirements

Configure Resources for Scale and Performance

Evaluate a Strategy for Moving to Azure

Implement a Migration or Upgrade Strategy for Moving to Azure

DP-300

Amazon link (affiliate)

Implement a Secure Environment (15-20%)

Configure Database Authentication by Using Platform and Database Tools

Configure database authorization by using platform and database tools

Configure database and object-level permissions using graphical tools

https://docs.microsoft.com/en-us/sql/authentication-access/getting-started-with-database-engine-permissions

Apply the principle of least privilege for all securables

https://docs.microsoft.com/en-us/sql/authorization-and-permissions-in-sql-server

Implement Security for Data at Rest

Implement Security for Data in Transit

Implement Compliance Controls for Sensitive Data

Monitor and Optimize Operational Resources (15-20%)

Monitor Activity and Performance

Implement Performance-related Maintenance Tasks

Identify Performance-related Issues

Configure Resources for Optimal Performance

Configure a User Database for Optimal Performance

Optimize Query Performance (5-10%)

Review Query Plans

Evaluate Performance Improvements

Review Database Table and Index Design

Perform Automation of Tasks (10-15%)

Create Scheduled Tasks

Evaluate and Implement an Alert and Notification Strategy

Manage and Automate Tasks in Azure

Plan and Implement a High Availability and Disaster Recovery (HADR) Environment (15-20%)

Recommend an HADR Strategy for a Data Platform Solution

Test a HADR Strategy by Using Platform, OS and, Database Tools

Perform Backup and Restore a Database by Using Database Tools

Configure HA/DR by Using OS, Platform, and Database Tools

Perform Administration by Using T-SQL (10-15%)

Examine System Health

Monitor Database Configuration by Using T-SQL

Perform Backup and Restore a Database by Using T-SQL

Manage Authentication by Using T-SQL

Manage Authorization by Using T-SQL

This brings us to the end of DP-300 Study Guide

What do you think? Let me know in the comments section if I have missed out on anything. Also, I love to hear from you about how your preparation is going on!

In case you are looking for other Azure certification exams check out this page

Follow/Like ravikirans.com to receive updates

Sign up for Newsletter

Want to be notified as soon as I post? Subscribe to RSS feed / leave your email address in the subscribe section. Share the article to your social networks with the below links so it can benefit others.

Share the Article in Your Social Media Networks

  • 1
  • 1
  •  
  •  
  •  
    2
    Shares

You may also like