You have an Azure subscription.
You plan to deploy an Azure SQL database by using an Azure Resource Manager template.
How should you complete the template? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

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

Comment: *

Name: *

Email: *

Verification: *

You plan to migrate on-premises Microsoft SQL Server databases to Azure.
You need to identify which deployment and resiliency options meet the following requirements:
Support user-initiated backups.
Support multiple automatically replicated instances across Azure regions.
Minimize administrative effort to implement and maintain business continuity.
What should you identify? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/sql-server-on-azure-vm-iaas-what-is-overview
https://docs.microsoft.com/en-us/dotnet/architecture/cloud-native/infrastructure-resiliency-azure

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.\\[<language>]
• B.%<language>
• C.\\[<language>]
• D.@<language>

Comment: *

Name: *

Email: *

Verification: *

A data engineer creates a table to store employee information for a new application. All employee names are in the US English alphabet. All addresses are locations in the United States. The data engineer uses the following statement to create the table.

You need to recommend changes to the data types to reduce storage and improve performance.
Which two actions should you recommend? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

• A.Change PhoneNumber to the float data type.
• B.Change Salary to the money data type.
• C.Change PhoneNumber to the bigint data type.
• D.Change LastHireDate to the date data type.
• E.Change LastHireDate to the datetime2(7) data type.

Comment: *

Name: *

Email: *

Verification: *