New Year Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: Board70

Pass Using DP-300 Exam Dumps

Page: 4 / 11
Question 16

You have an Azure subscription that contains an instance of SQL Server on an Azure virtual machine named VM1 and a Microsoft Entra Domain Services domain that contains two users named User1 and User2.

On the default instance of SQL Server on VM1, you create a credential named Credentiall for User1.

You need to ensure that User2 can create a SQL Server Agent proxy that will use Credential1. The solution must use the principle of least privilege.

Which role should you assign to User2?

Options:

A.

sysadmin

B.

SQLAgentUserRole

C.

SQLAgentOperatorRole

D.

SQLAgentReaderRole

Question 17

You are monitoring an Azure Stream Analytics job.

You discover that the Backlogged input Events metric is increasing slowly and is consistently non-zero.

You need to ensure that the job can handle all the events.

What should you do?

Options:

A.

Remove any named consumer groups from the connection and use $default.

B.

Change the compatibility level of the Stream Analytics job.

C.

Create an additional output stream for the existing input stream.

D.

Increase the number of streaming units (SUs).

Question 18

What should you implement to meet the disaster recovery requirements for the PaaS solution?

Options:

A.

Availability Zones

B.

failover groups

C.

Always On availability groups

D.

geo-replication

Question 19

What should you use to migrate the PostgreSQL database?

Options:

A.

Azure Data Box

B.

AzCopy

C.

Azure Database Migration Service

D.

Azure Site Recovery

Page: 4 / 11
Exam Code: DP-300
Exam Name: Administering Relational Databases on Microsoft Azure
Last Update: Dec 22, 2024
Questions: 341
DP-300 pdf

DP-300 PDF

$28.5  $94.99
DP-300 Engine

DP-300 Testing Engine

$33  $109.99
DP-300 PDF + Engine

DP-300 PDF + Testing Engine

$43.5  $144.99