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: 27)

Page 27 of 76
PDF with 352 Questions

You have an Azure subscription that contains an Azure SQL database. The database contains a table named table1.

You execute the following Transact-SQL statements.



You need to reduce the time it takes to perform analytic queries on the database.

Which configuration should you enable?

  1. ROW_MODE_MEMORY_GRANT_FEEDBACK
  2. BATCH_MODE_MEMORY_GRANT_FEEDBACK
  3. BATCH_MODE_ADAPTIVE_JOINS
  4. BATCH_MODE_ON_ROWSTORE

Answer(s): D



DRAG DROP (Drag and Drop is not supported)
You create a new Azure SQL managed instance named SQL1 and enable Database Mail extended stored procedures.

You need to ensure that SQL Server Agent jobs running on SQL1 can notify administrators when a failure occurs.

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:



You have a Microsoft SQL Server 2019 database named DB1 and an Azure SQL managed instance named SQLMI1.

You need to move a SQL Server Agent job from DB1 to SQLMI1.

Which job attribute is unsupported in SQLMI1?

  1. log to table
  2. email notifications
  3. schedules
  4. output files

Answer(s): D



DRAG DROP (Drag and Drop is not supported)
You create an Azure SQL managed instance and a job that performs backups.

You need to configure the job to notify a distribution group by email when the job fails. The solution must minimize administrative effort.

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.

NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.

  1. See Explanation section for answer.

Answer(s): A

Explanation:



Page 27 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