You have an Azure Active Directory (Azure AD) tenant named contoso.com that contains a user named [email protected] and an Azure SQL managed instance named SQLMI1.
You need to ensure that [email protected] can create logins in SQLMI1 that map to Azure AD service principals.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Correct Answer:

1 - Grant SQLMI1 read access to Azure AD.
2 - Run CREATE LOGIN [email protected] FROM EXTERNAL PROVIDER on the master database
3 - Run ALTER SERVER ROLE securityadmin ADD MEMBER [email protected].
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/aad-security-configure-tutorial

Comment: *

Name: *

Email: *

Verification: *

You deploy a database to an Azure SQL Database managed instance.
You need to prevent read queries from blocking queries that are trying to write to the database.
Which database option should set?

• A.PARAMETERIZATION to FORCED
• B.PARAMETERIZATION to SIMPLE
• C.Delayed Durability to Forced
• D.READ_COMMITTED_SNAPSHOT to ON

Comment: *

Name: *

Email: *

Verification: *

You have the following Azure Resource Manager template.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Correct Answer:

Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/purchasing-models
https://docs.microsoft.com/en-us/azure/azure-sql/database/single-database-create-arm-template-quickstart

Comment: *

Name: *

Email: *

Verification: *

You have an Azure SQL database named DB1.
You need to ensure that DB1 will support automatic failover without data loss if a datacenter fails. The solution must minimize costs.
Which deployment option and pricing tier should you configure?

• A.Azure SQL Database Premium
• B.Azure SQL Database serverless
• C.Azure SQL Database managed instance Business Critical
• D.Azure SQL Database Standard

Comment: *

Name: *

Email: *

Verification: *

You are creating a new notebook in Azure Databricks that will support R as the primary language but will also support Scala and SQL.
Which switch should you use to switch between languages?

• A.Error! Hyperlink reference not valid.]
• B.%<language>
• C.Error! Hyperlink reference not valid.]
• D.@<language>

Comment: *

Name: *

Email: *

Verification: *