Free DP-300 Mock Exam – Practice Online Confidently

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?

When establishing a secure connection between a client application and Azure SQL Database, which protocol provides encryption both in transit and at rest?

You are designing an enterprise data warehouse in Azure Synapse Analytics that will contain a table named Customers. Customers will contain credit card information.

You need to recommend a solution to provide salespeople with the ability to view all the entries in Customers. The solution must prevent all the salespeople from viewing or inferring the credit card information.

What should you include in the recommendation?

Your on-premises network contains a Microsoft SQL Server 2016 server that hosts a database named db1.

You have an Azure subscription.

You plan to migrate db1 to an Azure SQL managed instance.

You need to create the SQL managed instance. The solution must minimize the disk latency of the instance.

Which service tier should you use?

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?