Labour Day Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: bigdisc65

Last Attempt DP-300 Questions

Page: 8 / 11
Question 32

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 33

Your company analyzes images from security cameras and sends alerts to security teams that respond to unusual activity. The solution uses Azure Databricks.

You need to send Apache Spark level events, Spark Structured Streaming metrics, and application metrics to Azure Monitor.

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions in the answer area and arrange them in the correct order.

Options:

Question 34

You have an Azure SQL database named sqldb1.

You need to minimize the amount of space by the data and log files of sqldb1.

What should you run?

Options:

A.

DBCC SHRINKDATABASE

B.

sp_clean_db_free_space

C.

sp_clean_db_file_free_space

D.

DBCC SHRINKFILE

Question 35

You have an instance of SQL Server on Azure Virtual Machines named VM1.

You need to implement a disaster recovery solution that meets the following requirements:

• Returns the solution to an operational state within 15 minutes of a failure

• Can perform disaster recovery testing in an isolated environment

• Minimizes administrative effort

What should you include in the solution?

Options:

A.

Azure Site Recovery

B.

a failover cluster instance (FCI)

C.

auto-failover groups

D.

active geo-replication

Page: 8 / 11
Exam Code: DP-300
Exam Name: Administering Microsoft Azure SQL Solutions
Last Update: May 3, 2024
Questions: 311
DP-300 pdf

DP-300 PDF

$31.5  $90
DP-300 Engine

DP-300 Testing Engine

$36.75  $105
DP-300 PDF + Engine

DP-300 PDF + Testing Engine

$49  $140