MicrosoftUpgradeTransitionYourMCITPSQLServer2005DBDtoMCITPSQLServer2008DBD70-454题库资料.pdf

Microsoft 70-454 Upgrade: Transition Your MCITP SQL Server 2005 DBD to MCITP SQL Server 2008 DBD Version: 34.0 买题库 QQ:860424807 Microsoft 70-454 Exam QUESTION NO: 1 You have a table that has 10 million rows. The table has a view that returns all of the rows. You discover performance degradation when you run an unfiltered view. You need to recommend a solution to replace the view. The solution must require that the returned data is filtered by a parameter. What should you use? A. an indexed view B. a scalar function C. a table-valued function D. atable-valued type Answer: C Explanation: QUESTION NO: 2 You are a database developer. You plan to design a database solution by using SQL Server 2008. There are two schemas named Sales and Marketing. You are the owner of the Sales schema and the Marketing schema is owned by a user named MarketingUser. Users of the Marketing schema do not have permissions to access the Sales schema. You have permissions to create objects in all schemas in the database. The Sales schema has a table named Customers. You plan to create a stored procedure in the Marketing schema for the marketing team. The stored procedure will select data from the Customers table and will be owned by MarketingUser. You need to ensure that the marketing team is able to execute the stored procedure. What should you do? A. Create the procedure by using the EXECUTE AS SELF option. B. Create the procedure by using the EXECUTE AS CALLER option. C. Create the procedure by using the EXECUTE AS OWNER option. D. Create the procedure by using the EXECUTE AS USER=MarketingUser option. Answer: A Explanation: 买题库 QQ:860424807 2 Microsoft 70-454 Exam QUESTION NO: 3 You have a table named Table1. A sample of the data in Table1 is shown in the followi