Microsoft DP-300 Exam Questions Instant Access

Question 1

You have an Azure SQL managed instance that hosts multiple databases.

You need to configure alerts for each database based on the diagnostics telemetry of the database.

What should you use?

AAzure SQL Analytics alerts based on metrics

BSQL Health Check alerts based on diagnostics logs

CSQL Health Check alerts based on metrics

DAzure SQL Analytics alerts based on diagnostics logs

Answer : D

https://docs.microsoft.com/en-us/azure/azure-sql/database/metrics-diagnostic-telemetry-logging-streaming-export-configure?tabs=azure-portal#configure-the-streaming-export-of-diagnostic-telemetry

Question 2

You have an Azure subscription that contains an Azure SQL database named SQLDB1 in the Hyperscale service tier SQLD81 has zone-redundant storage (ZRS) enabled. You need to create a copy of SQLDB1 in the paired Azure region. The solution must minimize administrative effort What should you do first?

ACreate a logical server for Azure SQL Database.

BModify the Backup storage redundancy setting for SQLDB1.

CCreate another Azure SQL database in the Hyperscale service tier.

DExport SQLDB1.

Answer : A

Question 3

You have an Azure subscription.

You plan to deploy four SQL Server on Azure Virtual Machines instances to two Azure regions. Two instances will be deployed to each region. Each region will host a domain-independent availability group. You need to recommend a high availability, disaster recovery (HA/DR) solution for the planned deployment. The solution must minimize administrative effort. What should you include in the recommendation?

Aa Network Load Balancing (NLB) cluster

Ba workgroup cluster

Can Active Directory-detached cluster

Da Hyper-V cluster

Answer : C

Question 4

You need to implement a solution to notify the administrators. The solution must meet the monitoring requirements.

What should you do?

ACreate an Azure Monitor alert rule that has a static threshold and assign the alert rule to an action group.

BAdd a diagnostic setting that logs QueryStoreRuntimeStatistics and streams to an Azure event hub.

CAdd a diagnostic setting that logs Timeouts and streams to an Azure event hub.

DCreate an Azure Monitor alert rule that has a dynamic threshold and assign the alert rule to an action group.

Answer : D

https://azure.microsoft.com/en-gb/blog/announcing-azure-monitor-aiops-alerts-with-dynamic-thresholds/

Question 5

You have the on premises networks shown in the following table.

You have an Azure subscription that contains an Azure SQL Database server named SQL1. SQL1 contains two databases named DB1 and DB2.

You need to configure access to DB1 and DB2. The solution must meet the following requirements:

Ensure that DB1 can be accessed only by users in Branch1.

Ensure that DB2 can be accessed only by users in Branch2.

Solution: You connect to DB1 and run the following command:

EXECUTE sp_set_firewall_rule 'Deny db1 users', '131.107.11.0', '131.107.11.255'

You connect to DB2 and run the following command:

EXECUTE sp_set_database_firewall_rule 'Deny db2 users', '131.107.10.0', '131.107.10.255'

Does this meet the goal?

AYes

BNo

Answer : B

Question 6

You are developing an application that uses Azure Data Lake Storage Gen 2.

You need to recommend a solution to grant permissions to a specific application for a limited time period.

What should you include in the recommendation?

Arole assignments

Baccount keys

Cshared access signatures (SAS)

DAzure Active Directory (Azure AD) identities

Answer : C

A shared access signature (SAS) provides secure delegated access to resources in your storage account. With a SAS, you have granular control over how a client can access your data. For example:

What resources the client may access.

What permissions they have to those resources.

How long the SAS is valid.

Note: Data Lake Storage Gen2 supports the following authorization mechanisms:

Shared Key authorization

Shared access signature (SAS) authorization

Role-based access control (Azure RBAC)

Access control lists (ACL) Data Lake Storage Gen2 supports the following authorization mechanisms:

Shared Key authorization

Shared access signature (SAS) authorization

Role-based access control (Azure RBAC)

Access control lists (ACL)

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

Question 7

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

Answer : B

https://docs.microsoft.com/en-us/azure/azure-sql/migration-guides/database/sql-server-to-sql-database-overview

Microsoft Administering Microsoft Azure SQL Solutions DP-300 Exam Questions