Microsoft-PRO Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005 Set 2

You plan to use a managed assembly in the proseware_projects database that includes a method to save the contents of an xml column as a local file. You need to import the assembly without granting it unnecessary permissions. Which permission level should you assign to the assembly?

You are designing the data archiving strategy for the proseware_projects database. You need to identify the data that should be archived when a project is completed. Your design must ensure that minimal storage space is used, and it must fulfill the business requirements for the solution. What should you do?

For the MarketingAnalysis database, you are adding functionality that sends the results of a query in an e-mail message to the marketing supervisors when new sales data has been entered. You need to implement a method that fulfills this requirement and minimizes the security risks. Which method should you use?

You are creating a management plan for the proseware_biz database. You need to specify the action that must be taken before manually inserting data through a bulk load process. Your plan must fulfill the availability and recoverability business requirements, and it also must require minimal administrative effort. Which action should you specify?

There are currently no permissions set on the following four objects in the proseware_biz database: Sales.Customersa table containing customer dataSales.CustomerContactsa table containing customer contact dataSales.ContactLista view that retrieves customer data from the Sales.Customers and Sales.CustomerContacts tablesSales.GetContacta stored procedure that retrieves data from the Sales.ContactList view You need to permit the sales_employee database role to retrieve data by using the Sales.GetContact stored procedure. Which action or actions should you perform? (Choose all that apply.)

You are creating a management plan for the proseware_biz database. You need to specify the steps that must be performed to fail over to the secondary server in order to take the primary server offline for planned maintenance. The primary server will resume its role after the maintenance task has been completed. Which step or steps should you specify? (Choose all that apply.)

You need to design a high-availability strategy for the proseware_projects database. Your design must fulfill all business and technical requirements. Which strategy should you use?

You are creating a management plan for the proseware_biz database. You need to specify the action that must be taken before manually inserting data through a bulk load process. Your plan must fulfill the availability and recoverability business requirements, and it also must require minimal administrative effort. Which action should you specify?

You need to specify the changes to the existing firewall configuration settings that are required by the HTTP endpoint that will be used by the proseware_projects database. What should you do?

You plan to use a managed assembly in the proseware_projects database that includes a method to save the contents of an xml column as a local file. You need to import the assembly without granting it unnecessary permissions. Which permission level should you assign to the assembly?