Which line of code should you insert at line 09?
The application populates a DataSet object by using a SqlDataAdapter object. You use the DataSet
object to update the Categories database table in the database.
You write the following code segment. (Line numbers are included for reference only.)
01 SqlDataAdapter dataAdpater = new SqlDataAdapter(“SELECT CategoryID,
CategoryName FROM Categories”, connection);
02 SqlCommandBuilder builder = new SqlCommandBuilder(dataAdpater);
03 DataSet ds = new DataSet();
04 dataAdpater.Fill(ds);
05 foreach (DataRow categoryRow in ds.Tables[0].Rows)
06 {
07 if (string.Compare(categoryRow[“CategoryName”].ToString(), searchValue,
true) == 0)
08 {
09
10 }
11 }
12 dataAdpater.Update(ds);
You need to remove all the records from the Categories database table that match the value of the
searchValue variable. Which line of code should you insert at line 09?
What should you recommend?
You are designing a Windows Forms application that allows users to search a product
catalog and place orders. You have the following requirements: Display a progress indicator
while the application is searching the catalog. Ensure that users can cancel search
operations. You need to recommend an approach that meets the requirements. What
should you recommend?
You need to configure the client computers in the North America office to improve the name resolution response
Your company has a single Active Directory forest that has a domain in North America named
na.contoso.com and a domain in South America named sa.contoso.com. The client computers run
Windows 7. You need to configure the client computers in the North America office to improve the
name resolution response time for resources in the South America office. What should you do?
Wich the correct form.
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 must to retrieve a connection
string. Wich the correct form.
Which approach should you recommend?
You are adding functionality to an ASP.NET MVC 2 Web application. You have the following
requirements when passing form data to the server: Provide a simple way to map posted
form values to a custom class object. Control the deserialization of custom class objects
that are passed to the server. You need to design the application to meet the requirements.
Which approach should you recommend?
Which the correct Propertie to insert?
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. The application uses a Microsoft
ADO.NET SQL Server managed provider.
“Data Source=myServerAddress; Initial Catalog=myDataBase; User Id=myUsername;
Password=secret;”
You need to ensure that the database credentials are secure. Which the correct Propertie to insert?
You need to apply the custom master page to only the content pages of the site
You have a SharePoint site. The current master page of the site is v4.master. You create a
custom master page named MyMasterPage.master. You deploy the master page to
/_catalogs/masterpage/. You need to apply the custom master page to only the content pages of
the site. What should you do?
Which two actions should you perform?
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create a multi-tier
application. You use Microsoft ADO.NET Entity Data Model (EDM) to model entities. The model
contains entities named SalesOrderHeader and SalesOrderDetail. For performance considerations in
querying SalesOrderHeader, you detach SalesOrderDetail entities from ObjectContext. You need to
ensure that changes made to existing nSalesOrderDetail entities updated in other areas of your
application are persisted to the database. Which two actions should you perform? (Each correct
answer presents part of the solution. Choose two.)
What should you recommend?
You are designing a Windows Forms application. You intend to display graphics on a form
in the application by using a third-party Windows Presentation Foundation (WPF) control.
You need to recommend a control for hosting the third-party WPF control. What should you
recommend?
What are two possible ways to achieve this goal?
You have a sandboxed SharePoint 2010 application for managing sales proposals. The
application runs in a hosted environment that does not allow direct access to external
services or the installation of proxies or external content types. The account status for your
application is contained in a Customer Relationship Management (CRM) system hosted on
a separate server. The account status information is exposed via Web services. You need
to display account status from the CRM system in the form of dashboards, pie charts, and
other reports to the users within your firewall. What are two possible ways to achieve this
goal? (Each correct answer presents a complete solution. Choose two.)