Microsoft 70-516 : TS: Accessing Data with Microsoft .NET Framework 4

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 the ADO.NET LINQ to Entity model
to retrieve data from the database.
You need to call a function that is defined in the conceptual model from within the LINQ to Entities queries.
You create a common language runtime (CLR) method that maps to the function. What should you do
next?

• A. Apply the EdmComplexTypeAttribute attribute to the method.
• B. Apply the EdmFunctionAttribute attribute to the method.
• C. Declare the method as static.
• D. Declare the method as abstract.

You add a table to the database to track changes to part names. The table stores the following row values:
-the username of the user who made the change
-a part ID
-the new part name
-a DateTime value
You need to ensure detection of unauthorized changes to the row values.
You also need to ensure that database users can view the original row values.

• A. Add a column named hash. Use System.Security.Cryptography.MD5 to create an MD5 hash of the row values, and store in the hash column.
• B. Add a column named signature. Use System.Security.Cryptography.RSA to create a signature for all of the row values. Store the signature in the signature column. Publish only the public key internally.
• C. Use System.Security.Cryptography.DES to encrypt all the row values using an encryption key held by the application.
• D. Use System.Security.Cryptography.RSA to encrypt all the row values. Publish only the key internally.

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application. You use the Entity Framework Designer to create the following Entity Data Model.

The application contains a class as shown in the following code segment. (Line numbers are included for
reference only.)
01 public class MyBaseClass : EntityObject
02 {
03 ....
04 }
You need to ensure that all generated entities inherit from MyBaseClass. What should you do?

• A. Create a new ObjectQuery that uses MyBaseClass as the type parameter.
• B. Change MyBaseClass to inherit from ObjectContext.
• C. Modify the generated code file so that all entities inherit from MyBaseClass.
• D. Use the ADO.NET EntityObject Generator template to configure all entities to inherit from MyBaseClass.

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 the ADO.NET Entity Framework to manage persistence-ignorant entities. You create an
ObjectContext instance named context.
Then, you directly modify properties on several entities. You need to save the modified entity values to the
database.
Which code segment should you use?

• A. context.SaveChanges();
• B. context.SaveChanges(SaveOptions.AcceptAllChangesAfterSave);
• C. context.SaveChanges(SaveOptions.None);
• D. context.SaveChanges(SaveOptions.DetectChangesBeforeSave);

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?

• A. Stopwatch w1 = new Stopwatch(); w1.Start(); cmd1.ExecuteNonQuery(); w1.Stop(); Trace.WriteLine(w1.ElapsedMilliseconds); w1.Start(); cmd2.ExecuteNonQuery(); w1.Stop(); Trace.WriteLine(w1.ElapsedMilliseconds);
• B. Stopwatch w1 = Stopwatch.StartNew(); cmd1.ExecuteNonQuery(); w1.Stop(); Trace.WriteLine(w1.ElapsedMilliseconds); w1 = Stopwatch.StartNew(); cmd2.ExecuteNonQuery(); w1.Stop(); Trace.WriteLine(w1.ElapsedMilliseconds);
• C. Stopwatch w1 = Stopwatch.StartNew(); cmd1.ExecuteNonQuery(); w1.Stop(); Trace.WriteLine(w1.ElapsedMilliseconds); w1.Start(); cmd2.ExecuteNonQuery(); w1.Stop(); Trace.WriteLine(w1.ElapsedMilliseconds);
• D. Stopwatch w1 = new Stopwatch(); w1.Start(); cmd1.ExecuteNonQuery(); w1.Stop(); Trace.WriteLine(w1.ElapsedMilliseconds); w1.Reset(); cmd2.ExecuteNonQuery(); w1.Stop(); Trace.WriteLine(w1.ElapsedMilliseconds);