You need to ensure that you can access the list by using strongly-typed objects in Microsoft Visual Studio 201
You plan to create a custom Web Part that displays items from a custom SharePoint list named
Project. You need to ensure that you can access the list by using strongly-typed objects in
Microsoft Visual Studio 2010. What should you do first?
Which code segment should you use?
You need to fill a DataSet from the result that is returned by the stored procedure. The first result
set must be added to a DataTable named Class, and the second result set must be added to a
DataTable named Student. Which code segment should you use?
Which approach should you recommend?
You are designing a solution on a SharePoint 2010 intranet site where administrative
access to the SharePoint 2010 application server is not available. You need to ensure that
site usage information is collected on search statistics for all the sites on the farm. Which
approach should you recommend?
Which code segment should you use?
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to develop an application
that uses LINQ to SQL. The application contains the following model.
Each region contains a single vendor. Customers order parts from the vendor that is located in their
region. You need to ensure that each row in the Customer table references the appropriate row
from the Vendor table. Which code segment should you use?
What should you recommend?
You are designing a Windows Presentation Foundation (WPF) application that will process
data. The data is stored in a Microsoft SQL Server 2008 database. You plan to access the
data by using ADO.NET Entity Framework 4. You need to recommend an approach that
minimizes the number of calls to the database server. What should you recommend?
What should you configure from Group Policy?
Your network contains an Active Directory domain named contoso.com. All domain controllers run
Windows Server 2008 R2 and are configured as DNS servers. All client computers run Windows 7.
You create a new zone named secure.contoso.com and configure the zone to use DNSSEC. You need
to ensure that all client computers verify whether the name and address information of
secure.contoso.com is validated by the DNS servers. What should you configure from Group Policy?
Which IsolationLevel should you use?
You use Microsoft .NET Framework 4 to develop an application that connects to a Microsoft SQL
Server 2008 database. You need to prevent dirty or phantom reads. Which IsolationLevel should you
use?
Which approach should you recommend?
You are designing an ASP.NET Web application to manage and display sensitive
information stored in a Microsoft SQL Server database. The database also provides
authorization information for users. All Web pages that display sensitive information require
an authenticated login. There is no visitor access to these pages. You have the following
requirements: Separate authorization logic from the application. Prevent the application
from directly accessing the database server. You need to design a data access and
authorization solution. Which approach should you recommend?
Which access method should you use?
You have a SharePoint site collection that contains 100 sites. Each site contains 100 lists. You
need to retrieve all item titles from all lists. The data must be retrieved in the minimum amount of
time. Which access method should you use?
Which code segment should you insert at line 04?
You use Microsoft .NET Framework 4 to develop an application that connects to a Microsoft SQL
Server 200B database. You populate a SqlDataAdapter by using the following code. (Line numbers
are included for reference only.)
01 SqlDataAdapter dataAdapterl = new SqlDataAdapter
(“SELECT * FROM [BlogEntries]
ORDER BY CreationDote”, connection);
02 cmdBuilder = nev SqlCormnandBuilder(dataAdapterl);
03 dataAdapterl.Fill(BlogEntryDataSet, “BlogEntries”); 04
05 connection.Close()
You need to update the blog owner for all BlogEntry records.
Which code segment should you insert at line 04?