Study material for exam AZ-101 Microsoft Azure Integration and Security

By:   |   Updated: 2019-04-05   |   Comments (2)   |   Related: More > Professional Development Certifications


I want to pass the Microsoft exam AZ-101 related to Azure. Can you let me know if you have any tips or study materials to help pass this exam?


In this tip we will give you links you can use to study and prepare for this test.

What is Azure?

It is a Microsoft Cloud computing service. It includes thousands of services like web pages, virtual machines (in Linux, Windows and more), databases in the cloud, applications, IA and more.

Who should take this exam?

This exam is oriented to Azure Administrators in charge of security, networking, load balancing, virtual networking and the migration of on-premises servers to Azure.

I am a SQL Server DBA. Is this exam for me?

If your company is big you may have an Azure Administrator and you may need this exam to coordinate and help to migrate your SQL Server on-premises to Azure SQL or to an Azure Virtual Machine (VM). Also, this exam will help you handle the security of your machines and databases, because you will learn about multi-factor authentication (MFA) and Manage Role Based Access Control (RBAC). The MFA is used in Azure SQL, so you may need to understand the security terms. If your company is small and you are in charge of Azure because you are the Azure administrator and the DBA, this exam is a must.

In other words, if you are a DBA, this exam is NOT A MUST, but it is something recommended if you will migrate to Azure or you are working or planning to migrate to Azure. If you are in charge of Azure, this exam is a must.

Is the exam difficult?

Not so much. The AZ certification series are simpler than previous versions of Azure Exams (70-53x series, which was a nightmare and you needed to be Ironman+Hulk+Thor to pass). If you do not have any experience in Azure, yes, you will need to study a lot, but it is possible to pass.

Which books would you recommend for this exam?

The following book list will be useful:

Which courses are recommended for this exam?

The following courses will be useful:

Could you provide some links to study, for this exam?

Yes. The following links will be useful:

Evaluate and perform server migration to Azure

Implement and manage application services

Implement advanced virtual networking

Secure identities

Next Steps

For more information about this exam refer to these links:

Last Updated: 2019-04-05

get scripts

next tip button

About the author
MSSQLTips author Daniel Calbimonte Daniel Calbimonte is a Microsoft SQL Server MVP, Microsoft Certified Trainer and Microsoft Certified IT Professional.

View all my tips
Related Resources

Comments For This Article

Friday, April 05, 2019 - 12:27:16 PM - Greg Robidoux Back To Top

Thanks this has been updated.

Friday, April 05, 2019 - 11:52:37 AM - NNN Back To Top

AZ-100 or AZ-101?


Recommended Reading

Study material for exam 98-364 Database Fundamentals

Study material for exam 70-462 Administering Microsoft SQL Server 2012 and 2014 Databases

Study material for exam 70-761 Querying Data with Transact-SQL

Study material for exam 70-778 Analyzing and Visualizing Data with Microsoft Power BI (beta)

Study material for exam 70-767 Implementing a SQL Data Warehouse

get free sql tips
agree to terms

Learn more about SQL Server tools