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

DP-300 Exam Dumps - Microsoft Certified: Azure Database Administrator Associate Questions and Answers

Page: 1 / 11
Questions 4

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

What should you do?

Options:

A.

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

B.

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

C.

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

D.

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

Buy Now
Questions 5

You need to recommend a solution to meet the security requirements and the business requirements for DB3. What should you recommend as the first step of the solution?

Options:

A.

Run the sys.5p_cdc_en«ble_db stored procedure.

B.

Run the alter table statement and specify the enable chahgc_tracking clause.

C.

Run the alter database statement and specify the set cmange_trackinc> - on clause.

D.

Run the sp_addarticle stored procedure.

Buy Now
Questions 6

Based on the PaaS prototype, which Azure SQL Database compute tier should you use?

Options:

A.

Business Critical 4-vCore

B.

Hyperscale

C.

General Purpose v-vCore

D.

Serverless

Buy Now
Questions 7

Which windowing function should you use to perform the streaming aggregation of the sales data?

Options:

A.

Sliding

B.

Hopping

C.

Session

D.

Tumbling

Buy Now
Page: 1 / 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