Shared Flashcard Set

Details

DBA Exam 2 review - 3
Chapter 8
9
Computer Science
Undergraduate 4
03/23/2011

Additional Computer Science Flashcards

 


 

Cards

Term
Facets:
Definition
the core objects on which standards are built
Term
object types
Definition
 Facets
 Conditions
 Policies
 Policy targets
 Policy categories
Term
Conditions:
Definition
are the equivalent of a WHERE clause in a
DML statement
 They define the criteria that need to be checked
Term
Policy targets:
Definition
used to specify the objects to compare the
condition against
Term
Policies:
Definition
created for a single condition and are set to either
enforce or check compliance
Term
Policies modes
Definition
 On Demand
 On Change: Log Only
 On Change: Prevent
 On Schedule
Term
Policy categories:
Definition
can be used to group one or more policies
into a single compliance unit
Term
Central Management Server
Definition
Can configure a Central Management Server to allow you to manage multiple instances of SQL Server
Term
Working with Policy Based Management, requirements
Definition
You must be a member of the PolicyAdminstratorRole role
in the msdb database to configure Policy Based Management
settings
Supporting users have an ad free experience!