You're attempting to authenticate users in your Azure SQL Database. Which two methods can you use to authenticate against Azure SQL using identities in Entra ID?

You have an Azure SQL database. The database contains a table that uses a columnstore index and is accessed infrequently.

You enable columnstore archival compression.

What are two possible results of the configuration? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

You have an Azure subscription that contains an Azure Data Factory version 2 (V2) data factory named df1. DF1 contains a linked service.

You have an Azure Key vault named vault1 that contains an encryption kay named key1.

You need to encrypt df1 by using key1.

What should you do first?

Your organization wants to deploy a SQL Server HA/DR solution in Azure. They have the following requirements:

Automatic failover without manual intervention.

Read and write operations should be possible on the primary replica, while only read operations should be allowed on the secondary replica.

Both primary and secondary replicas must reside in different Azure regions for disaster recovery purposes.

Which of the following configurations meets all the provided requirements?

You have two on-premises Microsoft SQL Server 2019 instances named SQL1 and SQL2.

You need to migrate the databases hosted on SQL1 to Azure. The solution must meet the following requirements:

• The service that hosts the migrated databases must be able to communicate with SQL2 by using linked server connections.

• Administrative effort must be minimized.

What should you use to host the databases?