New Updated Microsoft MCTS 70-516 Real Exam Questions and Answers Download 181-190

Ensurepass

QUESTION 181

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 use Entity SQL of the ADO.NET Entity Framework to retrieve data from the database. You need to define a custom function in the conceptual model. You also need to ensure that the function calculates a value based on properties of the object. Which two XML element types should you use? (Each correct answer presents part of the solution. Choose two.)

 

  1. Function

  2. FunctionImport

  3. Dependent

  4. Association

  5. DefiningExpression

 

Correct Answer: AE

 

 

QUESTION 182

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application. You deploy a Windows Communication Foundation (WCF) Data Service to a production server. The application is hosted by Internet Information Services (IIS). After deployment, applications that connect to the service receive the following error message:

 

“The server encountered an error processing the request. See server logs for more details.”

 

You need to ensure that the actual exception data is provided to client computers. What should you do?

 

  1. Modify the application’s Web.config file. Set the value for the customErrors element to Off.

  2. Modify the application’s Web.config file. Set the value for the customErrors element to RemoteOnly.

  3. Add the FaultContract attribute to the class that implements the data service.

  4. Add the ServiceBehavior attribute to the class that implements the data service.

 

Correct Answer: D

 

 

QUESTION 183

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?

 

  1. categoryRow.Delete();

  2. ds.Tables[0].Rows.RemoveAt(0);

  3. ds.Tables[0].Rows.Remove(categoryRow);

  4. ds.Tables[0].Rows[categoryRow.GetHashCode()].Delete();

 

Correct Answer: A

 

 

QUESTION 184

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. The application uses the ADO.NET Entity Framework to model entities. The database includes objects based on the exhibit.

 

The application includes the following code segment. (Line numbers are included for reference only.)

 

01 using (AdventureWorksEntities advWorksContext = new AdventureWorksEntities()){

02 …

03 }

 

You need to retrieve a list of all Products from today’s sales orders for a specified customer. You also need to ensure that the application uses the minimum amount of memory when retrieving the list. Which code segment should you insert at line 02?

 

  1. Contact customer = context.Contact.Where(“it.ContactID = @customerId”,

new ObjectParameter(“customerId”, customerId)).First(); customer.SalesOrderHeader.Load();

foreach (SalesOrderHeader order in customer.SalesOrderHeader)

{

order.SalesOrderDetail.Load();

if (order.OrderDate.Date == DateTime.Today.Date)

{

foreach (SalesOrderDetail item in order.SalesOrderDetail)

{

Console.WriteLine(String.Format(“Product: {0} “, item.ProductID));

}

}

}

 

  1. Contact customer = context.Contact.Where(“it.ContactID = @customerId”,

new ObjectParameter(“customerId”, customerId)).First(); customer.SalesOrderHeader.Load();

foreach (SalesOrderHeader order in customer.SalesOrderHeader)

{

if (order.OrderDate.Date == DateTime.Today.Date)

{

order.SalesOrderDetail.Load();

foreach (SalesOrderDetail item in order.SalesOrderDetail)

{

Console.WriteLine(String.Format(“Product: {0} “, item.ProductID));

}

}

}

 

  1. Contact customer = (from contact in context.Contact.Include

(“SalesOrderHeader”) select contact).FirstOrDefault();

foreach (SalesOrderHeader order in customer.SalesOrderHeader)

{

order.SalesOrderDetail.Load();

if (order.OrderDate.Date == DateTime.Today.Date)

{

foreach (SalesOrderDetail item in order.SalesOrderDetail)

{

Console.WriteLine(String.Format(“Product: {0} “, item.ProductID));

}

}

}

 

  1. Contact customer = (from contact in context.Contact.Include (“SalesOrderHeader.SalesOrderDetail”) select contact).FirstOrDefault();

foreach (SalesOrderHeader order in customer.SalesOrderHeader)

{

if (order.OrderDate.Date == DateTime.Today.Date)

{

foreach (SalesOrderDetail item in order.SalesOrderDetail)

{

Console.WriteLine(String.Format(“Product: {0} “, item.ProductID));

}

}

}

 

Correct Answer: B

 

 

QUESTION 185

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application. The application contains the following code segment. (Line numbers are included for reference only.)

 

01 class DataAccessLayer

02 {

03 private static string connString;

04 …

05 …

06 public static DataTable GetDataTable(string command){

07 …

08 …

09 }

10 }

 

You need to define the connection life cycle of the DataAccessLayer class. You also need to ensure that the application uses the minimum number of connections to the database. What should you do?

 

  1. Insert the following code segment at line 04.

private static SqlConnection conn = new SqlConnection(connString);

public static void Open()

{

conn.Open();

}

public static void Close()

{

conn.Close();

}

 

  1. Insert the following code segment at line 04.

