Microsoft DP-300 Exam Practice Test Instant Access

Question 1

You have a Microsoft SQL Server 2017 server.

You need to migrate the server to Azure. The solution must meet the following requirements:

* Ensure that the latest version of SQL Server is used.

* Support the SQL Server Agent service.

Minimize administrative effort.

What should you use?

ASQL Server on Azure Virtual Machines

BAzure SQL Database

Can Azure SQL Database elastic pool

DAzure SQL Managed Instance

Answer : A

Question 2

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?

AAzure SQL Database Hyperscale

BAzure SQL Database managed instance General Purpose

CAzure SQL Database Premium

DAzure SQL Database Basic

Answer : C

By default, the cluster of nodes for the premium availability model is created in the same datacenter. With the introduction of Azure Availability Zones, SQL Database can place different replicas of the Business Critical database to different availability zones in the same region. To eliminate a single point of failure, the control ring is also duplicated across multiple zones as three gateway rings (GW). The routing to a specific gateway ring is controlled by Azure Traffic Manager (ATM). Because the zone redundant configuration in the Premium or Business Critical service tiers does not create additional database redundancy, you can enable it at no extra cost. By selecting a zone redundant configuration, you can make your Premium or Business Critical databases resilient to a much larger set of failures, including catastrophic datacenter outages, without any changes to the application logic. You can also convert any existing Premium or Business Critical databases or pools to the zone redundant configuration.

Incorrect Answers:

C . This feature is not available in SQL Managed Instance.

https://docs.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla

Question 3

You have a single availability set that contains two SQL Server on Azure Virtual Machines instances.

The instances were deployed by using an Azure Marketplace SQL Server 2019 Enterprise image that has the latest cumulative updates applied. The instances are configured as the nodes of a failover cluster instance (FCI) named FCI1.

You need to ensure that client applications can connect to FCI1. The solution must meet the following requirements:

* Provide an availability SLA

* Minimize costs.

What should you create?

Aa virtual network name (VNN) resource

Ba Basic Azure Load Balancer

Ca distributed network name (DNN) resource

Dan Azure Standard Load Balancer

Answer : C

Question 4

You are designing an anomaly detection solution for streaming data from an Azure IoT hub. The solution must meet the following requirements:

Send the output to an Azure Synapse.

Identify spikes and dips in time series data.

Minimize development and configuration effort.

Which should you include in the solution?

AAzure SQL Database

BAzure Databricks

CAzure Stream Analytics

Answer : C

Anomalies can be identified by routing data via IoT Hub to a built-in ML model in Azure Stream Analytics

https://docs.microsoft.com/en-us/learn/modules/data-anomaly-detection-using-azure-iot-hub/

https://docs.microsoft.com/en-us/azure/stream-analytics/azure-synapse-analytics-output

Question 5

You need to recommend which configuration to perform twice to enable access to the primary and secondary replicas of DB3. The solution must meet the availability requirements.

What should you recommend?

AConfigure virtual network service endpoints.

BEnable database firewall rules.

CCreate database-scoped credentials.

DConfigure connection strings that reference the read-write listener.

Answer : D

Question 6

You have an on-premises Microsoft SQL Server 2019 instance that hosts a database named DB1.

You have an Azure subscription that contains an Azure SQL database named SQLDB1.

You need to replicate DB1 to SQlDC1.

Which type of replication should you use?

Apeer-to-pec

Bmerge

Ctransactional

Dsnapshot

Answer : C

Question 7

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).

Answer : A

https://docs.microsoft.com/en-us/azure/dms/tutorial-sql-server-to-managed-instance

Microsoft Administering Microsoft Azure SQL Solutions DP-300 Exam Practice Test