To reduce the cost of an Azure SQL Server VM you intend to run full time for three years, which option should you choose?

Which service performs block level replication of your Azure virtual machine?

Scenario: The Daily Bugle is a New Yorker newspaper led by the irascible, gruff publisher named J. J. Jameson and it is housed in the Flatiron Building. Peter Parker is one of the developers at the Daily Bugle and needs to employ a block predicate to prevent users from updating rows to values that violate its row-level security predicate.

Which of the following should Peter use to accomplish this?

Storage performance is a critical component of an I/O heavy application like a database engine. Azure offers a broad array of storage options and can even build your storage solution to meet your workload requirements.

Azure Storage is a highly scalable, secure storage platform that offers a range of solutions to meet the needs of many applications. The following types of storage support encryption at rest with either a Microsoft managed or a user-defined encryption key.

_____ is effectively a file share that can be mounted inside a virtual machine, without the need to set up any hardware. SQL Server can use [?] as a storage target for a failover cluster instance.

You have an Azure subscription that contains an Azure SQL database named SQL1.SQL1 is in an Azure region that does not support availability zones.You need to ensure that you have a secondary replica of SQL1 in the same region.What should you use?

You have an Azure SOI database named SQLDb1 that contains the resources shown in the following table. (As shown in the image). Column1 contains JSON data.

You need to compress Column1. The solution must minimize the amount of storage used.

What should you use?

You have an Azure subscription that contains two instances of SQL Server on Azure Virtual Machines named VM1 and VM2. Both instances runMicrosoft SQL Server 2019 CU8.

You need to deploy a failover cluster instance (FCI) to VM1 and VM2 that will use Azure shared disks.

The solution must maximize resiliency.Which quorum option should you use?

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?

Identify the missing word(s) in the following sentence within the context of Microsoft Azure.

______ is used to grant limited rights to resources in an Azure storage account for a specified time period. This feature enables applications to access resources such as blobs and files, without requiring that they're authenticated first. You should only use SAS for data that you intend to make public.

Which of the following is a benefit of Azure Database for PostgreSQL?