keywords:
Bookmark and Share



Front Back
Name the SQL Server 2008 Editions. (1-4)
  • Express
  • Workgroup
  • Standard
  • Enterprise
  • Developer
  • Web
  • Mobile
Use of Express server edition.(1-4)
For disconnected clients or stand-alone applications.
Use of Workgroup server edition.(1-4)
Database for workgroup or branch office applications.
Use of Standard server edition.(1-4)
Database server for departmental-level applications.
Use of Enterprise server edition.(1-4)
Highly scalable and available enterprise-level database.
Use of Developer server edition.(1-4)
Enterprise edition, licensed for development and testing.
Use of Web server edition.(1-4)
Enables hosting companies to provide low cost, highly scalable hosting with a low monthly licensing fee.
Use of Mobile server edition. (1-4)
Compact database for smart handheld devices.
What are the minimum (recommended) processor requirements for SQL Server 2008? What are the minimum processor requirments for 64-bit? (1-5)
  • Intel compatible Pentium 600Mhz+ (1 Ghz+)
  • 1Ghz+ for 64-bit
What are the minimum (recommended) memory requirements for SQL server? (1-5)
  • Standard, Enterprise, Developer editions: 512MB (1GB+)
  • Express Edition: 192MB (512MB+)
What are the minimum disk space requirements for? (1-5)
  • Database Components
  • Analysis Services
  • Reporting Services
  • Integration Services
  • Client Components
  • 280MB
  • 90MB
  • 120MB
  • 120MB
  • 850MB
What versions of SQL Server 2008 will run on Vista 32-bit? (1-7)
  • Standard
  • Workgroup
  • Enterprise
  • Developer
What versions of SQL Server 2008 will run on Server 2008 32-bit? (1-7)
  • Expresss
  • Standard
  • Workgroup
  • Enterprise
  • Developer
What versions of SQL Server 2008 will run on Server 2003 SP2 32-bit? (1-7)
  • Expresss
  • Standard
  • Workgroup
  • Enterprise
  • Developer
What versions of SQL Server 2008 will run on XP Professional SP2 32-bit? (1-7)
  • Expresss
  • Standard
  • Workgroup
  • Enterprise
  • Developer
What versions of SQL Server 2008 will run on XP SP2 (32-bit and 64-bit)? (1-7)
  • Expresss
What versions of SQL Server 2008 will run on Vista 64-bit? (1-8)
  • Expresss
  • Standard
  • Workgroup
  • Enterprise
  • Developer
What versions of SQL Server 2008 will run on Windows Server 2008 64-bit? (1-8)
  • Expresss
  • Standard
  • Workgroup
  • Enterprise
  • Developer
What versions of SQL Server 2008 will run on Server 2003 64-bit? (1-8)
  • Expresss
  • Standard
  • Workgroup
  • Enterprise
  • Developer
What versions of SQL Server 2008 will run on XP Professional 64-bit SP2? (1-8)
  • Expresss
  • Standard
  • Workgroup
  • Enterprise
  • Developer
Default Instance (3 pts.) (1-9)
  • The network name of the computer it's running on.
  • Preserves compatability with earlier version.
  • Can be only one
Named Instance (1-9)
  • The network name of the computer plus and instance name.
  • Required by applications calling for a non-default instance
  • Format of <computer name>\<instance name>
Browser service (2 pts.) (1-9)
  • Listens for incoming requests for SQL ServerĀ  resources.
  • Provides information about SQL server instances.
What are the 3 types of licensing for SQL Server 2008? (1-11)
  • Processor license
  • Server plus device CALs
  • Server plus user CALs
What does CAL stand for? (1-11)
Client Access License
Processor license (1-11)
  • Requires a single license for each CPU
  • Best suited for Internet and applications with high client/server ratios
Server plus device CALs (1-11)
  • Requires a license for each computer
  • Plus a CAL for each client device
  • Best suited for applications that don't need to pass through the firewall and that have a low CAL to Server ratio
Server plus user CALs (1-11)
  • Requires a license for each computer
  • Plus a CAL for each user
Enhanced physical security (1-13)
Fondation of SQL server security
Firewalls (1-13)
Integral to securing SQL servers
Isolated services (1-13)
Reduces the rist that one compromised component could be used to compromise others.
Service accounts (1-13)
  • Create with least privileges
  • SQL server automatically configures during setup
What accounts can be used for SQL server? (1-13/14)
Domain or local user accounts
Windows Collation (1-15)
Based on the rules associated Windows locale
SQL server collations (1-15)
Matches the code page number and sort order that may have been specified in earlier versions of SQL server.
Default collations and sort rules (1-15)
Applies if you do not designate collation or sort rules
Define collation (1-15)
Term referred to as a set of rules that determines how data is compared and collated
When and why should collation decisions be made? (1-15)
  • Decided at setup of server because to change the collation server settings all databases must be rebuilt
  • Collation can be decided at the time of creation for a new database.
What considerations are required for In-place upgrades to SQL 2008 (4 pts.) (1-17)
  • Easier, mostly automated
  • System data upgraded
  • No additional hardware
  • Apps point to same name
What considerations are required for Side-by-side upgrades (4pts) (1-17)
  • MoreĀ  granular control over process
  • Can be used to perform test migration
  • Relatively straightforward rollback
  • Can leverage failover/switchover
What side-by-side support exists for SQL Server 2008 32-bit? (1-17)
  • SQL Server 2005 (32-bit)
  • SQL Server 2005 (64-bit) x64
What side-by-side support exists for SQL Server 2008 64-bit IA64? (1-17)
  • SQL Server 2005 (64-bit) IA64
What side-by-side support exists for SQL Server 2008 (64-bit) x64? (1-17)
  • SQL Server 2005 (32-bit)
  • SQL Server 2005 (64-bit) x64
SQL Server 2008 Upgrade Advisor (1-17)
  • Tool to help you prepare for upgrades to SQL server 2008.
  • Analyzes installed SQL 2000 or 2005 components
  • Generates reports identifying issues that you should address before or after upgrading to SQL 2008
System Configuration Checker (SCC) (1-17)
Checks system for conditions that prevent a successful SQL server installation
What is the installation process steps for SQL server 2008? (1-21)
What are the areas that the SCC checks and requires? (4pts+subpoints) (1-22)
  • Software Requirements
    • Windows Management Instrumentation (WMI) must be available or installation blocked.
    • Unsupported OS blocks setup
  • Hardware requirements
    • Setup is not blocked but user is warned if memory requirements are not met
  • Security Requirements
  • System State Requirments
    • Other services, processes, or applications must not have any setup required files locked.
What are the 6 main components for server installation? (1-23)
  • SQL Server Database engine - core database engine, replication, search, and tools for managing relational and xml data, replication, and full-text search
  • Analysis Services - Server and tools for online analytical processing (OLAP) and data mining. Also installs integration services
  • Reporting services - Server and client components for generating and distributing reports.
  • Integration Services - tools and components for transferring data and preforming tasks
  • Notification services - platform for applications that send notifications
  • Management Tools - tools to access, configure, manage, and administer SQL Server components
What does OLAP stand for? (1-23)
Online Analytical Processing.
What type of services does the Management Tools component provide? (1-24)

  • Configuration Manager
  • Profiler
  • Database Engine Tuning Advisor
  • Business Intelligence Development Studio
  • Connectivity Components
x of y cards Next > >|