Latest Cisco 642-825 certifications -examsoon

Free 132-S-816.1 Demo Download

Examsoon offers free demo for Avaya Certification 132-S-816.1 exam (Specialist: Modular Messaging with Microsoft Exchange Implement & Support Elective Exam). You can check out the interface, question quality and usability of our practice exam before you decide to get it. We are the only one site can offer demo for almost all products.

Free Download 132-S-816.1 PDF exam Trainning Materials

1. Modular Messaging 3.1 for Exchange Message Application Servers (MASs) run the Microsoft Windows operating system. The customer wants to supply their own MAS.
Which versions of Windows are supported on the MASs?
A. Windows 2003 with Service Pack 1
B. Windows 2003 with Service Pack 2
C. Windows 2000 as long as this is an upgrade
D. Any release of Windows 2003 except Data Center Server
Answer: A

2. Which two statements are true about a customer-provided Avaya Messaging Application Server (MAS) for Modular Messaging for Microsoft Exchange that has Dialogic cards? (Choose two.)
A. Only Dialogic Analog CLAN is supported.
B. You must set the jumpers and switches as required.
C. You use the MAS software media for Dialogic Drivers.
D. The latest drivers are downloaded from the Dialogic website.
Answer: BC

3. How should you access the alarm Log on R3.1 Message Networking (MN) from the main menu?
A. Logs > Alarm Log
B. Reports > Alarm Log
C. Logs > Reports > Alarm Log
D. Reports > Logs > Alarm Log
Answer: A

4. Which three are configured using the Voice Mail System Configuration Tool? (Choose three.)
A. Auto Attendant
B. Class of Service
C. maximum mailbox size
D. the number of digits in a mailbox
Answer: ABD

5. What is the maximum hardware configuration allowed with Modular Messaging for Microsoft Exchange?
A. five Avaya Messaging Application Server (MAS) systems handling voice processing with a sixth acting as a Supplementary Server
B. six Avaya Messaging Application Server (MAS) systems handling voice processing with the sixth acting as a Supplementary Server
C. ten Avaya Messaging Application Server (MAS) systems handling voice processing with an eleventh acting as a Supplementary Server
D. eleven Avaya Messaging Application Server (MAS) systems handling voice processing with a twelfth acting as a Supplementary Server
Answer: C

6. A single Modular Messaging 1 for Exchange Message Application Server called MYMAS1 is running all services, including Call Me. In Voice Mail System Configuration, Call Me is enabled. The subscriber mailbox has the Allow Call Me option selected, and the mailbox is using the default rule to a valid external phone number of 915305558956. During acceptance testing, this phone number never rings with a Call Me call when a message is left in the mailbox.
What are two reasons that the Call Me call doesn’t reach the specified number? (Choose two.)
A. A restriction in the PBX is preventing the outcall.
B. The Call Me dialing rules are configured to not require the 91 before the rest of the number.
C. The Call Me port group is set to None in Voice Mail System Configuration, Message Application Servers, MYMAS1, Port Groups, Usage tab.
D. In Voice Mail System Configuration, Call Me, the Message Application Server running the Call Me service is identified, but the Message Application Servers that make the calls are not in the list.
Answer: AC

7. A Modular Messaging 3.1 for Exchange user in London, England, wants to use the Telephone User Interface to send a message to a Modular Messaging 1.1 for Exchange user in Los Angeles, California. The two locations share an Exchange Organization but the users are in different Voice Mail Domains.
How can this be accomplished?
A. The sender must address the message to the Numeric Address of the recipient.
B. The Octel Analog Networking connector must be installed and configured in Exchange.
C. This is not possible; the sender and recipient must be in the same Voice Mail Domain or the sender has to call the recipient.
D. The sender must address the message to the address of the recipient that represents the recipient on the Message Networking server.
Answer: A

8. You are installing Modular Messaging 3.1 for Exchange along with Message Networking 3.1 so the customer can continue to send and receive voice messages to the rest of the organization’s voice mail systems. They will continue to do this until the entire organization has been migrated to Modular Messaging; they realize that the Message Networking system is therefore a temporary solution.
What is required to meet the customer’s needs as defined above?
A. Message Networking must be installed on S3500 hardware.
B. The Message Networking server must have at least one analog port board.
C. The Modular Messaging license file must include the right to use Octel Analog Networking.
D. One of the Modular Messaging Message Application Servers must have at least one analog port board.
Answer: B

9. You are implementing a new Modular Messaging for Microsoft Exchange system for a customer with three Avaya Messaging Application Servers (MASs) connected to a single, large Microsoft Exchange Server. The customer enables offline storage for the Voice Mail Domain.
Which two statements are true about offline storage in this environment? (Choose two.)
A. Messages received by any MAS are stored in both the local spool folder on the MAS and in the path specified in VMSC.
B. The customer should allocate on the offline store approximately 10 GB of storage space per hour of message storage anticipated.
C. The Voice Mail Domain should be configured for an offline storage location in the format \servernamelocation or \<ip address>location.
D. If a user calls a given MAS that has become disconnected from the customer’s Ethernet they will not be able to retrieve any messages.
Answer: AC

10. Which three are necessary to ensure that the SIP configuration is taking calls? (Choose three.)
A. Avaya Communication Manager R3.0
B. Avaya SES at the supported software version
C. Avaya Communication Manager at the supported software version
D. RFA/WebLM License with signed certificate for Modular Messaging License
E. T1-QSIG cards in the Avaya Messaging Application Server (MAS) wired to the PBX
Answer: BCD

Free VCP-410 Demo Download

Examsoon offers free demo for VMWare Certification VCP-410 exam (VMware Certified Professional on VI4). You can check out the interface, question quality and usability of our practice exam before you decide to get it. We are the only one site can offer demo for almost all products.

Free Download VCP-410 PDF exam Trainning Materials

1. Creating which of the following optional partitions would change the default partition size for /?
A. /tmp
B. /home
C. /var/log
D. /usr
Answer: D

2. When installing ESX 4.0, where is the Service Console file system located?
A. In a virtual disk on a local VMFS datastore
B. In a virtual disk on a local or shared VMFS datastore
C. On a local physical disk or on a mapped SAN LUN
D. On a local physical disk
Answer: A

3. Once vCenter 4.x has been installed, a License Server is required in which of the following instances?
A. A License Server is always required
B. To support ESXi 4.x Hosts
C. To support ESX 3.5 Hosts
D. A License Server is no longer required
Answer: C

4. The vSphere 4 Host Update Utility provides a graphical user interface for (Choose Two):
A. performing a host compatibility check
B. upgrading standalone ESX/ESXi hosts
C. upgrading ESX hosts in DRS/HA clusters
D. keeping guest operating systems patched
Answer: AB

5. An administrator is installing ESX 4.0 on a physical server. Which of the following components would need to be modified or replaced to support a successful installation?
A. 4 Intel PRO 1000 Network Adapters
B. 2 LSI Logic LSI7202XP-LC Fibre Channel HBAs
C. 2 AMD Opteron CPUs
D. 4GB RAM
Answer: B

6. Which vSphere Editions include VMware Data Recovery (Choose Two)?
A. vSphere Essentials Plus or higher
B. vSphere Advanced or higher
C. vSphere Standard or higher
D. vSphere Essentials or higher
Answer: AB

7. Which of the following tasks can be selected from the home page of an ESX Server (Choose Three)?
A. Download VMware vCenter Server
B. Browse Objects Managed by this Host
C. Browse Virtual Machines in this Host’s inventory
D. Browse Datastores in this Host’s inventory
E. Download VMware Web Access Client
Answer: ABD

8. Which of the following partitions is specific to ESXi 4.0?
A. usr
B. vmkcore
C. scratch
D. swap
Answer: C

9. Which of the following features is not a part of the vSphere Advanced Edition?
A. VMware Storage VMotion
B. VMware VMotion
C. VMware Data Recovery
D. VMware Fault Tolerance
Answer: A

10. What are the minimum vSphere Small Business and Medium/Enterprise Editions that include VMware Data Recovery (Choose Two)?
A. vSphere Essentials Plus
B. vSphere Standard
C. vSphere Advanced
D. vSphere Essentials
Answer: AC

11. Which of the following functions cannot be performed remotely and must be performed from the ESXi Direct Console (Choose Three)?
A. Configure DNS Settings
B. Restart Management Agents
C. Test the Management Network
D. Restore a Standard Switch
E. Configure a Static IP Address
Answer: BCD

12. An ESX Administrator plans to install additional supported components on the ESX Server that would increase the memory requirements for the Service Console. Which ESX Server partition would also need to be increased during installation as a result?
A. /
B. vmfs3
C. swap
D. /boot
Answer: C

13. Additional licensing is required once the number of cores per CPU reaches which of the following?
A. 16 or more cores
B. 12 or more cores
C. 8 or more cores
D. 6 or more cores
Answer: C

14. What is the maximum number of cores that can be used with Standard licensing?
A. 8
B. 16
C. 12
D. 6
Answer: D

15. The default swap partition size for ESX 4.0 is which of the following?
A. 800MB
B. 1.6GB
C. 544MB
D. 600MB
Answer: D

Free HP0-S20 Demo Download

Examsoon offers free demo for HP AIS HP0-S20 exam (Implementing HP BladeSystem ). You can check out the interface, question quality and usability of our practice exam before you decide to get it. We are the only one site can offer demo for almost all products.

Free Download HP0-S20 PDF exam Trainning Materials

1. What can you do from the Insight Display on a c-Class BladeSystem enclosure?
A. Access the Health Summary of the enclosure.
B. Change IP addresses of iLO 2 on individual blades.
C. Power individual blades on or off.
D. Power the enclosure on or off.
Answer: A

2. Which tasks are part of the Evaluate Data step of the HP Troubleshooting Methodology? (Select three.)
A. analyze the mode of failure
B. gather messages from iLO logs
C. apply one change or one solution at a time
D. isolate faults to a hardware or software system
E. determine which components could cause the problem
F. check environmental conditions
Answer: ADE

3. Which features does the HP iLO Advanced for BladeSystem license include? (Select two.)
A. global team collaboration
B. server migration pack
C. enhanced networking
D. headless server deployment
E. integration with LDAP services
Answer: AE

4. Which benefits are server blades designed to provide? (Select two.)
A. ultra-density
B. highest internal expansion capability
C. power-efficiency
D. highest drive density
Answer: AC

5. Which features are included with the HP Modular Cooling System G2? (Select two.)
A. non-uniform airflow
B. fixed temperature set point
C. hot-swappable components
D. water leak detector
Answer: CD

6. Which statements are true about the AMD Opteron server memory architecture? (Select two.)
A. AMD Opteron uses HyperTransport for Direct Memory Access (DMA) transfers.
B. Each processor has its own memory.
C. A shared memory bus interconnects the CPUs with memory.
D. AMD Opteron uses 8-way interleaved memory in conjunction with proMem technology.
Answer: AB

7. Which ProLiant G6-series technology increases the speed at which data can be communicated between the processor and the memory DIMMs?
A. AMD Direct Connect Architecture
B. Intel Turbo Burst Technology
C. Intel QuickPath Technology
D. Intel Hyper-Threading Technology
Answer: C

8. Which options can be enabled in the HP Network Configuration Utility? (Select two.)
A. fault tolerance
B. NIC-assisted load balancing
C. switch-assisted load balancing
D. DHCP server support
Answer: AC

9. Which server blades are optimized for HPC (High Performance Computing) solutions? (Select two.)
A. BL2X0c
B. BL46Xc
C. BL49Xc
D. BL68Xc
E. BL8XXc
F. BL2×220c
Answer: AF

10. Which bays must be used when installing three power supplies in a c7000 to support power redundancy mode?
A. Bays 1, 2, 4
B. Bays 1, 2, 5
C. Bays 1, 3, 4
D. Bays 2, 3, 5
Answer: A

You can view Examsoon to get more information about 350-001GB2312-LAB Trainning Materials

