DP-300 practice questions 21–30

1. Question 21 · 354 in bank

   HOTSPOT - You are provisioning an Azure SQL database in the Azure portal as shown in the following exhibit.

   

   Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point. Hot Area:

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   Box 1: no extra time - Auto Pause is not checked in the exhibit. Note: If Auto Pause is checked the correct answer is: up to one minute Box 2: intermittent and unpredictable Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview

   Source: Adapted from community discussion — jimmyzaas

   References

   • Microsoft Learn

   

   Next question

2. Question 22 · 354 in bank

   You plan to deploy an app that includes an Azure SQL database and an Azure web app. The app has the following requirements: ✑ The web app must be hosted on an Azure virtual network. ✑ The Azure SQL database must be assigned a private IP address. ✑ The Azure SQL database must allow connections only from a specific virtual network. You need to recommend a solution that meets the requirements. What should you include in the recommendation?

   • AAzure Private Link
   • Ba network security group (NSG)
   • Ca database-level firewall
   • Da server-level firewall

   Show answer

   Answer: A

   Explanation

   A is correct B NSG is used to control in and out traffic for Azure resources, not the private stuff C and D have nothing to do with controlling virtual networks

   Source: Adapted from community discussion — Natali

   Next question

3. Question 23 · 354 in bank

   You have an Azure SQL database that contains a table named factSales. FactSales contains the columns shown in the following table.

   

   FactSales has 6 billion rows and is loaded nightly by using a batch process. You must provide the greatest reduction in space for the database and maximize performance. Which type of compression provides the greatest space reduction for the database?

   • Apage compression
   • Brow compression
   • Ccolumnstore compression
   • Dcolumnstore archival compression

   Show answer

   Answer: D

   Explanation

   Continued in the same article is this... "Additionally, with a columnstore index, you use partitioning to: Save an additional 30% in storage costs. You can compress older partitions with the COLUMNSTORE_ARCHIVE compression options. The data will be slower for query performance, which is acceptable if the partition is queries infrequently." Therefore the correct answer is D. The question is weird and should probably not include performance...but this is a nightly process where performance probably doesn't matter much.

   Source: Adapted from community discussion — JustAnotherDBA

   References

   • Microsoft Learn
   • Microsoft Learn

   Next question

4. Question 24 · 354 in bank

   You are planning a solution that will use Azure SQL Database. Usage of the solution will peak from October 1 to January 1 each year. During peak usage, the database will require the following: ✑ 24 cores ✑ 500 GB of storage ✑ 124 GB of memory ✑ More than 50,000 IOPS During periods of off-peak usage, the service tier of Azure SQL Database will be set to Standard. Which service tier should you use during peak usage?

   • ABusiness Critical
   • BPremium
   • CHyperscale

   Show answer

   Answer: A

   Explanation

   I believe that correct answer is A (Business critical in vCore purchasing model) because we have request to scale up and down not only in compute resources but also a storage which is available only vCore purchasing model. Hyperscale is not suits us well as well because it is reversable only within 45 days of the original migration to Hyperscale. Links https://docs.microsoft.com/en-us/azure/azure-sql/database/service-tiers-dtu?view=azuresql and https://docs.microsoft.com/en-us/azure/azure-sql/database/service-tier-hyperscale?view=azuresql

   Source: Adapted from community discussion — rctm_bm

   References

   • Microsoft Learn
   • azure.microsoft.com documentation
   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   Next question

5. Question 25 · 354 in bank

   HOTSPOT - You have an Azure subscription. You need to deploy an Azure SQL resource that will support cross database queries by using an Azure Resource Manager (ARM) template. How should you complete the ARM template? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area:

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   Box 1: Microsoft.Sql/managedInstances The Managed Instance depends on the Virtual Network. Reference: https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/create-template-quickstart?tabs=azure-powershell

   Source: Adapted from community discussion — reachmymind

   

   Next question

6. Question 26 · 354 in bank

   HOTSPOT - 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. Hot Area:

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   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

   Source: Adapted from community discussion — [Removed]

   References

   • Microsoft Learn
   • Microsoft Learn

   

   Next question

