2008 Sql Server Chapter 1

Front 1

What edition of Windows Server 2008 is not supported for SQL Server 2008 installations?

Back 1

Windows Server 2008 Server Core

Front 2

Which operating systems are supported for all editions of SQL Server?

Back 2

Windows Server 2003 Standard SP2 or higher, Windows Server 2008 Standard RCO or higher

Front 3

Which editions support the entire feature set available within the SQL Server data platform? Of these editions, which editions are not licensed for production use?

Back 3

Enterprise, Developer, and Evaluation

Developer and Evaluation editions are not licensed for use in a production environment.

Front 4

Which editions of SQL Server are designed as storage engines for embedded applications with limited hardware and feature support?

Back 4

Express and Compact editions are designed as storage engines for embedded applications and support only a single CPU, up to 1 GB of RAM, and a maximum database size of 4 GB.

Front 5

SQL Server 2008 is available in 5 editions for use in a production environment.

Back 5

Enterprise, Standard, Workgroup, Express, and Compact

Front 6

In addition to the core database engine technologies, SQL Server 2008 Enterprise supports Service Broker for ________.

Back 6

asynchronous processing

Front 7

Which edition of SQL Server supports installing more than one instance of SQL Server on a machine?

Back 7

Enterprise

Front 8

What are the authentication modes that SQL Server can be configured with?

Back 8

Windows Only
or
Windows AND SQL Server authentication

Front 9

SQL Server supports up to ____instances installed on a single machine; however, only the Enterprise Edition has multi-instance support

Back 9

50

Front 10

What are the two basic components of Database Mail?

Back 10

Database Mail uses mail profiles which can contain one or more mail accounts.

Front 11

What are the two types of mail profiles that can be created?

Back 11

Mail profiles can be configured as either public or private.

Front 12

To send mail messages, _________ must be running.

Back 12

SQL Server Agent

Front 13

You can create either public or private mail _______.

Back 13

profiles

Front 14

As part of the implementation of the new Web-based booking system at Margie’s Travel, customers should receive notices when a travel booking has been successfully saved. What technologies or features can the developers at Margie’s Travel use to
implement notifications? (Choose all that apply.)

A. Notification Services
B. Database Mail
C. Microsoft Visual Studio.NET code libraries
D. Activity Monitor

Back 14

B, C

Front 15

The developers at Margie’s Travel have decided to utilize Database Mail to send messages to their customers. The ability to send mail messages through a given profile needs to be restricted, but it must not require an approved user to specify a mail profile when sending messages. What settings need to be configured to meet these requirements? (Choose all that apply.)

A. Set the mail profile to public.
B. Set the mail profile to private.
C. Set the mail profile to private and grant access to approved users.
D. Designate the mail profile as the default.

Back 15

C, D

Front 16

You are deploying a new server within Wide World Importers that will be running a SQL Server 2008 instance in support of a new application. Because of the feature support that is needed, you will be installing SQL Server 2008 Enterprise. Which operating systems will support your installation? (Choose all that apply.)

A. Windows 2000 Server Enterprise SP4 or higher
B. Windows Server 2003 Enterprise
C. Windows Server 2003 Enterprise SP2
D. Windows Server 2008 Enterprise

Back 16

C,D

Front 17

You are deploying SQL Server 2008 Express in support of a new Web-based application that will enable customers to order directly from Coho Vineyards. Which operating system does NOT support your installation?

A. Windows XP Home Edition SP2
B. Windows Server 2008 Server Core
C. Windows Server 2003 Enterprise SP2
D. Windows XP Tablet Edition SP2

Back 17

B

Front 18

Margie’s Travel is opening a new division to offer online travel bookings to their customers. Managers expect the traffic volume to increase rapidly, to the point where hundreds of users will be browsing offerings and booking travel at any given time. Management would also like to synchronize multiple copies of the database of travel bookings to support both online and face-to-face operations. Which editions of SQL Server 2008 would be appropriate for Margie’s Travel to deploy for their new online presence? (Choose all that apply.)

A. Express
B. Standard
C. Enterprise
D. Compact

Back 18

B,C

B. Correct: Standard can handle the user load needed and supports the replication features
needed to synchronize databases.

C. Correct: Enterprise can scale to handle any load as well as provide any capability needed
by Margie’s Travel.

Front 19

Margie’s Travel decided to minimize the cost and deploy SQL Server 2008 Standard to support the new online division. After a successful launch, managers are having a hard time managing business operations and need to deploy advanced analytics. A new server running SQL Server will be installed. Which edition of SQL Server needs to be installed on the new server to support the necessary data analytics?
A. SQL Server 2008 Standard
B. SQL Server 2008 Express with Advanced Services
C. SQL Server 2008 Workgroup
D. SQL Server 2008 Enterprise

Back 19

D

D. Correct: Only SQL Server 2008 Enterprise supports all the advanced analytics needed, such as OLAP and Data Mining.

Front 20

Wide World Importers will be using the new FILESTREAM data type to store scanned images of shipping manifests. Which command must be executed against the SQL Server instance before FILESTREAM data can be stored?

A. ALTER DATABASE
B. DBCC
C. sp_confi gure
D. sp_fi lestream_confi gure

Back 20

D

Correct: sp_fi lestream_configure is used to enable the FILESTREAM access level as well as configure the Windows share to be used.

Front 21

Contoso has implemented a new policy that requires the passwords on all service accounts to be changed every 30 days. Which tool should the Contoso database
administrators use to change the service account passwords so that SQL Server services comply with the new policy?
A. Windows Service Control applet
B. SQL Server Management Studio
C. QL Server Confi guration Manager
D. SQL Server Surface Area Confi guration Manager

Back 21

C

C. Correct: Only the SQL Server Confi guration Manager has the code to decrypt and re-encrypt the service master key used by SQL Server services correctly when the service account or password is changed.