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:
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:
It is not correct. It should be this way:
1. Condition should be set to True.
2. Evaluation mode should be on schedule.
No, the explanation is correct.
The explanation is not correct. If the policy is “On Demand” there is no requirement to create a schedule.
The condition should also be set to “false” otherwise it throws false positives during the evaluation.
2-4-5
You want to run scheduled checks to confirm that the databases on the servers are not configured to AutoShrink.
So the condition should be set to FALSE.
When creating the policy you schedule it to run for example every hour you can evaluate the policy. All the databases with AutoShrink set to False will be green, all databases with AutoShrink set to True (enabled) are marked red.
Correct answer is 2-4-5
it has to be false if you want the database not to be shrink, i checked it practically, also you have operators to make change accordingly if you want to set it true then use != in condition but this question does not state that.
2,4,5
you cannot create a schedule for OnDemand and you cannot enable the policy if OnDemand is selected, so it should be 2-4-5