PrepAway - Latest Free Exam Questions & Answers

Author: seenagape

Which code segment should you insert at line 02?

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
The application connects to a Microsoft SQL Server database. You create the classes shown in the following exhibit:

You add the following code segment to the application. (Line numbers are included for reference only.)

01 public void QueryPlayers (List <League> leagues) {
02 …
03 }

You create a LINQ query to retrieve a collection of Player objects.
You need to ensure that the collection includes all the players from each team and every league. Which code segment should you insert at line 02?

Which deployment strategy should you recommend?

You are designing a solution for sharing information among employees located in a main office and several branch offices.
The solution will consist of the following elements:
– An ASP.NET Web application that accesses and manipulates large amounts of data
– Web services used by the Web application for data access
– A Microsoft SQL Server database Data displayed to users is never more than one day old.
You need to plan a deployment strategy that minimizes bandwidth requirements.
Which deployment strategy should you recommend?

Which code segment should you insert at line 12?

You have been assigned the task of writing code that executes an Entity SQL query that returns entity type objects that contain a property of a complex type.
(Line numbers are included for reference only.)

01 using (EntityCommand cmd = conn.CreateCommand())
02 {
03 cmd.CommandText = esqlQuery;
04 EntityParameter param = new EntityParameter();
05 param.ParameterName = “id”;
06 param.Value = 3;
07 cmd.Parameters.Add(param);
08 using (EntityDataReader rdr = cmd.ExecuteReader(CommandBehavior.SequentialAccess))
09 {
10 while (rdr.Read())
11 {
12 …
13 Console.WriteLine(“Email and Phone Info:”);
14 for (int i = 0; i < nestedRecord.FieldCount; i++)
15 {
16 Console.WriteLine(” ” + nestedRecord.GetName(i) + “: ” + nestedRecord.GetValue(i));
17 }
18 }
19 }
20 }

Which code segment should you insert at line 12?

Which data access technology should you recommend?

You are designing an ASP.NET Web application that will be developed by using Microsoft Visual Studio 2010. The application will interact with a Microsoft SQL Server database.
The data access layer of the application must meet the following requirements:
– Support rapid application development techniques.
– Allow the underlying database schema to change without affecting the object model.
– Contain strongly typed data objects.
You need to develop the data access layer.
Which data access technology should you recommend?