Online Access Free 070-523 Exam Questions

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. The
application connects to a Microsoft SQL Server database. The application uses the following object query
to load a product from the database. (Line numbers are included for reference only.)
01using (AdventureWorksEntities advWorksContext = new AdventureWorksEntities())
02{
03ObjectQuery <Product> productQuery = advWorksContext.Product.Where("it.ProductID = 900");
04
05}
You need to log the command that the query executes against the data source. Which code segment
should you insert at line 04?

• A.Trace.WriteLine(productQuery.CommandText);
• B.Trace.WriteLine(productQuery.ToString());
• C.Trace.WriteLine(productQuery.ToTraceString());
• D.Trace.WriteLine(((IQueryable)productQuery).Expression);

You are designing an ASP.NET Web application for content management.
You have the following requirements:
*Support multiple languages.
*Support dynamic changes to site content.
*Provide the ability to add content to the site without making changes to files within the application directory.
You need to recommend the application's source for retrieving content.
Which source should you recommend?

• A.global resources based on CurrentCulture
• B.local resources based on CurrentCulture
• C.a database based on CurrentUICulture
• D.a master page based on CurrentUICulture

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. The
application connects to a Microsoft SQL Server database. The application has two DataTable objects that
reference the Customers and Orders tables in the database. The application contains the following code
segment. (Line numbers are included for reference only.
01DataSet customerOrders = new DataSet();
02customerOrders.EnforceConstraints = true;
03ForeignKeyConstraint ordersFK = new ForeignKeyConstraint("ordersFK",
04customerOrders.Tables["Customers"].Columns["CustomerID"],
05customerOrders.Tables["Orders"].Columns["CustomerID"]);
06
07customerOrders.Tables["Orders"].Constraints.Add(ordersFK);
You need to ensure that an exception is thrown when you attempt to delete Customer records that have
related Order records. Which code segment should you insert at line 06?

• A.ordersFK.DeleteRule = Rule.Cascade;
• B.ordersFK.DeleteRule = Rule.SetDefault;
• C.ordersFK.DeleteRule = Rule.None;
• D.ordersFK.DeleteRule = Rule.SetNull;

You are developing an application to update a user's social status. You need to consume the service using
Windows Communication Foundation (WCF).
The client configuration is as follows.
<system.serviceModel>
<bindings>
<webHttpBinding>
<binding name="SocialConfig">
<security mode="TransportCredentialOnly">
<transport clientCredentialType="Basic"
?realm="Social API" />
</security>
</binding>
</webHttpBinding>
</bindings>
<client>
<endpoint address="http://contoso.com"
binding="webHttpBinding"
bindingConfiguration="SocialConfig"
contract="ISocialStatus"
name="SocialClient" />
</client> </system.serviceModel> The service contract is defined as follows. [ServiceContract] public interface ISocialStatus {
[OperationContract]
[WebInvoke(UriTemplate =
"/statuses/update.xml?status={text}")]
void UpdateStatus(string text); } Which code segment should you use to update the social status?

• A.using (WebChannelFactory<ISocialStatus> factory = new WebChannelFactory<ISocialStatus>(typeof(ISocialClient))) { factory.Credentials.Windows.ClientCredential.UserName = user.Name; factory.Credentials.Windows.ClientCredential.SecurePassword. SetAt(0, Convert.ToChar(user.Password)); ISocialStatus socialChannel = factory.CreateChannel();
  socialChannel.UpdateStatus(newStatus);
  }
• B.using (ChannelFactory<ISocialStatus> factory =
  new WebChannelFactory<ISocialStatus>(typeof(ISocialStatus)))
  {
  factory.Credentials.UserName.UserName = user.Name;
  factory.Credentials.UserName.Password = user.Password;
  ISocialStatus socialChannel = factory.CreateChannel();
  socialChannel.UpdateStatus(newStatus);
  }
• C.using (ChannelFactory<ISocialStatus> factory = new ChannelFactory<ISocialStatus>("POST")) { factory.Credentials.Windows.ClientCredential.UserName = user.Name; factory.Credentials.Windows.ClientCredential.SecurePassword. SetAt(0, Convert.ToChar(user.Password)); ISocialStatus socialChannel = factory.CreateChannel();
  socialChannel.UpdateStatus(newStatus);
  }
• D.using (WebChannelFactory<ISocialStatus> factory = new WebChannelFactory<ISocialStatus>("SocialClient"))
  {
  factory.Credentials.UserName.UserName = user.Name;
  factory.Credentials.UserName.Password = user.Password;
  ISocialStatus socialChannel = factory.CreateChannel();
  socialChannel.UpdateStatus(newStatus);
  }

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. The
application connects to a Microsoft SQL Server database. The application uses the following object query
to load a product from the database. (Line numbers are included for reference only.)
01using (AdventureWorksEntities advWorksContext = new AdventureWorksEntities())
02{
03ObjectQuery <Product> productQuery = advWorksContext.Product.Where("it.ProductID = 900");
04
05}
You need to log the command that the query executes against the data source. Which code segment
should you insert at line 04?

• A.Trace.WriteLine(productQuery.CommandText);
• B.Trace.WriteLine(productQuery.ToString());
• C.Trace.WriteLine(productQuery.ToTraceString());
• D.Trace.WriteLine(((IQueryable)productQuery).Expression);