What should you do?
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?
What should you conclude?
You are an enterprise application designer. You are designing a three-tier enterprise application. The application currently consists of a business layer and a data layer.
The application must perform the following tasks:
Support a smart client interface and a Web client interface. Achieve maximum reuse between the smart client interface and the Web client interface.
Reduce code duplication.
The systems analyst recommends adding a UI layer to perform the required tasks. You need to evaluate this recommendation. What should you conclude?
What should you do?
You need to create an assignment business rule that is based on an existing allocation rule. What should you do?
What should you do?
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?
Which five actions should you include?
You are an enterprise application developer. You are creating a Web service by using ASP.NET. The Web service estimates insurance premiums based on values passed by the client application. The Web server is on the perimeter network. The Web server uses .NET Remoting to communicate to components on an application server that is on the corporate network. The components on the application server use Microsoft Windows Integrated security to authenticate to the database server.
The perimeter network is configured to ensure that the following restrictions are imposed:
Only port 80 is open between the perimeter network and the external network. Application-specific ports might be opened between the perimeter network and the internal network when necessary.
You need to prepare a deployment verification list and a production verification list. Which five actions should you include? (Each correct answer presents part of the solution. Choose five.)
What should you do?
You create an allocation rule by using a Microsoft SQL Server 2005 implementation. You add a parameter to the allocation rule. The Members property does not appear in the Parameter Type drop-down box. You need to set the parameter type to Member of Dimension. What should you do?
What should you do?
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?
Which three performance counters should you use?
You are an enterprise application developer. You create a three-tier application for placing orders.
The application permits users to submit search requests by using a Web service. The Web service occasionally times out when search requests are submitted. You conclude that the Web service times out due to high network bandwidth utilization. You plan to create custom counters if
necessary. You need to use performance counters to analyze the data. Which three performance counters should you use? (Each correct answer presents part of the solution. Choose three.)
What should you do?
You plan to add a business rule to a model named MyModel. You need to ensure that the business rule distributes data to another model. What should you do?
Which data access object should you use in the DAL?
You are creating an ASP.NET application by using the .NET Framework 3.5.
The application will contain a Data Access Layer (DAL) that will support databases from third-party vendors. The application will display data by using a GridView control.
You need to ensure that the application meets the following requirements:
– Allow paging
– Provide optimistic concurrency
Which data access object should you use in the DAL?