Describe the physical and logical security consideration when planning an SQL Server 2012 installation.
What will be an ideal response?
Hardware should be maintained in a location with appropriate physical access controls. To satisfy disaster recovery needs, frequent backups should be created on media that is stored in a separate, secure physical location.
Logical security is the second dimension to consider. Microsoft recommends that SQL Server be installed on a dedicated server that is not shared with other Windows services such as a domain controller. With two critical applications running on a single server, it becomes difficult to isolate an administrative role to a single application and raises the likelihood that both services will be compromised in the event of a security breach.
You might also like to view...
The command to use help features of Emacs is:
a: [Ctrl-h] b: [Ctrl-h] k c: [Ctrl-h] t d: [Ctrl-h] i e: all of the above
Class templates also are called ______ types.
Fill in the blank(s) with the appropriate word(s).
The UPDATE command contains the word ____________________, followed by the name of the column to be updated, an equals sign, and the new value.
Fill in the blank(s) with the appropriate word(s).
The simplest type of filter is called Filter By Form.
Answer the following statement true (T) or false (F)