MCTS認證是微軟全新認證體系中最基礎的證書，其證書的等級相當於以前的MCP認證，但MCTS認證更有針對性的在每個證書多了其技術方向的說明，翻譯過來就是微軟認證技術專家的意思，MCTS認證據IT認證考試資源網介紹MCTS認證側重於某項的微軟產品或技術的資格的鑒定，考試科目最少只要1科就可以獲得1項
MCTS認證。
報考MCTS的基礎條件:
考試科目：70－431
資 格：無
學 歷：報考MCTS不限制考生的文憑，任何人都可以報考
能 力：基本的計算機應用能力，微軟公司建議考生最好相應的軟件使用和技術應用的經驗
相關的部份考題如下：
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 solution. Choose two.)
A. Named Pipes
B. TCP/IP
C. Shared Memory
D. Virtual Interface Adapter (VIA)
E. Multiprotocol
Answer: AB
2. Application developers in your company create an assembly that contains a CLR function.
This CLR
function reads data from a spreadsheet, performs some calculations, and returns the data to
a SQL
Server 2005 computer. You need to register the assembly with SQL Server 2005 by using the
CREATE
ASSEMBLY statement and the least privileged security permission set. Which permission set
should you
use?
A. Default
B. SAFE
C. EXTERNAL_ACCESS
D. UNSAFE
Answer: C
3. Your company has two SQL Server 2005 computers named SQL1 and SQL2. A user in your
company
named Eric writes many ad hoc queries against the company databases. Eric has access to the
Customer database on SQL1. He does not have access to the Sales database on SQL2. You need
to
ensure that Eric can write queries that join information from both servers. What should you
do first?
A. Create a linked server on SQL1 to SQL2. Configure the linked server to use impersonation.
B. Create a linked server on SQL1 to SQL2. Configure the linked server to use mapped logins.
C. Instruct Eric to write the queries on SQL2 by using the OPENQUERY statement and
specifying SQL1
as the server name.
D. Instruct Eric to specify SQL Server object names by using four-part notation
Answer: B