private SqlConnection conn = new SqlConnection(connString);

public void Open()

{

conn.Open();

}

public void Close()

{

conn.Close();

}

 

  1. Replace line 01 with the following code segment.

class DataAccessLayer : IDisposable

Insert the following code segment to line 04.

private SqlConnection conn = new SqlConnection(connString);

public void Open()

{

conn.Open();

}

public void Dispose()

{

conn.Close();

}

 

  1. Insert the following code segment at line 07:

using (SqlConnection conn = new SqlConnection(connString))

{

conn.Open();

}

 

Correct Answer: D

 

 

QUESTION 186

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application. The application connects to a Microsoft SQL Server 2008 database. The application contains two SqlCommand objects named cmd1 and cmd2. You need to measure the time required to execute each command. Which code segment should you use?

 

  1. Stopwatch w1 = new Stopwatch(); w1.Start(); cmd1.ExecuteNonQuery(); w1.Stop();

Trace.WriteLine(w1.ElapsedMilliseconds);

w1.Start();

cmd2.ExecuteNonQuery();

w1.Stop();

Trace.WriteLine(w1.ElapsedMilliseconds);

 

  1. Stopwatch w1 = new Stopwatch(); w1.Start(); cmd1.ExecuteNonQuery(); w1.Stop();

Trace.WriteLine(w1.ElapsedMilliseconds);

w1.Reset();

cmd2.ExecuteNonQuery();

w1.Stop();

Trace.WriteLine(w1.ElapsedMilliseconds);

 

  1. Stopwatch w1 = Stopwatch.StartNew();

cmd1.ExecuteNonQuery();

w1.Stop();

Trace.WriteLine(w1.ElapsedMilliseconds);

w1.Start();

cmd2.ExecuteNonQuery();

w1.Stop();

Trace.WriteLine(w1.ElapsedMilliseconds);

 

  1. Stopwatch w1 = Stopwatch.StartNew();

cmd1.ExecuteNonQuery();

w1.Stop();

Trace.WriteLine(w1.ElapsedMilliseconds);

w1 = Stopwatch.StartNew();

cmd2.ExecuteNonQuery();

w1.Stop();

Trace.WriteLine(w1.ElapsedMilliseconds);

 

Correct Answer: D

 

 

QUESTION 187

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application. The application connects to two different Microsoft SQL Server 2008 database servers named Server1 and Server2. A string named sql1 contains a connection string to Server1. A string named sql2 contains a connection string to Server2.

 

01 using (TransactionScope scope = new

02 …

03 )

04 {

05 using (SqlConnection cn1 = new SqlConnection(sql1))

06 {

07 try{

08 …

09 }

10 catch (Exception ex)

11 {

12 }

13 }

14 scope.Complete();

15 }

 

You need to ensure that the application meets the following requirements:

 

  • There is a SqlConnection named cn2 that uses sql2.

  • The commands that use cn1 are initially enlisted as a lightweight transaction.

 

The cn2 SqlConnection is enlisted in the same TransactionScope only if commands executed by cn1 do not throw an exception. What should you do?

 

  1. Insert the following code segment at line 02.

TransactionScope(TransactionScopeOption.Suppress)

Insert the following code segment at line 08.

using (SqlConnection cn2 = new SqlConnection(sql2))

{

try

{

cn2.Open();

cn1.Open();

}

catch (Exception ex){}

}

 

  1. Insert the following code segment at line 02.

TransactionScope(TransactionScopeOption.Suppress)

Insert the following code segment at line 08.

cn1.Open();

using (SqlConnection cn2 = new SqlConnection(sql2))

{

try

{

cn2.Open();

}

catch (Exception ex){}

}

 

  1. Insert the following code segment at line 02.

TransactionScope(TransactionScopeOption.RequiresNew)

Insert the following code segment at line 08.

using (SqlConnection cn2 = new SqlConnection(sql2))

{

try

{

cn2.Open();

cn1.Open();

}

catch (Exception ex){}

}

 

  1. Insert the following code segment at line 02.

TransactionScope(TransactionScopeOption.RequiresNew)

Insert the following code segment at line 08.

cn1.Open();

using (SqlConnection cn2 = new SqlConnection(sql2))

{

try

{

cn2.Open();

}

catch (Exception ex){}

}

 

Correct Answer: B

 

 

QUESTION 188

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application. The application uses the ADO.NET Entity Framework to model entities. The conceptual schema definition language (CSDL) file contains the following XML fragment.

<EntityType Name=”Contact”>

<Property Name=”EmailPhoneComplexProperty” Type=”AdventureWorksModel.EmailPhone” Nullable=”false” />

</EntityType>

<ComplexType Name=”EmailPhone”>

