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 planning the migration of the SERVER1 databases. The solution must meet the business requirements.
What should you include in the migration plan? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:
Azure Database Migration service
Box 1: Premium 4-VCore
Scenario: Migrate the SERVER1 databases to the Azure SQL Database platform.
* Minimize downtime during the migration of the SERVER1 databases.
Premimum 4-vCore is for large or business critical workloads. It supports online migrations, offline migrations, and faster migration speeds.
Incorrect Answers:
The Standard pricing tier suits most small- to medium- business workloads, but it supports offline migration only.
Box 2: A VPN gateway
You need to create a Microsoft Azure Virtual Network for the Azure Database Migration Service by using the Azure Resource Manager deployment model, which provides site-to-site connectivity to your on-premises source servers by using either ExpressRoute or VPN.
Reference:
https://azure.microsoft.com/pricing/details/database-migration/
https://docs.microsoft.com/en-us/azure/dms/tutorial-sql-server-azure-sql-online

Comment: *

Name: *

Email: *

Verification: *

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?

• A.row-level security
• B.data masking
• C.Always Encrypted
• D.column-level security

Comment: *

Name: *

Email: *

Verification: *

You have a SQL pool in Azure Synapse that contains a table named dbo.Customers. The table contains a column name Email.
You need to prevent nonadministrative users from seeing the full email addresses in the Email column. The users must see values in a format of [email protected] instead.
What should you do?

• A.From the Azure portal, set a mask on the Email column.
• B.From the Azure portal, set a sensitivity classification of Confidential for the Email column.
• C.From Microsoft SQL Server Management Studio, set an email mask on the Email column.
• D.From Microsoft SQL Server Management Studio, grant the SELECT permission to the users for all the columns in the dbo.Customers table except Email.

Comment: *

Name: *

Email: *

Verification: *

You are developing an application that uses Azure Data Lake Storage Gen 2.
You need to recommend a solution to grant permissions to a specific application for a limited time period.
What should you include in the recommendation?

• A.role assignments
• B.account keys
• C.shared access signatures (SAS)
• D.Azure Active Directory (Azure AD) identities

Comment: *

Name: *

Email: *

Verification: *