You need to create a policy to check the condition

DRAG DROP
You administer several Microsoft SQL Server 2012 servers.
You want to run scheduled checks to confirm that the databases on the servers are not configured to
AutoShrink.
You need to create a policy to check the condition.
What should you do? (To answer, move the appropriate actions from the list of actions to the
answer area and arrange them in the correct order.)

DRAG DROP
You administer several Microsoft SQL Server 2012 servers.
You want to run scheduled checks to confirm that the databases on the servers are not configured to
AutoShrink.
You need to create a policy to check the condition.
What should you do? (To answer, move the appropriate actions from the list of actions to the
answer area and arrange them in the correct order.)

Answer: See the explanation

Explanation:
Box 1:

Box 2:

Box 3:

Note:
* @autoshrink is used to enable/disable the autoshrink feature.
* The Evaluation Mode defines the combination of 1) when the policy will be evaluated and 2) what
the system will do in case of policy violation. The following evaluation modes are supported:



Leave a Reply 5

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


Donk

Donk

Evaluation mode should be “schedule” instead of “On Demand”??

David

David

I agree with Donk.
When on demand, no need to schedule.

God

God

2 – 4 – 5

Yalose

Yalose

Question states “You want to run scheduled checks to confirm…”

so it is 2-4-5