Knowledge check

Choose the best response for each of the questions below. Then select Check your answers.

Check your knowledge

Which of the following is a limitation of the Azure SQL Managed Instance link feature?

The link feature can only replicate databases of a certain size.

The link feature cannot replicate databases that use In-Memory OLTP objects on the General Purpose service tier.

The link feature cannot replicate databases that use columnstore indexes.

How many databases can be placed into a single availability group for one Azure SQL Managed Instance link?

Only one database

Multiple databases

Multiple databases, as long as the database size is less than a certain limit

What is one way in which Microsoft Purview policies can provide access to SQL Server?

Creating a login and mapping it to a Purview policy

Creating a policy in Purview based on a Microsoft Entra account

Creating a role in SQL Server that maps to a Purview policy

You must answer all questions before checking your work.