单项选择题
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a single Database Mail profile. Reports are sent to all the company employees by using the Mail profile. During office hours, a large volume of reports are sent by the sp_send_dbmail stored procedure. Now you notice that it takes a long time for the reports to be sent to the company manager. As the technical support, you have to speed up the delivery. So what action should you perform to achieve this goal?()
A.Another SMTP account should be added to the existing Database Mail profile
B.When you send the reports to the manager, you should use the @importance = high parameter.
C.You should change the Account Retry Attempts option of the Database Mail system properties
D.You should configure a new Database Mail profile. The new one will be used for sending the reports to the manager.
相关考题
-
单项选择题
YouworkinacompanywhichusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.YouintendtoconfigureFILESTREAMdata,enablingFILESTREAMforfileI/OstreamingaccessandallowingremoteclientcomputerstohavestreamingaccesstoFILESTREAMdata.YoumustmakesurethatFILESTREAMdataisenabled.Intheoptionsbelow,whichserviceshouldyouconfigure?()
A.You should configure Distributed File System
B.You should configure SQL Server
C.You should configure SQL Server Full Text
D.You should configure SQL Server VSS Writer -
单项选择题
YouworkinacompanywhichusesSQLServer2008.Youaretheadministratorofthecompanydatabase.InyourcompanythereisaserverwhichcontainsadefaultSQLServer2005instance.Foranewapplication,youhavetoinstallaSQLServer2008instanceontheserver.YourcompanyCIOassignsatasktoyou.Youmustmakesurethattherespectivecertifiedthird-partyapplicationshaveaccesstobothdatabaseinstances.Youhavetoachievethisgoalwithoutchangingtheexistingapplicationenvironments.Sowhatshouldyoudotoachievethisbyusingaslittledatabaseadministrativeeffortaspossible?()
A.You should install SQL Server 2008 as a named instance, and make the new application to use the new instance.
B.You should install SQL Server 2008 as the default instance, and make the new application to use the default instance.
C.You should upgrade the SQL Server 2005 application to use SQL Server 2008.
D.You should upgrade the SQL Server 2005 instance to a SQL Server 2008 instance. -
单项选择题
ouworkinacompanywhichusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.Accordingtothecompanyrequirement,youintendtoperformaninstallationofaninstanceofSQLServerReportingServices(SSRS)tothesamemachine.NowyourcompanyCIOwantsversionhistoriesofalldeployedreportscanbekept.Asatechnicalsupport,whatshouldyoudotoensurethis?()
A.You should use the http.sys listener to install the SSRS instance.
B.You should configure the SSRS database, make it use Native mode
C.You should configure the SSRS database, make it use SharePoint integrated mode
D.You should use the Internet Information Services default Web site to install the SSRS instance
