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

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

Page: 1 / 11
Questions 4

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

Buy Now
Questions 5

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
Questions 6

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:

Buy Now
Questions 7

You need to design a data retention solution for the Twitter feed data records. The solution must meet the customer sentiment analytics requirements.

Which Azure Storage functionality should you include in the solution?

Options:

A.

time-based retention

B.

change feed

C.

lifecycle management

D.

soft delete

Buy Now
Page: 1 / 11
Exam Code: DP-300
Exam Name: Administering Microsoft Azure SQL Solutions
Last Update: May 2, 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