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

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
You use a TableAdapter object to load a DataTable object.
The DataTable object is used as the data source for a GridView control to display a table of customer
information on a Web page.
You need to ensure that the application meets the following requirements:
-Load only new customer records each time the page refreshes.
-Preserve existing customer records. What should you do?

• A. Set the ClearBeforeFill property of the TableAdapter to true. Use the Fill method of the TableAdapter to load additional customers.
• B. Set the ClearBeforeFill property of the TableAdapter to false. Use the GetData method of the TableAdapter to create a new DataTable.
• C. Set the ClearBeforeFill property of the TableAdapter to true. Use the GetData method of the TableAdapter to create a new DataTable.
• D. Set the ClearBeforeFill property of the TableAdapter to false. Use the Fill method of the TableAdapter.

You use Microsoft .NET Framework 4.0 to develop an ASP.NET Web application that connects to a
Microsoft SQL Server 2008 database.
The application uses Integrated Windows authentication in Internet Information Services (IIS) to
authenticate users.
A connection string named connString defines a connection to the database by using integrated security.
You need to ensure that a SqlCommand executes under the application pool's identity on the database
server.
Which code segment should you use?

• A. using (var conn = new SqlConnection())
  {
  conn.ConnectionString = connString;
  SqlCommand cmd = null;
  using (HostingEnvironment.Impersonate())
  {
  cmd = new SqlCommand("SELECT * FROM BLOG", conn);
  }
  conn.Open();
  var result = cmd.ExecuteScalar();
  }
• B. using (var conn = new SqlConnection(connString))
  {
  var cmd = new SqlCommand ("SELECT * FROM BLOG, conn);
  conn.Open();
  using(HostingEnvironment.Impersonate())
  {
  var result = cmd.ExecuteScalar();
  }
  }
• C. using (var conn = new SqlConnection())
  {
  conn.ConnectionString = connString;
  var cmd = new SqlCommand("SELECT * FROM BLOG", conn);
  using (HostingEnvironment.Impersonate())
  {
  conn.Open();
  }
  var result = cmd.ExecuteScalar();
  }
• D. using (var conn = new SqlConneccion())
  {
  using (HostingEnvironroent.Impersonate())
  {
  conn.ConnectionString = connString;
  }
  var cmd = new SqlCommand("SELECT * FROM BLOG, conn);
  conn.Open() ;
  var result = cmd.ExecuteScalar();
  }

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 database includes a database table named ProductCatalog as shown in the exhibit:

You add the following code segment to query the first row of the ProductCatalog table. (Line numbers are included for reference only.)
01 using(SqlConnection cnx = new SqlConnection(connString)
02 {
03 var command = cnx.CreateCommand();
04 command.CommandType = CommandType.Text;
05 command.CommandText = "SELECT TOP 1 * FROM dbo.ProductCatalog";
06 cnx.Open();
07 var reader = command.ExecuteReader();
08 if (reader.Read())
09 {
10 var id = reader.GetInt32(0);
11 ...
12 reader.Close();
13 }
14 }
Which answer belongs in line 11?

• A. var weight = reader.GetDouble(1); var price = reader.GetDecimal(2); var status = reader.GetBoolean(3);
• B. var weight = reader.GetDouble(1); var price = reader.GetFloat(2); var status = reader.GetBoolean(3);
• C. var weight = reader.GetFloat(1); var price = reader.Doublel(2); var status = reader.GetByte(3);
• D. var weight
  = reader.GetFloat(1); var price = reader.GetDecimal(2); var status = reader.GetByte(3);

You are developing a WCF data service that will expose an existing Entity Data Model (EDM). You have the following requirements:
-Users must be able to read all entities that are exposed in the EDM.
-Users must be able to update or replace the SalesOrderHeader entities.
-Users must be prevented from inserting or deleting the SalesOrderHeader entities
You need to ensure that the data service meets the requirements. Which code segment should you use in the Initialize method?

• A. config.SetEntitySetAccessRule("*", EntitySetRights.AllRead); config.SetEntitySetAccessRule("SalesOrderHeader", EntitySetRights.WriteMerge | EntitySetRights.WriteReplace);
• B. config.SetEntitySetAccessRule("*", EntitySetRights.AllRead); config.SetEntitySetAccessRule("SalesOrderHeader", EntitySetRights.AllWrite);
• C. config.SetEntitySetAccessRule("*", EntitySetRights.AllRead); config.SetEntitySetAccessRule("SalesOrderHeader", EntitySetRights.All);
• D. config.SetEntitySetAccessRule("*", EntitySetRights.AllRead); config.SetEntitySetAccessRule("SalesOrderHeader", EntitySetRights.WriteAppend |
  EntitySetRights.WriteDelete);

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?

• A. Modify the application's Web.config file. Set the value for the customErrors element to RemoteOnly.
• B. Modify the application's Web.config file. Set the value for the customErrors element to Off.
• C. Add the FaultContract attribute to the class that implements the data service.
• D. Add the ServiceBehavior attribute to the class that implements the data service.