Microsoft TS: Accessing Data with Microsoft .NET Framework 4 - 070-516 Exam Practice Test

A. DataSet ds = new DataSet(); DataTable dt = ds.Tables.Add("Product"); adapter.Fill(0, 10, dt);

B. DataSet ds = new DataSet(); ds.ExtendedProperties["RowCount"] = 10; ds.ExtendedProperties["RowIndex"] = 0; adapter.Fill(ds);

C. DataSet ds = new DataSet(); DataTable dt = ds.Tables.Add("Product"); dt.ExtendedProperties["RowCount"] = 10; dt.ExtendedProperties["RowIndex"] = 0; adapter.Fill(dt);

D. DataSet ds = new DataSet(); adapter.Fill(ds, 0, 10, "Product");

A. Navigate to the GetActiveProducts stored procedure in Server Explorer, and drag the procedure onto the Product entity in the LINQ to SQL model designer surface.

B. Select the Product entity, view the entity's property window, and change the Name for the entity to GetActiveProducts.

C. Add a property named GetActiveProducts to the Product entity.

D. Select the Product entity, view the entity's property window, and change the Source for the entity to GetActiveProducts.

A. try {
context.SaveChanges();
}
catch(OptimisticConcurrencyException ex)
{
context.Refresh(RefreshMode.ClientWins, loadedCustomer);
}

B. try {
context.SaveChanges();
}
catch(EntitySqlException ex)
{
context.Refresh(RefreshMode.StoreWins, loadedCustomer);
}

C. try {
context.SaveChanges();
}
catch(EntitySqlException ex)
{
context.Refresh(RefreshMode.ClientWins, loadedCustomer);
}

D. try {
context.SaveChanges();
}
catch(OptimisticConcurrencyException ex)
{
context.Refresh(RefreshMode.StoreWins, loadedCustomer);
}

A. Set the value of the .edmx file's Metadata Artifact Processing property to Copy to Output Directory.

B. Set the value of the .edmx file's Build Action property to Copy to Output.

C. Modify the connection string in the application's .config file to refer to the relative path to the .edmx file.

D. Modify the connection string in the application's .config file to refer to the absolute physical path to the .edmx file.

A. MD5CryptoServiceProvider

B. DSACryptoServiceProvider

C. SHA1CryptoServiceProvider

D. AESCryptoServiceProvider

A. 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.

B. 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.

C. 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".

D. Create a SubEntity named Address. Map the SubEntity to a stored procedure that retrieves city, region, and country.

A. using(SqlConnection cnn = new SqlConnection(strCnn)) { try { SqlCommand cmd = new SqlCommand(sql, cnn); cnn.Open(); dr = cmd.ExecuteReader(); } catch {
throw;
}
}

B. SqlConnection cnn = new SqlConnection(strCnn); SqlCommand cmd = new SqlCommand(sql, cnn); cnn.Open(); { try { dr = cmd.ExecuteReader(); cnn.Close(); } catch {
throw;
}
}

C. SqlConnection cnn = new SqlConnection(strCnn); SqlCommand cmd = new SqlCommand(sql, cnn);
cnn.Open();
{
try
{
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
}
catch
{
cnn.Close();
throw;
}
}

D. SqlConnection cnn = new SqlConnection(strCnn); SqlCommand cmd = new SqlCommand(sql, cnn); cnn.Open(); { try { dr = cmd.ExecuteReader(); } finally {
cnn.Close();
}
}

A. Contact customer = context.Contact.Where("it.ContactID = @customerId", new ObjectParameter("customerId", customerId)).First(); customer.SalesOrderHeader.Load(); foreach (SalesOrderHeader order in customer.SalesOrderHeader) {
if (order.OrderDate.Date == DateTime.Today.Date)
{
order.SalesOrderDetail.Load();
foreach (SalesOrderDetail item in order.SalesOrderDetail)
{
Console.WriteLine(String.Format("Product: {0} ", item.ProductID)); } } }

B. Contact customer = (from contact in context.Contact.Include ("SalesOrderHeader") select contact).FirstOrDefault(); foreach (SalesOrderHeader order in customer.SalesOrderHeader) {
order.SalesOrderDetail.Load();
if (order.OrderDate.Date == DateTime.Today.Date)
{
foreach (SalesOrderDetail item in order.SalesOrderDetail)
{
Console.WriteLine(String.Format("Product: {0} ", item.ProductID)); } } }

