Database, authentication and authorisation

Question 1

CosmosDB

Answer 1

Globally distributed database. It is super-fast and easy to manage. Scale to infinite performance and size. Can be costly.

Question 2

Azure SQL

Answer 2

Fully managed and using stable MS SQL Technology. Compatible with on-prem SQL Servers.

Question 3

Azure Database for MySQL

Answer 3

A very popular community driven open-source DB that is used in millions of applications. Very robust and stable.

Question 4

Azure Database for PostgreSQL

Answer 4

Also a very popular choice of relational database. Provides enterprise features like horizontal scaling. Azure offers a managed version.

Question 5

Database Migration Services

Answer 5

Migration of almost any kind of database to Azure SQL or SQL server. Guides, step-by-step instructions, comprehensive documentation.

Question 6

Authentication

Answer 6

• Make sure you are you
• Confirming identity
• First test for access

Question 7

Authorisation

Answer 7

• Comes after authentication
• Granular control for access.
• Should this user have access to these resources

Question 8

Azure AD

Answer 8

Azure active directory is not normal Active Directory
AAD service:
• Mandatory – can’t have an azure account with an AAD service
• First user - Every Azure account needs a first user and this user is the AAD instance

Question 9

MFA

Answer 9

An extra layer of security using something you know, something you have and something you are.