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

Microsoft Certified: Azure Database Administrator Associate Changed DP-300 Questions

Page: 6 / 11
Question 24

You need to identify the event_flle target for monitonng DB3 after the migration to Azure SQL Database. The solution must meet the management requirements,

What should you use as the event_file target?

Options:

A.

an Azure SQL database

B.

an Azure Blob Storage container

C.

a SQL Server filegroup

D.

an Azure Files share

Question 25

You need to recommend a backup solution to restore DB3. The solution must meet the availability requirements. Which type of backup should you use?

Options:

A.

transaction log

B.

point-in-time restore (PITR)

C.

differential

D.

long-term retention (LTR)

Question 26

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

Options:

A.

Sliding

B.

Hopping

C.

Session

D.

Tumbling

Question 27

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?

Options:

A.

Configure virtual network service endpoints.

B.

Enable database firewall rules.

C.

Create database-scoped credentials.

D.

Configure connection strings that reference the read-write listener.

Page: 6 / 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