1.
You are creating an ASP.NET application by using the .NET Framework 3.5.
The master page contains a Web control that retrieves data from several data sources, including Microsoft SQL
Server 2008 and Microsoft Access 2007.
You need to ensure that the Web control can provide the retrieved data for use in other controls on the page.
What should you do?
2.
You are creating ASP.NET applications by using the .NET Framework 3.5.
The application has two tables named Products and ProductPrice.
The application retrieves and stores data from the Product table into a Dataset object. The application uses the
DataSet object to modify and update the data that is retrieved. The update command for the related
SqlDataAdapter class is generated automatically by using a SqlCommandBuilder object.
You plan to retrieve and modify data from the Product and ProductPrice tables as a unit.
You need to ensure that the application can update the data in the tables.
What should you do?
3.
You are creating an ASP.NET application by using the .NET Framework 3.5.
The application stores data in a database that might be implemented in Microsoft SQL Server, Microsoft
Access, or a variety of third-party databases.
You need to implement a data access strategy that meets the following requirements:
- The same data access code is used for all database platforms.
- The application defines the SQL syntax used.
- The application reduces the vulnerability to SQL injection attacks.
What should you do?
4.
You are creating an ASP.NET application by using the .NET Framework 3.5.
You create a Web form in the application. You add a GridView control to the Web form.
You plan to use an existing business object. The business object provides the select, insert, update, and delete methods.
You need to implement data binding that will allow the GridView control to take full advantage of the business object.
What should you do?
5.
You are creating an ASP.NET application by using the .NET Framework 3.5.
You use LINQ to SQL to query a Microsoft SQL Server 2008 database. You need to create a LINQ query to retrieve information on order and order details.
You need to ensure that the LINQ query executes the following SQL statement:
SELECT Order.OrderID
, Order.Description
, OrderDetails.UnitPrice
FROM Order JOIN OrderDetails
ON Order.OrderID = OrderDetails.OrderID
Which LINQ query should you use?
6.
You are creating an ASP.NET application by using the .NET Framework 3.5. The application has the following components: A user interface (UI) Web services A Microsoft SQL Server 2008 database The application
communicates with the Web services to access data. The Web services and database are hosted on the same server. The database server is moved to a remote location. The remote location is connected via a high-speed
WAN network. A firewall between the database and the ASP.NET application prevents access to all ports except port 80 and port 443. You need to ensure the application maintains as secure a communication possible with the Web services.
What should you do?
7.
You are creating an ASP.NET application by using the .NET Framework 3.5. The application must access a
Microsoft SQL Server 2008 database. The database and the ASP.NET application are located on two different servers. The two servers are located on networks separated by a firewall. Only port 80 and port 443 are open through the firewall. You need to ensure that the application can access the database. What should you do?
8.
You are creating an ASP.NET application by using the .NET Framework 3.5.
You plan to develop the application along with a team of developers, graphic designers, and content designers.
Some of your team members do not have Microsoft Visual Studio 2008 installed on their computers.
You need to ensure that Visual Studio 2008 can automatically recognize new graphics, content, and other media files that are added to the project.
What should you do?
9.
You are creating an ASP.NET application by using the .NET Framework 3.5.
You plan to deploy the application.
You need to ensure that the names of the generated assemblies conform to the rules specified by the deployment environment.
What should you do?
10.
You are creating an ASP.NET application by using the .NET Framework 3.5.
Developers update individual pages frequently. You need to ensure that when individual pages are updated, the time required to load the other pages to the Web site remains unaffected.
What should you do?