What should you do?

You have a server named Serverl that is hosted in an Azure virtual machine. Server1 contains the following:
One instance of SQL Server 2016 Enterprise
10 databases
500 stored procedures
You have a database named Databasel that is hosted on Server1.
Database1 contains 100 queries that are executed dynamically from web applications.
You plan to remove data from the procedure cache on Database1.
You have the following requirements:
Changes to Database1 must not affect other databases that are hosted on Server1
Changes to Database1 must not affect the performance of queries that are stored in other databases. The solution must minimize administrative effort.
You need to remove the data from the procedure cache as quickly as possible.
What should you do?
A. Run DBCC FREEPROCCACHE.
B. Run ALTER DATABASE SCOPED CONFIGURATION CLEAR PROCEDURE CACHE in the context of Database 1.
C. Run DBCC DROPCLEANBUFFERS.
D. Write a script that iterates through each stored procedure definition and add WITH RECOMPILE to the definition.

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.