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?
- Set the mail profile to public.
- Set the mail profile to private and grant access to approved users.
- Designate the mail profile as the default.
- Set the mail profile to private.
- Set the mail profile to private and grant access to approved users.
- Designate the mail profile as the default.
EXPLANATION:
You need to configure the mail profile to be private along with granting access to the mail profile for approved users.
Designating a mail profile as the default allows approved users to send mail using the profile without the need to specify the profile explicitly.
Margie’s Travel decided to minimize the cost and deploy SQL SVR 2008 STD to support the new online division. After a successful launch, managers are having a hard time managing business operatoins and need to deploy advanced analytics. A new server running SQL SVR will be installed. Which edition of SQL SVR needs to be installed on teh new server to support the necessary data analytics?
- SQL SVR 08 Workgroup
- SQL SVR 08 Standard
- SQL SVR 08 Express with Advanced Services
- SQL Server 08 Enterprise
SQL Server 08 Enterprise
EXPLANATION:
Only SQL Server 2008 Enterprise supports all the advanced analytics needed, such as OLAP and Data Mining
You have a list of words that should be excluded from search arguments. Which action should you perform in SQL SVR 08 to meet your requirements with the least amount of effort?
- Populate a thesaurus file and associate the thesaurus file to the full text index.
- Create a noise word file and associate the noise word file to the full text index.
- Create a stop list and associate the stop list to the full text index.
- Parse the inbound query and remove any common words from the search arguments.
Create a stop list and associate the stop list to the full text index.
EXPLANATION:
Stop lists are created in SQL 08 to exclude words from a full text index as well as search arguments. After the stop list is associated to a full text index, any queries that use the index automatically have any stop words removed from the search arguments.
You are the database administrator at your company. You need to enable the sales support team to perform fuzzy searches on product descriptions. Which actions do you need to perform to satisfy user needs with the least amount of effort? (Choose two. Each forms part of the correct answer.)
- Create a full text index on the table of product descriptions for the description column and specify CHANGE_TRACKING AUTO.
- Create a full text catalog and specify the filegroup to store the contents of the catalog.
- Create a full text index on the table of product descriptions for the description column and specify NO POPULATION.
- Create a full text catalog specifying the filegroup for backup purposes and the root path to store the contents of the catalog on the file system.
- Create a full text index on the table of product descriptions for the description column and specify CHANGE_TRACKING AUTO.
- Create a full text catalog and specify the filegroup to store the contents of the catalog.
EXPLANATION:
Full text catalogs contain full text indexes and the contents of the indexes are stored within the database in SQL Server 2008.
CHANGE_TRACKING AUTO option enables SQL Server to populate the full text index upon initial creation and migrate changes automatically to underlying data into the index.
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?
- SQL Server Configuration Manager
- SQL Server Management Studio
- SQL Server Surface Area Configuration Manager
- Windows Service Control applet
- SQL Server Configuration Manager
EXPLANATION:
Only the SQL Server Configuration 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 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.)
- Windows Server 2008 Enterprise
- Windows 2000 Server Enterprise SP4 or higher
- Windows Server 2003 Enterprise
- Windows Server 2003 Enterprise SP2
- Windows Server 2008 Enterprise
- Windows Server 2003 Enterprise SP2
EXPLANATION
SQL Server 2008 Enterprise is supported on Windows Server 2003 Enterprise SP2 and later or Windows Server 2008 Enterprise.
SQL Server 2008 Enterprise Edition is supported on Windows Server 2003 Enterprise SP2 and later or Windows Server 2008 Enterprise.
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.)
- Microsoft Visual Studio.NET code libraries
- Database Mail
- Activity Monitor
- Notification Services
- Microsoft Visual Studio.NET code libraries
- Database Mail
EXPLANATION
Database Mail can be used to send messages to customers.
A Visual Studio.NET application can be created to use the mail libraries available within the .NET Framework.
You want to configure your full text indexes such that SQL Server migrates changes into the index as quickly as possible with the minimum amount of administrator effort. Which command should you execute?
- ALTER FULLTEXT INDEX ON <table_name> SET CHANGE_TRACKING AUTO
- ALTER FULLTEXT INDEX ON <table_name> START UPDATE POPULATION
- ALTER FULLTEXT INDEX ON <table_name> START INCREMENTAL POPULATION
- ALTER FULLTEXT INDEX ON <table_name> START FULL POPULATION
ALTER FULLTEXT INDEX ON <table_name> SET CHANGE_TRACKING AUTO
EXPLANATION:
When the CHANGE_TRACKING argument is set to AUTO, SQL Server automatically updates the full text index as changes to underlying data occur. In AUTO mode, no administrator intervention is required either manually or via a scheduled job.
Exam Objective:
Installing and Configuring SQL Server 2008
Exam SubObjective(s): Configure full-text indexing.
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.)
- Compact
- Express
- Standard
- Enterprise
- Standard
- Enterprise
EXPLANATION:
Standard can handle the user load needed and supports the replication features needed to synchronize databases.
Enterprise can scale to handle any load as well as provide any capability needed by Margie’s Travel.
Exam Objective:
Installing and Configuring SQL Server 2008
Exam SubObjective(s): Install SQL Server 2008 and related services.
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?
- Windows Server 2003 Enterprise SP2
- Windows XP Tablet Edition SP2
- Windows Server 2008 Server Core
- Windows XP Home Edition SP2
Windows Server 2008 Server Core
EXPLANATION:
SQL Server 2008 Express is not supported on Windows Server 2008 Server Core.
Exam Objective:
Installing and Configuring SQL Server 2008
Exam SubObjective(s): Install SQL Server 2008 and related services.
You want to perform a proximity search based on a weighting value for the search arguments. Which options for the CONTAINSTABLE predicate should you use?
- FORMSOF with the THESAURUS keyword
- FORMSOF with the INFLECTIONAL keyword
- ISABOUT with the WEIGHT keyword
- ISABOUT
ISABOUT with the WEIGHT keyword
EXPLANATION:
ISABOUT performs proximity searches and it also applies weighting if the WEIGHT keyword and weighting value are supplied.
Exam Objective:
Installing and Configuring SQL Server 2008
Exam SubObjective(s): Configure full-text indexin
You want to search for two terms based on proximity within a row. Which full text predicates can be used to perform proximity searches? (Choose two. Each forms a separate answer.)
- FREETEXT
- CONTAINSTABLE
- FREETEXTTABLE
- CONTAINS
- CONTAINSTABLE
- CONTAINS
EXPLANATION
CONTAINS allows proximity searches by using the NEAR keyword.
CONTAINSTABLE allows proximity searches by using the NEAR keyword.
Exam Objective:
Installing and Configuring SQL Server 2008
Exam SubObjective(s): Configure full-text indexing.
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?
- sp_configure
- DBCC
- ALTER DATABASE
- sp_filestream_configure
sp_filestream_configure
EXPLANATION:
sp_filestream_configure is used to enable the FILESTREAM access level as well as configure the Windows share to be used.
Exam Objective:
Installing and Configuring SQL Server 2008
Exam SubObjective(s): Configure SQL Server instances.
