Microsoft TS: Accessing Data with Microsoft .NET Framework 4 - 70-516무료 덤프문제 풀어보기

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

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

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

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

A. SqlDataAdapter dataAdapter2 = new SqlDataAdapter("UPDATE [BlogEntries] SET [BlogOwner] = "New
'Owner' 3", connection);
dataAdapter2.Update(BlogEntryDataSet, "BlogEntries");

B. SqlDataAdapter dataAdapter2 = new SqlDataAdapter(dataAdapterl.UpdateCommand); dataAdapter2.Fill(BlogEntryDataSet, "BlogEntries");

C. foreach(DataRow row in BlogEntryDataSet.Tables["BlogEntries"].Rows) {
row.Item["BlogOwner""] = "New Owner";
}
dataAdapter1.Update(BlogEntryDataSet, "BlogEntries");

D. foreach(DataRow row in BlogEntryDataSet.Tables["BlogEntries"].Rows) {
row.Item["BlogOwner""] = "New Owner";
}
dataAdapter1.Fill(BlogEntryDataSet, "BlogEntries");

A. context.MergeOption = MergeOption.OverwriteChanges;

B. context.MergeOption = MergeOption.NoTracking;

C. context.MergeOption = MergeOption.AppendOnly;

D. context.MergeOption = MergeOption.PreserveChanges;

A. var prods = ctx.ExecuteStoreQuery<Product>(prodQuery, new ObjectParameter("p0", "Road Bikes")).ToList();

B. var prods = ctx.CreateQuery<Product>(prodQuery, new ObjectParameter("p0", "Road Bikes")).ToList();

C. var prods = ctx.ExecuteFunction<Product>(prodQuery, new ObjectParameter("p0", "Road Bikes")).ToList();

D. var prods = ctx.ExecuteStoreCommand(prodQuery, new ObjectParameter("p0", "Road Bikes")).ToList();

A. ordersFK.DeleteRule = Rule.Cascade;

B. ordersFK.DeleteRule = Rule.None;

C. ordersFK.DeleteRule = Rule.SetNull;

D. ordersFK.DeleteRule = Rule.SetDefault;

A. Initial Catalog= SQL01\INST01

B. Data Source=SQL01\INST01

C. Initial Catalog= INST01\SQL01

D. Data Source=INST01\SQL01

A. Insert the following code segment at line 06:
Proxy.Credentials = new NetworkCredential("Authorization", "WRAP
access_token=\"123456789"\"");

B. Insert the following code segment at line 06:
Proxy.SendingRequest += new EventHandler<SendingRequestEventArgs>
(proxy_SendingRequest);
Insert the following code segment at line 09:
void proxy_SendingRequest(object sender, SendingRequestEventArgs e){ e.RequestsHeaders.Add("Authorization","WRAP access_token", "123456789"); }

C. Insert the following code segmen at line 06:
Proxy.Credentials = new NetworkCredential("WRAP access_token", "123456789");

D. Insert the following code segmen at line 06:
Proxy.SendingRequest += new EventHandler<SendingRequestEventArgs>
(proxy_SendingRequest);
Insert the following code segmen at line 09:
void proxy_SendingRequest(object sender, SendingRequestEventArgs e){
e.RequestsHeaders.Add("WRAP access_token", "123456789");
}

A. Option

B. Option

C. Option

D. Option

A. while(cust.EntityState == EntityState.Modified)
{
try
{
context.SaveChanges();
}
catch(Exception)
{
if(count++ > 2 && context.Connection.State ==
ConnectionState.Broken
{
throw new Exception();
}
}
}

B. while(count++ < 3)
{
try
{
context.SaveChanges();
break;
}
catch(Exception)
{
}
}

C. while(true)
{ context.SavingChanges += delegate(System.Object o, System.EventArgs e) {
if(count++ >2)
{
throw new Exception();
}
context.SaveChanges();
}
}

D. while(context.ObjextStateManager.GetObjectStateEntry (cust).OriginalValues.IsDBNull(0)) {
if(count++ >2)
{
break;
}
context.SaveChanges();
}

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

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

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

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

A. using (SqlConnection conn = new SqlConnection(connString))
{
conn.Open() ;
cmd.Connection = conn;
cmd.CommandText = updateStmt;
cmd.ExecuteNonQuery() ;
}

B. using (SqlConnection conn = new SqlConnection(connString))
{
cmd.Connection = conn;
cmd.CommandText = updateStmt;
cmd.ExecuteNonQuery();
cmd.Connection.Close();
}

C. SqlConnection conn = new SqlConnection(connString); conn.Open(); cmd.Connection = conn; cmd.CommandText = updateStmt; cmd.ExecuteNonQuery(); cmd.Connection.Close() ;

D. SqlConnection conn = new SqlConnection(connString); conn.Open(); cmd.Connection = conn; cmd.CommandText = updateStmt; cmd.ExecuteNonQuery();

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

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

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