Passcerty.com » Microsoft » Role-based » DP-300

DP-300 Exam Questions & Answers

Exam Code: DP-300

Exam Name: Administering Relational Databases on Microsoft Azure

Updated: Apr 30, 2024

Q&As: 325

At Passcerty.com, we pride ourselves on the comprehensive nature of our DP-300 exam dumps, designed meticulously to encompass all key topics and nuances you might encounter during the real examination. Regular updates are a cornerstone of our service, ensuring that our dedicated users always have their hands on the most recent and relevant Q&A dumps. Behind every meticulously curated question and answer lies the hard work of our seasoned team of experts, who bring years of experience and knowledge into crafting these premium materials. And while we are invested in offering top-notch content, we also believe in empowering our community. As a token of our commitment to your success, we're delighted to offer a substantial portion of our resources for free practice. We invite you to make the most of the following content, and wish you every success in your endeavors.


Download Free Microsoft DP-300 Demo

Experience Passcerty.com exam material in PDF version.
Simply submit your e-mail address below to get started with our PDF real exam demo of your Microsoft DP-300 exam.

Instant download
Latest update demo according to real exam

*Email Address

* Our demo shows only a few questions from your selected exam for evaluating purposes

Free Microsoft DP-300 Dumps

Practice These Free Questions and Answers to Pass the Role-based Exam

Questions 1

HOTSPOT

You have an Azure SQL database named db1 on a server named server1.

You use Query Performance Insight to monitor db1.

You need to modify the Query Store configuration to ensure that performance monitoring data is available as soon as possible.

Which configuration setting should you modify and which value should you configure? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Hot Area:

Show Answer
Questions 2

You need to recommend an availability strategy for an Azure SQL database. The strategy must meet the following requirements:

1.

Support failovers that do not require client applications to change their connection strings.

2.

Replicate the database to a secondary Azure region.

3.

Support failover to the secondary region. What should you include in the recommendation?

A. failover groups

B. transactional replication

C. Availability Zones

D. geo-replication

Show Answer
Questions 3

You have SQL Server on an Azure virtual machine that contains a database named DB1.

You have an application that queries DB1 to generate a sales report.

You need to see the parameter values from the last time the query was executed.

Which two actions should you perform? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

A. Enable Last_Query_Plan_Stats in the master database

B. Enable Lightweight_Query_Profiling in DB1

C. Enable Last_Query_Plan_Stats in DB1

D. Enable Lightweight_Query_Profiling in the master database

E. Enable PARAMETER_SNIFFING in DB1

Show Answer
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?

A. DBCC SHRINKDATABASE

B. sp_clean_db_free_space

C. sp_clean_db_file_free_space

D. DBCC SHRINKFILE

Show Answer
Questions 5

You have a data warehouse in Azure Synapse Analytics.

You need to ensure that the data in the data warehouse is encrypted at rest.

What should you enable?

A. Transparent Data Encryption (TDE)

B. Advanced Data Security for this database

C. Always Encrypted for all columns

D. Secure transfer required

Show Answer

Viewing Page 1 of 3 pages. Download PDF or Software version with 325 questions

123>

Related ExamsRelated Certifications