Administering Relational Databases on Microsoft Azure DP-300

Candidates for this exam are database administrators and data management specialists that manage on-premises and cloud relational databases built with Microsoft SQL Server and Microsoft Azure Data Services.

View Schedule Enquire Now

7500+

Trained

20+

Certified Trainers

4.6

rating

N/A

Overview

Candidates for this exam are database administrators and data management specialists that manage on-premises and cloud relational databases built with Microsoft SQL Server and Microsoft Azure Data Services.

The Azure database administrator implements and manages the operational aspects of cloud-native and hybrid data platform solutions built on Azure Data Services and SQL Server. The Azure database administrator uses a variety of methods and tools to perform day-to-day operations, including applying knowledge of using T-SQL for administrative management purposes.

This role is responsible for management, availability, security and performance monitoring and optimization of modern relational database solutions. This role works with the Azure data engineer role to manage operational aspects of data platform solutions.

Key Features of the course

Great Practical oriented Hands-On Lab Sessions

50% plus hands-on lab sessions to encourage Thinking-Based Learning

Renowned Microsoft Azure Partner

Being a Microsoft Learning Partner provides us with the edge over competition

Well-structured use-cases based sessions

Well-structured use-cases to simulate challenges encountered in a Real-World environment

Mentoring competency driven session

Microsoft certified instructor-led training and mentoring sessions to develop Competency-Based Learning

Relevant Study Material

Get relevant study material designed by industry experts

Intensive Interactive Sessions

Interactive-rich virtual and face-to-face classroom teaching to inculcate Problem-Based Learning

Curriculum

Topics Covered

Module 1: The Role of The Azure Database Administrator
- Azure Data Platform Roles
- Azure Database Platforms and Options
- SQL Server Compatibility Levels
- Azure Preview Features .
- Using the Azure Portal and SQL Server Management Studio
- Provision a SQL Server on an Azure Virtual Machine
- Connect to SQL Server and Restore a Backup
Module 2: Plan and Implement Data Perform Resources
- Deploying SQL Server using IaaS
- Deploying SQL Server using PaaS
- Deploying Open-Source Database Solutions on Azure
- Deploying Azure SQL Database
- Deploy a VM using an ARM template
- Configure resources needed prior to creating a database
- Deploy an Azure SQL Database
- Register the Azure SQL Database instance in Azure Data Studio and validate connectivity
- Deploy PostgreSQL or MySQL using a client tool to validate connectivity
Module 3: Implement a Secure Environment
- Lesson:
- Configure Database Authentication
- Configure Database Authorization
- Implement Security for Data at Rest
- Implement Security for Data in Transit
- Implement Compliance Controls for Sensitive Data Templates
- Implement a Secure Environment
- Enable Advanced Data Security and Data Classification
- Manage access to database objects
- Manage access to database objects
Module 4: Monitor and optimize Operational Resources
- Baselines and Performance Monitoring
- Major Causes of Performance Issues
- Configuring Resources for Optimal Performance
- User Database Configuration
- Performance-related Maintenance Tasks
- Monitor and Optimize Resources
- Isolate CPU Problems
- Use Query Store observe blocking problems
- Detect and correct fragmentation issues
Module 5: Optimize Query Performance
- Explore Performance-based Database Design
- Understanding SQL Server Query Plans
- Evaluate Performance Improvements
- Query Performance Troubleshooting
- Identify issues with database design AdventureWorks2017
- Isolate problem areas in poorly performing queries in AdventureWorks2017
- Use Query Store to detect and handle regression in AdventureWorks2017
- Use query hints to impact performance in AdventureWorks2017
Module 6: Automation of Tasks
- Setting up Automatic Deployment
- Defining Scheduled Tasks
- Configuring Extended Events
- Managing Azure PaaS resources Using Automated Methods
- Deploy an Azure template from a Quickstart template on GitHub
- Configure notifications based on performance metrics
- Deploy an Azure Automation Runbook (or elastic job) to rebuild indexes on an Azure SQL Database
Module 7:Plan and Implement a High Availability and Disaster Recovery Environment
- High Availability and Disaster Recovery Strategies
- IaaS Platform and Database Tools for HADR
- PaaS Platform and Database Tools for HADR
- Database Backup and Recovery
- Plan and Implement a High Availability and Disaster Recovery Environment
- Create an Always On Availability Group
- Enable Geo-Replication for Azure SQL Database
- Backup to URL and Restore from URL

Prerequisite

Azure Fundamentals :
Azure Data Fundamentals .

Exam Details:

Name: AZ-104: Microsoft Azure Administrator

No. of Questions: 40 - 60

Duration: 140 minutes

Passing Score: 70%

Skills measured :

Plan and implement data platform resources (15-20%) .
Implement a secure environment (15-20%)
Monitor and optimize operational resources (15-20%) .
Optimize query performance (5-10%) .
Perform automation of tasks (10-15%)
Plan and implement a High Availability and Disaster Recovery (HADR) environment (15-20%)
Perform administration by using T-SQL (10-15%)

