Deploying and Supporting an Application
Questions derived from the 70-547VB – PRO: Designing and Developing Web-Based Applications by Using the Microsoft .NET Framework (VB.NET).
Objective: Deploying and Supporting an Application
SubObjective: Evaluate the physical design of an application (considerations include the design of the project structure, the number of files, the number of assemblies and the location of these resources on the server)
Item Number: 70-547VB.6.5.3
Multiple Answer, Multiple Choice
You develop Web-based applications for an online gaming company. You have created a Web application that takes bets online by updating and retrieving data from a SQL Server database. All servers in your company use Windows 2003 Enterprise Edition. All SQL Servers in your company use SQL 2005 Enterprise Edition.
Customers complain that performance when accessing the applications through the Web server has suffered. You decided to add two more Web servers to alleviate the load. Your solution performs adequately until the percent of customers accessing the applications increases by 40 percent. The customers also complain queries against the SQL Server are slow.
You want to improve performance and provide failover protection for the servers. Which actions should you take to improve performance? (Choose two. Each answer is part of the complete solution.)
- Eliminate two Web servers. Establish a Web garden with at least four CPUs.
- Configure the existing Web servers into a Web farm with Network Load Balancing.
- Add two more SQL Servers and configure the existing and new SQL Servers in a cluster. Add the SQL Servers to a SQL Cluster.
- Add two more SQL Servers and configure the database to ship the transaction log to databases on the other SQL Servers.
- Add another SQL Server and configure the new SQL Server to mirror the existing SQL Server.
B. Configure the existing Web servers into a Web farm with Network Load Balancing.
C. Add two more SQL Servers and configure the existing and new SQL Servers in a cluster. Add the SQL Servers to a SQL Cluster.
In this scenario, you must improve performance and provide failover protection for the servers. You should configure the existing Web servers into a Web farm with Network Load Balancing. A Web farm allows a Web site to be spread across multiple servers. You should use Network Load Balancing (NLB) to provide high availability. NLB can be used to detect host failures and distribute traffic to hosts that are operational. A Web farm can ensure that customers from the Internet can access an available server. NLB can improve performance by using a distributed algorithm to load balance network traffic the Web site. You should add two more SQL Servers, configure the existing and new SQL Servers in a cluster, and add the SQL Servers to a SQL Cluster. A cluster of the SQL Servers can provide high availability and protection against data loss. By configuring clustering, you can prevent down time of the databases on which customers will run queries and system databases. Clustering provides protection for all databases on the SQL Server.
You should not establish a Web garden to improve performance. A Web garden may improve performance by allowing a Web site to use multiple CPUs on a single server. However, a Web garden cannot provide failover protection because the Web site runs on a single computer. A Web garden cannot provide NLB because there are no other servers between which to balance the network load.
You should not configure the database to ship the transaction log to the other SQL Servers. Shipping the transaction log to another SQL Server is a common way to provide a redundant copy of the database. However, this method does not provide high availability which was a requirement in this scenario.
You should not configure the database to mirror to another database on a separate SQL Server. Database mirroring can provide high availability and protection from database failure. However, database mirroring only protects against a failure of the database accessed by customers. Database mirroring does not protect the system databases of the SQL Server. If a failure in one of the system databases causes the SQL Server to no longer function, then customers would not be able to use the Web application. You should cluster the SQL Servers to protect against a failure in the system database of the SQL Server.
MSDN Library > Enterprise Servers and Development > Connected Services Framework > Connected Services Framework 3.0 > CSF 3.0 Developer Guide > Using the Core Components of Connected Services Framework > The Session Component > Frequently Asked Questions About Session > What is the Relationship Between Session Clustering and Load Balancing?
MSDN Library > Enterprise Servers and Development > SQL Server > SQL Server 2005 Documentation > SQL Server 2005 Books Online > Installing SQL Server > Preparing to Install SQL Server 2005 > Configuring High Availability > Failover Clustering