<Property Type=”String” Name=”EmailAddress” MaxLength=”50″ FixedLength=”false” Unicode=”true” />

<Property Type=”String” Name=”Phone” MaxLength=”25″ FixedLength=”false” Unicode=”true” />

</ComplexType>

 

You write the following code segment. (Line numbers are included for reference only.)

 

01 using (EntityConnection conn = new EntityConnection(“name=AdvWksEntities”))

02 {

03 conn.Open();

04 string esqlQuery = @”SELECT VALUE contacts FROM

05 AdvWksEntities.Contacts AS contacts

06 WHERE contacts.ContactID == 3″;

07 using (EntityCommand cmd = conn.CreateCommand())

08 {

09 cmd.CommandText = esqlQuery;

10 using (EntityDataReader rdr = cmd.ExecuteReader())

11 {

12 while (rdr.Read())

13 {

14 …

15 }

16 }

17 }

18 conn.Close();

19 }

 

You need to ensure that the code returns a reference to a ComplexType entity in the model named EmailPhone. Which code segment should you insert at line 14?

 

  1. int FldIdx = 0;

EntityKey key = record.GetValue(FldIdx) as EntityKey;

foreach (EntityKeyMember keyMember in key.EntityKeyValues)

{

return keyMember.Key + ” : ” + keyMember.Value;

}

 

  1. IExtendedDataRecord record = rdr[“EmailPhone”]as IExtendedDataRecord;

int FldIdx = 0;

return record.GetValue(FldIdx);

 

  1. DbDataRecord nestedRecord = rdr[“EmailPhoneComplexProperty”] as DbDataRecord;

return nestedRecord;

 

  1. int fieldCount = rdr[“EmailPhone”].DataRecordInfo.FieldMetadata.Count;

for (int FldIdx = 0; FldIdx < fieldCount; FldIdx++)

{

rdr.GetName(FldIdx);

if (rdr.IsDBNull(FldIdx) == false)

{

return rdr[“EmailPhone”].GetValue(FldIdx).ToString();

}

}

 

Correct Answer: C

 

 

QUESTION 189

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application. The application connects to a Microsoft SQL Server 2008 database. You must retrieve a connection string. Which of the following is the correct connection string?

  1. string connectionString = ConfigurationSettings.AppSettings[“connectionString”];

  2. string connectionString = ConfigurationManager.AppSettings[“connectionString”];

  3. string connectionString = ApplicationManager.ConnectionStrings[“connectionString”];

  4. string connectionString = ConfigurationManager.ConnectionStrings[“connectionString”].ConnectionString;

 

Correct Answer: D

 

 

QUESTION 190

You use Microsoft Visual Studio 2010 and Microsoft Entity Framework 4.0 to create an application. The application connects to a Microsoft SQL Server database. You use the ADO.NET LINQ to SQL model to retrieve data from the database. The applications contains the Category and Product entities as shown in the following exhibit:

 

70-516-demo-25

 

You need to ensure that LINO to SQL executes only a single SQL statement against the database. You also need to ensure that the query returns the list of categories and the list of products. Which code segment should you use?

 

  1. using (NorthwindDataContext dc = new NorthwindDataContext()) { dc.ObjectTrackingEnabled = false;

var categories = from c in dc.Categories

select c;

foreach (var category in categories) {

Console.WriteLine(“{0} has {1} products”, category.CategoryName, category.Products.Count); }

}

 

  1. using (NorthwindDataContext dc = new NorthwindDataContext()) { dc.DeferredLoadingEnabled = false; DataLoadOptions dlOptions = new DataLoadOptions();

dlOptions.LoadWith<Category>(c => c.Products);

dc.LoadOptions = dlOptions;

var categories = from c in dc.Categories

select c;

foreach (var category in categories) {

Console.WriteLine(“{0} has {1} products”, category.CategoryName, category.Products.Count); }

}

 

  1. using (NorthwindDataContext dc = new NorthwindDataContext()) { dc.DeferredLoadingEnabled = false;

var categories = from c in dc.Categories

select c;

foreach (var category in categories) {

Console.WriteLine(“{0} has {1} products”, category.CategoryName, category.Products.Count); }

}

 

  1. using (NorthwindDataContext dc = new NorthwindDataContext()) { dc.DeferredLoadingEnabled = false; DataLoadOptions dlOptions = new DataLoadOptions();

dlOptions.AssociateWith<Category>(c => c.Products);

dc.LoadOptions = dlOptions;

var categories = from c in dc.Categories

select c;

foreach (var category in categories) {

Console.WriteLine(“{0} has {1} products”, category.CategoryName, category.Products.Count); }

}

 

Correct Answer: B

 

Instant Access to Download Latest Complete Collection of Microsoft MCTS 70-516 Real Exam

Try Microsoft MCTS 70-516 Free Demo