Term
| Which components of SQL Server will need dedicated service accounts? |
|
Definition
Database Engine
SQL Server Agent |
|
|
Term
| Which Windows resources is SQL Server able to access? |
|
Definition
| Those for which the service account has been granted permissions. |
|
|
Term
| What types of character data operations does a collation sequence control? |
|
Definition
Storage
Retrieval
Sorting
Comparison |
|
|
Term
| At what levels can collation sequences be specified? |
|
Definition
Instance
Database
Table
Column |
|
|
Term
| At what level is it mandatory to specify a collation sequence? |
|
Definition
|
|
Term
| What SQL Server feature controls case sensitivity and accent sensitivy? |
|
Definition
|
|
Term
| What authentication modes are supported by SQL Server? |
|
Definition
Windows Only (integrated)
Windows and SQL Server (mixed mode) |
|
|
Term
| Which is the preferred authentication mode for SQL Server? Why? |
|
Definition
| Windows Only, it is much more secure. |
|
|
Term
| True or False: An instance can contain more than one database. |
|
Definition
|
|
Term
| How many unnamed instances can a host support? |
|
Definition
|
|
Term
| What is the server name for a named SQL instance? |
|
Definition
|
|
Term
| What is the server name for a default SQL instance? |
|
Definition
|
|
Term
| Why might you want to have more than one SQL instance on the same host machine? |
|
Definition
To support multiple service pack or pathc levels.
Support multiple sets of configuration options.
Support multiple environments (such as QA and Development). |
|
|
Term
| If your company resides in one location or within the same country, should you accept the default collation sequence during installation? |
|
Definition
| Yes, because SQL Server Setup automatically detects the Windows system locale and selects the appropriate SQL Server collation. |
|
|
Term
| True or False: Use the Windows Service Control applet to change service accounts and passwords for SQL Server services. |
|
Definition
| False. Use SQL Server Configuration Manager, becuase it inlcudes the code to regenerate the service master key. |
|
|
Term
| What SQL Server component would you use to configure communications protocols? |
|
Definition
| SQL Server Configuration Manager |
|
|
Term
| How would you prevent a SQL Server Instance from being discovered, or enumerated? |
|
Definition
| Set "Hide Instance" to Yes under the protocol section for the instance in SQL Server Configuration Manager |
|
|
Term
| How do you force encryption on a SQL Server Instance? |
|
Definition
| By setting the "Force Encryption" flag in SQL Server Configuration Manager. |
|
|
Term
| What type of collation will provide the best performance: Windows, Binary or SQL Server? |
|
Definition
|
|
Term
| Which command must be executed against the SQL Server instance before FILESTREAM data can be stored? |
|
Definition
|
|
