Which Transact-SQL code should you run?
You manage a SQL Server 2008 computer that has a default instance of SQL Server 2008 installed. You want tointegrate the Database Engine on the server with the NTFS file system. You enable FILESTREAM on the server.You need to enable FILESTREAM for Transact-SQL and Win32 streaming access. Which Transact-SQL code should you run?
What is the recommended type of account that you should configure for this purpose?
You are the database administrator of your company. You install a SQL Server 2008 computer on the network.You want to ensure that the SQL Server service is able to interact with other network services. What is the recommended type of account that you should configure for this purpose?
Which SSRS deployment should you use?
You are the SQL administrator for your company. You have deployed two SQL Server 2008 computers named SQL1 and SQL2 on your network. You need to deploy SQL Server Reporting Services (SSRS) to support both ad hoc and scheduled reports. Yourdeployment should provide maximum performance for SSRS.
Which SSRS deployment should you use?
which role should you add Adam to allow him to perform these tasks without giving him unnecessarypermissions?
You are the database administrator of your company. The network contains a SQL Server 2008 computer thathas a default instance of SQL Server installed. You want to allow an assistant administrator named Adam to beable to perform the following tasks:
? Execute, start, or stop all local jobs.
? Delete the job history for any local job.
? Enable or disable all local jobs and schedules.
To which role should you add Adam to allow him to perform these tasks without giving him unnecessarypermissions?
Which system stored procedure should the job execute?
You are the SQL administrator for your company. Two SQL Server 2008 computers, named SQL1 and SQL2 ,have been deployed.
Several reports run on a daily basis and are e-mailed to the appropriate personnel using Database Mail. The msdb database is growing much larger than expected, and you discover that this is due to the volume of e-mailmessages generated by Database Mail. You need to delete all e-mail messages that are more than 30 days oldfrom the msdb database.
You decide to create a job that will automatically run once each week. Which system stored procedure should the job execute?
What should you do next to ensure that the SQL Server service starts successfully?
You are the database administrator of your company. The network contains an instance of SQL Server 2008. Youconfigure a domain user account that will be used by the SQL Server service for the default instance. Afterseveral days, you discover that the SQL Server service is unable to start. You investigate and discover thepassword for the domain account has expired. To avoid this problem in the future, you create a new user account that will be used by the SQL Server service.The user account’s password does not expire. What should you do next to ensure that the SQL Server service starts successfully?
Which Transact-SQL script must you run on all three servers?
You are the SQL administrator for your company. You have three SQL Server 2008 computers named SQL1 , SQL2 , and SQL3 . Each server supports a single instance.
You have been asked to configure SQL1 to connect to remote data sources that use OLE DB. You have alsobeen asked to configure SQL2 to control CPU usage and to configure SQL3 to provide access to physicalmemory. Which Transact-SQL script must you run on all three servers?
Which three actions must you perform?
You are your company’s SQL administrator. A SQL Server 2008 computer named SQL3 is running SQL ServerReporting Services (SSRS) in SharePoint integrated mode. Your company has decided to discontinue the use of SharePoint Services due to lack of use. You must configureSSRS to use native mode and still be able to access all SSRS content. You start the SQL Reporting Service Configuration tool and configure SSRS to use native mode. You need tocomplete the process. Which three actions must you perform? (Choose three. Each correct answer represents part of the complete solution.)
Which service should you enable to provide this functionality?
You manage an instance of SQL Server 2008. You want to be able to back up and restore the SQL Serverinstance by using the Volume Shadow Copy Service (VSS) framework. Which service should you enable to provide this functionality?
which location should you obtain this information?
You have been hired as the SQL administrator for your company. The IT director tells you that the company hasthree SQL servers: one SQL Server 2005 server and two SQL Server 2008 servers. He shows you where thecomputers are located. You need to determine the version and build number for the SQL Server 2008 servers. You also need todetermine the collation used by the server. From which location should you obtain this information?