TAILIEUCHUNG - The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P154

The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P154: Congratulations on your journey to become certified in SQL Server 2008. This book will help prepare you for your exam and give you a practical view of working with SQL Server 2008. | 70 Appendix Self Test Appendix break the linked server you created for secured access to Oracle. Answer D is incorrect because you already have linked server and while linked servers provide an alternative to distributed ad hoc distributed they don t prevent distributed ad hoc queries. 9. You need to write a query that joins data from your local SQL Server Instance with data from an Oracle instance. You need to be able to submit specific syntax to the Oracle instance to get the correct results by using a pass-through query. No linked servers currently exist for the remote Oracle instance. You are not an administrator on the system. Which one of the following choices meets your needs A. Use OPENQUERY B. Use OPENDATASOURCE C. Use OPENROWSET D. Create a Linked Server Correct Answer and Explanation C. Answer C is correct becauseOPEN-ROWSET allows you to submit pass-through queries to a remote system and it does not require that you be an administrator as long as an administrator has allowed ad hoc distributed queries and enabled the required provider for ad hoc access. Incorrect Answers and Explanations A B and D. Answer A is incorrect because OPENQUERY requires that you have a linked server definition in order to use it. Answer B is incorrect because the OPENDATASOURCE function does not support pass-through queries. Answer D is incorrect because you are not an administrator and don t have the privilege to create linked servers on the SQL Server instance. 10. You need to provide support for distributed queries to a remote SQL Server instance but you need to allow it only for selected users. Which one of the following solutions meets the requirements A. Grant execute permissions on the OPENROWSET function to the selected users. B. Create a linked server and assign the selected users credentials to use when connecting to the remote instance C. Enable the disallow adhoc access on the SQL Server OLE DB to prevent ad hoc access Self Test Appendix Appendix 71 D. Use .

Đã phát hiện trình chặn quảng cáo AdBlock
Trang web này phụ thuộc vào doanh thu từ số lần hiển thị quảng cáo để tồn tại. Vui lòng tắt trình chặn quảng cáo của bạn hoặc tạm dừng tính năng chặn quảng cáo cho trang web này.