What does Xebia provide differently?

Step into the realm of learning for an all-inclusive growth. Xebia is a pioneering IT consultancy and service provider that aims at Enterprise Development, Agile Development, DevOps, and Outsourcing Services.

World-class Training

Xebia Academy offers an intensive learning program and industry-specific training courses. It’s a globally acclaimed Microsoft Partner for Microsoft Azure training and certification courses. ReadmoreReadless

Boon To Career

Xebia offers excellent consultancy, innovative tools, and continuous career growth. We will train you to become a Cloud Computing expert.ReadmoreReadless

Expert Advantage

Get trained by our in-House Azure experts with an average of 18 years of experience: Azure Experts with extensive knowledge of Microsoft Azure services. ReadmoreReadless

Flexible Learning

Pick the right course: You can choose a public class at our training centre, or learn with your colleagues in a customized, in-company training program, facilitated on-site at your location, anywhere in the world. ReadmoreReadless

Global Experience

18 years of professional training experience and trusted by over 1,00,000 professionals worldwide. Xebia Academy is the largest producer of Microsoft Azure certifications globally. ReadmoreReadless

Hands-on And Practical Learning Experience

Our trainers are hands-on Azure experts and provide interactive training sessions which let students master required skills in real-world scenarios, giving them an edge in the industry. ReadmoreReadless

Certification Process

01

Enroll in Administering Relational Databases on Microsoft Azure DP-300 course
02

Attend the DP-300 training
03

Get eligible to attempt the Exam DP-300
04

Pass the exam
05

Get certified as an Azure Professional

Industry Connect

Who should attend this course?

Data Architects
Application Developers

What skills will you learn in the course?

Cloud Computing and Azure

Learn the basics of cloud computing and Azure and getting started with subscriptions and accounts of Azure.ReadmoreReadless

Cloud Computing Advantages

Learn about the benefits of Cloud computing services, distinguish between its categories and get familiar with the terminology benefitting with Azure architecture. ReadmoreReadless

Tools and Services

Learn and discuss the core solutions that include Microsoft Azure’s tools and services.ReadmoreReadless

Network Safety

Explore the general security and features of network security, and ensuring safety of cloud resources.ReadmoreReadless

Identity Features

Learn about the identity, governance and privacy that helps Azure in making a secure access cloud resources.ReadmoreReadless

Cloud Governance

Learn how Azure affixes to general regulatory and compliance standards and how to make a cloud governance strategy.ReadmoreReadless

Why should you attend this course?

This BootCamp course is designed to help candidates pass the Microsoft DP-300 certification exam to become Microsoft certified Azure Database Administrator Associate

View Schedule Blogs

Program Visual Library

Lorem ipsum dolor sit amet

FAQs

The Microsoft AZ-104 certification exam is the replaced version of the AZ-103 exam. To become a Microsoft Certified Azure Administrator Associate, candidates will need to clear the AZ-104 exam. By taking up this Azure Administrator certification, candidates learn to implement, manage, and monitor an organization’s Microsoft Azure environment.

The Microsoft AZ-104 online training in Xebia offers candidates proper training and relevant study material to clear the new role-based AZ-104 certification exam targeted for Azure Administrators.

AZ-104 certification exam can be taken up by:

Azure administrators and engineers
System administrators
IT professionals
Anyone who wants to make their carrier in Azure Cloud
Can be a beginner and someone who has any kind of experience in any other cloud.

Candidates need to answer between 40-60 questions. However, the number of questions may change as and when changes in technology and job roles occur.

Candidates will get 180 minutes to complete the Microsoft Azure Administrator Associate exam.

The Microsoft Azure Administrator certification cost ?4,800 in India. The Microsoft Azure Expert and Associate level certification exams are typically priced at US$165. The exam cost is mostly priced according to the currency values in specific regions and countries. However, the exam prices are subject to change and may also vary depending on the additional taxes that may apply in some countries and regions.

Candidates will need to score 700 to pass the Microsoft Azure Administrator Associate exam. On each exam domain, a minimum score of 35 percent needs to be scored.

Candidates must wait for 24 hours to retake the AZ-104 exam. Also, candidates can log in to their certification dashboard to reschedule the exam .

You can renew your Microsoft Certifications by simply passing a free, unproctored, online renewal assessment on Microsoft Learn, instead of retaking exams. The assessments measure the skills you need to remain up to date in your job role. They’re shorter than the original exams because they focus only on the latest technology changes, Take the free online assessment and pass it?before your certification expires. When you pass, your certification extends for one year from its current expiration date.

Instructor-led training from Xebia helps you prepare best for Exam

Self-paced learning on Microsoft Learn

Take a practice test

Sign into the Certification Dashboard. For detailed instructions on how to sign in, visit:?Access your Certification Dashboard.

This certification is valid for two years. However, after two years, the certification will still be available on your transcript but in a different section from your active certifications.