C. Contact customer = (from contact in context.Contact.Include ("SalesOrderHeader.SalesOrderDetail") select contact).FirstOrDefault(); foreach (SalesOrderHeader order in customer.SalesOrderHeader) {
if (order.OrderDate.Date == DateTime.Today.Date)
{
foreach (SalesOrderDetail item in order.SalesOrderDetail)
{
Console.WriteLine(String.Format("Product: {0} ", item.ProductID)); } } }

D. Contact customer = context.Contact.Where("it.ContactID = @customerId", new ObjectParameter("customerId", customerId)).First(); customer.SalesOrderHeader.Load(); foreach (SalesOrderHeader order in customer.SalesOrderHeader) {
order.SalesOrderDetail.Load();
if (order.OrderDate.Date == DateTime.Today.Date)
{
foreach (SalesOrderDetail item in order.SalesOrderDetail) { Console.WriteLine(String.Format("Product: {0} ", item.ProductID)); } } }

A. SByte obj = (SByte)rdr[1];

B. String obj = (String)rdr[1];

C. XmlReader obj = (XmlReader)rdr[1];

D. Type obj = (Type)rdr[1];

A. AdvWorksDataContext dc = new AdvWorksDataContext("...");
var prod = from p in dc.Products
where p.Color == "Black, Red"
select p;
foreach(var product in prod){
product.ListPrice = product.StandardCost * 1.5M;
}
dc.SubmitChanges();

B. string[] colorList = new string[] {"Black", "Red"}; AdvWorksDataContext dc = new AdvWorksDataContext(); var prod = from p in dc.Products
where colorList.Contains(p.Color)
select p;
foreach(var product in prod){
product.ListPrice = product.StandardCost * 1.5M;
}
dc.SubmitChanges();

C. AdvWorksDataContext dc = new AdvWorksDataContext("..."); var prod = from p in dc.Products
select p;
var list = prod.ToList();
foreach(Product product in list){
if(product.Color == "Black, Red"){
product.ListPrice = product.StandardCost * 1.5M;
}
}
dc.SubmitChanges();

D. AdvWorksDataContext dc = new AdvWorksDataContext("..."); var prod = from p in dc.Products
select p;
var list = prod.ToList();
foreach(Product product in list){
if((product.Color == "Black) && (product.Color == "Red")){
product.ListPrice = product.StandardCost * 1.5M;
}
}
dc.SubmitChanges();

A. protected List <Product> Products { get; set; }

B. public abstract List <Product> Products { get; set; }

C. public static List <Product> Products { get; set; }

D. public virtual List <Product> Products { get; set; }

A. adapter.TableMappings.Add("Table", "App_Products"); adapter.TableMappings.Add("Table1", "App_Categories"); adapter.Fill(ds);

B. adapter.Fill(ds.Tables["App_Products"]); adapter.Fill(ds.Tables["App_Categories"]);

C. adapter.TableMappings.Add("Products", "App_Products"); adapter.TableMappings.Add("Categories", "App_Categories"); adapter.Fill(ds);

D. adapter.Fill(ds, "Products"); adapter.Fill(ds, "Categories");

A. Add the following code segment before calling SaveChanges() on context2:
context2.ApplyOriginalValues("Parts", part1);

B. Add the following code segment before calling SaveChanges() on context2:
context2.Attach(part1);
context2.ObjectStateManager.ChangeObjectState(part1,
System.Data.EntitySate.Modified);

C. Add the following code segment before calling SaveChanges() on context2:
context2.ApplyCurrentValues("Parts", part1);

D. Add the following code segment before calling SaveChanges() on context2:
context2.Attach(part1);
context2.ApplyCurrentValues("Parts", part1);

A. Create a new ObjectQuery that uses MyBaseClass as the type parameter.

B. Use the ADO.NET EntityObject Generator template to configure all entities to inherit from MyBaseClass.

C. Modify the generated code file so that all entities inherit from MyBaseClass.

D. Change MyBaseClass to inherit from ObjectContext.