070-516 試験問題を無料オンラインアクセス

The application user interface displays part names or color names in many plases 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 segmend to the Part class in Part.cs:
  public string FormattedName(){
  return string.Format("## {0} ##", this.Name);
  }
• B.Add the following code segmend to the Color class in Color.cs:
  public string FormattedName(){
  return string.Format("## {0} ##", this.Name);
  }
• C.Add the following code segment to the ExtensionMethods class in ExtensionMethods.cs:
  public static string FormattedName (this Part entity){
  return string.Format("## {0} ##", entity.Name)
  }
• D.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)
  }
• E.Add the following code segment to the ExtensionMethods class in ExtensionMethods.cs:
  public static string FormattedName (this Color entity){
  return string.Format("## {0} ##", entity.Name)
  }

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
You use Microsoft ADO.NET Entity Data Model (EDM) to model entities.
You create an entity named Person with a schema defined by the following XML fragment.
<EntityType Name="CPerson"> <Key> <PropertyRef Name="PersonId" /> </Key>
<Property Name="PersonId" Type="Int32" Nullable="false" />
<Property Name="CompanyName" Type="String" />
<Property Name="ContactName" Type="String" />
<Property Name="ContactTitle" Type="String" />
<Property Name="Address" Type="String" />
</EntityType>
You need to ensure that entities within the application are able to add properties related to the city, region,
and country of Person's address.
What should you do?

• A.Create a SubEntity named Address. Map the SubEntity to a stored procedure that retrieves city, region, and country.
• B.Create a new entity named Address. Add a person ID property to filter the results to display only the City, Region, and Country properties for a specific Person entity.
• C.Create a view named Name that returns city, region, and country along with person IDs. Add a WHERE clause to filter the results to display only the City, Region and Country properties for a specific Person entity.
• D.Create a new complex type named CAddress that contains the properties for city, region, and country. Change the Type of the Address property in CPerson to "Self.CAddress".

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create a Windows
Communication Foundation (WCF) Data Services service.
The service connects to a Microsoft SQL Server 2008 database. The service is hosted by an Internet
Information Services (IIS) 6.0 Web server.
The application works correctly in the development environment. However, when you connect to the service
on
the production server, attempting to update or delete an entity results in an error.
You need to ensure that you can update and delete entities on the production server. What should you do?

• A.Add the following line of code to the InitializeService method of the service: config.SetEntitySetAccessRule ("*", EntitySetRights.WriteDelete | EntitySetRights.WriteMerge);
• B.Configure IIS to allow the POST and DELETE verbs for the .svc Application Extension.
• C.Configure IIS to allow the PUT and DELETE verbs for the .svc Application Extension.
• D.Add the following line of code to the InitializeService method of the service: config.SetEntitySetAccessRule ("*", EntitySetRights.WriteDelete | EntitySetRights.WriteInsert);

You use Microsoft Visual Studio 2010 and .NET Framework 4.0 to create an application.
The application connects to a Microsoft SQL Server 2008 database. The application contains the following
code segment.
string SQL = string.Format("SELECT * FROM Customer WHERE CompanyName LIKE '%
{0}%', companyName);
var cmd = new SqlCommand(SQL, con);
You need to reduce the vulnerability to SQL injection attacks. Which code segment should you use?

• A.string SQL = "SELECT * FROM Customer Where " + "CompanyName LIKE @companyName"; var cmd = new SqlCommand(SQL,con); cmd.Parameters.AddWithValue("@companyName", string.Format("%{0}%", companyName));
• B.string SQL = "SELECT * FROM Customer Where " + "CompanyName LIKE @companyName"; var cmd = new SqlCommand(SQL,con); var param = new SqlParameter ("@companyName", string.Format("%{0}%", companyName));
• C.string SQL = string.Format("SELECT * FROM " + " Customer Where CompanyName LIKE {0}",
  new SqlCommand("@companyName", string.format("%{0}%", companyName))); var cmd = new SqlCommand(SQL, con);
• D.string SQL = "SELECT" * FROM Customer @companyName; var cmd = new sqlcommand(SQL,con); cmd.Parameters.AddWithValue("companyName", string.format("where companyName LIKE '%{0}%'", companyName));

You are developing a new feature that displays an auto-complete list to users as the type color names. You
have an
existing ContosoEntities context object named contex.
To support the new feature you must develop code that will accept a string object named text containing a
user's
partial input and will query the Colors database table to retrieve all color names that begin with that input.
You need to create an Entity SQL (ESQL) query to meet the requirement.
The query must not be vulnerable to a SQL injection attack. Which code segment should you use?

• A.var parameter = new ObjectParameter("text", HttpUtility.HtmlEncode(text) + "%"); var result = context.CreateQuery<string>(
  "SELECT (c.Name) FROM Colors AS c WHERE c.Name LIKE '@text'@, parameter);
• B.var parameter = new ObjectParameter("text", text + "%");
  var result = context.CreateQuery<string>(
  "SELECT VALUE (c.Name) FROM Colors AS c WHERE c.Name LIKE @text",
  parameter);
• C.var parameter = new ObjectParameter("text", text + "%"); var result = context.CreateQuery<string>(
  "SELECT VALUE (c.Name) FROM Colors AS c WHERE c.Name LIKE '@text'", parameter);
• D.var parameter = new ObjectParameter("text", text + "%");
  var result = context.CreateQuery<string>( "SELECT (c.Name) FROM Colors AS c WHERE c.Name LIKE @text", parameter);