I posted it here because I cold not find section for 70-315

1.       You create an ASP.NET application that produces sales reports. The sales data is stored in a Microsoft SQL Server database that is used for transaction processing. The application consists of complex Transact-SQL statements. Many users report that the report generation is taking longer to run each day. You need to improve response times. What are two possible ways to achieve this goal? (Each correct answer presents a complete solution. Choose two)

A.   Use an OleDbDataAdapter indexes exist on the SQL Server tables.

B.   Ensure that appropriate indexes exist in the SQL Server tables.

C.   Rewrite your SQL statements to use aliases for all table names.

D.   Rewrite your direct SQL statements as stored procedures and call the stored procedures from your application.

E.   Configure queries to run in the security context of the user who is running the query.

Answer: B, D

2.       You are creating an order entry application. You set Orders.aspx as the start page. You want users to log on to Orders.aspx by supplying a user name and password. You create a Login.aspx page to validate the user name and password. You need to ensure that users log on by using Login.aspx before they are allowed to access Orders.aspx. Which two courses of action should you take? (Each correct answer presents part of the solution. Choose two)

A.   In the authentication section of the Web.config file, set the mode attribute of the authentication element to Forms. Set the name attribute of the forms element to Login.aspx.

B.   In the authentication section of the Web.config file, set the mode attribute of the authentication element to Forms. Set the loginUrl attribute of the forms element to Login.aspx.

C.   In the authorization section of the Web.config file, set the users attribute of the deny element to “?”:

D.   In the credentials section of the Web.config file, set the users attribute of the dent element to “?”.

E.   In the credentials section of the Machine.config file, set the users attribute of the deny element to “*”.

F.   In the authorization section of the Machine.config file, set the mode attribute of the authentication element to Forms. Set the policyFile attribute of the trust element to Login.aspx.

G.  Create a Page directive in Orders.aspx to load the Login.aspx page.

Answer: B, C

3.       You create an ASP.NET application named Inventory. This application will be used by customers on the Internet. During the beta test period, you ensure that the actual ASP.NET error message is displayed whenever an error is encountered. Both developers and beta testers see the actual text of the error message. You perform beta testing of other applications on the same beta test server during the beta testing period for Inventory. All of the other applications display ASP.NET error messages. After the beta testing period is complete, the beta test server is promoted to a production server. You want all applications to display a single, user-friendly error message. You want to configure Inventory and the production server to meet these goals. You want to perform this task by using the minimum amount of administrative effort. Which two actions should you take? (Each correct answer presents part of the solution. Choose two)

A.   Set the mode parameter of the customErrors element in the Web.config file for Inventory to “On”.

B.   Remove the customErrors element from the Web.config file for Inventory.

C.   Set the mode parameter of the customErrors element in the Inventory.config file to “On”.

D.   Remove the customErrors element from the Inventory.config file.

E.   Set the mode parameter of the customErrors element in the Machine.config file to “On”.

F.   Remove the customErrors element from the Machine.config file.

Answer: B, E

4.       You use Visual Studio .NET to develop a Windows-based application that will interact with a Microsoft SQL Server database named FolksTecSrv. Your application will display employee information from a table named Employees. You use ADO.NET to access the data from the database. To limit the possibility of errors, you must ensure that any type mismatch errors between your application code and the database are caught at compile time rather than at run time. Which two actions should you take? (Each correct answer presents part of the solution. Choose two)

A. Create an XML schema for Employees.

B. Create an XML style sheet for Employees.

C. Create an XML namespace for Employees.

D. Create a typed DataSet object based on the XML schema.

E. Create a typed DataSet object based on the XML style sheet.

F. Create a TypeDelegator class based on the XML namespace.

Answer: A, D