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

You are designing a data archival strategy for order data. The placements of data and partitions for the Sales.Orders table at the end of July are shown in the following display. On which filegroup should you locate partition 2 of the Sales.OrderArchive table?

You need to implement the HTTP endpoint for the Sales.AddOrder and Sales.GetOrderDetails stored procedures while minimizing the risk of unauthorized access to data and the risk of execution of unauthorized Transact-SQL code. Which action or actions should you perform? (Choose all that apply.)

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 planning the configuration of the SQL Server 2005 instance where the BusinessData database will be stored. As a security precaution, you need to ensure that Windows services that are not essential are disabled. Which Windows service or services should be disabled? (Choose all that apply.)

You are designing the backup strategy for the BusinessData database. You need to ensure that the backup strategy fulfills the business requirements for minimizing data loss and database downtime. Which three backup methods should your strategy include? (Each correct answer presents part of the solution. Choose three.)

You are designing the interim disk availability solution for SQL1. You plan to use Windows RAID functionality. You need to identify the most appropriate RAID configuration to fulfill the availability requirements. Which RAID configuration should you use?

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 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?

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 designing the backup strategy for the BusinessData database. You need to ensure that the backup strategy fulfills the business requirements for minimizing data loss and database downtime. Which three backup methods should your strategy include? (Each correct answer presents part of the solution. Choose three.)