DP 300 Practice

What type of storage offers the lowest latency in Azure?

• Ultra SSD

• Premium SSD

• Standard SSD

Answer explanation

Ultra Disk offers the lowest latency of the three storage types.

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

• Availability set

• Azure Reserved VM Instances

• Pay as You Go Licensing

Answer explanation

Azure Reserved VM Instance can offer significant cost saving over pay as you go licensing.

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

• Azure Site Recovery

• Azure Site Recovery

• Availability Groups

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?

• BEFORE UPDATE

• POST UPDATE

• AFTER INSERT

• AFTER UPDATE

Answer explanation

AFTER UPDATE prevents users from updating rows to values that violate the predicate.

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.

• File Storage

• Disk Storage

• Cosmos Storage

• Blob Storage

Answer explanation

File Storage - File storage 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 File storage as a storage target for a failover cluster instance.

https://docs.microsoft.com/en-us/azure/storage/common/storage-introduction

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?

• log shipping

• active geo-replication

• Microsoft SQL Server failover clusters

• auto-failover groups

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?

• 
  the COMPRESS() function

• columnstore archive compression

• row compression

• columnstore compression

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?

• node majority with a cloud witness

• node majority with no witness

• node majority with a le share witness

• node majority with a disk witness

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?

• Azure SQL Database Premium

• Azure SQL Database serverless

• Azure SQL Database Basic

• Azure SQL Database Hyperscale

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.

• SAS

• SQL

• SAML

• SSL