PrepAway - Latest Free Exam Questions & Answers

Author: seenagape

You need to ensure that the window responds while users type a name

You are creating a Windows Presentation Foundation (WPF) application by using Microsoft
.NET Framework 4 and Microsoft SQL Server 2008. You create a window that allows users
to search for products that match a given name. Search results are displayed when the user
types each letter of the product name. You use a method named FindProducts to obtain the
list of products. Users report that when they type a letter of the product name, the window
stops responding for a varying amount of time. While the window stops responding, users
cannot type more letters. The window stops responding even when the search generates

few results. You need to ensure that the window responds while users type a name. What
should you do?

You need to ensure that the application calls a stored procedure that accepts a table-valued parameter

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. The
application connects to a Microsoft SQL Server 2008 database. You need to ensure that the
application calls a stored procedure that accepts a table-valued parameter. You create a
SqlParameter object. What should you do next?

What should your model contain?

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. The
application connects to a Microsoft SQL Server database. The Data Definition Language (DDL) script
of the database contains the following code segment.
CREATE TABLE [Sales].[SalesOrderHeader](
[SalesOrderID] [int] IDENTITY(1,1) NOT NULL,
[BillToAddressID] [int] NOT NULL,

CONSTRAINT [PK_SalesOrderHeader_SalesOrderID]
PRIMARY KEY CLUSTERED ([SalesOrderID] ASC)
)
ALTER TABLE [Sales].[SalesOrderHeader]
WITH CHECK ADD CONSTRAINT [FK_SalesOrderHeader_Address]
FOREIGN KEY([BilIToAddressID])
REFERENCES [Person].[Address]([AddressID])
You create an ADO.NET Entity Framework model.
You need to ensure that the entities of the model correctly map to the DDL of the database.
What should your model contain?

You need to design a solution that promotes code reusability

You are creating a Windows Presentation Foundation (WPF) application by using Microsoft
.NET Framework 4 and Microsoft Visual Studio 2010. The application will consist of several
data entry forms. Each data entry form requires a user to enter phone numbers and
addresses. You need to design a solution that promotes code reusability. What should you
do?

You need to ensure that entities can be sent to the service as XML

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. You
use Plain Old CLR objects (POCO) to model your entities. The application communicates with a
Windows Communication Foundation (WCF) Data Services service. You need to ensure that entities
can be sent to the service as XML. What should you do?

Which two actions should you recommend?

You are designing an ASP.NET Web application that will be accessed by local intranet
users. The Web application will store temporary data files locally. The Web server is running
IIS 7.5. You have the following requirements: Temporary data file ownership must be set to
the user account. Temporary data files stored locally must be accessible only to the
authenticated user. You need to recommend an approach for securing the temporary data
files. Which two actions should you recommend? (Each correct answer presents part of the
solution. Choose two.)

which two procedures should you add the Qproductld parameter?

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. You
create stored procedures by using the following signatures:
• CREATE procedure [dbo].[Product_Insert] (@name varchar (50) / 6pri.ce float)
• CREATE procedure [dbo].[Product_Updatej (@id int, Bname varchar(50), @price float)
• CREATE procedure [dbo].[Product_Delete] (@ id int)
• CREATE procedure [dbo] .[Order_Insert] (@productld int, @quantity int)
• CREATE procedure [dbo] .[Order_Update] (@id int, Gquantity int,@originalTimestamp
tlmestamp)
• CREATE procedure [dbo].[Order_Delete](@id int)
You create a Microsoft ADO.NET Entity Data Model (EDM) by using the Product and Order entities as
shown in the exhibit. (Click the Exhibit button.)

You need to map the Product and Order entities to the stored procedures. To which two procedures
should you add the Qproductld parameter? (Each correct answer presents part of the solution.
Choose two.)

Which authentication approach should you recommend?

You are designing a SharePoint 2010 application that contains a Web Part. The Web Part
must connect to an RSS data stream provided by a Web service. The Web service is on
another server in the domain. You need to recommend an authentication approach that
meets the following requirements: ·SharePoint users must not be required to supply
additional credentials for the Web service. .Standard authentication systems available to
SharePoint 2010 must be used. Which authentication approach should you recommend?