CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. Microsoft
  5. DP-300

Free DP-300 Exam Braindumps (page: 38)

Page 38 of 76
PDF with 352 Questions

You have an Azure subscription that contains an Azure SQL database named db1.
You need to implement SQL insights for db1.

Which two resources should you create first? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

  1. a storage account
  2. a virtual machine
  3. an Azure logic app
  4. an Azure function
  5. a Log Analytics workspace

Answer(s): B,E



You have an Azure subscription that contains the resources shown in the following table.


App1 experiences transient connection errors and timeouts when it attempts to access db1 after extended periods of inactivity.

You need to modify db1 to resolve the issues experienced by App1 as soon as possible, without considering immediate costs.

What should you do?

  1. Enable automatic tuning for db1.
  2. Increase the number of vCores allocated to db1.
  3. Decrease the auto-pause delay for db1.
  4. Disable auto-pause delay for db1.

Answer(s): D



HOTSPOT (Drag and Drop is not supported)
You have an Azure SQL database named DB1 that contains a table named Table1.
You run a query to load data into Table1.
The performance metrics of Table1 during the load operation are shown in the following exhibit.


Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.

NOTE: Each correct selection is worth one point.

  1. See Explanation section for answer.

Answer(s): A

Explanation:



DRAG DROP (Drag and Drop is not supported)
You have a database named db1.
The log for db1 contains the following entry.


You need to ensure that db1 can process transactions.

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

  1. See Explanation section for answer.

Answer(s): A

Explanation:



Page 38 of 76



Post your Comments and Discuss Microsoft DP-300 exam with other Community members:

laks commented on December 26, 2024
so far seems good
UNITED STATES
upvote

Jack commented on October 24, 2024
Muito bom as perguntas
Anonymous
upvote

TheUser commented on October 23, 2024
So far seems good
Anonymous
upvote

anonymus commented on October 23, 2024
master database differential backup is not supported in sql server
EUROPEAN UNION
upvote

Ntombi commented on October 17, 2024
i find the questions helpful for my exam preparation
Anonymous
upvote

Ntombi commented on October 17, 2024
The questions help me to see if I understood what I have learned
Anonymous
upvote

ntombi commented on October 17, 2024
writing exam at the end of the month
Anonymous
upvote

Raby commented on August 13, 2024
Wonderful work guys. The PDF version helped me pass. Thank you
EUROPEAN UNION
upvote