70\uff0d431
\n<\/a>\u8cc7\u00a0\u00a0\u00a0 \u683c\uff1a\u7121
\n\u5b78\u00a0\u00a0\u00a0 \u6b77\uff1a\u5831\u8003MCTS\u4e0d\u9650\u5236\u8003\u751f\u7684\u6587\u6191\uff0c\u4efb\u4f55\u4eba\u90fd\u53ef\u4ee5\u5831\u8003
\n\u80fd\u00a0\u00a0\u00a0 \u529b\uff1a\u57fa\u672c\u7684\u8a08\u7b97\u6a5f\u61c9\u7528\u80fd\u529b\uff0c\u5fae\u8edf\u516c\u53f8\u5efa\u8b70\u8003\u751f\u6700\u597d\u76f8\u61c9\u7684\u8edf\u4ef6\u4f7f\u7528\u548c\u6280\u8853\u61c9\u7528\u7684\u7d93\u9a57<\/p>\n\u76f8\u95dc\u7684\u90e8\u4efd\u8003\u984c\u5982\u4e0b\uff1a<\/p>\n
1. You are preparing for a new installation of SQL Server 2005. You need to select the<\/p>\n
protocols that client
\ncomputers might use to connect to the server. Which two protocols can you use to achieve<\/p>\n
this goal?
\n(Each correct answer presents a complete solution. Choose two.)
\nA. Named Pipes
\nB. TCP\/IP
\nC. Shared Memory
\nD. Virtual Interface Adapter (VIA)
\nE. Multiprotocol
\nAnswer: AB
\n2. Application developers in your company create an assembly that contains a CLR function.<\/p>\n
This CLR
\nfunction reads data from a spreadsheet, performs some calculations, and returns the data to<\/p>\n
a SQL
\nServer 2005 computer. You need to register the assembly with SQL Server 2005 by using the<\/p>\n
CREATE
\nASSEMBLY statement and the least privileged security permission set. Which permission set<\/p>\n
should you
\nuse?
\nA. Default
\nB. SAFE
\nC. EXTERNAL_ACCESS
\nD. UNSAFE
\nAnswer: C
\n3. Your company has two SQL Server 2005 computers named SQL1 and SQL2. A user in your<\/p>\n
company
\nnamed Eric writes many ad hoc queries against the company databases. Eric has access to the
\nCustomer database on SQL1. He does not have access to the Sales database on SQL2. You need<\/p>\n
to
\nensure that Eric can write queries that join information from both servers. What should you<\/p>\n
do first?
\nA. Create a linked server on SQL1 to SQL2. Configure the linked server to use impersonation.
\nB. Create a linked server on SQL1 to SQL2. Configure the linked server to use mapped logins.
\nC. Instruct Eric to write the queries on SQL2 by using the OPENQUERY statement and<\/p>\n
specifying SQL1
\nas the server name.
\nD. Instruct Eric to specify SQL Server object names by using four-part notation
\nAnswer: B<\/p>\n","protected":false},"excerpt":{"rendered":"
MCTS\u8a8d\u8b49\u662f\u5fae\u8edf\u5168\u65b0\u8a8d\u8b49\u9ad4\u7cfb\u4e2d\u6700\u57fa\u790e\u7684\u8b49\u66f8\uff0c\u5176\u8b49\u66f8\u7684\u7b49\u7d1a\u76f8\u7576\u65bc\u4ee5\u524d\u7684MCP\u8a8d\u8b49\uff0c\u4f46MCTS\u8a8d\u8b49\u66f4\u6709\u91dd\u5c0d\u6027\u7684\u5728\u6bcf\u500b\u8b49\u66f8\u591a\u4e86\u5176\u6280\u8853\u65b9\u5411\u7684\u8aaa\u660e\uff0c\u7ffb\u8b6f\u904e\u4f86\u5c31\u662f\u5fae\u8edf\u8a8d\u8b49\u6280\u8853\u5c08\u5bb6\u7684\u610f\u601d\uff0cMCTS\u8a8d\u8b49\u64daIT\u8a8d\u8b49\u8003\u8a66\u8cc7\u6e90\u7db2\u4ecb\u7d39MCTS\u8a8d\u8b49\u5074\u91cd\u65bc\u67d0\u9805\u7684\u5fae\u8edf\u7522\u54c1\u6216\u6280\u8853\u7684\u8cc7\u683c\u7684\u9452\u5b9a\uff0c\u8003\u8a66\u79d1\u76ee\u6700\u5c11\u53ea\u89811\u79d1\u5c31\u53ef\u4ee5\u7372\u5f971\u9805 MCTS\u8a8d\u8b49\u3002 \u5831\u8003MCTS\u7684\u57fa\u790e\u689d\u4ef6: \u8003\u8a66\u79d1\u76ee\uff1a70\uff0d431 \u8cc7\u00a0\u00a0\u00a0 \u683c\uff1a\u7121 \u5b78\u00a0\u00a0\u00a0 \u6b77\uff1a\u5831\u8003MCTS\u4e0d\u9650\u5236\u8003\u751f\u7684\u6587\u6191\uff0c\u4efb\u4f55\u4eba\u90fd\u53ef\u4ee5\u5831\u8003 \u80fd\u00a0\u00a0\u00a0 \u529b\uff1a\u57fa\u672c\u7684\u8a08\u7b97\u6a5f\u61c9\u7528\u80fd\u529b\uff0c\u5fae\u8edf\u516c\u53f8\u5efa\u8b70\u8003\u751f\u6700\u597d\u76f8\u61c9\u7684\u8edf\u4ef6\u4f7f\u7528\u548c\u6280\u8853\u61c9\u7528\u7684\u7d93\u9a57 \u76f8\u95dc\u7684\u90e8\u4efd\u8003\u984c\u5982\u4e0b\uff1a 1. You are preparing for a new installation of SQL Server 2005. You need to select the protocols that client computers might use to connect to the server. Which two protocols can you use to achieve this goal? (Each correct answer presents a complete […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[3269,549,548],"class_list":["post-2109","post","type-post","status-publish","format-standard","hentry","category-microsoft","tag-70-431","tag-70-431-"],"_links":{"self":[{"href":"https:\/\/www.killtest.com.tw\/index.php?rest_route=\/wp\/v2\/posts\/2109","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.killtest.com.tw\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.killtest.com.tw\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.killtest.com.tw\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.killtest.com.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2109"}],"version-history":[{"count":5,"href":"https:\/\/www.killtest.com.tw\/index.php?rest_route=\/wp\/v2\/posts\/2109\/revisions"}],"predecessor-version":[{"id":2177,"href":"https:\/\/www.killtest.com.tw\/index.php?rest_route=\/wp\/v2\/posts\/2109\/revisions\/2177"}],"wp:attachment":[{"href":"https:\/\/www.killtest.com.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2109"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.killtest.com.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2109"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.killtest.com.tw\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2109"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}