分類: Microsoft

Microsoft SQL Server 2005 Implementation & Maintenance
科目編號 : 70-431
考題名稱 : Microsoft SQL Server 2005 Implementation & Maintenance
題庫數目 : 85 Q&As
更新時間 : 2010-03-05

Microsoft SQL Server 2005 Implementation & Maintenance 認證作為全球IT領域專家 Microsoft  熱

門認證之壹，是許多大中IT企業選擇人才標準的必備條件。 如果妳正在準備 70-431 考試，為

Microsoft Microsoft SQL Server 2005 Implementation & Maintenance認證做最後沖刺，又苦於沒有絕

對權威的考試真題模擬， Killtest 希望能助妳成功！

以下是Killtest 70-431 題庫部分真題的分享：

Exam : Microsoft 70-431
Title : Microsoft SQL Server 2005 Implementation & Maintenance

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

Killtest 100% 保證您通過 70-431 的考試.如果妳使用 Killtest 模擬測試，我們將保證妳的第壹次慘

加考試即取得成功，否則我們將全額退款！

Windows Server 2008 Network Infrastructure, Configuring，代號 70-642，是屬於MCSE2008 的一科考試。部份70-642的考題如下：

1.Your company has a main office and two branch offices. Domain controllers in the main office host an
Active Directory-integrated zone.
The DNS servers in the branch offices host a secondary zone for the domain and use the main office DNS
servers as their DNS Master servers for the zone.
The company adds a new branch office. You add a member server named Branch3 and install the DNS
Server server role on the server. You configure a secondary zone for the domain. The zone transfer fails.
You need to configure DNS to provide zone data to the DNS server in the new branch office.
What should you do?
A.Run dnscmd by using the ZoneResetMasters option.
B.Run dnscmd by using the ZoneResetSecondaries option.
C.Add the new DNS server to the Zone Transfers tab on one of the DNS servers in the main office.
D.Add the new DNS server to the DNSUpdateProxy Global security group in Active Directory Users and
Computers.
Answer: C
2 Your company has a single Active Directory domain. All servers run Windows Server 2008. You install
an additional DNS server that runs Windows Server 2008. You need to delete the pointer record for the IP
address 10.3.2.127. What should you do?
A.Use DNS manager to delete the 127.in-addr.arpa zone.
B.Run the dnscmd /RecordDelete 10.3.2.127 command at the command prompt.
C.Run the dnscmd /ZoneDelete 127.in-addr.arpa command at the command prompt.
D.Run the dnscmd /RecordDelete 10.in-addr.arpa. 127.2.3 PTR command at the command prompt.
Answer: D
3.Your company has a server named Server1 that runs a Server Core installation of Windows Server
2008, and the DNS Server server role. Server1 has one network interface named Local Area Connection.
The static IP address of the network interface is configured as 10.0.0.1. You need to create a DNS zone
named local.contoso.com on Server1. Which command should you use?
A.ipconfig /registerdnslocal.contoso.com
B.dnscmd Server1 /ZoneAdd local.contoso.com /DSPrimary
C.dnscmd Server1 /ZoneAdd local.contoso.com /Primary /file local.contoso.com.dns
D.netsh interface ipv4 set dnsserver name=local.contoso.com static 10.0.0.1 primary
Answer: C
4. Your company has an Active Directory domain named ad.contoso.com. All client computers run
Windows Vista.
The company has recently acquired a company that has an Active Directory domain named
ad.fabrikam.com. A two-way forest trust is established between the ad.fabrikam.com domain and the
ad.contoso.com domain.
You need to edit the ad.contoso.com domain Group Policy object (GPO) to enable users in the
ad.contoso.com domain to access resources in the ad.fabrikam.com domain.
What should you do?
A.Configure the DNS Suffix Search List option to ad.contoso.com, ad.fabrikam.com.
B.Configure the Allow DNS Suffix Appending to Unqualified Multi-Label Name Queries option to True.
C.Configure the Primary DNS Suffix option to ad.contoso.com, ad.fabrikam.com. Configure the Primary
DNS Suffix Devolution option to True.
D.Configure the Primary DNS Suffix option to ad.contoso.com, ad.fabrikam.com. Configure the Primary
DNS Suffix Devolution option to False.
Answer: A