Most Recent Microsoft DP-300 Exam Questions & Answers

Prepare for the Microsoft Administering Microsoft Azure SQL Solutions exam with our extensive collection of questions and answers. These practice Q&A are updated according to the latest syllabus, providing you with the tools needed to review and test your knowledge.

QA4Exam focus on the latest syllabus and exam objectives, our practice Q&A are designed to help you identify key topics and solidify your understanding. By focusing on the core curriculum, These Questions & Answers helps you cover all the essential topics, ensuring you're well-prepared for every section of the exam. Each question comes with a detailed explanation, offering valuable insights and helping you to learn from your mistakes. Whether you're looking to assess your progress or dive deeper into complex topics, our updated Q&A will provide the support you need to confidently approach the Microsoft DP-300 exam and achieve success.

The questions for DP-300 were last updated on Dec 17, 2024.

Viewing page 1 out of 68 pages.
Viewing questions 1-5 out of 341 questions

Get All 341 Questions & Answers

Question No. 1

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

What should you do?

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

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

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

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

Show Answer

Correct Answer: D

https://azure.microsoft.com/en-gb/blog/announcing-azure-monitor-aiops-alerts-with-dynamic-thresholds/

Question No. 2

Your on-premises network contains a server that hosts a 60-TB database named DB 1. The network has a 10-Mbps internet connection.

You need to migrate DB 1 to Azure. The solution must minimize how long it takes to migrate the database.

What should you use?

AAzure Migrate

BData Migration Assistant (DMA)

CAzure Data BOX

DAzure Database Migration Service

Show Answer

Correct Answer: C

https://www.techtarget.com/searchitoperations/tip/Easily-transfer-VMs-to-the-cloud-with-Microsoft-Azure-Migrate

Question No. 3

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?

ADBCC SHRINKDATABASE

Bsp_clean_db_free_space

Csp_clean_db_file_free_space

DDBCC SHRINKFILE

Show Answer

Correct Answer: D

DBCC SHRINKDATABASE shrinks the size of the data and log files in the specified database.

Incorrect Answers:

D: To shrink one data or log file at a time for a specific database, execute the DBCC SHRINKFILE command.

https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-shrinkdatabase-transact-sql

Question No. 4

SIMULATION

You have two on-premises servers that run Windows Server 2019 and host a Microsoft SQL Server 2017 Always On availability group named AG1. AG1 contains a single database named DB1.

You have an Azure subscription. The subscription contains a virtual machine named VM1 that runs Linux.

You need to migrate DB1 to a SQL Server 2019 instance on VM1. The solution must minimize the downtime of DB1 during the migration.

What should you do? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Asee the answer below in explanation

Show Answer

Correct Answer: A

Answer as in image below.

Question No. 5

You need to recommend a process to automate the management of DB3. The solution must meet the management requirements. What should be the first step of the process?

AConfigure Microsoft Entra authentication for the logical server that hosts DB3.

BCreate a database that has database-scoped credentials.

CConfigure a private endpoint for connectivity to DB3.

DCreate data base-scoped credentials in DB3.

Show Answer

Correct Answer: C

Unlock All Questions for Microsoft DP-300 Exam

Full Exam Access, Actual Exam Questions, Validated Answers, Anytime Anywhere, No Download Limits, No Practice Limits

Get All 341 Questions & Answers