Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
10 Cards in this Set
- Front
- Back
|
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 |
B,C
|
|
|
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. |
C, D
|
|
|
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 |
C,D
|
|
|
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 |
B
|
|
|
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 |
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. |
|
|
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 |
D
D. Correct: Only SQL Server 2008 Enterprise supports all the advanced analytics needed, such as OLAP and Data Mining. |
|
|
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 |
D
Correct: sp_fi lestream_configure is used to enable the FILESTREAM access level as well as configure the Windows share to be used. |
|
|
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. SQL Server Configuration Manager D. SQL Server Surface Area Configuration Manager |
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. |
|
|
You have a reference database named OrderHistory, which should not allow any data to be modified. How can you ensure, with the least amount of effort, that users can only read data from the database?
A. Add all database users to the db_datareader role. B. Create views for all the tables and grant select permission only on the views to database users. C. Set the database to READ_ONLY. D. Grant select permission on the database to all users and revoke insert, update, and |
c
C. Correct: Unless the database is in READ_ONLY mode, members of the db_owner role can |
|
|
You are the database administrator at Blue Yonder Airlines and are primarily responsible for the Reservations database, which runs on a server running SQL Server 2008. In addition to customers booking flights through the company’s Web site, flights can be booked with several partners. Once an hour, the Reservations database receives multiple files from partners, which are then loaded into the database using the Bulk Copy Program (BCP) utility. You need to ensure that you can recover the database to any point in time while also maximizing the performance of import routines. How would you configure the database to meet business requirements?
A. Enable AUTO_SHRINK B. Set PARAMETERIZATION FORCED on the database C. Configure the database in the Bulk-logged recovery model D. Configure the database in the Full recovery model |
D
Correct: The full recovery model ensures that you can always recover the database to any point in time. |