7. Question 27 · 354 in bank

   HOTSPOT - You have an on-premises Microsoft SQL Server 2019 instance that hosts a database named DB1. You plan to perform an online migration of DB1 to an Azure SQL managed instance by using the Azure Database Migration Service. You need to create a backup of DB1 that is accessible to the Azure Database Migration Service. What should you run for the backup and where should you store the backup? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area:

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   Box 1: ..with CHECKSUM option - Azure Database Migration Service does not initiate any backups, and instead uses existing backups, which you may already have as part of your disaster recovery plan, for the migration. Be sure that you take backups using the WITH CHECKSUM option. Box 2: An SMB share - For online migrations from SQL Server to SQL Managed Instance using Azure Database Migration Service, you must provide the full database backup and subsequent log backups in the SMB network share that the service can use to migrate your databases. Reference: https://docs.microsoft.com/en-us/azure/dms/tutorial-sql-server-managed-instance-online

   Source: Adapted from community discussion — testdumps2017

   References

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   

   Next question

8. Question 28 · 354 in bank

   HOTSPOT - 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. Hot Area:

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   Box 1: "Microsoft.Sql/servers" Example: "resources": [ { "type": "Microsoft.Sql/servers", "apiVersion": "2021-08-01-preview", "name": "[parameters('serverName')]", "location": "[parameters('location')]", "properties": { "administratorLogin": "[parameters('administratorLogin')]", "administratorLoginPassword": "[parameters('administratorLoginPassword')]" } }, { "type": "Microsoft.Sql/servers/databases", "apiVersion": "2021-08-01-preview", "name": "[format('{0}/{1}', parameters('serverName'), parameters('sqlDBName'))]", "location": "[parameters('location')]", "sku": { "name": "Standard", "tier": "Standard" }, "dependsOn": [ "[resourceId('Microsoft.Sql/servers', parameters('serverName'))]" ] } Box 2: "dependsOn": [ Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/single-database-create-arm-template-quickstart

   References

   • Microsoft Learn

   

   Next question

9. Question 29 · 354 in bank

   You have an on-premises Microsoft SQL Server 2019 server that hosts a database named DB1. You have an Azure subscription that contains an Azure SQL managed instance named SQLMI1 and a virtual network named VNET1. SQLMI1 resides on VNET1. The on-premises network connects to VNET1 by using an ExpressRoute connection. You plan to migrate DB1 to SQLMI1 by using Azure Database Migration Service. You need to configure VNET1 to support the migration. What should you do?

   • AConfigure service endpoints.
   • BConfigure virtual network peering.
   • CDeploy an Azure firewall.
   • DConfigure network security groups (NSGs).

   Show answer

   Answer: D

   Explanation

   A. Configure service endpoints: Service endpoints provide secure and direct connectivity to Azure services over the Azure backbone network. They are not typically used for connectivity between on-premises environments and Azure services. B. Configure virtual network peering: Virtual network peering is used to connect two Azure virtual networks seamlessly. Since your scenario involves an on-premises network and not another Azure virtual network, peering is not applicable. C. Deploy an Azure firewall: An Azure firewall is a network security service that protects Azure Virtual Network resources. It could be used to govern the traffic between your on-premises environment and the Azure SQL Managed Instance, but it is not the primary tool for enabling connectivity. D. Configure network security groups (NSGs): Network Security Groups are used to control inbound and outbound traffic to network interfaces (NIC), VMs, and subnets. By creating and applying NSG rules, you can ensure that traffic from the on-premises network can reach SQLMI1 over the ExpressRoute connection.

   Source: Adapted from community discussion — erz

   References

   • Microsoft Learn
   • Microsoft Learn

   Next question

10. Question 30 · 354 in bank

    You have an on-premises Microsoft SQL server that uses the FileTables and Filestream features. You plan to migrate to Azure SQL. Which service should you use?

    • AAzure SQL Database
    • BSQL Server on an Azure Virtual Machine
    • CAzure SQL Managed Instance
    • DAzure Database for MySQL

    Show answer

    Answer: B

    Explanation

    https://docs.microsoft.com/en-us/azure/azure-sql/migration-guides/database/sql-server-to-sql-database-overview?view=azuresql If one of the following conditions applies to your business, consider moving to a SQL Server virtual machine (VM) instead: You have strict dependency on features that are still not supported, such as FileStream/FileTable, PolyBase, and cross-instance transactions.

    Source: Adapted from community discussion — eric0718

    References

    • Microsoft Learn

    Next question

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

DP-300 practice, question 21. 354 questions available.