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:
Hello,
Wrong answer according to me. The question speaks about “scheduled checks”. Why not “on schedule” evaluation mode?
Greetings,
0
0
“schedule” box is correct insted of on demand
0
0
Agree that it must be to schedule instead of on demand
0
0
Yes Schedule is right.
0
0
SO, false > Schedule > create & enable
0
0
1. Define condition by setting @Autoshrink to FALSE
2. Define policy by setting Evaluation Mode to ‘On schedule’
3. Define a schedule within the policy definition
4. Check ‘Enabled’ button for policy
5. In SSMS (Policy Management), right-click on the policy and select ‘Evaluate’ to ensure its validity.
0
0
Oh, but those are not the options given. So…Wrong!
0
0
@pete; Slazenjer_m is giving the overview of the process.. lol…
0
0
Answer is:
2
4
5
0
0
but we are enabling the policy by enabling the schedule..
0
0
but we are enabling the policy by creating the schedule..
so on demand seems okay
0
0
https://technet.microsoft.com/en-us/library/59417a54-55f1-4468-ba41-368aa852c2d4(v=sql.110)
0
0