Term
| What are the eight editions of SQL Server 2008 available? |
|
Definition
Enterprise
Developer
Evaluation
Standard
Workgroup
Web
Express
Compact |
|
|
Term
| Which two editions of SQL Server are not licensed for production use? |
|
Definition
|
|
Term
| Which editions of SQL Server support the entire feature set available? |
|
Definition
| Enterprise, Developer and Evaluation |
|
|
Term
| Which editions of SQL Server are meant to be storage engines for embedded applications? |
|
Definition
|
|
Term
| What is the maximum database size for SQL Express? |
|
Definition
|
|
Term
| What is the maximum database size in Enterprise, Standard and Workgroup editions of SQL Server? |
|
Definition
|
|
Term
| Which editions of SQL Server support Partitioning? |
|
Definition
|
|
Term
| Does SQL Server Standard Edition support parallel operations? |
|
Definition
|
|
Term
| How many instances of SQL Server can you install on one host? |
|
Definition
50 instances on a stand-alone server for Enterprise Edition, 16 on all others.
SQL Server Enterprise supports 25 instances on a failover cluster. |
|
|
Term
| Which SQL Editions support snapshots? |
|
Definition
|
|
Term
| Which SQL Editions support clustering? |
|
Definition
| Enterprise and Standard (2 nodes only) |
|
|
Term
| Is Policy-Based Management supported on Standard Edition? |
|
Definition
|
|
Term
| Which editions support CLR? |
|
Definition
|
|
Term
| Which editions support full text search? |
|
Definition
| Enterprise, Standard and Workgroup. Express with Advanced Services. |
|
|
Term
| Which editions support transactional replication? |
|
Definition
|
|
Term
| Which editions support Merge Replication? |
|
Definition
| All, but Express and Compact can be subscribers only |
|
|
Term
| Name three features that are available in Enterprise Edition only. |
|
Definition
(pick any three)
Partitioning
Parallel Operations
Database Snapshots
Indexed Views
Log Compression
Online Operations
Resource Governor
Backup Compression
Hot Add Memory/CPU
Change Data Capture
Data Compression
Data Mining
Fuzzy grouping/lookup
Term extraction/lookup
OLAP processing
Scale-out reporting
Data-driven subscriptions
Linked measures/dimensions
Perspectives
Partitioned cubes
Time series
Parallel processing and prediction
Advanced mining algorithms |
|
|
Term
| What is the message queuing system integrated into SQL Server 2008? |
|
Definition
|
|
Term
|
Definition
| Extract, Transform and Load |
|
|
Term
| What feature of SQL 2008 would you use to support ETL? |
|
Definition
| SSIS (SQL Server Integration Services) |
|
|
Term
| What are the two main components of SSRS? |
|
Definition
| Report Server and Report Designer |
|
|
Term
| Which edition of SQL Server 2008 would you recommend for the major database platform for a corporation with over 5000 employees and several international locations? |
|
Definition
|
|
Term
| Why would you want to use SQL Server Standard Edition rather than Enterprise? |
|
Definition
|
|
