You are designing a CLR stored procedure that will access a remote Web service. You need to ensure that the CLR stored procedure can access the remote Web service. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
A. Grant EXECUTE on the CLR stored procedure.
B. Implement a custom trust level policy.
C. Configure the CLR stored procedure to use the SAFE permission set.
D. Configure the CLR stored procedure to use the EXTERNAL_ACCESS permission set.
You need to design a solution to guarantee that a stored procedure is part of every transaction. What should you do?
A. Enable implicit transactions.
B. Enable Distributed Transaction Coordinator (DTC).
C. Set the NOCOUNT option to ON.
D Set the XACT_ABORT option to ON.
You have a server that runs SQL Server 2008. The server supports an online application. New products are constantly being added to a database stored on the server. You identify the following:
– Searches often take too long
– Users cannot search by using multiple criteria
– Users cannot adequately search product descriptions
– Most queries that search the product descriptions use “LIKE *%…%”‘ as the filter predicate
You need to provide a developer the ability to create and modify database diagrams from an existing database by using SQL Server Management Studio. The solution must minimize the amount of permissions assigned to the developer. What should you do?
A. Add the developer to the sysadmin role.
B. Add the developer to the db_owner role.
C. Grant the developer the CREATE TABLE permission only.
D. Grant the developer the CREATE SCHEMA permission only.
Your company has four offices. Each office contains a server that runs SQL Server 2008. All corporate data is stored in a central location. You need to create a reporting solution. The solution must meet the following requirements:
– Minimize hardware costs
– Minimize administrative effort
– Minimize the time it takes to generate the reports
– Enable users to run reports locally, even if a WAN link fails
What should you do?
A. Implement database mirroring.
B. Implement log shipping.
C. Create horizontally partitioned tables and a federated database.
D. Implement a geographically dispersed SQL Server 2008 cluster.