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

You are designing the HTTP endpoint for the proseware_projects application. A developer submits a CREATE ENDPOINT script for your approval. The script includes the following settings:AUTHENTICATION = (INTEGRATED)PORTS = (SSL)BATCHES = ENABLED You need to ensure that the script minimizes the security risks that are associated with the HTTP endpoint. What should you do prior to running the script?

The proseware_biz database includes a table named HR.Employee that contains employee data. The table has a clustered index on its EmployeeID column. You plan to create the following view, which retrieves the EmployeeID and HireDate fields for all employees who have been employed during the previous 12 months. CREATE VIEW HR.EmployedInLastYearWITH SCHEMABINDINGASSELECT EmployeeID, HireDateFROM HR.EmployeeWHERE HireDate > DATEADD(year,-1,GETDATE()) You need to create an appropriate index to optimize the performance of queries that reference this view. Which CREATE INDEX statement 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 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 are designing security for the HTTP endpoint for the proseware_projects application. You need to identify which login or logins should be granted the CONNECT permission on the HTTP endpoint. Which login or logins should you use? (Choose all that apply.)

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?

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

The proseware_biz database includes a table named HR.Employee that contains employee data. The table has a clustered index on its EmployeeID column. You plan to create the following view, which retrieves the EmployeeID and HireDate fields for all employees who have been employed during the previous 12 months. CREATE VIEW HR.EmployedInLastYearWITH SCHEMABINDINGASSELECT EmployeeID, HireDateFROM HR.EmployeeWHERE HireDate > DATEADD(year,-1,GETDATE()) You need to create an appropriate index to optimize the performance of queries that reference this view. Which CREATE INDEX statement should you use?