Latest Microsoft 70-516 Real Exam Download 191-200

EnsurepassQUESTION 191 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.   SQLConnection conn = new SQLConnection(connectionString); conn.Open(); SqlTransaction tran = db.BeginTransaction(IsolationLevel. ...); ...   You must retrieve not commited records originate from various transactions. Which method should you use?   A.       ReadUncommited Read more [...]

Latest Microsoft 70-516 Real Exam Download 181-190

EnsurepassQUESTION 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 Read more [...]

Latest Microsoft 70-516 Real Exam Download 171-180

EnsurepassQUESTION 171 You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application. You use the Entity Framework Designer to create an Entity Data Model (EDM). You need to create a database creation script for the EDM. What should you do?   A.       Use a new Self-Tracking Entities template. B.       Drag entities to Server Explorer. C.        Run the Generate Read more [...]

Latest Microsoft 70-516 Real Exam Download 161-170

EnsurepassQUESTION 161 The database contains orphaned Color records that are no longer connected to Part records. You need to clean up the orphaned records. You have an existing ContosoEntities context object named context. Which code segment should you use?   A.       var unusedColors = context.Colors.Where(c => !c.Parts.Any()).ToList(); foreach (var unused in unusedColors){ context.DeleteObject(unused) } context.SaveChanges();   B.       Read more [...]

Latest Microsoft 70-516 Real Exam Download 151-160

EnsurepassQUESTION 151 You are working with an ObjectContext object that targets the mainframe and another ObjectContext object that targets SQL Server. When it's time to save the changes, you want all changes to be sent to the mainframe and to SQL Server as one transaction. How can you accomplish this?   A.       Just save both ObjectContext objects because they automatically join the same transaction. B.       Save to the mainframe Read more [...]

Latest Microsoft 70-516 Real Exam Download 141-150

EnsurepassQUESTION 141 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 uses a Microsoft ADO. NET SQL Server managed provider. When a connection fails, the application logs connection information, including the full connection string. The information is stored as plain text in a .config file. You need to ensure that the database credentials are secure. Which connection Read more [...]

Latest Microsoft 70-516 Real Exam Download 131-140

EnsurepassQUESTION 131 You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application. You use the ADO.NET Entity Framework to model your entities. You use Plain Old CLR Objects (POCO) entities along with snapshot-based change tracking. The code accesses the POCO entities directly. You need to ensure that the state manager synchronizes when changes are made to the object graph. Which ObjectContext method should you call?   A.       Read more [...]

Latest Microsoft 70-516 Real Exam Download 121-130

EnsurepassQUESTION 121 You want to execute a SQL insert statement from your client application, so you set the CommandText property of the command object and open the connection. Which method will you execute on the command?   A.       ExecuteScalar B.       ExecuteXmlReader C.        ExecuteReader D.       ExecuteNonQuery   Correct Answer: D     Read more [...]

Latest Microsoft 70-516 Real Exam Download 110-120

EnsurepassQUESTION 111 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. You define a Category class by writing the following code segment. (Line numbers are included for reference only.)   01 public class Category 02 { 03 public int CategoryID { get; set; } 04 public string CategoryName { get; set; } 05 public string Description { get; set; } 06 public byte[] Picture { Read more [...]

Latest Microsoft 70-516 Real Exam Download 101-110

EnsurepassQUESTION 101 You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application. You use the ADO.NET Entity Framework Designer to model entities. You need to create a Plain Old CLR Object (POCO) class that can be used with the ObjectContext.CreateObject method to create a proxy. What should you do?   A.       Create a custom data class that has a Protected constructor that does not have parameters. B.       Read more [...]

Latest Microsoft 70-516 Real Exam Download 91-100

EnsurepassQUESTION 91 You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application that uses the ADO.NET Entity Framework to model entities. You create an entity model as shown in the following diagram.     You need to ensure that all Person entities and their associated EmailAddresses are loaded. Which code segment should you use?   A.       var people = context.People.Include("EmailAddresses").ToList(); Read more [...]

Latest Microsoft 70-516 Real Exam Download 81-90

EnsurepassQUESTION 81 You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 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?   A.       Read more [...]

Latest Microsoft 70-516 Real Exam Download 61-70

EnsurepassQUESTION 71 The application user interface displays part names or color names in many places as '## Name ##'. You need to provide a method named FormattedName() to format part names and color names throughout the application. What should you do?   A.       Add the following code segment to the ExtensionMethods class in ExtensionMethods.cs: public static string FormattedName (this IName entity){ return string.Format("## {0} ##", entity.Name) Read more [...]

Latest Microsoft 70-516 Real Exam Download 51-60

EnsurepassQUESTION 61 You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application that connects to a Microsoft SQL Server 2008 database. You add the following table to the database.   CREATE TABLE ObjectCache ( Id INT IDENTITY PRIMARY KEY, SerializedObjectData XML)   You write the following code segment to retreive records from the ObjectCache table. (Line numbers are included for reference only.)   01 string s = GetConnectionStringFromConfigFile("xmldb"); Read more [...]

Latest Microsoft 70-516 Real Exam Download 41-50

EnsurepassQUESTION 51 You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create a Windows Communication Foundation (WCF) Data Services service. WCF Data Services uses an authentication scheme that requires an HTTP request that has the following header format:   GET /Odata.svc/Products(1) Authorization: WRAP access_token="123456789"   The application includes the following code. (Line numbers are included for reference only.)   01 public class Read more [...]

Latest Microsoft 70-516 Real Exam Download 31-40

EnsurepassQUESTION 31 Which class should you use to manage multiple tables and relationships among them?   A.       DataRow B.       DataView C.        DataTable D.       DataSet   Correct Answer: D     QUESTION 32 You want to set up a primary key on a column. Which properties on the data column must be set? (Each correct answer Read more [...]

Latest Microsoft 70-516 Real Exam Download 21-30

EnsurepassQUESTION 21 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 stores user names and passwords in the database. You need to ensure that users cannot read passwords extracted from the database. What should you do?   A.       Encrypt stored passwords by using the RC2CryptoServiceProvider class. B.       Read more [...]

Latest Microsoft 70-516 Real Exam Download 1-10

EnsurepassQUESTION 1 You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application. You manually create your own Context class named AdventureWorksDB that inherits from ObjectContext. You need to use AdventureWorksDB to invoke a stored procedure that is defined in the data source. Which method should you call?   A.        Translate B.        ExecuteFunction C.         Read more [...]