1. 1 Exception handling
* Configure R4 to enable exception handling
* Filename:R4-DUMP Username:ccie Password:cisco
* Ftp address: 150.1.YY.254
RackYYR4:
ip ftp username ccie
ip ftp password cisco
exception protocol ftp
exception dump150.1.YY.254
exception corefile R4-DUMP
3.2 System logging
? Buffer alert critical emergencies and error
? Set the buffer size to 8192
? Indicate the date and time for each logged entry
RackYYR5:
logging on
logging buffered 8192 errors
clock timezone GMT 8
clock set hh:mm:ss month year
service timestamps log datetime local-time year show-timezone
Verify: show logging;
(所有设备的时间好像是都预先配置好的,我最后看到所有的设备都一个时间,和windows的时间相差无几)
3.3 DHCP
* Configure R5 to provide the following parameters for DHCP client on VLAN_55
* IP address
* DNS server YY.YY.55.60 and YY.YY.55.67
* Domain:cisco.com
* Default gateway
* Hosts must retain DHCP assigned address 10 days
* Permit only secure ARP entries to be installed in R5"s ARP table
RackYYR5:
Service dhcp
ip dhcp excluded address YY.YY.55.254
ip dhcp excluded address YY.YY.55.60
ip dhcp excluded address YY.YY.55.67
ip dhcp pool cisco
network YY.YY.55.0 255.255.255.0
default-router YY.YY.55.254
dns-server YY.YY.55.60 YY.YY.55.67
domain-name ccie.com
lease 10
update arp
Security
6.1 Tracing Traffic Source to Device under Attack
* It is suspected that Dos attack is being launched at host 150.3.YY.254 select an appropriate device to configure so that you can start tracing the source of this attack.
* Your solution must meet the following criteria
* The result of the trace must be sent to syslog once a day
* This device is limited to trace to one IP address only
* DO NOT configure ACL to achieve this
RackYYR5:
ip source-track 150.1.YY.254
ip source-track address-limit 1
ip source-track syslog-interval 1440
Verify: show ip source-track; show ip source-track
6.2 IP Fragment Attacking
* R4上收到了一个来自BB1，源是随要地址的攻击，目的地是一个web服务器：10.1.Y.5要求
* R4阻止这些攻击流量，并允许其他流量通过
Rack11R4:
ip access-list extended FRAGMENT
deny ip any host 10.1.yy.5 fragment
permit ip any any
int g0/0
ip access-group FRAGMENT in
6.3 Catalyst Security
* On Sw1-Fa0/7 configure 802.1.x authentication meeting the following When clients that do not
RackYYSw1:
aaa new-model
aaa authentication dot1x default group radius
aaa authorization network default group radius
dot1x system-auth-control
dot1x guest-vlan supplicant
int Fa0/7
Switchport mode access
dot1x port-control auto
dot1x guest-vlan 55
dot1x host-mode multi-host
Verify: show dot1x all; show dot1x interface interface-id details
QOS
4.1 Congestion Avoidance Notication
* Configure R1-S0/0/0 such that is out bound traffic has utilized 75% of total bandwidth.
* R1 should sign that the network is congested and the recipients need to slow down sending packets.
* DO NOT configure Frame Relay BECN or FECN for this question
RackYYR1:
Ip tcp ecn
Policy-map QOS
class class-default
bandwidth percent 75
random-detect
random-detect ecn
interface s0/0/0
no random-detect
service-policy output QOS
Verify: show policy-map interface interface-id
4.2 Traffic policing
* Client on VLAN_BB1 and VLAN_55 access a URL located on VLAN_BB2 frequently. This URL is http://www.this website.com/directory.
* Select one suitable router to configure, so as to conserve bandwidth meeting the following criteria.
* Traffic from this URL back to these clients should not exceed 640000 bits per second.
* If the files download from this URL are image file then drop the traffic
* You may assume image the names end with the suffix:*.gif*.jpg or *.jpeg
RackYYR6:
ip cef
ip access-list extended TRAFFIC
permit ip 150.2.YY.0 0.0.0.255 150.1.YY.0 0.0.0.255
permit ip 150.2.YY.0 0.0.0.255 YY.YY.55.0 0.0.0.255
class-map match-all url
match access-group name TRAFFIC
match protocol http host www.thiSwebsite.com
match protocol http url /directory /*
class-map match-all pic
match class-map url
match protocol http url *.jpg|*.jpeg|*.gif
policy-map NBAR
class pic
drop
class url
police cir 64000
interface Gi0/1
service-policy input NBAR
ip nbar protocol-discovery
Verify: show policy-map interface interface-id
4.3 Discard Eligible and Traffic Shaping
* The Frame Relay link on R5 is experiencing heavy congesting. Configure R5 so that the Frame Relay provider does not drop any routing protocol packets during
* congesting and if the number of packets in R5"s Frame Relay interface queue exceeds 10,then the traffic rate will reduced to 32000 bps.
RackYYR5:
access-list 105 deny ospf any any
access-list 105 deny tcp any eq 179 any
access-list 105 deny tcp any any eq 179
access-list 105 deny pim any any
access-list 105 permit ip any any
frame-relay de-list 1 protocol ip list 105
interface s0/0.5
frame-relay de-group 1 503
map-class frame-relay FRTS
Frame-Relay adaptive-shaping interface-congestion 10
Frame-Relay mincir 32000
interface Serial0/0
Frame-Relay traffic-shaping
interface Serial0/0.5
Frame-Relay interface-dlci 503
class FRTS
Verify: show frame-relay pvc dlci
Multicast
5.1 Sparse Mode Multicasting
* There is a multicast source for group 224.2.2.2 located at VLAN_BB2 and another source for group 224.3.3.3 located at VLAN_BB3.There are clients on VLAN_55 that would like to access these two groups.
* Configure R5,R3, Sw1,R1 and R6 to meet the following requirements
* Configure all devices using sparse mode
* R1 will be the RP for both multicast groups and R3 will be backup RP. Use the most reliable way to achieve this objective and do not configure RP information statically
* R5 needs to be able to ping both 224.2.2.2 and 224.3.3.3
RackYYR6:
ip multicast-routing
int g0/1
ip pim sparse-mode
ip igmp join-group 224.2.2.2 (这是预配置)
int g0/0
ip pim sparse-mode
ip igmp join-group 224.3.3.3 (这是预配置)
int s0/0/0
ip pim sparse-mode
ip pim nbma-mode
　
RackYYR1:
ip multicast-routing
int s0/0/0
ip pim sparse-mode
ip pim nbma-mode
int g0/0
ip pim sparse-mode
int lo200
ip pim sparse-mode
ip pim send-rp-ann LO200 sco 10 group-list 11
ip pim send-rp-dis LO200 sco 10
access-list 11 per 224.2.2.2
access-list 11 per 224.3.3.3
RackYYSw1:
ip multicast-routing
int VLAN 100
ip pim sparse-mode
int Fa0/3
ip pim sparse-mode
　
RackYYR3:
ip multicast routing
int g0/0
ip pim sparse-mode
int s0/0/0.3
ip pim sparse-mode
ip pim nbma-mode
ip pim dr-priority 200
int lo0
ip pim sparse-mode
ip pim send-rp-ann Loopback0 sco 10 group-list 33
ip pim send-rp-dis Loopback0 sco 10
access-list 33 permit 224.2.2.2
access-list 33 permit 224.3.3.3
RackYYR5:
ip multicast-routing
int s0/0/0.5
ip pim sparse-mode
ip pim nbma-mode
　
int g0/0
ip pim sparse-mode
Verify: show ip pim neighbor; show ip pim rp mapping; R5 ping group addresses 224.2.2.2 and 224.3.3.3;
5.2 Defense against Multicast Dos Attack
* There is a concern that hacker launch Dos attack against R5 with multicast group membership traffic. Configure R5 so that accept only 100 IGMP reports at any time but this limit does not apply to the group 224.3.3.3.
RackYYR5:
ip access-list extended 105
permit igmp any host 224.3.3.3
int g0/0
ip igmp limit 110 except 105
Verify: show ip igmp interface interface-id
[M1]使用前缀列表,只允许特定网段进入RIP
[M2]重分布RIP进OSPF时,度量值为加和,M-2是OSPF重新计算的度量值
[M3]Nssa
[M4]180.88.0.0/18
[M5]区域间通告汇总路由
[M6]考虑偏移列表无法使用前缀列表,这里使用访控进行定义
[M7]重分布
直连接口
[M8]作接口上对R6的汇总路由,.并利用路由图拒绝掉到OSPF汇总路由
[M9]过滤EIGRP到OSPF区域里的YY.YY.0.0/16的汇总路由
[M10]过滤掉由R3产生的单条汇总0.0.0.0,同时允许其它的明细路由
[M11]从EIGRP100中过滤掉YY.YY.0.0/16的汇总路由条目到OSPF YY
[M12]接口汇总,将所有通告给R6的YY.YY.0.0的路由汇总为单条路由.(并过滤其网段的明细路由)
[M13]

2. 1 Sparse Mode Multicasting
* There is a multicast source for group 224.2.2.2 located at VLAN_BB2 and another source for group 224.3.3.3 located at VLAN_BB3.There are clients on VLAN_55 that would like to access these two groups.
* Configure R5,R3, Sw1,R1 and R6 to meet the following requirements
* Configure all devices using sparse mode
* R1 will be the RP for both multicast groups and R3 will be backup RP. Use the most reliable way to achieve this objective and do not configure RP information statically
* R5 needs to be able to ping both 224.2.2.2 and 224.3.3.3
RackYYR6:
ip multicast-routing
int g0/1
ip pim sparse-mode
ip igmp join-group 224.2.2.2 (这是预配置)
int g0/0
ip pim sparse-mode
ip igmp join-group 224.3.3.3 (这是预配置)
int s0/0/0
ip pim sparse-mode
ip pim nbma-mode
　
RackYYR1:
ip multicast-routing
int s0/0/0
ip pim sparse-mode
ip pim nbma-mode
int g0/0
ip pim sparse-mode
int lo200
ip pim sparse-mode
ip pim send-rp-ann LO200 sco 10 group-list 11
ip pim send-rp-dis LO200 sco 10
access-list 11 per 224.2.2.2
access-list 11 per 224.3.3.3
RackYYSw1:
ip multicast-routing
int VLAN 100
ip pim sparse-mode
int Fa0/3
ip pim sparse-mode
　
RackYYR3:
ip multicast routing
int g0/0
ip pim sparse-mode
int s0/0/0.3
ip pim sparse-mode
ip pim nbma-mode
ip pim dr-priority 200
int lo0
ip pim sparse-mode
ip pim send-rp-ann Loopback0 sco 10 group-list 33
ip pim send-rp-dis Loopback0 sco 10
access-list 33 permit 224.2.2.2
access-list 33 permit 224.3.3.3
RackYYR5:
ip multicast-routing
int s0/0/0.5
ip pim sparse-mode
ip pim nbma-mode
　
int g0/0
ip pim sparse-mode
Verify: show ip pim neighbor; show ip pim rp mapping; R5 ping group addresses 224.2.2.2 and 224.3.3.3;
5.2 Defense against Multicast Dos Attack
* There is a concern that hacker launch Dos attack against R5 with multicast group membership traffic. Configure R5 so that accept only 100 IGMP reports at any time but this limit does not apply to the group 224.3.3.3.
RackYYR5:
ip access-list extended 105
permit igmp any host 224.3.3.3
int g0/0
ip igmp limit 110 except 105
Verify: show ip igmp interface interface-id
[M1]使用前缀列表,只允许特定网段进入RIP
[M2]重分布RIP进OSPF时,度量值为加和,M-2是OSPF重新计算的度量值
[M3]Nssa
[M4]180.88.0.0/18
[M5]区域间通告汇总路由
[M6]考虑偏移列表无法使用前缀列表,这里使用访控进行定义
[M7]重分布
直连接口
[M8]作接口上对R6的汇总路由,.并利用路由图拒绝掉到OSPF汇总路由
[M9]过滤EIGRP到OSPF区域里的YY.YY.0.0/16的汇总路由
[M10]过滤掉由R3产生的单条汇总0.0.0.0,同时允许其它的明细路由
[M11]从EIGRP100中过滤掉YY.YY.0.0/16的汇总路由条目到OSPF YY
[M12]接口汇总,将所有通告给R6的YY.YY.0.0的路由汇总为单条路由.(并过滤其网段的明细路由)
[M13]

3. 1 vtp
* Sw1/Sw2/Sw3/Sw4
* VTP domain:VTP+YY
* VTP mode:Transparent
RackYYSw1/SW2/SW3/SW4:
vtp domain VTPYY
vtp mode transparent
that’s not need to use s/c mode in VTP
1.2
VLAN
Sw1:
40 VLAN_BB1
55 VLAN_55
60 VLAN_BB3
100 VLAN_100
200 VLAN_200
Sw2:
50 VLAN_BB2
100 VLAN_100
200 VLAN_200
Sw3
60 VLAN_BB3
200 VLAN_200
Sw4
200 VLAN_200
RackYYSw1:
VLAN Name Status Ports
1 default active F0/7,F0/8,F0/9,F0/11,F0/12,F0/13,F0/14Fa0/15,Fa0/17 Fa0/18,Gi0/1,Gi0/2
40 VLAN_BB1 active Fa0/4, Fa0/10
55 VLAN_55 active Fa0/5
60 VLAN_BB3 active Fa0/6
100 VLAN_100 active Fa0/1, Fa0/2
200 VLAN_200 active
RackYYSw2:
VLAN Name Status Ports
1 default active F0/4,F0/5,F0/7,F0/8,F0/9,F0/11,F0/12,F0/13,F0/14,F0/16,F0/17
F0/18,Gi0/1,Gi0/2
50 VLAN_BB2 active F0/6, F0/10
100 VLAN_100 active F0/1, F0/2
200 VLAN_200 active Po10
RackYYSw3:
VLAN Name Status Ports
1 default active F0/1,F0/2,F0/3,F0/4 F0/5, F0/6, F0/7,F0/8,F0/9,F0/11,F0/12,F0/13, F0/14, F0/15, F0/16,F0/17,F0/18,Gi0/1,Gi0/2
60 VLAN_BB3 active Fa0/10
200 VLAN_200 active
RackYYSw4:
VLAN Name Status Ports
1 default active F0/1,F0/2,F0/3,F0/4,F0/5,F0/6,F0/7,F0/8,F0/9,F0/10F0/11,F0/12
F0/13,F0/14,F0/15,F0/16,F0/17,F0/18,Gi0/1,Gi0/2
200 VLAN_200 active Po10
Verify: show vlan brief
When u done, u must verify careful.
做完的时候，可以仔细核对下，注意大小写,我做的时候只要是二层的端口全使用Swithport mode access
1.3 Port-channel between Sw1 a Sw2
* Sw1 and Sw2 layer 3 Ether channel use port-channel 21 only
* Assign YY.YY.100.1/24 to Sw1 Port-channel 21
* Assign YY.YY.100.2/24 to Sw2 Port-channel 21
* ensure interface F0/23 and F0/24 are channel member for both Switch
* Do not reply on PAgP or LACP to facilitate the connection
* Verify layer 2 and layer 3 connectivity via the channel link
RackYYSw1:
interface range FastEthernet0/23-24
shutdown
no Switchport
channel-group 21 mode on
no shutdown
interface Port-channel21
ip address YY.YY.100.1 255.255.255.0
　
RackYYSw2:
interface range FastEthernet0/23-24
shutdown
no Switchport
channel-group 21 mode on
no shutdown
interface Port-channel21
ip address YY.YY.100.2 255.255.255.0
Verify: show vtp status; show etherchannel summary; show etherchannel port-channel;
1.4 Port-channel between Sw1-Sw3 and Sw2-Sw4
* Sw1-Sw3 Sw2-Sw4 layer 2 Ether-channels use port 10 only F0/19 and F0/20 are members of the switches
* On Sw2 and Sw4 assign all interface in the EC as static-access port on VLAN_200 unconditional enable PAGP to facility the connection
* verify layer 2 connectivity via the channel link
RackYYSw1:
interface range FastEthernet0/19-20
shutdown
Switchport trunk encapsulation isl
Switchport mode trunk
channel-group 10 mode desirable
no shutdown
　
RackYYSw3:
interface range FastEthernet0/19-20
shutdown
Switchport trunk encapsulation isl
Switchport mode trunk
channel-group 10 mode desirable
no shutdown
RackYYSw2:
interface range FastEthernet0/19-20
shutdown
Switchport mode access
Switchport access VLAN 200
channel-group 10 mode desirable
no shutdown
　
RackYYSw4:
interface range FastEthernet0/19-20
shutdown
Switchport mode access
Switchport access VLAN 200
channel-group 10 mode desirable
no shutdown
Verify: show etherchannel summary; show etherchannel portchannel;
结合下面的VLAN,可以看到Sw2和Sw4的po10也在VLAN200,在你做敲channel-group 10 mode desirable之前先Switchport access VLAN 200,要不在VLAN的表中会看不到po10.
在做完的时候一定要Show一下.看看 Port-channel起来了没
1.5
* Catalyst layer 3 configuration
* Configure Sw1 and Sw2 IP address as outlined n diagram
* Connectivity to R3 uses route ports
* R1 and R2 are members of vlan 100 on Sw1 and Sw2
1.6
* Catalyst layer 3 configuration
* Configure Sw3 and Sw4 IP addressing
* Configure VLAN_200 in Sw1 with IP address YY.YY.34.1/24
* Configure VLAN_200 in Sw2 with IP address YY.YY.43.1/24
* Verify the connectivity between Sw1 and Sw2
RackYYSw1:
VLAN 100 YY.YY.12.254/24
VLAN 200 YY.YY.34.1/24
RackYYSw2:
VLAN 100 YY.YY.21.254/24
VLAN 200 YY.YY.43.1/24
RackYYSw3:
VLAN 200 YY.YY.34.254/24
RackYYSw4:
VLAN 200 YY.YY.43.254/24
RackYYSw1:
ip routing
interface VLAN100
ip address YY.YY.12.254 255.255.255.0
interface VLAN200
ip address sYY.YY.34.1 255.255.255.0
　
RackYYSw2:
ip routing
interface VLAN100
ip address YY.YY.21.254 255.255.255.0
interface VLAN200
ip address YY.YY.43.1 255.255.255.0
　
RackYYSw3:
ip routing
interface VLAN200
ip address YY.YY.34.254 255.255.255.0
RackYYSw4:
ip routing
interface VLAN200
ip address YY.YY.43.254 255.255.255.0
Verify: show ip interface brief; show ip route
RackYYSw1:
interface FastEthernet0/3
no Switchport
ip address YY.YY.13.2 255.255.255.0
　
RackYYSw2:
interface FastEthernet0/3
no Switchport
ip address YY.YY.31.2 255.255.255.0
Verify: show interface status; show ip interface brief; show ip route
1.7Catalyst feature
* Cofigure Sw1-F0/1 so that the interface will stop forwarding unicast traffic if the input rate exceeds 65 Mbps
RackYYSw1:
interface Fa0/1
Storm-control unicast level 55.00
Verify: show storm-control unicast
1.8 Catalyst tunning
* Cofigure the amount of tine a neighbou should hold CDP information sent by Sw2 before discarding it to 2 minutes
RackYYSw1:
cdp holdtime 120
Verify: show cdp
1.9 Catalyst Feature
* Configure Sw1 to control and block the flood of unknown Multicast traffic on the interface F0/5
RackYYSw1:
interface Fa0/5
Switchport block multicast
Ip Igmp snooping
或者’ip cgmp enable’
Verify: show interface interface-id switchport
第二部分：IGP和BGP
IGP
2.1 OSPF Bbackbones
* The link between Sw1 and Sw2
* All interface in VLAN_100 on Sw1 Sw2 R1 and R2
* R3 G0/0 and G0/1 and the fa0/3 on Sw1 and Sw2
* Loop back 0 interface on Sw1 Sw2 R2 and R3
* Verifying that all OSPF neighbor have built their adjacencies
RackYYR1:
Router ospf YY
network YY.YY.12.1 0.0.0.0 area 0
network YY.YY.21.1 0.0.0.0 area 0
　
RackYYR2:
Router ospf YY
network YY.YY.2.2 0.0.0.0 area 0
network YY.YY.12.2 0.0.0.0 area 0
network YY.YY.21.2 0.0.0.0 area 0
　
RackYYSw1:
Router ospf YY
network YY.YY.7.7 0.0.0.0 area 0
network YY.YY.12.254 0.0.0.0 area 0
network YY.YY.13.2 0.0.0.0 area 0
network YY.YY.100.1 0.0.0.0 area 0
　
RackYYSw2:
Router ospf YY
network YY.YY.8.8 0.0.0.0 area 0
network YY.YY.21.254 0.0.0.0 area 0
network YY.YY.31.2 0.0.0.0 area 0
network YY.YY.100.2 0.0.0.0 area 0
　
RackYYR3:
Router ospf YY
network YY.YY3.3 0.0.0.0 area 0
network YY.YY.13.1 0.0.0.0 area 0
network YY.YY.31.1 0.0.0.0 area 0
Verify: show ip ospf interface brief; show ip ospf neighbor
2.2 OSPF over NBMA
* OSPF area 11 consist of the follow interface and attributes
* The Frame Relay network between R3 R4 R5
* Loop back 0 on R4 and R5
* VLAN_55
* Ensure there is no DR/BDR
RackYYR3:
interface s0/0/0.3
ip ospf network point-to-multipoint non-broadcast
Router ospf YY
network YY.YY.11.3 0.0.0.0 area 11
nei YY.YY.11.4
nei YY.YY.11.5
　
RackYYR4:
interface s0/0/0.4
ip ospf network point-to-multipoint non-broadcast
Router ospf YY
network YY.YY.4.4 0.0.0.0 area 11
network YY.YY.11.4 0.0.0.0 area 11
RackYYR5:
interface s0/0/0.5
ip os net point-to-multipoint non-broadcast
Router ospf YY
network YY.YY.5.5 0.0.0.0 area 11
network YY.YY.11.5 0.0.0.0 area 11
network YY.YY.55.254 0.0.0.0 area 11
Verify: show ip ospf interface brief; show ip ospf neighbor
2.3 OSPF ASBR and RIP version 2
* Configure R4 to receive RIP v2 routes from Backbone 1
* When properly configured you will receives RIP v2 routes in the class B address range 199.172.Z.Z[M1]
* Configure R4 so that the external RIP routes are injected into area 11 and appear throughout that OSPF domain[M2]
* Ensure external routes originates from Autonomous Systems Boundary Routers (ASBR) outside area 11 cannot be flooded within the area[M3]
* Permit OSPF type-3 routes into area 11(在R5上看)
RackYYR4:
ip prefix-list fbb1 per 199.172.0.0/16 le 32
Router rip
version 2
no auto-summary
network 150.1.0.0
distribute-list prefix fbb1 in Fa0/0
Router ospf YY
redistribute rip metric-type 1 subnets
area 11 nssa
　
RackYYR3:
Router ospf YY
area 11 nssa
　
RackYYR5:
Router ospf YY
area 11 nssa
Verify: show ip protocol; show ip route rip; show ip ospf; show ip route ospf;
2.4 Area 34 and Area 43
* OSPF area 34 consists of the VLAN_200 interfaces on Sw1 and Sw3 and loopback 0 in Sw3
* OSPF area 43 consists of the VLAN_200 interfaces on Sw2 and Sw4 and loopback 0 in Sw4
RackYYSw1:
Router ospf YY
network YY.YY.34.1 0.0.0.0 area 34
　
RackYYSw2:
Router ospf YY
network YY.YY.43.1 0.0.0.0 area 43
　
RackYYSw3:
Router ospf YY
network YY.YY.9.9 0.0.0.0 area 34
network YY.YY.34.254 0.0.0.0 area 34
　
RackYYSw4:
Router ospf YY
network YY.YY.10.10 0.0.0.0 area 43
network YY.YY.43.254 0.0.0.0 area 43
Verify: show ip ospf interface brief; show ip ospf neighbor
2.5 OSPF ABR
* Static routes are not permitted for this question
* inject a default route into area 0 area 11 area 34 area 43
* Use fewest number of steps or commands to completes this
RackYYR3:
Router ospf YY
area 11 nssa default-information-originate
default-information originate always
Verify: show ip route ospf; show ip ospf database
2.6 OSPF Summary
* Add the following interface on R2 to Area 0
* Loopback 22 180.88.22.254/24
* Loopback 32 180.88.32.254/24
* Loopback 47 180.88.47.254/24
* Summarize the above address into a single route
* Your summary route must be compact and not waste address space[M4]
* Verify the Summary is in the OSPF routing table on R5 and you can ping all the host address
* R3、Sw 1、Sw2都要做区域间汇总。[M5]
RackYYR2:
int lo22
ip address 180.88.22.254 255.255.255.0
int lo32
ip address 180.88.32.254 255.255.255.0
int lo47
ip address 180.88.47.254 255.255.255.0
Router ospf YY
network 180.88.0.0 0.0.63.255 area 0
这里我选择直接在3个loopback接口上使用IOS12.4版本后支持的接口宣告ospf的方法。即快捷，又不会出错。
RackYYR3/Sw1/Sw2:
Router ospf YY
area 0 range 180.88.0.0 255.255.192.0
Verify; show ip ospf; show ip route ospf; show ip ospf database
(只要在OSPF中公告的loop口,ip add是24位的,我全用的是点到点类型)
2.7 RIP version 2
* Advertise all the individual YY.YY.0.0 network prefixes generated within your lab topology to backbone 1
* Instruct the backbone 1 router that your networks are 5 hops away[M6]
* Filter all other prefixes to backbone 1
RackYYR4:
Access-list 4 per YY.YY.0.0 0.0.255.255
Router rip
Redistribute ospf yy metric 1
Offset-list 4 out 4 g0/0
Distribute-list 4 out g0/0
Verify: debug ip rip
这个地方， 我用方法2： router rip
Redistribute os 8 metric 5 route-map fromOSPF
Route-map fromOSPF per 10
Match ip add prefix-list fromOSPF
Ip prefix-list fromOSPF per 8.8.0.0/16 le 32
使用一个重分发的命令就解决了3个需求。我们的口号是用最少的策略解决问题，让router的CPU消耗降到最低。并且注入到RIP database里的路由也只有8.8.0.0/16内的了。
或者使用我的方法3 ： router rip
Redis os 8 route-map fromOSPF
Default-metric 5
Route-map fromOSFP per 10
Match ip add fromOSPF
Ip access-list standard fromOSPF
Per 8.8.0.0 0.0.255.255
或者使用我的方法4 ： router rip
Redis os 8 route-map fromOSPF
Route-map fromOSPF per 10
Set metric 5
Distribute-list prefix fromOSPF out os 8
Ip prefix-list fromOSPF per 8.8.0.0/16 le 32
源的方法最烂; 让router执行了3次策略才完成了需求。
2.8 EIGRP
* EIGRP 100 AS 100 consists of the following interface
* The Frame Relay network between R1 and R6
* Loopback0 on R1 and R6
* The BB2 interface on R6 should appear as an external EIGRP route on R1[M7]
* R6 must have a single 16 bit prefix via R1 to the YY.YY.0.0 network. Do not use route filters or automatic summary[M8]
* Redistribute EIGRP routes into ospf area
RackYYR1:
Ip prefix-list eto per YY.YY.0.0/16
Route-map eto deny 10
Match ip add pre eto
Route-map eto per 20
[M9]
ip prefix-list ote seq 5 permit 0.0.0.0/0
route-map ote deny 10
match ip address prefix-list ote
route-map ote permit 20
[M10]
Router eigrp 100
No au
Net YY.YY.16.1 0.0.0.0
Net YY.YY.1.1 0.0.0.0
Redistribute ospf YY metric 10000 100 255 1 1500 route-map ote
Router os yy
Redistribute eigrp 100 subnets metric-type 1 route-map eto [M11]
Int s0/0/0
Ip summary ei 100 YY.YY.0.0 255.255.0.0 [M12]
　
RackYYR6:
Route-map con per 10
Match interface E0/1
Router eigrp 100
No au
Net YY.YY.16.6 0.0.0.0
Net YY.YY.6.6 0.0.0.0
Redistribute connected route-map CON metric 10000 100 255 1 1500
Verify: show ip protocol; show ip route eigrp; show ip route ospf;
2.9 EIGRP over BB3
* The backbone 3 router will be sending some class A,B and C IP prefixes
* Create a prefix-list and apply it so that the EIGRP process will only accept prefixes in the class C address might on the routing table
* Deny all routes to BB3
(这里要注意到first octet=192-200)
前缀列表 访问列表
A:0.0.0.0/1 le 32 0.0.0.0 127.255.255.255
B:128.0.0.0/2 le 32 128.0.0.0 63.255.255.255
C:192.0.0.0/3 le 32 192.0.0.0 31.255.255.255
RackYYR6:
Ip prefix-list fbb3 per 192.0.0.0/5 le 32
Ip prefix-list fbb3 per 200.0.0.0/8 le 32
Ip prefix-list tbb3 deny 0.0.0.0/0 le 32
Router eigrp 100
Net 150.3.YY.1 0.0.0.0
Distribute-list prefix fbb3 in F0/0
Distribute-list prefix tbb3 out F0/0
Verify: show ip protocol; show ip route eigrp
2.10 IPV6
R1 G0/1 2033:YY:YY:21::1
S0/0/0 2033:YY:YY:16::1(FE80::217:94FF:FE15:8C90)
R6 f0/1 2033:YY:YY:62::6
S0/3/0 2033:YY:YY:16::6(FE80::215:C6FF:FE4A:6210)
All the interface run OSPF v3
RackYYR1#show ipv6 interface brief
Gi0/0 [up/up]
FE80::ZZZZ:ZZZZ:ZZZZ //link-local address
2038:YY:YY:11::1
Serial0/0/0 [up/up]
FE80::ZZZZ:ZZZZ:ZZZZ
2038:YY:YY:61::1
RackYYR6#show ipv6 interface brief
Gi0/0 [up/up]
FE80::ZZZZ:ZZZZ:ZZZZ
2038:YY:YY:66::6
Serial0/0/0 [up/up]
FE80::ZZZZ:ZZZZ:ZZZZ
2038:YY:YY:61::6
RackYYR1#show ipv6 route
IPv6 Routing Table -7 entries
Codes: C -Connected, L -Local, S -Static, R -RIP, B -BGP U -Per-user Static route I1 -ISIS L1, I2 -ISIS L2, IA – ISIS inte area, IS -ISIS summary O – OSPF intr OI – OSPF inter, OE1 – OSPF ext 1, OE2 -OSPF ext 2 ON1 – OSPF NSSA ext 1, ON2 – OSPF NSSA ext 2
C 2038:YY:YY:11::/64 [0/0]
　via ::, Gi0/0
L 2038:YY:YY:11::1/128 [0/0]
　via ::, Gi0/0
C 2038:YY:YY:61::/64 [0/0]
　via ::, Serial0/0/0
L 2038:YY:YY:61::1/128 [0/0]
　via ::, Serial0/0/0
O 2038:YY:YY:66::/64 [110/65]
　via FE80::ZZZZ:ZZZZ:ZZZZ, Serial0/0/0
L FE80::/10 [0/0]
　via ::, Null0
L FF00::/8 [0/0]
　via ::, Null0
　
RackYYR6#show ipv6 route
IPv6 Routing Table -7 entries Codes: C -Connected, L -Local, S -Static, R -RIP, B -BGP U -Per-user Static route I1 -ISIS L1, I2 -ISIS L2, IA -ISIS inter area, IS -ISIS summary O – OSPF intra, OI – OSPF inter, OE1 – OSPF ext 1, OE2 -OSPF ext 2 ON1 – OSPF NSSA ext 1, ON2 – OSPF NSSA ext 2
O 2038:YY:YY:11::/64 [110/65]
　via FE80::ZZZZ:ZZZZ:ZZZZ, Serial0/0
C 2038:YY:YY:61::/64 [0/0]
　via ::, Serial0/0/0
L 2038:YY:YY:61::6/128 [0/0]
　via ::, Serial0/0/0
C 2038:YY:YY:66::/64 [0/0]
　via ::, Gi0/0
L 2038:YY:YY:66::6/128 [0/0]
　via ::, Gi0/0
L FE80::/10 [0/0]
　via ::, Null0
L FF00::/8 [0/0]
　via ::, Null0
　
RackYYR1:
ipv6 unicast-routing
ipv6 Router ospf YY
　Router-id YY.YY.1.1
interface Serial0/0/0
　ipv6 address 2033:YY:YY:16::1/64
　ipv6 ospf network point-to-point
　ipv6 ospf 8 area 0
　Frame-Relay map ipv6 2038:YY:YY:16::6 106 broadcast
　Frame-Relay map ipv6 "link_local" 106 broadcast
interface g0/1
　ipv6 address 2033:YY:YY:21::1/64
　ipv6 ospf 1 area 0
　
RackYYR6:
ipv6 unicast-routing
ipv6 Router ospf YY
　Router-id YY.YY.6.6
interface Serial0/0/0
　ipv6 address 2033:YY:YY:16::6/64
　ipv6 ospf network point-to-point
　ipv6 ospf 6 area 0
　Frame-Relay map ipv6 2033:YY:YY:16::1 601 broadcast
　Frame-Relay map ipv6 "link_local" 601 broadcast
interface g0/1
　ipv6 address 2033:YY:YY:62::6/64
　Ipv6 ospf 6 area 0
Verify: show ipv6 interface brief; show ipv6 route
BGP
* R1: Loopback 200: 200.1YY.101.1/32
* R2: Loopback 200: 200.1YY.102.1/32
* R3: Loopback 200: 200.YY.3.1/32
* R4: Loopback 200: 200.YY.4.1/32
* R5: Loopback 200: 200.YY.5.1/32
* R6: Loopback 200: 200.1YY.106.1/32
7.1 IBGP
* Configure IBGP as follows
* AS YY: Configure only R3 R4,and R5 to be part of the AS YY ,R3 is the Route-Reflector for this AS
* AS 1YY:Configure only R1,R2 and R6 to be part of the AS 1YY. Don’t configure RR or confederation in the AS
* You can use any IP address to form the IBGP peers
* Advertise the loopback 200 on all BGP routers through BGP and make sure you are able to ping these loopbacks from inside each AS
* Loopback 200:
* AS YY: 200.YY.X.1/32
* AS 1YY:200:1YY.10X.1/32
RackYYR3:
Router bgp YY
no auto-summary
no synchronization
bgp Router-id YY.YY.3.3
network 200.YY.3.1 mask 255.255.255.255
neighbor YY.YY.4.4 remote-as YY
neighbor YY.YY.4.4 update-source loop0
neighbor YY.YY.4.4 route-reflector-client
neighbor YY.YY.5.5 remote-as yy
neighbor YY.YY.5.5 update-source loop0
neighbor YY.YY.5.5 route-reflector-client
　
RackYYR4:
Router bgp YY
no auto-summary
no synchronization
bgp Router-id YY.YY.4.4
network 200.YY.4.1 mask 255.255.255.255
neighbor YY.YY.3.3 remote-as YY
neighbor YY.YY.3.3 update-source Loopback0
　
RackYYR5:
Router bgp YY
no auto-summary
no synchronization
bgp Router-id YY.YY.5.5
network 200.YY.5.1 mask 255.255.255.255
neighbor YY.YY.3.3 remote-as YY
neighbor YY.YY.3.3 update-source Loopback0
如果用peer-group，配置如下：
RACK08R3#router bgp 8
no synchronization
bgp router-id 8.8.3.3
bgp log-neighbor-changes
network 200.8.3.1 mask 255.255.255.255
neighbor zhenglei peer-group
neighbor zhenglei remote-as 8
neighbor zhenglei update-source Loopback0
neighbor zhenglei route-reflector-client
neighbor 8.8.4.4 peer-group zhenglei
neighbor 8.8.5.5 peer-group zhenglei
no auto-summary
　
RackYYR1:
Router bgp 10YY
no auto-summary
no synchronization
bgp Router-id YY.YY.1.1
network 200.1YY.101. 1 mask 255.255.255.255
neighbor YY.YY.2.2 remote-as 10YY
neighbor YY.YY.2.2 update-source Loopback0
neighbor YY.YY.6.6 remote-as 10YY
neighbor YY.YY.6.6 update-source Loopback0
　
RackYYR2:
Router bgp 10YY
no auto-summary
no synchronization
bgp Router-id YY.YY.2.2
network 200.1YY.102.1 mask 255.255.255.255
neighbor YY.YY.1.1 remote-as 10YY
neighbor YY.YY.1.1 update-source Loopback0
neighbor YY.YY.6.6 remote as 10YY
neighbor YY.YY.6.6 update-source Loopback0
　
RackYYR6:
Router bgp 10YY
no auto-summary
no synchronization
bgp Router-id YY.YY.6..6
network 200.1YY.106.1 mask 255.255.255.255
neighbor YY.YY.1.1 remote-as 10YY
neighbor YY.YY.1.1 update-source Loopback0
neighbor YY.YY.2.2 remote-as 10YY
neighbor YY.YY.2.2 update-source Loopback0
Verify: show ip bgp summary; show ip bgp
7.2 EGP
Configure EBGP as follows
* R6 EBGP peers with BB2 IP address 150.2.YY.254 AS 254
* R1 EBGP peers with R3
* R2 EBGP peers with R3
* You can use any IP address to form the EBGP peers
* Make sure all routers in AS YY have the EBGP routes from AS 254 via 1YY on their BGP and IP routing tables. You do not need to ping these routes
* Make sure you are able to ping the loop back 200 from all BGP routers on both AS. You are permitted to use 4 static routes within minimum mask to fulfill this Requirement
RackYYR6:
Router bgp 10YY
neighbor 150.2.YY.254 remote-as 254
neighbor 150.2.YY.254 local-as YY no-prepend
　
RackYYR1:
Router bgp 10YY
neighbor YY.YY.3.3 remote-as YY
neighbor YY.YY.3.3 ebgp-multihop 255
neighbor YY.YY.3.3 update-source Loopback0
　
RackYYR2:
Router bgp 10YY
neighbor YY.YY.3.3 remote-as YY
neighbor YY.YY.3.3 ebgp-multihop 255
neighbor YY.YY.3.3 update-source Loopback0
　
RackYYR3:
Router bgp YY
Neighbor YY.YY.1.1 remote-as 10YY
Neighbor YY.YY.2.2 remote-as 10YY
Neighbor YY.YY.1.1 update-source loop0
Neighbor YY.YY.2.2 update-source loop0
Neighbor YY.YY.1.1 ebgp-multihop 255
Neighbor YY.YY.2.2 ebgp-multihop 255
　
RackYYSw1:
Ip route 200.1YY.100.0 255.255.252.0 valn 100
Ip route 200.1yy.106.1 255.255.255.255 Y.Y.1.1
RackYYSw2:
Ip route 200.1YY.100.0 255.255.252.0 valn 100
Ip route 200.1yy.106.1 255.255.255.255 Y.Y.1.1
[M13]Verify: show ip bgp; ping all lo200 in ASYY and AS1YY
7.3 Path Selection
* Configure R1 so it informs AS YY that the routes 200.1YY.101.1 and 200.1YY.106.1 are to preferable be reached via R1
* Configure R2 so it informs AS YY ,that the routes 200.1YY.102.1 are to preferable be reached via R2
* Route filtering is not permitted, DO NOT change any attributes coming from BGP AS 254
RackYYR1: ;
ip prefix-list r2loop seq 5 permit 200.1YY.102.1/32
route-map MED permit 10
match ip address prefix r2loop
set metric 100
route-map MED permit 20
Router bgp 10YY
neighbor YY.YY.3.3 route-map MED out
　
RackYYR2:
ip prefix-list r1r6loop per 200.1yy.101.1/32
ip prefix-list r1r6loop per 200.1yy.106.1/32
route-map MED permit 10
match ip address prefix r1r6loop
set metric 100
route-map MED permit 20
Router bgp 10YY
neighbor YY.YY.3.3 route-map MED out
　
RackYYR6:
Router bgp 10YY
Neighbor YY.YY.1.1 send-community
Neighbor YY.YY.2.2 send-community
　
RackYYR1:
Router bgp 10YY
Neighbor YY.YY.2.2 send-community
Neighbor YY.YY.3.3 send-community
　
RackYYR2:
Router bgp 10YY
Neighbor YY.YY.1.1 send-community
Neighbor YY.YY.3.3 send-community
　
RackYYR3:
Router bgp YY
Neighbor YY.YY.4.4 send-community
Neighbor YY.YY.5.5 send-community
Verify：show ip bgp; show ip bgp community
第三部分： IP Feature
(组播8分，安全8分，QOS8分，IP特性8分，合计32分)
IP IOS feature
3.1 Exception handling
* Configure R4 to enable exception handling
* Filename:R4-DUMP Username:ccie Password:cisco
* Ftp address: 150.1.YY.254
RackYYR4:
ip ftp username ccie
ip ftp password cisco
exception protocol ftp
exception dump150.1.YY.254
exception corefile R4-DUMP
3.2 System logging
? Buffer alert critical emergencies and error
? Set the buffer size to 8192
? Indicate the date and time for each logged entry
RackYYR5:
logging on
logging buffered 8192 errors
clock timezone GMT 8
clock set hh:mm:ss month year
service timestamps log datetime local-time year show-timezone
Verify: show logging;
(所有设备的时间好像是都预先配置好的,我最后看到所有的设备都一个时间,和windows的时间相差无几)
3.3 DHCP
* Configure R5 to provide the following parameters for DHCP client on VLAN_55
* IP address
* DNS server YY.YY.55.60 and YY.YY.55.67
* Domain:cisco.com
* Default gateway
* Hosts must retain DHCP assigned address 10 days
* Permit only secure ARP entries to be installed in R5"s ARP table
RackYYR5:
Service dhcp
ip dhcp excluded address YY.YY.55.254
ip dhcp excluded address YY.YY.55.60
ip dhcp excluded address YY.YY.55.67
ip dhcp pool cisco
network YY.YY.55.0 255.255.255.0
default-router YY.YY.55.254
dns-server YY.YY.55.60 YY.YY.55.67
domain-name ccie.com
lease 10
update arp
Security
6.1 Tracing Traffic Source to Device under Attack
* It is suspected that Dos attack is being launched at host 150.3.YY.254 select an appropriate device to configure so that you can start tracing the source of this attack.
* Your solution must meet the following criteria
* The result of the trace must be sent to syslog once a day
* This device is limited to trace to one IP address only
* DO NOT configure ACL to achieve this
RackYYR5:
ip source-track 150.1.YY.254
ip source-track address-limit 1
ip source-track syslog-interval 1440
Verify: show ip source-track; show ip source-track
6.2 IP Fragment Attacking
* R4上收到了一个来自BB1，源是随要地址的攻击，目的地是一个web服务器：10.1.Y.5要求
* R4阻止这些攻击流量，并允许其他流量通过
Rack11R4:
ip access-list extended FRAGMENT
deny ip any host 10.1.yy.5 fragment
permit ip any any
int g0/0
ip access-group FRAGMENT in
6.3 Catalyst Security
* On Sw1-Fa0/7 configure 802.1.x authentication meeting the following When clients that do not
RackYYSw1:
aaa new-model
aaa authentication dot1x default group radius
aaa authorization network default group radius
dot1x system-auth-control
dot1x guest-vlan supplicant
int Fa0/7
Switchport mode access
dot1x port-control auto
dot1x guest-vlan 55
dot1x host-mode multi-host
Verify: show dot1x all; show dot1x interface interface-id details
QOS
4.1 Congestion Avoidance Notication
* Configure R1-S0/0/0 such that is out bound traffic has utilized 75% of total bandwidth.
* R1 should sign that the network is congested and the recipients need to slow down sending packets.
* DO NOT configure Frame Relay BECN or FECN for this question
RackYYR1:
Ip tcp ecn
Policy-map QOS
class class-default
bandwidth percent 75
random-detect
random-detect ecn
interface s0/0/0
no random-detect
service-policy output QOS
Verify: show policy-map interface interface-id
4.2 Traffic policing
* Client on VLAN_BB1 and VLAN_55 access a URL located on VLAN_BB2 frequently. This URL is http://www.this website.com/directory.
* Select one suitable router to configure, so as to conserve bandwidth meeting the following criteria.
* Traffic from this URL back to these clients should not exceed 640000 bits per second.
* If the files download from this URL are image file then drop the traffic
* You may assume image the names end with the suffix:*.gif*.jpg or *.jpeg
RackYYR6:
ip cef
ip access-list extended TRAFFIC
permit ip 150.2.YY.0 0.0.0.255 150.1.YY.0 0.0.0.255
permit ip 150.2.YY.0 0.0.0.255 YY.YY.55.0 0.0.0.255
class-map match-all url
match access-group name TRAFFIC
match protocol http host www.thiSwebsite.com
match protocol http url /directory /*
class-map match-all pic
match class-map url
match protocol http url *.jpg|*.jpeg|*.gif
policy-map NBAR
class pic
drop
class url
police cir 64000
interface Gi0/1
service-policy input NBAR
ip nbar protocol-discovery
Verify: show policy-map interface interface-id
4.3 Discard Eligible and Traffic Shaping
* The Frame Relay link on R5 is experiencing heavy congesting. Configure R5 so that the Frame Relay provider does not drop any routing protocol packets during
* congesting and if the number of packets in R5"s Frame Relay interface queue exceeds 10,then the traffic rate will reduced to 32000 bps.
RackYYR5:
access-list 105 deny ospf any any
access-list 105 deny tcp any eq 179 any
access-list 105 deny tcp any any eq 179
access-list 105 deny pim any any
access-list 105 permit ip any any
frame-relay de-list 1 protocol ip list 105
interface s0/0.5
frame-relay de-group 1 503
map-class frame-relay FRTS
Frame-Relay adaptive-shaping interface-congestion 10
Frame-Relay mincir 32000
interface Serial0/0
Frame-Relay traffic-shaping
interface Serial0/0.5
Frame-Relay interface-dlci 503
class FRTS
Verify: show frame-relay pvc dlci
Multicast
5.1 Sparse Mode Multicasting
* There is a multicast source for group 224.2.2.2 located at VLAN_BB2 and another source for group 224.3.3.3 located at VLAN_BB3.There are clients on VLAN_55 that would like to access these two groups.
* Configure R5,R3, Sw1,R1 and R6 to meet the following requirements
* Configure all devices using sparse mode
* R1 will be the RP for both multicast groups and R3 will be backup RP. Use the most reliable way to achieve this objective and do not configure RP information statically
* R5 needs to be able to ping both 224.2.2.2 and 224.3.3.3
RackYYR6:
ip multicast-routing
int g0/1
ip pim sparse-mode
ip igmp join-group 224.2.2.2 (这是预配置)
int g0/0
ip pim sparse-mode
ip igmp join-group 224.3.3.3 (这是预配置)
int s0/0/0
ip pim sparse-mode
ip pim nbma-mode
　
RackYYR1:
ip multicast-routing
int s0/0/0
ip pim sparse-mode
ip pim nbma-mode
int g0/0
ip pim sparse-mode
int lo200
ip pim sparse-mode
ip pim send-rp-ann LO200 sco 10 group-list 11
ip pim send-rp-dis LO200 sco 10
access-list 11 per 224.2.2.2
access-list 11 per 224.3.3.3
RackYYSw1:
ip multicast-routing
int VLAN 100
ip pim sparse-mode
int Fa0/3
ip pim sparse-mode
　
RackYYR3:
ip multicast routing
int g0/0
ip pim sparse-mode
int s0/0/0.3
ip pim sparse-mode
ip pim nbma-mode
ip pim dr-priority 200
int lo0
ip pim sparse-mode
ip pim send-rp-ann Loopback0 sco 10 group-list 33
ip pim send-rp-dis Loopback0 sco 10
access-list 33 permit 224.2.2.2
access-list 33 permit 224.3.3.3
RackYYR5:
ip multicast-routing
int s0/0/0.5
ip pim sparse-mode
ip pim nbma-mode
　
int g0/0
ip pim sparse-mode
Verify: show ip pim neighbor; show ip pim rp mapping; R5 ping group addresses 224.2.2.2 and 224.3.3.3;
5.2 Defense against Multicast Dos Attack
* There is a concern that hacker launch Dos attack against R5 with multicast group membership traffic. Configure R5 so that accept only 100 IGMP reports at any time but this limit does not apply to the group 224.3.3.3.
RackYYR5:
ip access-list extended 105
permit igmp any host 224.3.3.3
int g0/0
ip igmp limit 110 except 105
Verify: show ip igmp interface interface-id
[M1]使用前缀列表,只允许特定网段进入RIP
[M2]重分布RIP进OSPF时,度量值为加和,M-2是OSPF重新计算的度量值
[M3]Nssa
[M4]180.88.0.0/18
[M5]区域间通告汇总路由
[M6]考虑偏移列表无法使用前缀列表,这里使用访控进行定义
[M7]重分布
直连接口
[M8]作接口上对R6的汇总路由,.并利用路由图拒绝掉到OSPF汇总路由
[M9]过滤EIGRP到OSPF区域里的YY.YY.0.0/16的汇总路由
[M10]过滤掉由R3产生的单条汇总0.0.0.0,同时允许其它的明细路由
[M11]从EIGRP100中过滤掉YY.YY.0.0/16的汇总路由条目到OSPF YY
[M12]接口汇总,将所有通告给R6的YY.YY.0.0的路由汇总为单条路由.(并过滤其网段的明细路由)
[M13]

4. 1 Congestion Avoidance Notication
* Configure R1-S0/0/0 such that is out bound traffic has utilized 75% of total bandwidth.
* R1 should sign that the network is congested and the recipients need to slow down sending packets.
* DO NOT configure Frame Relay BECN or FECN for this question
RackYYR1:
Ip tcp ecn
Policy-map QOS
class class-default
bandwidth percent 75
random-detect
random-detect ecn
interface s0/0/0
no random-detect
service-policy output QOS
Verify: show policy-map interface interface-id
4.2 Traffic policing
* Client on VLAN_BB1 and VLAN_55 access a URL located on VLAN_BB2 frequently. This URL is http://www.this website.com/directory.
* Select one suitable router to configure, so as to conserve bandwidth meeting the following criteria.
* Traffic from this URL back to these clients should not exceed 640000 bits per second.
* If the files download from this URL are image file then drop the traffic
* You may assume image the names end with the suffix:*.gif*.jpg or *.jpeg
RackYYR6:
ip cef
ip access-list extended TRAFFIC
permit ip 150.2.YY.0 0.0.0.255 150.1.YY.0 0.0.0.255
permit ip 150.2.YY.0 0.0.0.255 YY.YY.55.0 0.0.0.255
class-map match-all url
match access-group name TRAFFIC
match protocol http host www.thiSwebsite.com
match protocol http url /directory /*
class-map match-all pic
match class-map url
match protocol http url *.jpg|*.jpeg|*.gif
policy-map NBAR
class pic
drop
class url
police cir 64000
interface Gi0/1
service-policy input NBAR
ip nbar protocol-discovery
Verify: show policy-map interface interface-id
4.3 Discard Eligible and Traffic Shaping
* The Frame Relay link on R5 is experiencing heavy congesting. Configure R5 so that the Frame Relay provider does not drop any routing protocol packets during
* congesting and if the number of packets in R5"s Frame Relay interface queue exceeds 10,then the traffic rate will reduced to 32000 bps.
RackYYR5:
access-list 105 deny ospf any any
access-list 105 deny tcp any eq 179 any
access-list 105 deny tcp any any eq 179
access-list 105 deny pim any any
access-list 105 permit ip any any
frame-relay de-list 1 protocol ip list 105
interface s0/0.5
frame-relay de-group 1 503
map-class frame-relay FRTS
Frame-Relay adaptive-shaping interface-congestion 10
Frame-Relay mincir 32000
interface Serial0/0
Frame-Relay traffic-shaping
interface Serial0/0.5
Frame-Relay interface-dlci 503
class FRTS
Verify: show frame-relay pvc dlci
Multicast
5.1 Sparse Mode Multicasting
* There is a multicast source for group 224.2.2.2 located at VLAN_BB2 and another source for group 224.3.3.3 located at VLAN_BB3.There are clients on VLAN_55 that would like to access these two groups.
* Configure R5,R3, Sw1,R1 and R6 to meet the following requirements
* Configure all devices using sparse mode
* R1 will be the RP for both multicast groups and R3 will be backup RP. Use the most reliable way to achieve this objective and do not configure RP information statically
* R5 needs to be able to ping both 224.2.2.2 and 224.3.3.3
RackYYR6:
ip multicast-routing
int g0/1
ip pim sparse-mode
ip igmp join-group 224.2.2.2 (这是预配置)
int g0/0
ip pim sparse-mode
ip igmp join-group 224.3.3.3 (这是预配置)
int s0/0/0
ip pim sparse-mode
ip pim nbma-mode
　
RackYYR1:
ip multicast-routing
int s0/0/0
ip pim sparse-mode
ip pim nbma-mode
int g0/0
ip pim sparse-mode
int lo200
ip pim sparse-mode
ip pim send-rp-ann LO200 sco 10 group-list 11
ip pim send-rp-dis LO200 sco 10
access-list 11 per 224.2.2.2
access-list 11 per 224.3.3.3
RackYYSw1:
ip multicast-routing
int VLAN 100
ip pim sparse-mode
int Fa0/3
ip pim sparse-mode
　
RackYYR3:
ip multicast routing
int g0/0
ip pim sparse-mode
int s0/0/0.3
ip pim sparse-mode
ip pim nbma-mode
ip pim dr-priority 200
int lo0
ip pim sparse-mode
ip pim send-rp-ann Loopback0 sco 10 group-list 33
ip pim send-rp-dis Loopback0 sco 10
access-list 33 permit 224.2.2.2
access-list 33 permit 224.3.3.3
RackYYR5:
ip multicast-routing
int s0/0/0.5
ip pim sparse-mode
ip pim nbma-mode
　
int g0/0
ip pim sparse-mode
Verify: show ip pim neighbor; show ip pim rp mapping; R5 ping group addresses 224.2.2.2 and 224.3.3.3;
5.2 Defense against Multicast Dos Attack
* There is a concern that hacker launch Dos attack against R5 with multicast group membership traffic. Configure R5 so that accept only 100 IGMP reports at any time but this limit does not apply to the group 224.3.3.3.
RackYYR5:
ip access-list extended 105
permit igmp any host 224.3.3.3
int g0/0
ip igmp limit 110 except 105
Verify: show ip igmp interface interface-id
[M1]使用前缀列表,只允许特定网段进入RIP
[M2]重分布RIP进OSPF时,度量值为加和,M-2是OSPF重新计算的度量值
[M3]Nssa
[M4]180.88.0.0/18
[M5]区域间通告汇总路由
[M6]考虑偏移列表无法使用前缀列表,这里使用访控进行定义
[M7]重分布
直连接口
[M8]作接口上对R6的汇总路由,.并利用路由图拒绝掉到OSPF汇总路由
[M9]过滤EIGRP到OSPF区域里的YY.YY.0.0/16的汇总路由
[M10]过滤掉由R3产生的单条汇总0.0.0.0,同时允许其它的明细路由
[M11]从EIGRP100中过滤掉YY.YY.0.0/16的汇总路由条目到OSPF YY
[M12]接口汇总,将所有通告给R6的YY.YY.0.0的路由汇总为单条路由.(并过滤其网段的明细路由)
[M13]

5. 1 OSPF Bbackbones
* The link between Sw1 and Sw2
* All interface in VLAN_100 on Sw1 Sw2 R1 and R2
* R3 G0/0 and G0/1 and the fa0/3 on Sw1 and Sw2
* Loop back 0 interface on Sw1 Sw2 R2 and R3
* Verifying that all OSPF neighbor have built their adjacencies
RackYYR1:
Router ospf YY
network YY.YY.12.1 0.0.0.0 area 0
network YY.YY.21.1 0.0.0.0 area 0
　
RackYYR2:
Router ospf YY
network YY.YY.2.2 0.0.0.0 area 0
network YY.YY.12.2 0.0.0.0 area 0
network YY.YY.21.2 0.0.0.0 area 0
　
RackYYSw1:
Router ospf YY
network YY.YY.7.7 0.0.0.0 area 0
network YY.YY.12.254 0.0.0.0 area 0
network YY.YY.13.2 0.0.0.0 area 0
network YY.YY.100.1 0.0.0.0 area 0
　
RackYYSw2:
Router ospf YY
network YY.YY.8.8 0.0.0.0 area 0
network YY.YY.21.254 0.0.0.0 area 0
network YY.YY.31.2 0.0.0.0 area 0
network YY.YY.100.2 0.0.0.0 area 0
　
RackYYR3:
Router ospf YY
network YY.YY3.3 0.0.0.0 area 0
network YY.YY.13.1 0.0.0.0 area 0
network YY.YY.31.1 0.0.0.0 area 0
Verify: show ip ospf interface brief; show ip ospf neighbor
2.2 OSPF over NBMA
* OSPF area 11 consist of the follow interface and attributes
* The Frame Relay network between R3 R4 R5
* Loop back 0 on R4 and R5
* VLAN_55
* Ensure there is no DR/BDR
RackYYR3:
interface s0/0/0.3
ip ospf network point-to-multipoint non-broadcast
Router ospf YY
network YY.YY.11.3 0.0.0.0 area 11
nei YY.YY.11.4
nei YY.YY.11.5
　
RackYYR4:
interface s0/0/0.4
ip ospf network point-to-multipoint non-broadcast
Router ospf YY
network YY.YY.4.4 0.0.0.0 area 11
network YY.YY.11.4 0.0.0.0 area 11
RackYYR5:
interface s0/0/0.5
ip os net point-to-multipoint non-broadcast
Router ospf YY
network YY.YY.5.5 0.0.0.0 area 11
network YY.YY.11.5 0.0.0.0 area 11
network YY.YY.55.254 0.0.0.0 area 11
Verify: show ip ospf interface brief; show ip ospf neighbor
2.3 OSPF ASBR and RIP version 2
* Configure R4 to receive RIP v2 routes from Backbone 1
* When properly configured you will receives RIP v2 routes in the class B address range 199.172.Z.Z[M1]
* Configure R4 so that the external RIP routes are injected into area 11 and appear throughout that OSPF domain[M2]
* Ensure external routes originates from Autonomous Systems Boundary Routers (ASBR) outside area 11 cannot be flooded within the area[M3]
* Permit OSPF type-3 routes into area 11(在R5上看)
RackYYR4:
ip prefix-list fbb1 per 199.172.0.0/16 le 32
Router rip
version 2
no auto-summary
network 150.1.0.0
distribute-list prefix fbb1 in Fa0/0
Router ospf YY
redistribute rip metric-type 1 subnets
area 11 nssa
　
RackYYR3:
Router ospf YY
area 11 nssa
　
RackYYR5:
Router ospf YY
area 11 nssa
Verify: show ip protocol; show ip route rip; show ip ospf; show ip route ospf;
2.4 Area 34 and Area 43
* OSPF area 34 consists of the VLAN_200 interfaces on Sw1 and Sw3 and loopback 0 in Sw3
* OSPF area 43 consists of the VLAN_200 interfaces on Sw2 and Sw4 and loopback 0 in Sw4
RackYYSw1:
Router ospf YY
network YY.YY.34.1 0.0.0.0 area 34
　
RackYYSw2:
Router ospf YY
network YY.YY.43.1 0.0.0.0 area 43
　
RackYYSw3:
Router ospf YY
network YY.YY.9.9 0.0.0.0 area 34
network YY.YY.34.254 0.0.0.0 area 34
　
RackYYSw4:
Router ospf YY
network YY.YY.10.10 0.0.0.0 area 43
network YY.YY.43.254 0.0.0.0 area 43
Verify: show ip ospf interface brief; show ip ospf neighbor
2.5 OSPF ABR
* Static routes are not permitted for this question
* inject a default route into area 0 area 11 area 34 area 43
* Use fewest number of steps or commands to completes this
RackYYR3:
Router ospf YY
area 11 nssa default-information-originate
default-information originate always
Verify: show ip route ospf; show ip ospf database
2.6 OSPF Summary
* Add the following interface on R2 to Area 0
* Loopback 22 180.88.22.254/24
* Loopback 32 180.88.32.254/24
* Loopback 47 180.88.47.254/24
* Summarize the above address into a single route
* Your summary route must be compact and not waste address space[M4]
* Verify the Summary is in the OSPF routing table on R5 and you can ping all the host address
* R3、Sw 1、Sw2都要做区域间汇总。[M5]
RackYYR2:
int lo22
ip address 180.88.22.254 255.255.255.0
int lo32
ip address 180.88.32.254 255.255.255.0
int lo47
ip address 180.88.47.254 255.255.255.0
Router ospf YY
network 180.88.0.0 0.0.63.255 area 0
这里我选择直接在3个loopback接口上使用IOS12.4版本后支持的接口宣告ospf的方法。即快捷，又不会出错。
RackYYR3/Sw1/Sw2:
Router ospf YY
area 0 range 180.88.0.0 255.255.192.0
Verify; show ip ospf; show ip route ospf; show ip ospf database
(只要在OSPF中公告的loop口,ip add是24位的,我全用的是点到点类型)
2.7 RIP version 2
* Advertise all the individual YY.YY.0.0 network prefixes generated within your lab topology to backbone 1
* Instruct the backbone 1 router that your networks are 5 hops away[M6]
* Filter all other prefixes to backbone 1
RackYYR4:
Access-list 4 per YY.YY.0.0 0.0.255.255
Router rip
Redistribute ospf yy metric 1
Offset-list 4 out 4 g0/0
Distribute-list 4 out g0/0
Verify: debug ip rip
这个地方， 我用方法2： router rip
Redistribute os 8 metric 5 route-map fromOSPF
Route-map fromOSPF per 10
Match ip add prefix-list fromOSPF
Ip prefix-list fromOSPF per 8.8.0.0/16 le 32
使用一个重分发的命令就解决了3个需求。我们的口号是用最少的策略解决问题，让router的CPU消耗降到最低。并且注入到RIP database里的路由也只有8.8.0.0/16内的了。
或者使用我的方法3 ： router rip
Redis os 8 route-map fromOSPF
Default-metric 5
Route-map fromOSFP per 10
Match ip add fromOSPF
Ip access-list standard fromOSPF
Per 8.8.0.0 0.0.255.255
或者使用我的方法4 ： router rip
Redis os 8 route-map fromOSPF
Route-map fromOSPF per 10
Set metric 5
Distribute-list prefix fromOSPF out os 8
Ip prefix-list fromOSPF per 8.8.0.0/16 le 32
源的方法最烂; 让router执行了3次策略才完成了需求。
2.8 EIGRP
* EIGRP 100 AS 100 consists of the following interface
* The Frame Relay network between R1 and R6
* Loopback0 on R1 and R6
* The BB2 interface on R6 should appear as an external EIGRP route on R1[M7]
* R6 must have a single 16 bit prefix via R1 to the YY.YY.0.0 network. Do not use route filters or automatic summary[M8]
* Redistribute EIGRP routes into ospf area
RackYYR1:
Ip prefix-list eto per YY.YY.0.0/16
Route-map eto deny 10
Match ip add pre eto
Route-map eto per 20
[M9]
ip prefix-list ote seq 5 permit 0.0.0.0/0
route-map ote deny 10
match ip address prefix-list ote
route-map ote permit 20
[M10]
Router eigrp 100
No au
Net YY.YY.16.1 0.0.0.0
Net YY.YY.1.1 0.0.0.0
Redistribute ospf YY metric 10000 100 255 1 1500 route-map ote
Router os yy
Redistribute eigrp 100 subnets metric-type 1 route-map eto [M11]
Int s0/0/0
Ip summary ei 100 YY.YY.0.0 255.255.0.0 [M12]
　
RackYYR6:
Route-map con per 10
Match interface E0/1
Router eigrp 100
No au
Net YY.YY.16.6 0.0.0.0
Net YY.YY.6.6 0.0.0.0
Redistribute connected route-map CON metric 10000 100 255 1 1500
Verify: show ip protocol; show ip route eigrp; show ip route ospf;
2.9 EIGRP over BB3
* The backbone 3 router will be sending some class A,B and C IP prefixes
* Create a prefix-list and apply it so that the EIGRP process will only accept prefixes in the class C address might on the routing table
* Deny all routes to BB3
(这里要注意到first octet=192-200)
前缀列表 访问列表
A:0.0.0.0/1 le 32 0.0.0.0 127.255.255.255
B:128.0.0.0/2 le 32 128.0.0.0 63.255.255.255
C:192.0.0.0/3 le 32 192.0.0.0 31.255.255.255
RackYYR6:
Ip prefix-list fbb3 per 192.0.0.0/5 le 32
Ip prefix-list fbb3 per 200.0.0.0/8 le 32
Ip prefix-list tbb3 deny 0.0.0.0/0 le 32
Router eigrp 100
Net 150.3.YY.1 0.0.0.0
Distribute-list prefix fbb3 in F0/0
Distribute-list prefix tbb3 out F0/0
Verify: show ip protocol; show ip route eigrp
2.10 IPV6
R1 G0/1 2033:YY:YY:21::1
S0/0/0 2033:YY:YY:16::1(FE80::217:94FF:FE15:8C90)
R6 f0/1 2033:YY:YY:62::6
S0/3/0 2033:YY:YY:16::6(FE80::215:C6FF:FE4A:6210)
All the interface run OSPF v3
RackYYR1#show ipv6 interface brief
Gi0/0 [up/up]
FE80::ZZZZ:ZZZZ:ZZZZ //link-local address
2038:YY:YY:11::1
Serial0/0/0 [up/up]
FE80::ZZZZ:ZZZZ:ZZZZ
2038:YY:YY:61::1
RackYYR6#show ipv6 interface brief
Gi0/0 [up/up]
FE80::ZZZZ:ZZZZ:ZZZZ
2038:YY:YY:66::6
Serial0/0/0 [up/up]
FE80::ZZZZ:ZZZZ:ZZZZ
2038:YY:YY:61::6
RackYYR1#show ipv6 route
IPv6 Routing Table -7 entries
Codes: C -Connected, L -Local, S -Static, R -RIP, B -BGP U -Per-user Static route I1 -ISIS L1, I2 -ISIS L2, IA – ISIS inte area, IS -ISIS summary O – OSPF intr OI – OSPF inter, OE1 – OSPF ext 1, OE2 -OSPF ext 2 ON1 – OSPF NSSA

Free 642-741 Demo Download

Examsoon offers free demo for Others 642-741 exam (Implementing Cisco Unified Wireless Voice Networks). You can check out the interface, question quality and usability of our practice exam before you decide to get it. We are the only one site can offer demo for almost all products.

Free Download 642-741 PDF exam Trainning Materials

1. What two benefits result from Cisco WLC configuration of DCA for 5-GHz VoWLAN deployments? (Choose two.)
A. Avoid channels with microwave oven noise.
B. Manually remove channels not supported by the VoWLAN clients.
C. Avoid 802.11n 40-MHz wide channels.
D. Automatically avoid nearby radar.
Answer: BD

2. Which protocol is used by multicast to prevent loops?
A. OSPF
B. RIP
C. RPF
D. BGP
E. EIGRP
Answer: C

3. What must be true about the client before upstream traffic stream metrics can be displayed on the Cisco WLC?
A. must be Cisco Compatible Extensions version 2
B. must be Cisco Compatible Extensions version 3
C. must be Cisco Compatible Extensions version 4
D. must be associated to a Platinum QoS WLAN
E. must be associated to an access point on a Cisco WLC with code version 5.0 or newer
Answer: C

4. Which statement describes the WLCv5.2 delivery of a multicast packet from a wired PC source on VLAN_X to a respective wireless client using SSID_X, using a WLAN controller enabled for multicast?
A. A packet is delivered to Cisco WLC and forwarded via multicast to all of its associated APs, and finally to all wireless clients of that Cisco WLC, via wireless multicast.
B. A packet is delivered to Cisco WLC and forwarded via unicast to all of its associated APs, and finally to all wireless clients of that Cisco WLC, via wireless unicast.
C. A packet is delivered to Cisco WLC and forwarded via multicast to all of its associated APs, discarded at APs without SSID_X joined wireless clients, and forwarded at APs with SSID_X joined wireless clients via wireless multicast.
D. A packet is delivered to Cisco WLC and forwarded via unicast to all of its associated APs, discarded at APs without SSID_X joined wireless clients, and forwarded at APs with SSID_X joined wireless clients via wireless multicast.
E. A packet is delivered to Cisco WLC and forwarded via multicast to all of its associated APs, discarded at APs without SSID_X joined wireless clients, and forwarded at APs with SSID_X joined wireless clients via wireless unicast.
F. A packet is delivered to Cisco WLC and forwarded via unicast to all of its associated APs, discarded at APs without SSID_X joined wireless clients, and forwarded at APs with SSID_X joined wireless clients via wireless unicast.
Answer: C

5. Which two messages can carry the TSPEC from client to the AP? (Choose two.)
A. probe request
B. association request
C. authentication request
D. reassociation request
Answer: BD

6. Which two statements are correct if IGMP snooping is enabled on a Cisco WLC? (Choose two.)
A. The router IGMP table is updated with the IP address of the wireless clients as the last reporter.
B. The IGMP packets from the wireless clients are forwarded to the router without modifications.
C. The IGMP packets from the wireless clients are received at the Cisco WLC, which in turn generates a query for the client.
D. The IGMP packets from the wireless clients are received at the WLC and are used to update the router via Cisco Group Management Protocol update from the Cisco WLC.
E. The router IGMP table is updated with the IP address of the Cisco WLC as the last reporter.
Answer: CE

7. On the Cisco Aironet Access Points connected to a Cisco Unified Wireless LAN controller, which TCLAS queue transmits RTP packets with correct 802.11e QoS markings?
A. UP
B. VO
C. VI
D. BK
E. BE
Answer: B

8. Which two statements are correct regarding multicast implementation using a WLAN controller (v2) and AP? (Choose two.)
A. Multicast traffic is sent out on Cisco APs at the highest mandatory data rate.
B. Multicast traffic is sent out on Cisco APs at the highest supported data rate.
C. On Cisco APs, multicast traffic and beacons are sent out at the same data rates to maintain a common cell size for normal data as well as multicast data.
D. If there is more than one mandatory data rate, multicast traffic will be sent at the highest mandatory rate and beacons will be sent at the lowest mandatory rate.
E. On Cisco APs, multicast traffic will be sent out at the highest data rate that a client can maintain with the AP.
Answer: AD

9. Which statement is correct for both the LWAPP and CAPWAP AP upstream 802.1Q tagged wired QoS priority for a non-WMM-associated client frame that is H-REAP locally switched running v5.2?
A. Wireless client WMM UP classification is translated to a wired DSCP priority.
B. Wireless client 802.11p classification is translated to a wired DSCP priority.
C. Wireless client WMM UP classification is translated to a wired 802.1p CoS priority.
D. Wireless client 802.11p classification is translated to a wired 802.1p CoS priority.
E. WLAN configured QoS level is used to set the wired DSCP priority.
F. Wired 802.1p CoS priority is not set.
Answer: F

10. What frame type is used to signal TSPEC reservation from a client?
A. RSVP
B. ADDTS
C. 802.11 association information elements
D. WMM capabilities exchange
Answer: B

Free FM0-301 Demo Download

Examsoon offers free demo for FileMaker Certification FM0-301 exam (Filemaker7 Developer Essentials Exam). You can check out the interface, question quality and usability of our practice exam before you decide to get it. We are the only one site can offer demo for almost all products.

Free Download FM0-301 PDF exam Trainning Materials

1. If a field in FileMaker Pro 7 has been set to validate Always, which three actions will trigger validation on that field? (Choose three.)
A. importing data into that field
B. exporting data from that field
C. editing data in the field using Instant Web Publishing
D. clicking into the field, then immediately exiting the field
E. attempting to change the value of the field using a Set Field[ ] script step
Answer: ACE

2. Which statement is true in FileMaker Pro 7?
A. The Save record changes automatically layout option does not apply to users with [Full Access] privileges.
B. On a layout by layout basis, you can specify whether record changes made in Browse mode will be saved automatically.
C. On a layout by layout basis, you can specify whether changes made to the layout when exiting Layout mode will be saved automatically.
D. If the Save record changes automatically option has been turned off for a layout, then users will be prompted to save their changes only when exiting the layout.
Answer: B

3. Which three statements are true about field indexing in FileMaker Pro 7? (Choose three.)
A. Indexing improves the speed at which finds are performed.
B. Value lists require at least one of any field they reference to be indexed.
C. To establish a relationship between two fields, both fields are required to be indexed.
D. A value index, used in establishing relationships, stores up to 60 primary characters or digits per return-delimited line.
E. Using Unicode or ASCII as the default language by which a field is indexed causes sorts on that field to be case sensitive.
Answer: ABE

4. A database has two tables, Planet and Moon. Moons are related to a single planet and their relationship is set to delete related records in the Moon table when a Planet record is deleted. Which two things happen when the Planet table is deleted from the Tables tab of the Define Database dialog? (Choose two.)
A. All data in the Planet table are deleted.
B. All records in the Moon table are deleted.
C. All records in the Moon table remain unaffected.
D. All records in the Moon table are deleted if the option to "Also remove occurrences of these tables in the graph" was selected when deleting the Planet table.
E. All table occurrences of both Planet and Moon tables are removed if the option to "Also remove occurrences of these tables in the graph" was selected when deleting the Planet table.
Answer: AC

5. Consider a FileMaker Pro 7 database with the following tables and fields:
Using only Cartesian (cross or x ) relationships between occurrences of these tables, sorting if necessary, which two actions can be performed? (Choose two.)
A. determine the mode of the order amount
B. determine the date of the most recent order
C. display all records from the Customer table in a portal
D. create a value list that shows all orders for a chosen customer
E. create a portal to show one record for each product that has ever been ordered
Answer: BC

6. Click the Exhibit button
Consider a FileMaker Pro 7 database with two tables called Salesperson and Order, and a relationship between the two tables based on a SalespersonID field. The relationship is configured as shown in the exhibit. There is a layout called Salesperson Detail, based on the Salesperson table occurrence, with a portal showing Order records via the above relationship.
Which three statements are true? (Choose three.)
A. Deleting a Salesperson record also deletes all related Order records.
B. It is possible to create new Order records by importing data into the Salesperson table.
C. It is possible to create new Salesperson records by importing data into the Order table.
D. Users may create new Order records by entering data into the portal on the Salesperson Detail layout
E. It is possible to create a new Salesperson record using a Set Field [ ] script step in a script that runs in the context of the Order table.
F. It is possible to create a new Salesperson record by typing into a related salesperson field displayed on a layout that is based on the Order table.
Answer: DEF

7. Which three statements about field validation are true in FileMaker Pro 7? (Choose three.)
A. Fields can only be validated by a single criterion.
B. Field validation warnings may be triggered by scripts.
C. Users can be prevented from overriding the validation warning.
D. Users can be presented with a specific message that will see when a field fails validation.
E. A script can be specified to run when manually entered field data fails validation.
Answer: BCD

8. Which two statements about relationships are true in FileMaker Pro 7? (Choose two.)
A. The &gt; operator only works using numeric match fields.
B. You can build a relationship using multiple match fields.
C. It is possible to create a valid relationship where one match field is unindexed.
D. A table occurrence must be connected to at least one other table occurrence.
E. When enabling the option, "Allow creation of records in this table via this relationship", only =, &gt;=, &lt;= will properly populate match keys.
Answer: BC

9. Consider two FileMaker Pro 7 files, Alpha and Beta, where a table from Beta appears as an externally referenced table occurrence on Alpha’s Relationships Graph. Which three statements are true? (Choose three.)
A. Layouts in Alpha can display data from Beta.
B. Alpha can contain multiple valid file references to Beta.
C. It is impossible to lock records in both Alpha and Beta simultaneously.
D. Layouts from Beta cannot be displayed in the same window as layouts from Alpha.
E. A table occurrence from Beta is required on Alpha’s Relationships Graph in order to call a script in Beta from Alpha.
Answer: ABD

10. What is the maximum number of characters that can be entered or imported into a text field in FileMaker Pro 7?
A. 64 thousand
B. 1 million
C. 1 billion
D. 1 trillion
E. Number of characters is limited only by disk space.
Answer: C

11. Click the Exhibit button.
Given the FileMaker Pro 7 Relationships Graph shown in the exhibit, which table occurrence should be assigned to a layout that contains a portal that shows all students for all of a teacher’s classes?
A. Classes
B. Advisors
C. Teachers
D. Enrollment
Answer: C

12. Click the Exhibit button.
You want to build a FileMaker Pro 7 database that models a business organizational chart. One person may manage no one or many people. One person may be managed by at most one other person.
You want to build the system in such a way that a single layout showing information about a person can display both the name of the current person’s manager (if any) and the names of all people managed by the current person.
What is the minimum number of tables you must define in the Tables tab of the Define Database dialog to construct the layout?
A. one
B. two
C. three
D. four
Answer: A

13. Click the Exhibit button.
You have a FileMaker Pro 7 layout based on the table occurrence of Classes. You have a portal showing records from the table occurrence Students.
What happens if you place the field Students::Name into the portal?
A. The field displays &lt;Field Missing&gt; .
B. The field displays an enrolled student’s name in each row of the portal.
C. The field displays the first matching student’s name in every portal row.
D. The field displays an enrolled student’s name in each row of the portal only if the student name is calculated in the Enrollment table.
Answer: B

14. What is the maximum number of files that can be hosted on FileMaker Server 7?
A. 125
B. 250
C. 350
D. 500
E. The number is limited only by server hardware.
Answer: A

15. A number field in FileMaker Pro 7 called AmountPaid is set to auto-enter the following formula:.
The Do not replace existing value of field (if any) option is unchecked.
Which statement is true?
A. The calculation will only be evaluated the first time a value is entered into AmountPaid .
B. A user will not be able to manually edit the field once the calculation has been evaluated.
C. If the value in the AmountDue field is changed, the AmountPaid field will be re-evaluated.
D. The calculation will prevent a user from entering an incorrect value into the AmoundPaid field.
Answer: C

Free 000-001 Demo Download

Examsoon offers free demo for IBM certifications I 000-001 exam (Fund of Applying Maximo Enterprise Asset Mgmt Sol ‘09 ). You can check out the interface, question quality and usability of our practice exam before you decide to get it. We are the only one site can offer demo for almost all products.

Free Download 000-001 PDF exam Trainning Materials

1. What will happen to associated preventive maintenance (PM) records when an asset is decommissioned?
A. There is no automatic method to change the PM(s) status to INACTIVE.
B. The PM(s) will become in INACTIVE if ‘Change the Status of All Associated PM(s) to Inactive?’ is checked while decommissioning the asset.
C. The only way to change the status of the PM(s) to INACTIVE is to remove the assets from the PM(s) and then change the status of the PM(s) to INACTIVE.
D. If the ‘Change the Status of All Associated PM(s) to Inactive?’ is not selected during decommissioning, the PM(s) status will remain ACTIVE; however, work order cannot be generated from the PM having a decommissioned asset.
Answer: B

2. Which two aspects of the client’s environment will help determine sizing of the solution? (Choose two.)
A. the number of users
B. the number of locations
C. the number of types of hardware
D. the number of security protocols
E. the number of types of operating systems
Answer: AB

3. With which three other business initiatives does Enterprise Asset Management-a business paradigm-integrate strategic planning? (Choose three.)
A. sales
B. operations
C. maintenance
D. balance sheet
E. human resources
F. capital investment decision-making
Answer: BCF

4. Which three benefits do Enterprise Asset Management solutions provide? (Choose three.)
A. Reduce asset life.
B. Increase productivity.
C. Increase risk and costs.
D. Improve return on assets.
E. Reduce total cost of ownership.
F. Minimize collection on warranty claims.
Answer: BDE

5. Which application is installed with IBM Enterprise Asset Management for providing reporting capability?
A. Open Database Platform
B. External Report Integration
C. Business Objects/Crystal Reports
D. Business Intelligence Reporting Tool
Answer: D

6. Enterprise Asset Management packages offer a wide range of capabilities. Which three areas of capability are covered by IBM Maximo Asset Management solutions? (Choose three)
A. work orders
B. human resources
C. inventory control
D. preventive maintenance
E. facilities schedule management
F. customer relationship management
Answer: ACD

7. What is a feature of the Integration Framework?
A. Allow bulk importing of XML or flat files.
B. Allow bulk importing from Excel spreadsheets.
C. Allow bulk importing from external/legacy system.
D. Allow bulk importing from one database platform to another.
Answer: A

8. What is a rotating item?
A. A rotating item is an individual item that is defined with a common item number. An item is designated as rotating because one wants to be able to create individual asset records by using the information (Classification, Specification,and Item Assembly Structure) contained on the item record.
B. A rotating item is a set of items that are defined with a specific code. An item is designated as rotating because one does not want to be able to create individual asset records by using the information (Classification, Specification, and Item Assembly Structure) contained on the item record.
C. A rotating item is a set of kits that are defined with a specific description and GL. An item is designated as rotating because one has the single cost to manage prefers to be able to create individual asset records by using the information (Classification, Specification, and Item Assembly Structure) contained on the assembly record.
D. A rotating item is an individual item that is defined with a common item number and can be a spare part. An item is designated as rotating because one wants to be able to create multiple asset records by using the information (Classification, Specification, and Item Assembly Structure) contained on the item set records.
Answer: A

9. A competitor in the IBM Maximo Asset Management (IMAM) domain claims that their product contains pre-built workflows and common tasks that span and integrate across asset applications.
What should a solution advisor do when a customer is considering such a solution?
A. Dispute the vendor’s claims that these pre-built workflows even exist.
B. Inform the organization that workflow is an unimportant component in asset .
C. Inform the organization that all vendors have the same pre-built workflows incorporated in their products.
D. Inform the customer that if current business processes do not exactly match these workflows, customization is required.
Answer: D

10. A company just hired a new plant maintenance manager, and they are concerned about the number of corrupt asset records in the present system. In future they want to prevent this from happening. When implementing the new solution, what is recommended?
A. All maintenance personnel have full access to all records.
B. All maintenance personnel have read-only access to all data.
C. Only a very limited number of personnel have full access to static data records, but all maintenance personnel are able to enter work order data.
D. Maintenance personnel should not be using the system, and should only write entries on printed work orders and hire input clerks to enter these into the system.
Answer: C

11. A customer’s plant maintenance manager invites a solution advisor to discuss Enterprise Asset Management in general and how it might help the maintenance group work more effectively and efficiently.
What should the solution advisor do in the first meeting with the plant maintenance manager?
A. Ask the plant maintenance manager about the company’s history, competition, and market value.
B. Ask the plant maintenance manager about their background, education, and professional experience.
C. Ask the plant maintenance manager about current systems in use, issues with the system,and key areas where the manager wants to see improvements.
D. Ask the plant maintenance manager about the number of employees, union representation, and how IBM Maximo Asset Management can represent employees and their skill sets.
Answer: C

12. Which aspect of the client’s environment restricts how an asset management tool can be deployed?
A. which database servers are in use
B. which types of hardware are in use
C. which operating systems are in use
D. which authentication and security protocols are in use
Answer: D

13. Which two internet browsers are supported with IBM Maximo Asset Management V7.1? (Choose two.)
A. Opera
B. Netscape
C. Mozilla Firefox
D. Google Chrome
E. Microsoft Internet Explorer
Answer: CE

14. What are two common reporting requirements? (Choose two.)
A. the database connectivity method
B. the number of users in the solution
C. the number of reports being installed
D. ability to send completed reports by e-mail
E. reporting output available in Microsoft Excel
Answer: DE

15. When discussing plant maintenance with plant maintenance managers, frequently the topic of using preventive maintenance (PM) comes up. If this is used extensively and the PM work orders are regularly completed, what is told by this about the operation?
A. It is likely that equipment will break down frequently.
B. It is likely that equipment will break down infrequently.
C. It shows that maintenance is performed on an as needed basis.
D. It shows that there are frequent crises when it comes to maintaining equipment.
Answer: B

Free 1Y0-A11 Demo Download

Examsoon offers free demo for Citrix Other Certification 1Y0-A11 exam (Basic Administration for Citrix NetScaler 9.0). You can check out the interface, question quality and usability of our practice exam before you decide to get it. We are the only one site can offer demo for almost all products.

Free Download 1Y0-A11 PDF exam Trainning Materials

1. An administrator has just enabled caching and wants to make sure that this will positively impact server performance. Which information can the administrator get from the Dashboard to determine whether server performance was positively affected by enabling caching?
A. Client connection count increases
B. Server side request rate increases
C. Client connection count decreases
D. Server side request rate decreases
Answer: D

2. Scenario: An administrator must set up a NetScaler system network with USIP mode enabled. The NetScaler must be able to preserve client IP addresses in TCP/IP packets reaching the back-end servers except for connections coming from particular IP addresses that are defined in an ACL. In the case of connections coming from the IP addresses defined in the ACL, the packets reaching the back-end servers should receive the NetScaler IP address instead of the client IP address. On which entity should RNAT be configured to meet the requirements in this scenario according to best practices?
A. ACL
B. Client
C. Virtual server
D. Back-end server
Answer: A

3. A NetScaler system is running with high CPU usage frequently.
Which log can the administrator view to determine if the high CPU is being caused by the processes running in the user space?
A. syslog
B. nswlog
C. newnslog
D. nsconmsg
Answer: C

4. Which event would trigger a failover in a high availability pair?
A. The primary appliance reboots.
B. A forced synchronization event fails.
C. A monitored interface fails on the secondary node.
D. The default gateway does not return a heartbeat packet from the primary node.
Answer: A

5. Scenario: An administrator installed a NetScaler system and configured the NSIP and MIP for the system. The NetScaler system will be used primarily for load balancing in this environment.
Which additional step must the administrator take to ensure that the NetScaler system can perform the necessary server load balancing in this environment?
A. Disable USIP mode on both nodes
B. Use the MIP as the NSIP for a high availability environment
C. Create VIPs for the front-end connections to the back-end servers
D. Enable USNIP mode for the front-end connections to the back-end servers
Answer: C

6. Scenario: An administrator is planning the necessary configurations on a NetScaler system for an environment that requires the NetScaler system to advertise virtual IP addresses, directly connected routes and static routes on the upstream routers.
What must the administrator ensure is configured on the NetScaler system for this environment?
A. Static Routes
B. Link Load Balancing
C. Route Health Injection
D. Front-end Health Check
Answer: C

7. An administrator should configure Link Aggregation on a 7000 NetScaler system when __________. (Choose the correct option to complete the sentence.)
A. redundancy on a half duplex operation is required
B. redundancy on an operation across multiple data rates is required
C. the bandwidth requirements inbound to or outbound from the Netscaler are greater than 1 Gb/sec
D. the bandwidth requirements inbound to or outbound from the Netscaler are greater than 8 Gb/sec
Answer: C

8. An administrator is configuring a compression policy and does NOT want HTTP responses to be compressed.
Which step should the administrator take to achieve this?
A. Use the appropriate default compression policy
B. Configure the compression policy for HTTP requests only
C. Remove the "Accept-Encoding" header from the HTTP responses
D. Use Re-write to remove "Accept-Encoding" header from the HTTP requests
Answer: D

9. How can an administrator configure a health check for a server receiving HTTP traffic so that it monitors the responses of the server to actual client requests as opposed to probes whenever possible?
A. Use the default TCP monitor
B. Configure an HTTP-ECV monitor
C. Configure an HTTP-Inline monitor
D. Use the TCP monitor with the transparent parameter selected
E. Configure an HTTP monitor with the transparent parameter selected
Answer: C

10. Scenario: An administrator needs to create a health check that will mark an HTTP service down if the bound monitor probe fails. The administrator wants to create a monitor and configure the health check so that a trap is sent if the monitor probe reply exceeds 20 milliseconds.
How can the administrator create the monitor for this health check using the command line interface?
A. set mon monitor-HTTP-1 HTTP -interval 20 milli
B. add lb mon monitor-HTTP-1 HTTP -interval 20 milli
C. set mon monitor-HTTP-1 HTTP -resptimeout 20 milli
D. add lb mon monitor-HTTP-1 HTTP -resptimeout 20 milli
Answer: D

11. Where in the configuration utility can an administrator configure a NetScaler high availability pair to ensure that specific interfaces are NOT monitored?
A. The root of the System node
B. The root of the Network node
C. The interface sub node in the System node
D. The interface sub node in the Network node
Answer: D

12. An administrator configured cache redirection and needs to provide a report of how that feature is functioning in the network environment.
What can the administrator use to see a graphical representation of the statistics for the vserver performing the cache redirection?
A. The monitor view for the service bound to the correct vserver
B. The chart option in the Dashboard once the correct vserver is selected
C. The chart option in the Dashboard for the service bound to the correct vserver
D. The request and response rates option in the Dashboard once te correct vserver is selected
Answer: B

13. Which SNMP trap must an administrator configure to be informed when the response time for a monitor probe that had exceeded the set threshold returns to normal?
A. entityup
B. entitydown
C. monRespTimeoutAboveThresh
D. monRespTimeoutBelowThresh
Answer: D

14. A company is planning on implementing NetScaler systems in high availability pairs.
Which entry in the NS.CONF file of the secondary system needs to be unique from those of the primary system?
A. VMAC
B. VIP address
C. MIP address
D. NSIP address
Answer: D

15. An SNMP manager attempted to poll for an OID but received the error message: "response timeout." Which option could the administrator have misconfigured for SNMPv2 to cause this error message?
A. SNMP trap
B. SNMP user
C. SNMP group
D. SNMP community
Answer: D

Free EX0-106 Demo Download

Examsoon offers free demo for EXIN Inc Certification EX0-106 exam (SCNS Tactical Perimeter Defense). You can check out the interface, question quality and usability of our practice exam before you decide to get it. We are the only one site can offer demo for almost all products.

Free Download EX0-106 PDF exam Trainning Materials

1. For the new Snort rules you are building, it will be required to have Snort examine inside the content of the packet. Which keyword is used to tell Snort to ignore a defined number of bytes before looking inside the packet for a content match?
A. Depth
B. Offset
C. Nocase
D. Flow_Control
E. Classtype
Answer: B

2. You are planning on implementing a token-based authentication system in your network. The network currently is spread out over four floors of your building. There are plans to add three branch offices. During your research you are analyzing the different types of systems. Which of the following are the two common systems token-based authentication uses?
A. Challenge/Response
B. Random-code
C. Time-based
D. Challenge/Handshake
E. Password-Synch
Answer: AC

3. At a policy meeting you have been given the task of creating the firewall policy. What are the two basic positions you can take when creating the policy?
A. To deny all traffic and permit only that which is required.
B. To permit only IP traffic and filter TCP traffic
C. To permit only TCP traffic and filter IP traffic
D. To permit all traffic and deny that which is required.
E. To include your internal IP address as blocked from incoming to prevent spoofing.
Answer: AD

4. In order to perform promiscuous mode captures using the Wireshark capture tool on a Windows Server 2003 machine, what must first be installed?
A. IPv4 stack
B. IPv6 stack
C. WinPcap
D. Nothing, it will capture by default
E. At least two network adapters
Answer: C

5. You have implemented an IPSec policy, using only AH. You are analyzing your network traffic in Network Monitor, which of the following statements are true about your network traffic?
A. You will not be able to view the data in the packets, as it is encrypted.
B. You will not be able to identify the upper layer protocol.
C. You will be able to view the unencrypted data in the packets.
D. You will be able to identify the encryption algorithm in use.
E. You will not be able to view the packet header.
Answer: C

6. There are several options available to you for your new wireless networking technologies, and you are examining how different systems function. What transmission system uses short bursts combined together as a channel?
A. Frequency Hopping Spread Spectrum (FHSS)
B. Direct Sequence Spread Spectrum (DSSS)
C. Lamar Anthell Transmission (LAT)
D. Digital Band Hopping (DBH)
E. Digital Channel Hopping (DCH)
Answer: A

7. The exhibit represents a simple routed network. Node 7 is a Windows 2000 Professional machine that establishes a TCP communication with Node 10, a Windows 2003 Server. The routers are Cisco 2500 series running IOS 12.
While working at Node 10, you run a packet capture. Packets received by Node 10, and sent from Node 7 will reveal which of the following combination of source IP and source Physical addresses:
A. Source IP address 10.0.10.115, Source Physical address for Node 7
B. Source IP address 50.0.50.1, Source Physical address for Node 7
C. Source IP address for Router D’s Int E0, Source Physical address for Node 7
D. Source IP address 10.0.10.115, Source Physical address Router D’s Int E0
E. Source IP addresses for both Nodes 7 and Router D’s Int E0, Source Physical address for both Nodes 7 and Router D’s Int E0.
Answer: D

8. If you capture an 802.11 frame, and the ToDS bit is set to zero and the FromDS bit is set to zero, what type of WLAN is this frame a part of?
A. Mesh
B. Broadcast
C. Infrastructure
D. Hierarchical
E. Ad Hoc
Answer: E

9. You have just installed a new Intrusion Detection System in your network. You are concerned that there are functions this system will not be able to perform. What is a reason an IDS cannot manage hardware failures?
A. The IDS can only manage RAID 5 failures.
B. The IDS cannot be programmed to receive SNMP alert messages.
C. The IDS cannot be programmed to receive SNMP trap messages.
D. The IDS cannot be programmed to respond to hardware failures.
E. The IDS can only inform you that an event happened.
Answer: E

10. During your review of the logs of your Cisco router, you see the following line. What is the meaning of this line?
%SYS-5-CONFIG_I: Configured from console by vty1 (172.16.10.1)
A. A normal, but noteworthy event
B. An informative message
C. A warning condition has occurred
D. A debugging message
E. An error condition has occurred
Answer: A

11. You are configuring the rules on your firewall, and need to take into consideration that some clients in the network are using automatic addressing. What is the IP address range reserved for internal use for APIPA in Microsoft networks?
A. 169.254.0.0 /4
B. 169.254.0.0 /16
C. 169.254.0.0 /8
D. 169.254.0.0 /0
E. 168.255.0.0 /16
Answer: B

12. You are introducing a co-worker to the security systems in place in your organization. During the discussion you begin talking about the network, and how it is implemented. You mention something in RFC 791, and are asked what that is. What does RFC 791 specify the standards for?
A. IP
B. TCP
C. UDP
D. ICMP
E. Ethernet
Answer: A

13. You are working on your companys IPTables Firewall; you wish to create a rule to address traffic using ports 1024 through 2048. Which of the following would you use during the creation of your rule?
A. p:1024 P:2048
B. P:1024 p2048
C. p=1024-2048
D. 1024-2048
E. 1024:2048
Answer: E

14. You are monitoring the network traffic on your Frame-Relay Internet connection. You notice a large amount of unauthorized traffic on port 21. You examine the packets, and notice there are no files being transferred. Traffic on what other port must be examined to view any file contents?
A. 20
B. 119
C. 23
D. 80
E. 2021
Answer: A

15. You have recently taken over the security of a mid-sized network. You are reviewing the current configuration of the IPTables firewall, and notice the following rule:
ipchains -A input -p TCP -d 0.0.0.0/0 12345 -j DENY
What is the function of this rule?
A. This rule for the output chain states that all incoming packets from any host to port 12345 are to be denied.
B. This rule for the input chain states that all incoming packets from any host to port 12345 are to be denied.
C. This rule for the input chain states that any TCP traffic from any address destined for any IP address and to port 12345 is to be denied.
D. This rule for the output chain states that any TCP traffic from any address destined for any IP address and to port 12345 is to be denied.
E. This rule for the input chain states that all TCP packets inbound from any network destined to any network is to be denied for ports 1, 2, 3, 4, and 5.
Answer: C

Free EX0-107 Demo Download

Examsoon offers free demo for EXIN Inc Certification EX0-107 exam (SCNP Strategic Infrastructure Security). You can check out the interface, question quality and usability of our practice exam before you decide to get it. We are the only one site can offer demo for almost all products.

Free Download EX0-107 PDF exam Trainning Materials

1. To increase the security of your network and systems, it has been decided that EFS will be implemented in the appropriate situations. Two users are working on a common file, and often email this file back and forth between each other. Is this a situation where the use of EFS will create effective security, and why (or why not)?
A. No, the security will remain the same since both users will share the same key for encryption.
B. Yes, since the file will be using two keys for encryption the security will increase.
C. No, the security will remain the same since both users will share the same key for decryption.
D. Yes, since the file will be using two keys for decryption the security will increase.
E. No, EFS cannot be used for files that are shared between users.
Answer: E

2. During a one week investigation into the security of your network you work on identifying the information that is leaked to the Internet, either directly or indirectly. One thing you decide to evaluate is the information stored in the Whois lookup of your organizational website. Of the following, what pieces of information can be identified via this method?
A. Registrar
B. Mailing Address
C. Contact Name
D. Record Update
E. Network Addresses (Private)
Answer: ABCD

3. What is a problem with symmetric key cryptography?
A. It is slower than asymmetric key cryptography
B. Secure distribution of the public key
C. There is a lack of encryption protocols that can use symmetric key cryptography
D. Secure distribution of a secret key
E. Symmetric key cryptography is reserved for the NSA
Answer: D

4. What is the name of the informational page that is relevant to a particular command in Linux?
A. Readme Page
B. Lnx_nfo Page
C. Man Page
D. X_Win Page
E. Cmd_Doc Page
Answer: C

5. You have just become the senior security professional in your office. After you have taken a complete inventory of the network and resources, you begin to work on planning for a successful security implementation in the network. You are aware of the many tools provided for securing Windows 2003 machines in your network. What is the function of Secedit.exe?
A. This tool is used to set the NTFS security permissions on objects in the domain.
B. This tool is used to create an initial security database for the domain.
C. This tool is used to analyze a large number of computers in a domain-based infrastructure.
D. This tool provides an analysis of the local system NTFS security.
E. This tool provides a single point of management where security options can be applied to a local computer or can be imported to a GPO.
Answer: C

6. To maintain the security of your network you routinely run several checks of the network and computers. Often you use the built-in tools, such as netstat. If you run the following command: netstat -e
which of the following will be the result?
A. Displays all connections and listening ports
B. Displays Ethernet statistics
C. Displays addresses and port numbers in numerical form
D. Shows connections for the protocol specified
E. Displays per-protocol statistics
Answer: B

7. In the process of public key cryptography, which of the following is true?
A. Only the public key is used to encrypt and decrypt
B. Only the private key can encrypt and only the public key can decrypt
C. Only the public key can encrypt and only the private key can decrypt
D. The private key is used to encrypt and decrypt
E. If the public key encrypts, then only the private key can decrypt
Answer: E

8. You are aware of the significance and security risk that Social Engineering plays on your company. Of the following Scenarios, select those that, just as described, represent potentially dangerous Social Engineering:
A. A writer from a local college newspapers calls and speaks to a network administrator. On the call the writer requests an interview about the current trends in technology and offers to invite the administrator to speak at a seminar.
B. An anonymous caller calls and wishes to speak with the receptionist. On the call the caller asks the receptionist the normal business hours that the organization is open to the public.
C. An anonymous caller calls and wishes to speak with the purchaser of IT hardware and software. On the call the caller lists several new products that the purchaser may be interested in evaluating. The caller asks for a time to come and visit to demonstrate the new products.
D. An email, sent by the Vice President of Sales and Marketing, is received by the Help Desk asking to reset the password of the VP of Sales and Marketing.
E. An email is received by the Chief Security Officer (CSO) about a possible upgrade coming from the ISP to a different brand of router. The CSO is asked for the current network’s configuration data and the emailer discusses the method, plan, and expected dates for the rollover to the new equipment.
Answer: DE

9. In order for your newly written security policy to have any weight, it must be implemented. Which of the following are the three components of a successful Security Policy Implementation in an organization?
A. Policy Monitoring
B. Policy Design
C. Policy Committee
D. Policy Enforcement
E. Policy Documentation
Answer: ABD

10. Recently, you have seen an increase in intrusion attempts and in network traffic. You decide to use Snort to run a packet capture and analyze the traffic that is present. Looking at the example, what type of traffic did Snort capture in this log file?
A. Windows 2000 Ping Request
B. Windows NT 4.0 Ping Request
C. Linux Ping Request
D. Linux Ping Response
E. Windows NT 4.0 Ping Response
Answer: B

11. What type of cipher is used by an algorithm that encrypts data one bit at a time?
A. 64-bit encryption Cipher
B. Block Cipher
C. Stream Cipher
D. Diffuse Cipher
E. Split Cipher
Answer: C

12. You have become the lead security professional for a mid-sized organization. You are currently studying DNS issues, and configuration options. You come across the concepts of DNS Spoofing, and investigate more. What is DNS Spoofing?
A. DNS Spoofing is when the DNS client submits a false DNS request to the DNS server, and the DNS server responds with correct data.
B. DNS Spoofing is the DNS client submits a DNS request to the DNS server using a bogus IP address, and the DNS server responds to the incorrect host.
C. DNS Spoofing is when a DNS Server responds to an unauthorized DNS client, providing that client with name resolution.
D. DNS Spoofing is when a DNS client is forced to make a DNS query to an imposter DNS server, which send the client to an imposter resource.
E. DNS spoofing is when a DNS server provides name resolution to clients that are located in a different IP subnet than the server itself.
Answer: D

13. Attackers have the ability to use programs that are able to reveal local passwords by placing some kind of a pointer/cursor over the asterisks in a program’s password field. The reason that such tools can uncover passwords in some Operating Systems is because:
A. the passwords are simply masked with asterisks
B. the etc/passwd file is on a FAT32 partition
C. the passwords are decrypted on screen
D. the password text is stored in ASCII format
E. the etc/passwd file is on a FAT16 partition
Answer: A

14. As per the guidelines in the ISO Security Policy standard, what is the purpose of the section on Physical and Environmental Security?
A. The objectives of this section are to avoid breaches of any criminal or civil law, statutory, regulatory or contractual obligations and of any security requirements, and to ensure compliance of systems with organizational security policies and standards.
B. The objectives of this section are to prevent unauthorized access, damage and interference to business premises and information; to prevent loss, damage or compromise of assets and interruption to business activities; to prevent compromise or theft of information and information processing facilities.
C. The objectives of this section are to provide management direction and support for information security.
D. The objectives of this section are to maintain appropriate protection of corporate assets and to ensure that information assets receive an appropriate level of protection.
E. The objectives of this section are to control access to information, to prevent unauthorized access to information systems, to ensure the protection of networked services, and to prevent unauthorized computer access.
Answer: B

15. During the review of the security logs you notice some unusual traffic. It seems that a user has connected to your Web site ten times in the last week, and each time has visited every single page on the site. You are concerned this may be leading up to some sort of attack. What is this user most likely getting ready to do?
A. Mirror the entire web site.
B. Download entire DNS entries.
C. Scan all ports on a web server.
D. Perform a Distributed Denial of Service attack through the Web server.
E. Allow users to log on to the Internet without an ISP.
Answer: A

Free 74-924 Demo Download

Examsoon offers free demo for Microsoft Partner Competency 74-924 exam (MS Office Communication Server 2007-U.C Voice Specialization). You can check out the interface, question quality and usability of our practice exam before you decide to get it. We are the only one site can offer demo for almost all products.

Free Download 74-924 PDF exam Trainning Materials

1. You are an IT professional who are specialized in Microsoft Office Communications Server 2007. Now you are employed in an international company which is named Wiikigo. You are in charge of providing technical support to your company.
You perform the deployment of Microsoft Office Communicator 2007 Phone Edition devices. Overlapping fixed digit normalization rules are used by the devices. You are testing the devices and find that when in the off-hook mode, the devices dial a number before it is completely entered. You have to enable three-digit fixed-digit dialing when the devices are in off-hook mode.
So what action should you perform?
A. Use the no-quick-dial feature of Enterprise Voice Route Helper to configure the dial plan.
B. Client-side normalization should be enabled in Enterprise Voice Route Helper.
C. The "t" prefix value after the "+" sign should be used in the normalization rule.
D. The following normalization rule should be used during the testing phase. ^(d{1,1})$ Pre Pend +1$1
Answer: A

2. You are an IT professional who are specialized in Microsoft Office Communications Server 2007. Now you are employed in an international company which is named Wiikigo. You are in charge of providing technical support to your company.
You are planning to deploy a Microsoft Office Communications Server (OCS) 2007 network. Installation of 500 Microsoft Office Communicator phones in Huston is included in the deployment plan.
According to the company requirement, you have to make sure that the OCS 2007 deployment meets the following requirements:
Users must be able to use the Session Initiation Protocol (SIP) addresses and a five-digit dialing feature to make Office Communicator calls to each other.
Users must be able to make Public switched telephone network (PSTN) calls to the Office Communicator phones.
So what should you do? (Choose more than one)
A. A normalization rule in the Huston location profile should be configured to translate the five-digit dialing into a full E.164 number for the Office Communicator users.
B. A Mediation Server in Huston should be installed and configured.
C. All the Office Communicator users should be configured with a SIP URI and a full E.164 number.
D. A Phone Usage record should be configured for Huston, and it should be assigned to the Office Communicator users.
E. A Route should be configured to the Huston Mediation Server, and the Target Regular Expression should be configured to support the five-digit dialing feature.
Answer: A, B, C

3. You are an IT professional who are specialized in Microsoft Office Communications Server 2007. Now you are employed in an international company which is named Wiikigo. You are in charge of providing technical support to your company.
Microsoft Office Communications Server (OCS) 2007 has been installed in your company. The Enterprise Voice feature is enabled for all users. Now you receive a user report saying that she cannot receive calls from coworkers that are hosted on the PBX. The User Options exhibit below shows the configuration of the User Options setting for the user. You have to make sure that the user is able to receive calls from Microsoft Office Communicator 2007 client applications and the PSTN.
So what action should you perform to make sure of this???
A. The Policy option of the user should be changed from Company External to Company Internal.
B. The Enable Remote call control option should be chosen.
C. Enter a value in the Line URI text box that complies with the RFC 3966 format and includes a country code.
D. The Enable PBX integration check box should be chosen, and then specify a server URI that points to the PBX.
Answer: C

4. You are an IT professional who are specialized in Microsoft Office Communications Server 2007. Now you are employed in an international company which is named Wiikigo. You are in charge of providing technical support to your company.
Your company has offices in Boston and Paris. These offices are connected by an IP WAN configured for full duplex. You deploy a Microsoft Office Communications Server (OCS) 2007 Standard Edition front-end server in the Boston office. Microsoft Office Communicator 2007 users place voice calls between the two offices through the WAN. You find that most of the IP WAN bandwidth is utilized by data traffic. Only 440 Kbps of bandwidth is available for voice calls. You have to calculate the number of concurrent voice calls that will be supported between the two offices, including Ethernet and SRTP overhead per call.
How many calls should the current configuration support?
A. A total of seven calls will be supported in either direction by using Wideband codec.
B. A maximum of three calls will be supported in any one direction at any one time by using Wideband codec.
C. A total of eight calls will be supported by using Siren.
D. A total of six calls will be supported in either direction by using G.711.
Answer: B

5. You are an IT professional who are specialized in Microsoft Office Communications Server 2007. Now you are employed in an international company which is named Wiikigo. You are in charge of providing technical support to your company.
You have a Microsoft Office Communications Server (OCS) 2007 network deployed in your company.
You configure the OCS 2007 network to meet the following requirements:
All conferencing coordinators must be allowed to invite internal and federated users to the conferences.
Only the conferencing coordinator named Hao Chen is able to invite anonymous users to the conferences.
The Default policy settings exhibit shows the conferencing policy settings for the default policy.
The Policy settings for Hao Chen exhibit bellow shows the conferencing policy settings for Hao Chen.
The Global policy settings exhibit below shows the global conferencing policy settings for the OCS 2007 network.
You check and find that Hao Chen is not able to invite anonymous users to the conferences.
You have to make sure that Hao Chen is able to invite anonymous users without impacting the settings of the other conference coordinators.
So what should you do to make sure of this?(Choose more than one)??
A. A new conferencing policy named Anonymous should be created and it should be assigned to Hao Chen. Web conferencing should be enabled, and then the value of the Select settings for non-Active Directory users option should be set to Allow control of shared programs and desktop.
B. The global policy setting for the Anonymous participants option should be set to Enforce per user.
C. The Allow anonymous participants setting should be enabled for the user account of Hao Chen.
D. Hao Chen should be instructed to enable the Open Authenticated access setting when the conference is set up.
E. The global policy setting for the Anonymous participants option should be set to Allow users to invite anonymous participants.
F. The default conferencing policy should be modified, and then the value of the Select settings for non-Active Directory users option should be set to Allow control of shared programs and desktop.
Answer: B, C

6. You are an IT professional who are specialized in Microsoft Office Communications Server 2007. Now you are employed in an international company which is named Wiikigo. You are in charge of providing technical support to your company. Your company has had a Microsoft Office Communications Server (OCS) 2007 network deployed. For public switched telephone network (PSTN) connectivity, hybrid gateways are implemented.
Users use Microsoft Office Communicator 2007 phones to make calls to customers on PSTN. You get report from users saying that their confidential phone conversations are being recorded and stored on the network. You have not implemented a tool or a method that records the conversation. You need to find out how the conversations are being recorded.
So what action should you perform to achieve this???
A. Collect information about calls made or received by using QoE. Then, check whether the data is tampered with by using the archiving and CDR reporter on the information.
B. Trace the conversations by using the Network Monitor tool.
C. Capture all types of audio streams by using the Network Monitor tool and check the RTP header for the authentication tag used for encryption.
D. DVT should be used along with Organizer and Agents. Then, an agent should be installed on the Office Communicator client computer and the Agent should be configured to send a test call to the Organizer. Collect the packet information and analyze the data streams in the Network Monitor tool.
Answer: C

7. You are an IT professional who are specialized in Microsoft Office ommunications Server 2007. Now you are employed in an international company which is named Wiikigo. You are in charge of providing technical support to your company.
You have Microsoft Office Communication Server (OCS) 2007 and Microsoft Office Commmunicator 2007 client installed on your company network. You set up a Windows SharePoint Services 3.0 server and configure the Windows Server 2003 Certificate Authority for autoenrollment. Besides, you have Office Communicator Phone Edition phones installed and block UDP ports between 100 and 200 on your firewall that are outbound to the Internet.
You find that the Office Communicator Phone Edition phones do not register to OCS 2007 server. These phones do not have correct IP addresses and do not display the correct date and time.
You have to make sure that the following business requirements are met:
The network must have full Exchange Server 2007 functionality.
The phones must be connected to a separate virtual LAN (VLAN) along with all required servers that serve the physical phones.
So what should you do to make sure of this? (Choose more than one)
A. DNS for a SIP domain and an SMTP domain should be configured. DHCP scopes and scope options should be configured for the Office Communicator Phone Edition phones and the SharePoint Server. DNS SRV records should be configured for the SharePoint Server.
B. An internal NTP time source should be configured. A DNS SRV record should be configured to point to the internal NTP time source.
C. DNS for a SIP domain only should be configured. DHCP scopes and scope options should be configured for the Office Communicator Phone Edition phones.
D. DNS for an SMTP domain only should be configured. DHCP scopes and scope options should be configured for the Office Communicator Phone Edition phones.
E. DNS for a SIP domain and an SMTP domain should be configured. DHCP scopes and scope options should be configured for the Office Communicator Phone Edition phones.
Answer: B, E

8. You are an IT professional who are specialized in Microsoft Office Communications Server 200 Now you are employed in an international company which is named Wiikigo. You are in charge of providing technical support to your company.
You are testing the implementation of Microsoft Office Communications Server (OCS) 2007 Phone Edition devices at a site. The OCS 2007 network design exhibit below shows the OCS 2007 network design for the site. You receive report from users of the devices in the wiikigo.com domain. They tell you that they are not able to view their Microsoft Outlook 2000 contacts when logging on to the OCS 2007 network. You have to make sure that users in the wiikigo.com domain are able to use the OCS 2007 Phone Edition devices to make direct calls.
What action should you perform to make sure of this? ( Choose more than one)
A. Use the following http prefix to access these URLs from Microsoft Internet Explorer 7.0: https:/wiikigo.com/autodiscover/autodiscover.xmlhttps://autodiscover.wiikigo.com/autodiscover/autodiscover.xml. Confirm whether you receive a 600 Invalid request XML response from either request type.
B. In order to make sure of this, you have to verify the validity of the external certificate on the Exchange Server 2007 Client Access server.
C. In order to make sure of this, you have to verify that the correct Active Directory Service Connection Points (SCP) and DNS SRV records exist.
D. In order to make sure of this, you have to run exchucutil.ps1 on the Microsoft Exchange Server 2007 Unified Messaging servers and ocsumutil.exe on the OCS 2007 Enterprise Edition servers.
E. In order to make sure of this, you have to verify that DNS A records for wiikigo.com and autodiscover.wiikigo.com exist and that they point to the Exchange Server 2007 Client Access servers.
F. In order to make sure of this, you have to verify that DNS A records for wiikigo.com and autodiscover.wiikigo.com exist and that they point to the Exchange Server 2007 Unified Messaging servers.
Answer: A, B, E

Free 9L0-007 Demo Download

Examsoon offers free demo for Others 9L0-007 exam (Macintosh Service Certification Exam ). You can check out the interface, question quality and usability of our practice exam before you decide to get it. We are the only one site can offer demo for almost all products.

Free Download 9L0-007 PDF exam Trainning Materials

1. You are about to replace a MacBook Air logic board. Which of the following is the most important step you should take immediately after removing the bottom case?
A. Remove the thermal module.
B. Disconnect the main battery.
C. Remove the hard drive.
D. Remove the processor.
Answer: B

2. To ensure proper fan and temperature control in the Power Mac G5, you must run the thermal calibration routine found on the ______ disc whenever you replace a processor or logic board with a new processor or logic board.
A. Apple Service Diagnostic
B. Apple Hardware Test
C. Fan Control Installer
D. Mac OS X Installer
Answer: A

3. Which of the following most accurately describes what happens during Safe Sleep activation in Mac portables?
A. The contents of RAM are written to NVRAM before sleep.
B. The contents of the hard disk are encrypted before sleep.
C. The contents of RAM are written to hard disk before sleep.
D. The contents of the hard disk are read into RAM before sleep.
Answer: C

4. The LED on a MacBook MagSafe power adapter doesn’t illuminate at all when it’s plugged into the MacBook and you know the adapter is connected to a known good power source. What is most likely the cause of this symptom?
A. The MacBook has a faulty main battery.
B. The MagSafe adapter needs to be reset first.
C. The MacBook requires an SMC firmware update.
D. A MagSafe adapter connector pin is stuck down.
Answer: D

5. What does Apple recommend you do before replacing or installing any internal parts in an Xserve?
A. Remove all drive modules from the Xserve.
B. Remove the Xserve from its rack.
C. Press the System Identifier button.
D. Unlock all drive module bays.
Answer: B

6. You require additional information about a specific problem with a customer’s Mac. Which one of the following resources is the Apple-recommended choice for researching the problem?
A. Downloads
B. Discussions
C. User’s manual
D. Knowledge Base
Answer: D

7. A MacBook sometimes becomes unresponsive and the cursor freezes on the display when running an application. You have verified the symptom, and have already attempted to force the application to quit, but the computer remains unresponsive. What should you try next?
A. Disconnect all power sources for several minutes to reset the SMC.
B. Hold the eject button down for several seconds to reset the application.
C. Hold the trackpad button down for several seconds to regain cursor control.
D. Press the power button for several seconds to try shutting the computer down.
Answer: D

8. What precautions should be taken if a discharged CRT must remain exposed for any length of time?
A. You should reset the Power Manager Unit on the logic board.
B. You should perform a full set of video adjustments on the CRT.
C. You should remove the CRT from the computer or display assembly.
D. You should establish an ongoing lead between the CRT anode and ground.
Answer: D

9. A MacBook Pro powers on with no image on the built-in display. You connect an external display and restart the MacBook Pro, yet you still see no image on either display. Which of the following is most likely the cause of this symptom?
A. Dead battery
B. Not enough RAM
C. Faulty optical drive
D. RAM not completely seated
Answer: D

10. You are troubleshooting an eMac that has no image on its built-in display. You have already checked user controls and reset PRAM, but the issue persists. When you connect an external display to the eMac’s VGA output port and restart the eMac, you see a proper image on the external display. Which of the following service modules would most likely be the cause of these symptoms?
A. Display Analog Assembly
B. Power Supply Assembly
C. Logic Board
D. Hard drive
Answer: A

Free 70-442GB2312 Demo Download

Examsoon offers free demo for Microsoft Licensing 70-442GB2312 exam (PRO:Design & Optimize Data Access by Using MS SQL Serv 2005). You can check out the interface, question quality and usability of our practice exam before you decide to get it. We are the only one site can offer demo for almost all products.

Free Download 70-442GB2312 PDF exam Trainning Materials

1. 您是公司的数据库开发人员。您负责在公司新的 SQL Server 2005 计算机上将名为 DB1 和 DB2 的两个现有 SQL Server 2000 数据库合并为一个名为 NewDB 的数据库。
以下查询在用于访问 DB1 数据库的旧应用程序中可以正常工作。
SELECT * FROM Customer WHERE FaxNumber = NULL
但是，该查询在新的 SQL Server 2005 计算机上运行时将不会返回任何行，即使 FaxNumber 列中存在 NULL 值。
您需要解决该问题，以使该查询在 SQL Server 2005 计算机上能正常工作。您需要确保您的解决方案不会影响 DB2 中表和查询的行为。
您应该怎么办？
A. 使用 ISNULL 函数，而不是 = NULL。
B. 将 = NULL 更改为 IS NULL。
C. 将 = NULL 更改为 = ‘NULL’。
D. 在查询前面添加以下命令：SET ANSI_NULLS ON
E. 使用 ALTER DATABASE 命令将 ANSI_NULLS 数据库选项更改为 ON。
Answer: B

2. 您是公司的数据库开发人员。用户需要有关在 TotalDue 列中具有最高值的订单的信息。用户希望能够在每次请求信息时返回不同的记录百分比。
您需要在 SQL Server 2005 上生成代码，该代码将允许前端应用程序传递最终用户将为要返回的记录百分比提供的变量。
您应该如何编写代码？
A. CREATE PROCEDURE TopPercentTotalDue
@P int
AS
SELECT TOP(@P) PERCENT
TotalDue, OrderDate
FROM Purchasing.PurchaseOrderHeader
ORDER BY TotalDue DESC
B. CREATE PROCEDURE TopPercentTotalDue
@P int
AS
SELECT TOP(@P) PERCENT
TotalDue, OrderDate
FROM Purchasing.PurchaseOrderHeader
ORDER BY TotalDue ASC
C. CREATE PROCEDURE TopPercentTotalDue
@R int
AS
SET rowcount @R
SELECT TotalDue, OrderDate
FROM Purchasing.PurchaseOrderHeader
ORDER BY TotalDue DESC
D. CREATE PROCEDURE TopPercentTotalDue
@R int
AS
SET rowcount @R
SELECT TotalDue, OrderDate
FROM Purchasing.PurchaseOrderHeader
ORDER BY TotalDue ASC
Answer: A

3. 您是公司的数据库开发人员。您正在创建一个参数化存储过程，该存储过程将查询数据并返回一些行，其中包含作为该存储过程输入提供的动词的任何动词时态。查询还应返回同时包含名词的单数和复数形式的行。数据包括在若干 varchar(max) 和 varbinary(max) 列中。
您需要创建存储过程来满足这些要求。
您应该执行哪两项操作？（每个正确答案都仅给出了部分解决方案。请选择两个答案。）
A. 使用 LIKE 运算符。
B. 使用 CONTAINS 谓词。
C. 针对适当的一个或多个列创建全文索引。
D. 针对适当的一个或多个列创建非聚集索引。
Answer: BC

4. 您是公司的数据库开发人员。公司最近升级到了 SQL Server 2005。
您正在创建一个查询，以便返回显示指定员工组所下达采购订单总数的信息，按请求订单的供应商分组。
结果集应在其单独一列中显示每位员工的采购订单总数。每个供应商在结果集中都应有自己的行。
您需要创建查询来满足这些要求。
您应该使用哪个 Transact-SQL 命令？
A. CROSS APPLY
B. UNION
C. PIVOT
D. INTERSECT
Answer: C

5. 您是公司的数据库开发人员。有一个将订单项保存到 OrderItems 表的过程。如果该项不存在，则应执行插入。如果该项存在，则应执行更新。OrderItems 表设计为如下所示。
OrderID (PK, FK)
ProductID (PK, FK)
Quantity
int
int
int
您需要开发一个使用最少量资源的例程。
您应该使用哪个例程？
A. BEGIN TRY
UPDATE OrderItems SET Quantity = @Quantity
WHERE OrderID = @OrderID
AND ProductID = @ProductID;
END TRY
BEGIN CATCH
INSERT OrderItems (OrderID, ProductID, Quantity)
VALUES (@OrderID, @ProductID, @Quantity);
END CATCH
B. IF EXISTS (SELECT * FROM OrderItems
WHERE OrderID = @OrderID
AND ProductID = @ProductID
)
UPDATE OrderItems SET Quantity = @Quantity
WHERE OrderID = @OrderID
AND ProductID = @ProductID;
ELSE
INSERT OrderItems (OrderID, ProductID, Quantity)
VALUES (@OrderID, @ProductID, @Quantity);
C. IF NOT EXISTS (SELECT * FROM OrderItems
WHERE OrderID = @OrderID
AND ProductID = @ProductID
)
INSERT OrderItems (OrderID, ProductID, Quantity)
VALUES (@OrderID, @ProductID, @Quantity);
ELSE
UPDATE OrderItems SET Quantity = @Quantity
WHERE OrderID = @OrderID
AND ProductID = @ProductID;
D. UPDATE OrderItems SET Quantity = @Quantity
WHERE OrderID = @OrderID AND ProductID = @ProductID;
IF(@@ROWCOUNT = 0)
INSERT OrderItems (OrderID, ProductID, Quantity)
VALUES (@OrderID, @ProductID, @Quantity);
Answer: D

6. 您是公司的数据库开发人员。现必须优化 Stockholm 市订单的处理例程，以获得更好的性能。
当前例程如以下代码段所示。
…
DECLARE OrderCursor CURSOR FOR
SELECT OrderID, City, CustomerID FROM Orders;
OPEN OrderCursor;
FETCH NEXT FROM OrderCursor INTO @OrderID, @CustomerID, @City;
WHILE(@@FETCH_STATUS = 0)
BEGIN
IF(@City <> ‘Stockholm’)
GOTO Next;
<Code for processing order>
Next:
FETCH NEXT FROM OrderCursor INTO
@OrderID, @CustomerID, @City;
END
…
您需要优化该例程以获得最佳性能。
您应该怎么办？
A. 将游标更改为以 DYNAMIC 形式声明。
B. 将游标更改为以 KEYSET 形式声明。
C. 将游标更改为以 STATIC 形式声明。
D. 更改游标中的 SELECT 语句以包括 WHERE City = ‘Stockholm’。
E. 将 IF 语句更改为检查 @City = ‘Stockholm’，从而避免使用 GOTO 语句。
Answer: D

7. 您是公司的数据库开发人员。在您的数据库中，Employees 表包含大约 1,000 行，Orders 表包含数百万行。
Employees 表设计为如下所示。
EmployeeID (PK)
Firstname
Lastname
…
int
nvarchar(30)
nvarchar(30)
…
Orders 表设计为如下所示。
OrderID (PK)
SoldByEmployeeID (FK)
OrderDate
…
int
int
datetime
…
您需要编写一个查询，该查询返回每位员工所下的订单数。
您应该使用哪个查询？
A. SELECT e.Firstname, e.Lastname, COUNT(*)
FROM Employees AS e
LEFT OUTER JOIN Orders AS o
ON o.SoldByEmployeeID = e.EmployeeID
GROUP BY e.Firstname, e.Lastname
B. SELECT e.Firstname, e.Lastname, COUNT(*)
FROM Employees AS e
LEFT OUTER JOIN Orders AS o
ON o.SoldByEmployeeID = e.EmployeeID
GROUP BY e.EmployeeID, e.Firstname, e.Lastname
C. SELECT e.Firstname, e.Lastname, COUNT(o.OrderID)
FROM Employees AS e
LEFT OUTER JOIN Orders AS o
ON o.SoldByEmployeeID = e.EmployeeID
GROUP BY e.EmployeeID, e.Firstname, e.Lastname
D. SELECT e.Firstname, e.Lastname, COUNT(o.OrderID)
FROM Employees AS e
LEFT OUTER JOIN Orders AS o
ON o.SoldByEmployeeID = e.EmployeeID
GROUP BY e.Firstname, e.Lastname
Answer: C

8. 您是公司的数据库开发人员。每天将以 XML 文档的形式发送 Parts 数据库的信息，并将该信息放在 ProductXML 表的 ProductInfo 列中的单一行中。该 XML 文档中的信息的示例如下所示。
<Products>
<Product ID="…" Name="…" Number="…"/>
<Product ID="…" Name="…" Number="…"/>
…
</Products>
每天结束时将运行一个批处理作业。这个批处理作业将 XML 文档从 ProductXML 表导入 Product 表。将为每个 Product 元素从 XML 文档中提取产品的 ID、名称和编号，并将这些信息插入 Product 表的 ProductID、Name、和 Number 列中。在批处理结束时会截断 ProductXML 表。
您需要设计从 ProductXML 表中检索行以插入 Product 表的查询。
您应该使用哪个 Transact-SQL 查询从 ProductXML 表中查询数据？
A. SELECT
ProductInfo.value(’(/Products/Product)[1]/@ID’, ‘integer’)
AS ProductID,
ProductInfo.value(’(/Products/Product)[1]/@Name’, ‘varchar(50)’)
AS Name,
ProductInfo.value(’(/Products/Product)[1]/@Number’, ‘varchar(25)’)
AS ProductNumber
FROM ProductXML
B. SELECT
col.value(’@ID’, ‘integer’) AS ProductID,
col.value(’@Name’, ‘varchar(50)’) AS Name,
col.value(’@Number’, ‘varchar(25)’) AS ProductNumber
FROM ProductXML
CROSS APPLY ProductInfo.nodes(’/Products/Product’) AS x (col)
C. SELECT
col.query(’data(@ID), data(@Name), data(@Number)’)
FROM ProductXML
CROSS APPLY ProductInfo.nodes(’/Products/Product’) AS x (col)
D. SELECT
ProductInfo.query(’
for $p in /Products/Product
return fn:concat($p/@ID, $p/@Name, $p/@Number)
‘) AS Result
FROM ProductXML
Answer: B

9. 您是公司的数据库开发人员。一个名为 Articles 的表包含报纸文章，其设计如下所示。
ArticleID (PK)
Title
ArticleXml
CategoryID (FK)
int
nvarchar(50)
xml
int
ArticleXml 列中的 XML 文档如下所示。
<article>
<paragraph>…</paragraph>
<image>…</image>
…
<image>…</image>
…
</article>您需要设计一个查询，该查询将按照 CategoryID 值显示图像的总数。
您应该使用哪个查询？
A. SELECT
CategoryID
,COUNT(ArticleXml.value(’count(/article/image)’,
‘INT’)) AS NumberOfImages
FROM Articles
GROUP BY CategoryID;
B. SELECT
CategoryID
,COUNT(ArticleXml.exist(’/article/image’)
AS NumberOfImages
FROM Articles
GROUP BY CategoryID;
C. SELECT
CategoryID
,SUM(ArticleXml.value(’count(/article/image)’, ‘INT’))
AS NumberOfImages
FROM Articles
GROUP BY CategoryID;
D. SELECT
CategoryID
,SUM(ArticleXml.exist(’/article/image’)
AS NumberOfImages
FROM Articles
GROUP BY CategoryID;
Answer: C

10. 您是公司的数据库开发人员。公司正在从 SQL Server 2000 升级到 SQL Server 2005。公司新的编码标准要求符合 ANSI 标准。
您的经理要求您将以下查询转换为使用 ANSI 标准措词。
SELECT E.EmployeeID, E.Hiredate, J.Resume
FROM HumanResources.Employee AS E,
HumanResources.JobCandidate AS J
WHERE E.EmployeeID *= J.EmployeeID
新查询必须始终生成与现有查询相同的结果集。
您需要编写查询以满足这些要求。
您应该使用哪个 Transact-SQL 查询？
A. SELECT E.EmployeeID, E.Hiredate, J.Resume
FROM HumanResources.Employee AS E RIGHT OUTER JOIN
HumanResources.JobCandidate AS J
ON E.EmployeeID = J.EmployeeID
B. SELECT E.EmployeeID, E.Hiredate, J.Resume
FROM HumanResources.Employee AS E LEFT OUTER JOIN
HumanResources.JobCandidate AS J
ON E.EmployeeID = J.EmployeeID
C. SELECT E.EmployeeID, E.Hiredate, J.Resume
FROM HumanResources.Employee AS E INNER JOIN
HumanResources.JobCandidate AS J
ON E.EmployeeID = J.EmployeeID
D. SELECT E.EmployeeID, E.Hiredate, J.Resume
FROM HumanResources.Employee AS E FULL OUTER JOIN
HumanResources.JobCandidate AS J
ON E.EmployeeID = J.EmployeeID
Answer: B

Free 70-680 Demo Download

Examsoon offers free demo for MCTS 70-680 exam (TS:Windows 7,Configuring). You can check out the interface, question quality and usability of our practice exam before you decide to get it. We are the only one site can offer demo for almost all products.

Free Download 70-680 PDF exam Trainning Materials

1. You have a computer that runs Windows 7. The computer has two volumes named volume C and volume D.
You create a document on volume D.
You manually create a restore point and modify the document.
You view the properties of the document as shown in the exhibit. (Click the Exhibit button.)
You need to ensure that you can restore the current version of the document if the document is modified.
What should you do first?
A. Run Disk Cleanup on volume D.
B. Enable auditing on the document.
C. Turn on System Protection for volume D.
D. Start the Volume Shadow Copy Service (VSS).
Answer: C

2. You have a computer that runs Windows 7. You perform regular data backups and system image backups.
The computer experiences a hard disk failure. You replace the failed hard disk.
You need to recover the computer to the previous Windows 7 environment.
You start the computer from the Windows 7 installation media.
Which recover option should you select?
A. Command Prompt
B. Startup Repair
C. System Image Recovery
D. System Restore
Answer: C

3. You have a computer that runs Windows 7.
You discover that an application named App1 runs during the startup process.
You need to prevent only App1 from running during startup. Users must be allowed to run App1 manually.
What should you do?
A. From the local Group Policy, modify the application control policy.
B. From the local Group Policy, modify the software restriction policy.
C. From the System Configuration tool, select Diagnostic Startup.
D. From the System Configuration tool, modify the Startup applications.
Answer: D

4. You have a computer that runs Windows 7.
You need to identify which applications were installed during the last week.
What should you do?
A. From Reliability Monitor, review the informational events.
B. From System Information, review the Software Environment.
C. From Performance Monitor, review the System Diagnostics Report.
D. From Performance Monitor, run the System Performance Data Collector Set.
Answer: A

5. You have a computer that runs Windows 7. The computer has System Protection enabled.
You need to retain only the last System Protection snapshot of the computer. All other snapshots must be deleted.
What should you do?
A. Run Disk Cleanup for Programs and features.
B. Run Disk Cleanup for System Restore and Shadow Copies.
C. From the System Protection Restore settings, select Turn off System Restore.
D. From the System Protection Restore settings, select Only restore previous versions of files.
Answer: B

6. A remote user has a computer that runs Windows 7.
The user reports that he receives several error messages while using an application.
You do not have remote access to the user’s computer.
You need to tell the user how to create screenshots of the actions he performs on the computer. The solution must track the mouse actions that the user performs.
What should you instruct the user to do?
A. Press ALT+PrintScreen.
B. Run Psr.exe and then click Start Record.
C. From Mouse Properties, select Display pointer trails.
D. Run Snippingtool.exe, click New, and then click Window Snip.
Answer: B

7. Your network consists of one Active Directory domain. You have two computers named Computer1 and Computer2 that run Windows 7. Both computers are members of the domain.
From Computer1, you can recover all Encrypting File System (EFS) encrypted files for users in the domain.
You need to ensure that you can recover all EFS encrypted files from Computer2.
What should you do?
A. On Computer1, back up %systemroot%DigitalLocker. On Computer2, restore %systemroot%DigitalLocker.
B. On Computer1, export the data recovery agent certificate. On Computer2, import the data recovery agent certificate.
C. On Computer1, run Secedit.exe and specify the /export parameter. On Computer2, run Secedit.exe and specify the /import parameter.
D. On Computer1, run Cipher.exe and specify the /removeuser parameter. On Computer2, run Cipher.exe and specify the /adduser parameter.
Answer: B

8. You have a computer that runs Windows
You perform an image backup.
A virus infects the computer and causes the computer to become unresponsive.
You need to restore the computer as quickly as possible.
What should you do?
A. Start the computer by using the Last Known Good Configuration feature.
B. Start the computer from the Windows 7 DVD and then use the Startup Repair tool.
C. Start the computer from the Windows 7 DVD and then use the System Image Recovery tool.
D. Start the computer from Windows Preinstallation Environment (Windows PE) and then run Imagex.exe.
Answer: C

9. You have a computer that runs Windows 7.
You run the Configure Backup wizard as shown in the exhibit. (Click the Exhibit button.)
You need to ensure that you can back up the computer to a local disk drive.
What should you do before you run the Configure Backup wizard?
A. Connect a removable disk.
B. Log on as an administrator.
C. Start the Volume Shadow Copy Service (VSS).
D. Add your user account to the Backup Operators group.
Answer: A

10. You need to increase the size of a paging file.
What should you do?
A. From Disk Management, shrink the boot partition.
B. From Disk Management, shrink the system partition.
C. From System, modify the Advanced system settings.
D. From System, modify the System protection settings.
Answer: C

Free 70-526VB Demo Download

Examsoon offers free demo for MCTS 70-526VB exam (Microsoft .NET Framework 2.0 – Windows-based Client Development is in development). You can check out the interface, question quality and usability of our practice exam before you decide to get it. We are the only one site can offer demo for almost all products.

Free Download 70-526VB PDF exam Trainning Materials

1. You are creating a Windows Form. You add a TableLayoutPanel control named pnlLayout to the form. You set the properties of pnlLayout so that it will resize with the form.
You need to create a three-column layout that has fixed left and right columns. The fixed columns must each remain 50 pixels wide when the form is resized. The middle column must fill the remainder of the form width when the form is resized. You add the three columns in the designer.
Which code segment should you use to format the columns at run time?
A. pnlLayout.ColumnStyles.Clear()
pnlLayout.ColumnStyles.Add(New ColumnStyle(SizeType.Absolute, 50.0F))
pnlLayout.ColumnStyles.Add(New ColumnStyle(SizeType.AutoSize, 100.0F))
pnlLayout.ColumnStyles.Add(New ColumnStyle(SizeType.Absolute, 50.0F))
B. pnlLayout.ColumnStyles(0).Width = 50.0F
pnlLayout.ColumnStyles(0).SizeType = SizeType.Absolute
pnlLayout.ColumnStyles(2).Width = 50.0F
pnlLayout.ColumnStyles(2).SizeType = SizeType.Absolute
C. pnlLayout.ColumnStyles(0).Width = 50.0F
pnlLayout.ColumnStyles(0).SizeType = SizeType.Absolute
pnlLayout.ColumnStyles(1).Width = 100.0F
pnlLayout.ColumnStyles(1).SizeType = SizeType.AutoSize
pnlLayout.ColumnStyles(2).Width = 50.0F
pnlLayout.ColumnStyles(2).SizeType = SizeType.Absolute
D. pnlLayout.ColumnStyles.Clear()
pnlLayout.ColumnStyles.Add(New ColumnStyle(SizeType.Absolute, 50.0F))
pnlLayout.ColumnStyles.Add(New ColumnStyle(SizeType.Percent, 100.0F))
pnlLayout.ColumnStyles.Add(New ColumnStyle(SizeType.Absolute, 50.0F))
Answer: D

2. You are creating a Windows Forms application. Initialization code loads a DataSet object named ds that includes a table named Users. The Users table includes a column named IsManager.
You need to bind the IsManager column to the Checked property of a check box named chkIsManager.
Which code segment should you use?
A. chkIsManager.DataBindings.Add("Checked", ds, "Users.IsManager")
B. chkIsManager.DataBindings.Add("Checked", ds, "IsManager")
C. chkIsManager.Text = "{Users.IsManager}"
chkIsManager.AutoCheck = True
D. Me.DataBindings.Add("chkIsManager.Checked", ds, "Users.IsManager")
Answer: A

3. You are creating a Windows Forms application that includes the database helper methods UpdateOrder and UpdateAccount. Each method wraps code that connects to a Microsoft SQL Server 2005 database, executes a Transact-SQL statement, and then disconnects from the database.
You must ensure that changes to the database that result from the UpdateAccount method are committed only if the UpdateOrder method succeeds.
You need to execute the UpdateAccount method and the UpdateOrder method.
Which code segment should you use?
A. Using ts As New TransactionScope()
UpdateOrder()
UpdateAccount()
ts.Complete()
End Using
B. Using ts1 As New TransactionScope()
UpdateOrder()
Using ts2 As New
TransactionScope(TransactionScopeOption.RequiresNew)
UpdateAccount()
ts2.Complete()
End Using
ts1.Complete()
End Using
ts1.Complete();
C. Using ts1 As New TransactionScope()
UpdateOrder()
Using ts2 As New
TransactionScope(TransactionScopeOption.RequiresNew)
UpdateAccount()
ts2.Complete()
End Using
ts1.Complete()
End Using
D. Using ts As New TransactionScope(TransactionScopeOption.RequiresNew)
UpdateOrder()
End Using
Using ts As New TransactionScope(TransactionScopeOption.Required)
UpdateAccount()
ts.Complete()
End Using
Answer: A

4. You are creating a Windows Forms application. You add an ErrorProvider component named erpErrors and a DateTimePicker control named dtpStartDate to the application. The application also contains other controls.
You need to configure the application to display an error notification icon next to dtpStartDate when the user enters a date that is greater than today’s date.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
A. For the Validating event of dtpStartDate, create an event handler named VerifyStartDate.
B. For the Validated event of dtpStartDate, create an event handler named VerifyStartDate.
C. In the Properties Window for dtpStartDate, set the value of Error on erpErrors to Date out of range.
D. In VerifyStartDate, call erpErrors.SetError(dtpStartDate, "Date out of range") if the value of dtpStartDate.Value is greater than today’s date.
E. In VerifyStartDate, call erpErrors.SetError(dtpStartDate, null) if the dtpStartDate.Value is greater than today’s date.
Answer: AD

5. You are creating a Windows Form that includes a TextBox control named txtDate.
When a user right-clicks within the text box, you want the application to display a MonthCalendar control.
You need to implement a context menu that provides this functionality.
What should you do?
A. Add the following code to the form initialization.
Dim cal As New MonthCalendar()
Dim mnuContext As New ContextMenuStrip()
Dim host As New ToolStripControlHost(mnuContext)
txtDate.ContextMenuStrip = mnuContext
B. Add the following code to the form initialization.
Dim mnuContext As New ContextMenuStrip()
Dim cal As New MonthCalendar()
Dim host As New ToolStripControlHost(cal)
mnuContext.Items.Add(host)
txtDate.ContextMenuStrip = mnuContext
C. Add the following code to the form initialization.
Dim ctr As New ToolStripContainer()
Dim cal As New MonthCalendar()
ctr.ContentPanel.Controls.Add(cal)
txtDate.Controls.Add(ctr)
Add a MouseClick event handler for the TextBox control that contains the following code.
If e.Button = MouseButtons.Right Then
txtDate.Controls(0).Show()
End If
D. Add a MouseClick event handler for the TextBox control that contains the following code.
If e.Button = MouseButtons.Right Then
Dim mnuContext As New ContextMenuStrip()
Dim cal As New MonthCalendar()
Dim host As New ToolStripControlHost(cal)
mnuContext.Items.Add(host)
txtDate.ContextMenuStrip = mnuContext
End If
Answer: B

6. You are customizing a Windows Form. The form includes a menu that has several ToolStripMenuItem controls. An event handler is configured to handle the Click event for all ToolStripMenuItem controls. The event handler has the following signature.
Private Sub mnu_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs)
The form class includes a method that has the following signature.
Private Sub LogClick(ByVal ctlName As String)
You need to add code so that when a user clicks a ToolStripMenuItem control, the mnu_Click method calls the LogClick method. The LogClick method must be called with the ctlName parameter set to the menu text in the ToolStripMenuItem control.
Which code segment should you use?
A. Dim mnuItem As ToolStripMenuItem = CType(sender, ToolStripMenuItem)
LogClick(mnuItem.Text)
B. LogClick(e.ToString())
C. LogClick(Me.Text)
D. Dim mnuItem As ToolStripMenuItem =
CType(Me.GetContainerControl(), ToolStripMenuItem)
LogClick(mnuItem.Text)
Answer: A

7. You are creating a Windows Forms application. The application uses a SqlCommand object named cmd. The cmd object executes the following stored procedure.
CREATE PROCEDURE GetPhoneList
AS
BEGIN
SELECT CompanyName, Phone FROM Customers
SELECT CompanyName, Phone FROM Suppliers
END
You need to add all returned rows to the ListBox control named lstPhones.
Which code segment should you use?
A. Dim rdr As SqlDataReader = cmd.ExecuteReader()
Do
While rdr.Read()
lstPhones.Items.Add((rdr.GetString(0) + ControlChars.Tab +
rdr.GetString(1)))
End While
Loop While rdr.NextResult()
B. Dim rdr As SqlDataReader = cmd.ExecuteReader()
While rdr.Read()
lstPhones.Items.Add((rdr.GetString(0) + ControlChars.Tab +
rdr.GetString(1)))
End While
C. Dim rdr As SqlDataReader = cmd.ExecuteReader()
While rdr.NextResult()
While rdr.Read()
lstPhones.Items.Add((rdr.GetString(0) + ControlChars.Tab +
rdr.GetString(1)))
End While
End While
D. Dim rdr As SqlDataReader = cmd.ExecuteReader()
While rdr.NextResult()
lstPhones.Items.Add((rdr.GetString(0) + ControlChars.Tab +
rdr.GetString(1)))
End While
Answer: A

8. You are creating a Windows Forms application. The application loads a data table named dt from a database and modifies each value in the data table.
You add the following code. (Line numbers are included for reference only.)
01 Dim row As DataRow
02 For Each row In dt.Rows
03 Dim col As DataColumn
04 For Each col In dt.Columns
05
06 Trace.WriteLine(str)
07 Next col
08 Next row
You need to format the string named str to show the value of the column at the time the data is loaded and the current value in the column.
Which code segment should you add at line 05?
A. Dim str As String = String.Format("Column was {0} is now {1}",
row(col), row(col, DataRowVersion.Current))
B. Dim str As String = String.Format("Column was {0} is now {1}",
row(col, DataRowVersion.Default), row(col))
C. Dim str As String = String.Format("Column was {0} is now {1}",
row(col), row(col, DataRowVersion.Proposed))
D. Dim str As String = String.Format("Column was {0} is now {1}",
row(col, DataRowVersion.Original), row(col))
Answer: D

9. You are customizing a Windows Form. When the user clicks any button, you want the application to log information about the user’s actions by calling a method with the following signature.
Public Sub ctl_Click(ByVal sender As Object,
ByVal e As EventArgs)
You want the form to invoke this method when any Button control is clicked and only when a Button control is clicked.
You need to modify the form to invoke this method without interfering with the existing operations of the application.
What should you do?
A. Add the following code to the form initialization.
Dim ctl As Control
For Each ctl In Me.Controls
If TypeOf ctl Is Button Then
AddHandler ctl.Click, AddressOf ctl_Click
End If
Next ctl
B. Add the following code to the form initialization.
AddHandler Me.Click, AddressOf ctl_Click
C. Use the Properties dialog box to set the Click event for each Button control on the form to the ctl_Click method.
D. Use the Properties dialog box to set the Click event of the form to the ctl_Click method.
Answer: A

10. A method in your Windows Forms application executes a stored procedure in a Microsoft SQL Server 2005 database, and then executes a second stored procedure in a second SQL Server 2005 database.
You need to ensure that the call to the first stored procedure writes changes only if the call to the second stored procedure succeeds. Installation requirements prohibit you from introducing new components that use the COM+ hosting model.
What should you do?
A. Implement a transactional serviced component.
Add methods to this component to encapsulate the connect operation and execution of each stored procedure.
Register and use this serviced component.
B. Add a TransactionScope block.
Connect to each database and execute each stored procedure within the TransactionScope block.
Call the TransactionScope.Complete method if the call to both stored procedure succeeds.
C. Connect to both databases.
Call the SqlConnection.BeginTransaction method for each connection.
Call the SqlTransaction.Commit method on both returned transactions only if both stored procedures succeed.
D. Add a Try…Catch…Finally block.
Connect to each database and execute each stored procedure in the try block.
Answer: B

Free 70-441GB2312 Demo Download

Examsoon offers free demo for MCITP 70-441GB2312 exam (Designing Database Solutions by Using MS SQL Serv 2005). You can check out the interface, question quality and usability of our practice exam before you decide to get it. We are the only one site can offer demo for almost all products.

Free Download 70-441GB2312 PDF exam Trainning Materials

1. 您正在为支持 APP1 的数据库设计性能监视计划。
您只需要监视所需的指示器。
基线中应该包括哪个或哪些指示器？（请选择所有正确答案。）
A. 常用查询的响应时间
B. 数据库备份和恢复的完成时间
C. 磁盘 I/O
D. CPU 使用率
E. 网络数据包大小
F. 失败的 SOAP 请求
HTTP 身份验证请求
Answer: ACD

2. 您需要设计一个报表，提供所选商店的合并库存信息。此报表必须设计为仅显示用户所选商店的综合库存数据。解决方案必须尽可能少地占用额外网络资源。
您应该怎么办？
A. 使用 SQL Server Integration Services (SSIS) 将所有服务器中的所有库存数据复制到一个临时表中。设计一个报表，使用此临时表作为其数据源，并滤除未选商店的数据。
B. 实现复制，使每个服务器都包括所有其他服务器中的库存数据。 设计报表以使用与运行此报表的用户在相同位置的服务器。
C. 创建一个参数化存储过程，查询所需库存数据并以单一结果集形式返回结果。设计报表以将此存储过程用作报表数据源。
D. 在每个服务器上，创建一个显示该服务器的库存数据的视图。设计一个报表，此报表使用每个服务器中的视图作为其数据源并将过滤掉未选定的商店所提供的数据。
Answer: C

3. 您将要升级公司所有应用程序所使用的数据库服务器。作为升级过程中的第一步，您将升级开发数据库服务器。
您需要验证数据库服务器升级未将任何错误引入到数据库中。
您应该怎么办？
A. 在每个数据库中对每个存储过程执行单元测试脚本。
B. 在 SQL Server Management Studio 调试程序中执行存储过程，并验证结果。
C. 将数据库服务器的数据库兼容级别设置为 80。
D. 执行应用程序用户界面测试脚本以验证应用程序可以正常运行。
Answer: A

4. 您需要设计一个解决方案，以将旧系统中与天气相关的数据导入到新天气数据库表中。
您应该怎么办？
A. 编写一个 SQL Server Integration Services (SSIS) 包以导入数据。
B. 编写一个 Windows 窗体应用程序以导入数据。
C. 使用 bcp 实用程序导入数据。
D. 编写一个托管程序集以导入数据。
E. 编写一个使用链接服务器从 ODBC 数据库中查询数据的视图。
Answer: A

5. 您需要确保商店经理接收低库存电子邮件。您的解决方案必须将 SQL Server 计算机上的额外处理负荷降到最低。
您应该怎么办？
A. 编写一个在产品出现低库存情况时向商店经理发送电子邮件的 Notification Services 事件。
B. 编写一个列出所有低库存产品的 SSRS 报表，并确保通过电子邮件将此报表发送给每位商店经理。
C. 编写一个通过电子邮件将低库存消息发送给商店经理的 SQL Server 代理作业。
D. 编写一个每当更新库存时运行的触发器。规划此触发器以使用 sp_OA 系列的存储过程启动一个通过电子邮件将低库存消息发送给商店经理的 COM 对象。
Answer: A

6. 您需要设计一个解决方案，以便在 SQL Server 数据库服务器上控制对数据库对象所做的更改。您的解决方案必须符合现有的公司政策和程序。
您应该怎么办？
A. 要求开发人员签入对源代码管理数据库所做的所有代码更改。
B. 创建一个有权更改数据库对象的数据库用户帐户。
C. 向一个开发人员授予更改数据库对象的权限并在服务器上对这些更改启用日志记录。
D. 禁止在服务器之间复制数据库对象。
Answer: B

7. 您需要控制无意中对生产数据库服务器上的数据库对象所做的更改。
您应该怎么办？
A. 创建 DDL 触发器以回滚对数据库对象所做的更改。在维护活动过程中禁用 DDL 触发器。
B. 在数据库中废除所有 CREATE、ALTER 和 DROP 权限。
C. 在源代码管理工具中维护所有源代码。
D. 在单个文本文件中对所有数据库对象编写脚本。
Answer: A

8. 您需要确保随时可以查看导出到分发服务器中的 XML 数据的准确性。您的解决方案必须创建最少量的附加数据。
您应该怎么办？
A. 创建一个生成 XML 数据的存储过程，并在需要查看 XML 数据时重新运行此存储过程。
B. 创建一个生成 XML 数据的 SQL Server Integration Services (SSIS) 包，并在需要查看 XML 数据时重新运行此包。
C. 在新存档表内的 XML 列中存储所生成的 XML 数据。
D. 每次生成 XML 数据时创建完整数据库的副本。
Answer: C

9. 要提高性能，您需要重新设计可提供对聚合数据的访问权限的 StoreReports 视图。
您应该怎么办？
A. 使用一种支持 .NET Framework 的语言将此视图重写为存储过程。
B. 使用 Transact-SQL 将此视图重写为存储过程。
C. 向此视图添加索引。
D. 向构成此视图的基础表添加索引。
Answer: D

10. 您需要设计一个解决方案，以便在新商店开张时将数据库部署到新商店中。在您的解决方案中，使数据库可在生产环境中使用所需执行的步骤的数目必须最小。
您应该怎么办？
A. 从现有服务器中将数据库架构和所有查询数据复制到新服务器中。
B. 在现有服务器上分离此数据库，将数据库文件复制到新服务器中，并在新服务器上附加副本。在现有服务器上重新附加数据库。
C. 使用 SQL Server Integration Services (SSIS) 从现有服务器中将整个数据库复制到新服务器中。
D. 在现有服务器上备份数据库，并将备份恢复到新服务器中。
Answer: A

11. 您需要确保发送到分发服务器的导出 XML 数据中不包括库存低于指定阈值的产品。您的解决方案必须要求对任何现有数据库对象所做的更改数最少。
您应该怎么办？
A. 编写一个既接受所有库存更改又会在产品库存低于指定阈值时从数据库中删除产品的存储过程。
B. 在库存表上编写一个只要进行库存更改就会更新排除位列的触发器。
C. 编写一个基于当前库存更新排除位列的 SQL Server 代理作业。
D. 编写一个更新库存表和排除位列的用户定义函数，并确保所有更新库存的数据库对象都使用此新函数。
Answer: B

12. 您需要确保所有输入的订单都具有完整、一致和准确的信息。
您应该怎么办？
A. 编写一个参数化存储过程。
修改所有负责输入订单的应用程序或对象，使其在输入后续订单时，采用这个新的存储过程。
B. 编写一个将订单直接输入到相应表中的 COM 对象。
修改所有负责输入订单的应用程序或对象，使其在输入后续订单时，采用这个新的 COM 对象。
C. 编写一个将订单直接输入到相应表中的托管程序集。修改所有负责输入订单的应用程序或对象，使其在输入后续订单时，采用这个新的程序集。
D. 修改对包含订单信息的表的权限，以便最终用户无法直接访问这些表。
Answer: A

13. 您需要确保在向报表提供数据时使用正确的业务逻辑，以便报表包含正确的数据。
您应该怎么办？
A. 编写一个 Windows 应用程序，此应用程序将查询相应数据并建立一个包含此数据的新表。规划 SSRS 以使用新表作为数据源。
B. 使用 SQL Server Integration Services (SSIS) 将生产表复制到相同服务器上的报告表中。规划 SSRS 以便获取报告表中的数据。
C. 规划 SSRS 以使用相应的 Transact-SQL 查询获取数据。
D. 编写一个或多个返回数据的参数化存储过程。规划 SSRS 以使用存储过程和正确的参数查询报表数据。
Answer: D

14. 您需要为 APP2 设计一个数据库对象，返回人口统计数据。
您应该执行哪两项操作？（每个正确答案都仅给出了部分解决方案。请选择两个答案。）
A. 创建一个名为 Age 的计算列，此计算列是根据参与调查者出生日期和调查日期计算的。
B. 创建一个包含名为 Age 的计算列的视图，此计算列是根据参与调查者出生日期和调查日期计算的。
C. 创建一个用户定义函数，返回参与调查者在调查之日的年龄。
D. 创建一个参数化存储过程，返回参与调查者在调查之日的年龄。
E. 针对 Age 列创建索引。
Answer: AE

15. 您需要确保将所有新输入的订单传送到运货系统。
您应该怎么办？
A. 编写一个接受所有订单并将这些订单直接插入到相应的数据库表和运货系统中的 COM 对象。
B. 创建一个用于输入所有订单的 CLR 存储过程。编写存储过程以使用 COM 对象将数据输入到运货系统中。
C. 创建一个 SQL Server Integration Services (SSIS) 包以将所有订单导出到可由运货系统读取的 CSV 文件中。计划每小时运行一次此包。
D. 在 Order 表上编写一个将订单数据插入到运货系统中的触发器。
Answer: B

Free 70-444GB2312 Demo Download

Examsoon offers free demo for MCITP 70-444GB2312 exam (Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005). You can check out the interface, question quality and usability of our practice exam before you decide to get it. We are the only one site can offer demo for almost all products.

Free Download 70-444GB2312 PDF exam Trainning Materials

1. 您是一台名为 SQL1 的 SQL Server 2005 计算机的管理员。SQL1 最近已从两个处理器升级到八个处理器。下表概述了此 SQL1 配置。
您需要优化 SQL1 以便运行时间较长的查询可以运行并行计划。
您应该怎么办？
A. 将最大并行度更改为 1。
B. 将并行的开销阈值更改为 0。
C. 将关联掩码更改为 0。
D. 将"AWE Enabled"设置更改为 0。
Answer: C

2. 您是公司的数据库管理员。您使用 SP:Recompile 事件类运行 SQL 事件探查器。您发现存在大量重新编译的内容。
您需要找出存在大量重新编译内容的可能的原因。
哪一项最可能是该问题的原因？
A. 未从过程缓存中检索特殊批。
B. 未从过程缓存中检索 sp_executesql 批。
C. 数据库管理员在最常见存储过程所引用的所有表上执行了 UPDATE STATISTICS 语句。
D. 数据库管理员创建了一个新的存储过程。
Answer: C

3. 您是一台 SQL Server 2005 计算机的管理员。一段时间过后，服务器性能下降严重。您计划对索引环境进行故障排除。
您进行以下操作：重建使用最频繁的群集索引；优化最常访问的非群集索引；访问 sys.dm_db_index_usage_stats 动态管理视图 (DMV)。结果如下表所示。
您需要确定在未读取整个索引时，使用最频繁的非群集索引。
您应该使用 object_id 与 index_id 的哪种组合？
A. 使用 object_id 869578136 和 index_id 1。
B. 使用 object_id 309576141 和 index_id 1。
C. 使用 object_id 2066106401 和 index_id 1。
D. 使用 object_id 2066106401 和 index_id 2。
E. 使用 object_id 869578136 和 index_id 5。
Answer: E

4. 您是公司的数据库管理员。SQL 2005 Server 计算机已经运行了多月。这一周，由于出现查询性能问题，因此您开始调查锁定操作资源争用情况。sys.dm_os_wait_stats 动态管理视图 (DMV) 显示 max_wait_time_ms 列中的一个高值。
您需要查明此值是否是引起当前性能问题的一个因素。您还必须将对数据库用户的影响降到最低。
您应该怎么办？
A. 在动态管理视图 (DMV) 中重置统计信息。
B. 执行 UPDATE STATISTICS 命令。
C. 重新启动 SQL Server 服务。
D. 重新启动 SQL Server 计算机。
Answer: A

5. 您是一台名为 SQL1 的 SQL Server 2005 计算机的管理员。SQL1 上的所有数据库都已经创建在一个 RAID 10 卷上，且启用了自动文件增长属性。SQL1 上的所有事务日志都已经创建在另一个 RAID 10 卷上，且没有启用自动文件增长属性。
您需要确保在数据库即将耗尽磁盘空间时，能够获得通知。同时还需要防止因任何事务日志空间不足而产生错误。
您应该执行哪两项操作？（每个正确答案都仅给出了部分解决方案。请选择两个答案。）
A. 在 SQLServer:SQL Errors:Errors/sec 计数器上创建性能警报。
让警报在出现问题时通知您。
B. 在 SQLServer:Databases:Data File(s) Size (KB) 计数器上创建性能警报。
让警报在出现问题时通知您。
C. 在 LogicalDisk:% Free Space 计数器上创建性能警报。
让警报在出现问题时通知您。
D. 针对每个事务日志，在 SQLServer:Databases:PercentLogUsed 计数器上创建一条 SQL Server 性能条件警报。
定义响应，并通知您此问题。
E. 针对每个数据库，在 SQLServer:Databases:Data File(s) Size (KB) 计数器上创建一条 SQL Server 性能条件警报。
定义响应，将现有数据文件的大小增加 100 MB，并通知您此问题。
F. 针对每个数据库，在 SQLServer:Databases:Log Growths 计数器上创建一条 SQL Server 性能条件警报。
定义响应，自动备份事务日志，并通知您此问题。
Answer: DC

6. 您是您公司的数据库管理员。公司使用的数据库包含一个名为 Sales 的表。Sales 表的 CREATE 语句如相关材料所示。（单击"相关材料"按钮。）
此 Sales 表是频繁发生写操作的表，并且经常用于查询。在重建的前两个小时中，Sales 表上的两个索引变成碎片。叶级别页面和中级页面被频繁分割。有足够的磁盘空间可用于全面优化索引。
您需要在 Sales 表的 Sales_Amount 列上优化非聚集索引。
您应该执行哪两项操作？（每个正确答案都仅给出了部分解决方案。请选择两个答案。）
A. 重建索引时将 FILLFACTOR 选项设置为 70。
B. 重建索引时将 FILLFACTOR 选项设置为 100。
C. 重建索引时将 PAD_INDEX 选项设置为 OFF。
D. 重建索引时将 PAD_INDEX 选项设置为 ON。
Answer: AD

7. 您是公司的数据库管理员。公司使用的 SQL Server 2005 数据库包含一个名为 Production.Product 的表。表中有 40 多列。以下 Transact-SQL 语句显示了最常用的查询。
–QUERY 1
SELECT [Name], [ProductLine], [ListPrice], [Class], [Style]
FROM [Production].[Product]
WHERE [ProductLine] = ‘T’
–QUERY 2
SELECT * FROM [Production].[Product]
ORDER BY [Name]
您需要选择最佳索引以便支持对 Production.Product 表的最常用查询，同时使索引所需的空间降到最小。
您应该使用哪两个索引？（每个正确答案都仅给出了部分解决方案。请选择两个答案。）
A. 在 Name 列上创建聚集索引。
B. 在 Name 列上创建非聚集索引。
C. 在 ProductLine 列上创建非聚集索引并添加 ListPrice、Class 和 Style 列。
D. 在 ProductLine、ListPrice、Class 和 Style 列上创建聚集索引。
E. 在 ProductLine 和 ListPrice 列上创建非聚集索引。
Answer: CA

8. 您是一台名为 SQL1 的 SQL Server 2005 计算机的管理员。用户经常报告说他们收到了一些错误消息，这些消息称事务日志已满。当他们收到此消息时，其数据更改失败。您发现 SQL1 上的磁盘空间有限。
您需要将 SQL1 配置为自动防止因事务日志已满而导致用户数据更改失败。
您应该怎么办？
A. 针对 LOG_FILE_AUTO_GROW 事件在服务器级别配置事件通知。将 Service Broker 配置为自动向数据库管理员通知事件。
B. 针对 LOG_FILE_AUTO_GROW 事件在数据库级别配置事件通知。将 Service Broker 配置为自动向数据库管理员通知事件。
C. 将所有事务日志的最大大小增加一倍。将事务日志设置为自动增长 30%。
D. 创建 SQL Server 性能条件警报以便运行一项作业，此作业将备份事务日志并在事务日志超过计数器时使用数据库邮件向数据库管理员发送电子邮件。
Answer: D

9. 您是您公司的数据库管理员。您的 SQL Server 2005 计算机中只有一个处理器。您运行系统监视器并发现总的处理器使用率平均为 95%。
您需要使用系统监视器找出此问题是由哪个应用程序或服务引起的。
您应该怎么办？
A. 为 Processor:% Processor Time 添加 _total 实例。
B. 为 Processor:% Privileged Time 添加 _total 实例。
C. 为 Processor:% Privileged Time 添加每个实例。
D. 为 Process:% Processor Time 添加 _total 实例。
E. 为 Process:% Processor Time 添加每个实例。
Answer: E

10. 您是一台名为 SQL1 的 SQL Server 2005 计算机的数据库管理员。下面的查询运行频率很高。
SELECT E.EmployeeID, C.FirstName + ‘ ‘ + C.LastName AS FullName
, E.Title, E.VacationHours, E.SickLeaveHours, A.AddressLine1, A.AddressLine2, A.City, A.PostalCode, S.[Name] AS State
FROM HumanResources.Employee AS E
INNER JOIN HumanResources.EmployeeAddress AS EA
ON E.EmployeeID = EA.EmployeeID
INNER JOIN Person.Address AS A
ON A.AddressID = EA.AddressID
INNER JOIN Person.Contact AS C
ON C.ContactID = E.ContactID
INNER JOIN Person.StateProvince AS S
ON S.StateProvinceID = A.StateProvinceID
ORDER BY C.LastName
此查询中引用的所有表均频繁发生读取操作，但很少发生插入和更新操作。您无法更改数据库中的现有对象。您可以向数据库添加新对象。
您需要优化查询性能。
您应该怎么办？
A. 创建一个包含查询中用到的所有列的视图。
B. 创建一个包含查询中用到的所有列的分区表。
C. 创建一个包含查询中用到的所有列的索引视图。
D. 将 FILLFACTOR 选项设置为 50，以此更改当前索引。
Answer: C

11. 您是公司的数据库管理员。您收到警报，其中报告说 SQL Server 2005 数据库上的一些事务因死锁错误而终止。
您需要找出导致死锁的原因。
您应该怎么办？
A. 使用系统监视器跟踪 SQL Locks 对象中的 Number of Deadlocks/sec 计数器的应用程序实例。
B. 使用 sys.dm_tran_locks 动态管理视图 (DMV)。
C. 运行数据库引擎优化顾问 (DTA) 并实施建议。
D. 运行 SQL 事件探查器并创建一个包含死锁图形事件组的跟踪，然后提取死锁事件。
Answer: D

12. 您是您公司的数据库管理员。您管理名为 Sales 的 SQL Server 2005 数据库。为您提供了一个 SQL 事件探查器示例工作负荷，您要在普通的一天中查询 Sales 数据库。
您需要评估当前索引的有效性并确定合适的更改。
您首先应该怎么做？
A. 对示例工作负荷使用索引优化向导。
B. 使用 SQL 事件探查器运行示例工作负荷。
C. 用最常用的五个存储过程创建一个查询。然后单击"在数据库引擎优化顾问中分析查询"按钮。
D. 对示例工作负荷使用数据库引擎优化顾问 (DTA)。
Answer: D

13. 您是您公司的数据库管理员。您创建了新的存储过程。您运行此存储过程并发现一个错误。
您想要收集并处理运行此过程时生成的任何错误信息。错误日志记录必须使用最少量的资源，同时提供所需的功能。
您需要知道引起此错误的原因。您还需要在此新存储过程中添加合适的错误函数。
您应该怎么办？
A. 使用 @@error 函数。
B. 使用 TRY…CATCH 块。
C. 将 XACT_ABORT 命令设置为 OFF。
D. 使用 GOTO 语句。
Answer: B

14. 您是一台名为 SQL1 的 SQL Server 2005 计算机的数据库管理员。用户报告说，已经过了很长时间，自己的查询仍在运行。
您访问了 sys.dm_tran_locks 动态管理视图 (DMV)。相关结果如下表所示。
您需要查找连接受阻的用户的用户名。
以下哪两种方法可达到此目的？（每个正确答案都代表一个完整的解决方案，请选择两个答案。）
A. 执行 sp_who ‘55′。
B. 执行 sp_who ‘56′。
C. 在 Microsoft SQL Management Studio 中使用活动监视器并找到 process 55。
D. 在 Microsoft SQL Management Studio 中使用活动监视器并找到 process 56。
E. 从 sys.syslockinfo 兼容性视图中进行选择并找到 spid 55。
F. 从 sys.syslockinfo 兼容性视图中进行选择并找到 spid 56。
Answer: BD

15. 您是公司的数据库管理员。您发现以下 Transact-SQL 查询的执行速度非常缓慢。
SELECT VideoTitle, UpcNum, RetailPrice, ReleaseDate
FROM Srvideo.VideoTitle WITH (INDEX(0))
WHERE ReleaseDate BETWEEN ‘20050401′ AND ‘20050510′
在 VideoTitle 列上存在一个聚集索引。在 ReleaseDate 列（包括 UpcNum 和 RetailPrice 列）上存在一个非聚集索引。查询 sys.dm_db_index_physical_stats 动态管理函数 (DMF) 或 VideoTitle 表时，avg_fragmentation_in_percent 为 10%。
慢速查询的执行计划图解如相关材料所示。（单击"相关材料"按钮。）
您需要确保快速执行查询。
您应该怎么办？
A. 只在 ReleaseDate 列上重新创建索引。
B. 从查询中删除查询提示。
C. 更改查询提示以强制优化器执行聚集索引查找或执行扫描。
D. 在 VideoTitle 表上重建所有索引。
Answer: B

Free 310-810 Demo Download

Examsoon offers free demo for SUN Other Certifications 310-810 exam (Sun Certified MySQL 5.0 Database Administrator Part 1 ). You can check out the interface, question quality and usability of our practice exam before you decide to get it. We are the only one site can offer demo for almost all products.

Free Download 310-810 PDF exam Trainning Materials

1. Which of the following best describes how MySQL utilizes the grant table buffers?
A. The grant table buffer loads grant table information into memory for fast access.
B. The grant table buffer loads what users are currently logged in and performing queries.
C. The grant table buffer holds requests waiting to check the grant table to perform access-control.
Answer: A

2. MySQL is a multi-threaded database server. Every connection to the database server is handled by it’s own thread.
A. True
B. False
Answer: A

3. Which of the following is true for the command-line programs mysqlcheck and myisamchk?
A. mysqlcheck must run on the server to perform checks and repairs and myisamchk can perform checks and repairs on a remote server.
B. mysqlcheck can perform checks and repairs on a remote server, and myisamchk must run on the server.
C. Both mysqlcheck and myisamchk can perform checks and repairs on a remote server.
D. Neither mysqlcheck or myisamchk can perform checks and repairs on a remote server.
Answer: B

4. Which one of the following statements can be used to start MySQL 5.0 manually from the command line on windows?
A. C:> C:Program FilesMySQLMySQL Server 5.0binmysqladmin -u root start
B. C:> C:Program FilesMySQLMySQL Server 5.0binmysqld
C. C:> C:Program FilesMySQLMySQL Server 5.0binmysql_start
Answer: B

5. Which of the following statements correctly describes the way to enable and use shared memory connections to the MySQL database server?
A. Shared memory connections are available by default on all platforms, but must have TCP/IP networking disabled by using the –skip-networking option.
B. Shared memory connections are supported on all windows binaries, and is enabled by default.
C. Shared memory connections are supported on all windows binaries, and must be enabled by using the –shared-memory command line option.
D. Shared memory is not a supported communication method for the MySQL database server.
Answer: C

6. Which of the following is true for how the InnoDB storage engine uses diskspace?
A. It stores its data, index and undo information all in its own tablespace.
B. It stores its data in .MYD files, in the respective database directory, and its index and undo information in its own tablespace.
C. It stores its data and index in .MYD and .MYI files, in the respective database directory, and undo information in its own tablespace.
D. It stores its data, index and undo information in .MYD and .MYI files, in the respective database directory.
Answer: A

7. Which of the following APIs/connectors are included in a MySQL distribution?
A. Connector/J
B. Connector/ODBC
C. C API
D. Connector/NET
E. Connector/MJX
Answer: C

8. Which of the following best describes the processing model for how the MySQL server handles queries?
A. The server uses a one-tier processing model in which each storage engine optimizes and processes each query issued against it.
B. The server uses a two-tier processing model: a SQL/optimizer tier and a storage engine tier.
C. The server uses a three-tier processing model: a SQL/optimizer tier, a formatting tier and a storage engine tier.
Answer: B

9. Another user has issued LOCK TABLES pets READ You can…
A. Update table pets
B. SELECT from table pets
C. UPDATE and SELECT from table pets
D. None of the above
Answer: B

10. mysqldump can be instructed to dump…
A. Only table structures
B. Only data
C. Both table structures and data
Answer: C

11. Of the following mechanisms available to connect a MySQL client to a MySQL database server, which types of connections are only available on Windows based systems?
A. TCP/IP
B. Sockets
C. Shared Memory
D. Named Pipes
Answer: CD

12. When making connections to a MySQL server on a Unix platform, which of the following is true?
A. TCP/IP connections are faster than socket file connections.
B. Socket file connections are faster than TCP/IP connections.
C. TCP/IP and Socket file connections are equally as fast.
Answer: B

13. Which of the following is true of a MySQL client and server?
A. They must be run on the same type of Operating System.
B. They must be run on the same hardware architecture.
C. They do not have to be run on the same type of Operating System.
D. They do not have to be run on the same hardware architecture.
Answer: CD

14. Which of the following statements are true for locks established by the InnoDB storage engine?
A. It sometimes escalates locks to page level.
B. It sometimes escalates locks to table level.
C. It sometimes escalates locks to page or table level.
D. It never escalates locks to page or table level.
Answer: D

15. Which mysqld command line option disables incoming TCP/IP connections?
A. –shared-memory
B. –memlock
C. –no-networking
D. –skip-networking
Answer: D

Free 310-811 Demo Download

Examsoon offers free demo for SUN Other Certifications 310-811 exam (Sun Certified MySQL 5.0 Database Administrator Part II). You can check out the interface, question quality and usability of our practice exam before you decide to get it. We are the only one site can offer demo for almost all products.

Free Download 310-811 PDF exam Trainning Materials

1. Which of the following best describes how the relay log works?
A. It records the times when the slave connects to the master.
B. When a slave receives a change from the master, it is recorded in the relay log first and processed later.
C. When a slave receives a change from the master, it is processed first and then recorded in the relay log.
Answer: B

2. Which of the following statements about the slow query log is true?
A. The slow query log will always contain just slow queries.
B. The slow query log may not always contain just slow queries.
C. The slow query log always logs more than just slow queries.
Answer: B

3. Which of the following best describes why InnoDB tables should always have primary keys and why they should be short?
A. Because InnoDB uses primary keys to locate tables, and shorter keys make quicker lookups.
B. Because InnoDB uses primary keys to locate table rows, and shorter keys make quicker lookups.
C. Because InnoDB stores pointers in a log to all the primary keys and shorter keys make this log smaller.
Answer: B

4. Consider the following:
mysql> EXPLAIN SELECT Name FROM Country WHERE Code = ‘CAN’G
*************************** 1. row ***************************
id: 1
select_type: SIMPLE
table: Country
type: const
possible_keys: PRIMARY
key: PRIMARY
key_len: 3
ref: const
rows: 1
Extra:
Which of the following best describes the meaning of the value of the type column?
A. The table has exactly one row.
B. Several rows may be read from the table.
C. Only one row of all its rows need to be read.
Answer: C

5. Given the following MyISAM table structure:
mysql> desc city;
+————-+———-+——+—–+———+—————-+
| Field | Type | Null | Key | Default | Extra |
+————-+———-+——+—–+———+—————-+
| ID | int(11) | | PRI | NULL | auto_increment |
| Name | char(35) | | | | |
| CountryCode | char(3) | | | | |
| District | char(20) | | | | |
| Population | int(11) | | MUL | 0 | |
+————-+———-+——+—–+———+—————-+
and the following SQL statement:
SELECT Population
FROM city
WHERE Population = 10000
ORDER BY Population
LIMIT 5;
which of the following statements best describes how MySQL optimizer executes the query?
A. The optimizer uses the primary key column ID to read the index values, then uses the index on Population to filter the results. The optimizer will always choose to use a unique index first, then use a secondary index if available.
B. The optimizer uses the index on the Population column to search and filter the WHERE clause. A temporary table is used to perform a filesort on the results, and then only 5 records are returned to the client.
C. The optimizer uses the index on the Population column to search, filter and sort the Population column, then returns 5 records to the client. The optimizer does not need to read the data rows, and can return values from the index only, because the index contains just integer values that form a leftmost prefix for the key.
D. The optimizer uses the index on the Population column to search, filter and sort the Population column, and returns 5 records to the client. The optimizer does not need to read the data rows, and can return values from the index only because only those columns where specified in the SELECT statement.
E. The optimizer will never read data from disk, since MySQL caches both data and index in the key buffer.
Answer: D

6. The stored function year_to_date is created by the ‘root’@'localhost’ account as follows:
CREATE FUNCTION year_to_date ()
RETURNS DECIMAL(10,2)
SQL SECURITY DEFINER
BEGIN
…
END;
Within the routine body, a number of calculations are made on data in the financials table and the calculated value is returned. The only account which can access the financials table is ‘root’@'localhost’.
If a client connects with the account ‘joe’@'localhost’ and calls the year_to_date function, what will happen?
A. The function will always execute as if it was ‘root’@'localhost’ that invoked it since SQL SECURITY DEFINER has been specified.
B. The function will not execute, as ‘joe’@'localhost’ does not have access to the financials table
C. The function will not execute as SQL SECURITY DEFINER has been specified. It would execute if instead SQL SECURITY INVOKER had been specified
D. If the account ‘joe’@'localhost’ has the EXECUTE privilege on year_to_date, the function will complete successfully
Answer: D

7. When working with stored routines, which of the following are true in regards to the effect on the amount of data exchanged between client and server?
A. They may increase the amount of data exchanged.
B. They can help reduce the amount of data exchanged.
C. They have no effect on the amount of data exchanged.
Answer: B

8. Which of the following statements are true of how access control is based?
A. It is based off of an access control table in the mysql database.
B. It is based off of grant tables in the mysql database.
C. It is based off of an access control list stored in the data directory.
D. It is based off of an access control list stored inside the .frm files of each table.
Answer: B

9. Is the following statement true or false? The username you use to connect to MySQL must be the same as the login used to access the operating system.
A. true
B. false
Answer: B

10. Which of the following statements are required to create a key cache of 4 MB, assign the MyISAM table world.City to it and preload the index?
A. mysql> SET GLOBAL city_cache.key_buffer_size = 4194304;mysql> CACHE INDEX world.City IN city_cache;mysql> LOAD INDEX INTO CACHE world.City;
B. mysql> ALTER TABLE world.city KEY_CACHE = 4194304;
C. mysql> CREATE CACHE FOR world.City SIZE = 4194304;
D. It is not possible to create a key cache for a specific MyISAM table, only the global key cache can be used.
Answer: A

11. With replication, what on the master is used to send commands to the slave?
A. The relay log.
B. The binary log.
C. The SQL Thread.
Answer: B

12. How can stored routines be used to check for constraints or legality of incoming data?
A. They can make use of the VALIDATE DEFINER setting.
B. They can not be used to check for constraints or legality of data.
C. They can check and only perform an action if the incoming values match a specified value.
Answer: C

13. How can the SHOW PROCESSLIST command be helpful when optimizing queries?
A. It shows if a query is using an index or not.
B. It shows how the server processes a query.
C. If checked periodically, it can reveal queries that cause other queries to hang.
D. It shows the percentage of processing power that each query is using on a server.
Answer: C

14. Consider the following query:
GRANT ALL ON world.* TO ‘web’@'hostname’
What privileges would this give this user?
A. All privileges including GRANT.
B. All privileges except GRANT.
C. SELECT, INSERT, UPDATE and DELETE.
D. ALL can not be used when granting privileges.
Answer: B

15. Consider the following GRANT statement:
GRANT USAGE ON *.* TO ‘kofi’@'localhost’ IDENTIFIED BY ‘password’
What is the implications of executing that statement?
A. Kofi can access all database objects.
B. Kofi can access all his tables.
C. Kofi can display server system and status variables.
D. Kofi can grant privileges to others.
E. Kofi can access all database objects belonging to localhost.
Answer: C

Free 650-180 Demo Download

Examsoon offers free demo for Others 650-180 exam (SMBEN SMB Solutions for Engineers). You can check out the interface, question quality and usability of our practice exam before you decide to get it. We are the only one site can offer demo for almost all products.

Free Download 650-180 PDF exam Trainning Materials

1. Which of the following platform is composed of SDM, modular upgrades, 1500 VPN tunnels, and sixtyfour (64) 10/100 Mbps PoE switch ports?
A. ISR 1800
B. ISR 2800
C. Catalyst 500
D. Catalyst 3750
Answer: B

2. Mobility Express offers businesses the versatility to evolve and scale from a mobile foundation delivering businessgrade wireless features to a sophisticated wireless network capable of supporting
advanced mobility services and applications. Which of the following attribute exists ONLY on the UC520 model in the Cisco Mobility Express product line?
A. use of 802.11i signaling
B. comes with bundled CCA Management software
C. ability to function without an external controller
D. use of WPA2 security
Answer: D

3. In a traditional telephony environment, the station shelf will be replaced by which of the following in an IP telephony deployment?
A. a call control server
B. a TDM trunk shelf
C. the autoattendant application
D. a Layer 2 switch
Answer: D

4. Refer to the following attributes, which three are concerning to the CE500 platform? (Choose three)
A. Power over Ethernet
B. multiprotocol switching
C. Smartport advisor
D. GUI device manager
Answer: ACD

5. When to configure the IP routing while installing a new Cisco UC520?
A. When analog PSTN trunks are used.
B. When digital PSTN trunks are used.
C. When the service provider assigns static IP information.
D. When the service provider assigns dynamic IP information.
Answer: C

6. Refer to the following Cisco products, which three reside on the UC500 platform? (Choose three)
A. Cisco IOS
B. Cisco Unity Express
C. Cisco IOS Firewall
D. Cisco Unified Communications Manager Express
Answer: BCD

7. Which one of the following feature is the most important one of the Cisco (Linksys) Small Business NSS platform to distinguish it from other NAS systems?
A. the OS resides on the chassis
B. the option for RAID 10
C. a diskbased encryption mechanism
D. one terabyte storage capacity per drive
Answer: A

8. Which of the following is an example of converting signal from a TDM to an IP voice protocol via a voice gateway?
A. SIP to CAS
B. H.323 to SIP
C. CAS to Q.931
D. Q.931 to H.323
Answer: D

9. Which of the following is the exact attribute of the outofband management port on the ASA 5510?
A. It is the only ASA console port.
B. It can route network traffic.
C. It functions at serial line speed.
D. It can be used as a 10/100 switch port.
Answer: B

10. Which two of the following methods are true about testing the LAN connectivity on the Cisco CE520? (Choose two.)
A. Ping the IP address of the CiscoDistribution VLAN from the Cisco UC520 console.
B. Ping the IP address of the CiscoVoice VLAN from a device attached to the Cisco CE520
C. Ping the IP address of the CiscoData Access VLAN from the Cisco UC520 console.
D. Ping the IP address of the CiscoData VLAN from a device attached to the Cisco CE520
Answer: AB