Discussion
Home ‣ Certification ‣ Microsoft Certification See What Others Are Saying!
- Question
You are a Web developer for XYZ. You create an ASP.NET application that accesses sales and marketing data. The data is stored in a Microsoft SQL Server 2000 database on a server named XYZ01. The company purchases a factory automation software application. The application is installed on XYZ01, where it creates a second instance of SQL Server 2000 named Factory and a database named FactoryDB. You connect to FactoryDB by using Windows Integrated authentication. You want to add a page to your ASP.NET application to display inventory data from FactoryDB. You use a SqlConnection object to connect to the database. You need to create a connection string to FactoryDB in the instance of SQL Server named Factory on XYZ01. Which string should you use?
Options- A. ?Server=XYZ01;Data Source=Factory; Initial Catalog=FactoryDB;Integrated Security=SSPI?
- B. ?Server=XYZ01;Data Source=Factory; Database=FactoryDB;Integrated Security=SSP1?
- C. ?Data Source=XYZ01\Factory; Initial Category=Factory; Integrated Security=SSP1?
- D. ?Data Source=XYZ01\Factory; Database=FactoryDB; Integrated Security=SSP1?
- Correct Answer
- ?Data Source=XYZ01\Factory; Database=FactoryDB; Integrated Security=SSP1?
ExplanationThe Data Source attribute of the connection string contains the name, instance or network address of the instance of SQL Server to which to connect. In this scenario we are to connect to the Factory Instance on XYZ01 so we use XYZ01\Factory as data source. To specify the database we should either use the Database or the Initial Catalog attribute. Here we use Database=FactoryDB.
Incorrect Answers:
A, B: There is no Server attribute in the connection string. Instead we should use the Data Source attribute to specify the server and the instance.
C: There is no Initial Category attribute in the connection string. We can use Database or the Initial Catalog attribute to specify the database.
- 1. Which two descriptions are correct about characteristics of IPv6 unicast addressing? (Choose two) A. Global addresses start with 2000::/3. B. Link-local addresses start with FF00::/10. C. Link-local addresses start with FE00:/12. D. There is only one loopback address and it is ::1. Discuss
- 2. What are the six OSPF route types? Discuss
- 3. How many non- overlapping channels are available with 802.11b?
Options- A. 3
- B. 12
- C. 23
- D. 40 Discuss
- 4. Which IEEE committee has been sanctioned by WAP and is called WPA2? Discuss
- 5. When a station sends a transmission to the MAC address ff : ff : ff : ff : ff : ff, what type of transmission is it?
Options- A. Unicast
- B. Multicast
- C. Anycast
- D. Broadcast Discuss
- 6. In the operation of CSMA/CD, which host(s) have priority after the expiration of the backoff algorithm?
Options- A. All hosts have equal priority
- B. The two hosts that caused the collision will have equal priority
- C. The host that sent the jam signal after the collision
- D. The host with the highest MAC address Discuss
- 7. What is the Classs A Private IP address space? Discuss
- 8. What is the Class C private IP address space? Discuss
- 9. To use VLSM, what capability must the routing protocols in use possess?
Options- A. Support for multicast
- B. Multi-protocol support
- C. Transmission of subnet mask information
- D. Support for unequal load balancing Discuss
- 10. If you wanted administrators to see a message when logging into the router, which command would you use?
Options- A. message banner motd
- B. banner message motd
- C. banner motd
- D. message motd Discuss
More questions
Correct Answer: : A , D Explanation: An IPv6 Unicast address identifies a single network interface The Internet Protocol delivers packets sent to a unicast address to that specific interface
Correct Answer: Intra-area, inter area, El, E2, Nl, and N2
Correct Answer: 3
Explanation:
The IEEE 802.11b standard provides three non-overlapping channels.
Correct Answer: The IEEE 80211i standard has been sanctioned by WPA and is termed WPA version 2
Correct Answer: Broadcast
Explanation:
A transmission to the MAC address ff : ff : ff : ff : ff : ff is a broadcast transmission to all stations.
Correct Answer: All hosts have equal priority
Explanation:
After the expiration of the backoff algorithm , all hosts have equal priority.
Correct Answer: 10000 through 10255255255
Correct Answer: 19216800 through 192168255255
Correct Answer: Transmission of subnet mask information
Explanation:
To use VLSM, the routing protocols in use possess the capability to transmit subnet mask information.
Correct Answer: banner motd
Explanation:
The typical banner is a message of the day (MOTD) and is set by using the global configuration mode command banner motd.
Comments
There are no comments.Programming
Copyright ©CuriousTab. All rights reserved.