次の認定試験に速く合格する！

簡単に認定試験を準備し、学び、そして合格するためにすべてが必要だ。

会員センターカート (0)

070-516 無料問題集「Microsoft TS: Accessing Data with Microsoft .NET Framework 4」

ページ: 1 / 20
トータル 196 問

サインアップ、ログインされた後に、試験全体を無料で表示できるようになります。

質問 1

You are a tasked with performing a code review. The business rule is the following:
-If INSERTs into the first table succeed, then INSERT into the second table.
-However, if the INSERTs into the second table fail, roll back the inserts in the second table but do not roll back the inserts in the first table.
-Although this can also be done by way of regular transactions, It needs to be performed using
TransactionScope objects.
Whis code would fit this business rule?

（A）try
{ using (TransactionScope scope1 = new TransactionScope(TransactionScopeOption.Required)) {
...
}
using (TransactionScope scope2 = new TransactionScope(TransactionScopeOption.RequiresNew)) { .... } }

（B）try
{ using (TransactionScope scope1 = new TransactionScope(TransactionScopeOption.Required)) {
...
using (TransactionScope scope2 = new TransactionScope(TransactionScopeOption.RequiresNew))
{ .... }
......
}
}

（C）try
{ using (TransactionScope scope1 = new TransactionScope(TransactionScopeOption.Required)) {
....
try
{
.....
using (TransactionScope scope2 = new TransactionScope
(TransactionScopeOption.RequiresNew))
{ .... }
}
}
}

（D）try
{
using (TransactionScope scope1 = new TransactionScope(TransactionScopeOption)
{
....
try
{
.....
using (TransactionScope scope2 = new TransactionScope(TransactionScopeOption))
{ .... }
}
}
}

正解：C 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 2

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
The application connects to a Microsoft SQL Server database. The application uses the ADO.NET Entity
Framework to model entities.
The database includes objects based on the exhibit.
The application includes the following code segment. (Line numbers are included for reference only.)
01 using (AdventureWorksEntities context = new AdventureWorksEntities()){
02 ...
03 foreach (SalesOrderHeader order in customer.SalesOrderHeader){
04 Console.WriteLine(String.Format("Order: {0} ",
order.SalesOrderNumber));
05 foreach (SalesOrderDetail item in order.SalesOrderDetail){
06 Console.WriteLine(String.Format("Quantity: {0} ", item.Quantity));
07 Console.WriteLine(String.Format("Product: {0} ",
item.Product.Name));
08 }
09 }
10 }
You want to list all the orders for a specified customer. You need to ensure that the list contains the following fields:
-Order number
-Quantity of products
-Product name
Which code segment should you insert at line 02?

（A）Contact customer = (from contact in context.Contact
include("SalesOrderHeader") select conatct).FirstOrDefault();

（B）context.ContextOptions.LazyLoadingEnabled = true;
Contact customer = (from contact in context.Contact
include("SalesOrderHeader.SalesOrderDetail")
select conatct).FirstOrDefault();

（C）Contact customer = context.Contact.Where("it.ContactID = @customerId", new ObjectParameter ("customerId", customerId)).First();

（D）Contact customer = context.Contact.Where("it.ContactID = @customerId", new ObjectParameter ("@customerId", customerId)).First();

正解：C 解答を投票する

質問 3

Which one of these samples it the correct way to close the connection using Command Behavior?

（A）SqlDataReader rdr = new SqlDataReader(); string sql = @"sql statement"; SqlConnection conn = connection.GetConnection(); SqlCommand cmd = new SqlCommand(sql, conn); SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection); rdr.Close(); Console.WriteLine("{0}", rdr);

（B）SqlDataReader rdr = new SqlDataReader(); string sql = @"sql statement"; SqlConnection conn = connection.GetConnection(); SqlCommand cmd = new SqlCommand(sql, conn); SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection); Console.WriteLine("{0}", rdr);

（C）using (SqlDataReader rdr = new SqlDataReader())
{
string sql = @"sql statement";
SqlConnection conn = connection.GetConnection();
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
Console.WriteLine("{0}", rdr);
}

（D）SqlDataReader rdr = new SqlDataReader(); string sql = @"sql statement"; SqlConnection conn = connection.GetConnection(); SqlCommand cmd = new SqlCommand(sql, conn); SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection); conn.Close(); Console.WriteLine("{0}", rdr);

正解：A 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 4

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application. You use the Entity Framework Designer to create the following Entity Data Model.

You write a method named ValidatePostalCode to validate the postal code for the application.
You need to ensure that the ValidatePostalCode method is called before the PostalCode property set
method is completed and before the underlying value has changed.
Which code segment should you place in the entity's partial class?

（A）partial void OnPostalCodeChanged(string value) {
PostalCode = GetValidValue<string>(value, "ValidatePostalCode", false, true) ;
}

（B）public string ValidatedPostalCode
{
set
{
ValidatePostalCode(value);
_PostalCode = value;
}
get
{
return _PostalCode;
}
}

（C）partial void OnPostalCodeChanging(string value) {
ValidatePostalCode(value);
}

（D）public string ValidatedPostalCode
{
set
{
_PostalCode = StructuralObject.SetValidValue("ValidatePostalCode", false);
}
get
{
return _PostalCode;
}
}

正解：C 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 5

You use Microsoft .NET Framework 4.0 to develop an application that connects to a Microsoft SQL Server
2008 database.
You need to prevent dirty or phantom reads. Which IsolationLevel should you use?

（A）Snapshot

（B）Serializable

（C）ReadCommited

（D）ReadUncommited

正解：A 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 6

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. You add the following store procedure
to the database.
CREATE PROCEDURE GetSalesPeople AS BEGIN
SELECT FirstName, LastName, Suffix, Email, Phone FROM SalesPeople END
You write the following code segment. (Line numbers are included for reference only.)
01 SqlConnection connection = new SqlConnection("...");
02 SqlCommand command = new SqlCommand("GetSalesPeople", connection);
03 command.CommandType = CommandType.StoredProcedure;
04 ...
You need to retreive all of the results from the stored procedure. Which code segment should you insert at line 04?

（A）var res = command.ExecuteScalar();

（B）var res = command.ExecuteXmlReader();

（C）var res = command.ExecuteNonQuery();

（D）var res = command.ExecuteReader();

正解：D 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 7

You use Microsoft Visual Studio 2010 and the Microsoft .NET Framework 4.0 to create an application.
The application connects to a Microsoft SQL Server database. The application uses DataContexts to query
the database.
You define a foreign key between the Customers and Orders tables in the database.
You need to ensure that when you delete a customer record, the corresponding order records are deleted.
You want to achieve this goal by using the minimum amount of development effort. What should you do?

（A）Override the Delete operation of the customer entity.

（B）Use the ExecuteDynamicDelete method of the DataContext object.

（C）Modify the foreign key between the Customers and Orders tables to enable the ON DELETE CASCADE option.

（D）Remove the foreign key between the Customers and Orders tables.

正解：C 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 8

You use Microsoft Visual Studio 2010 and .NET Framework 4.0 to develop an application that uses the
Entity Framewok.
You need to execute custom logic when an entity is attached to the ObjectContext. What should you do?

（A）Create a partial method named OnStateChanged in the partial class for the entity.

（B）Create a partial method named OnAttached in the partial class for the entity.

（C）Create an event handler to handle the ObjectStateManagerChanged event.

（D）Create an event handler to handle the ObjectMaterialized event.

正解：C 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 9

You use Microsoft .NET Framework 4.0 to develop an application that connects to a local Microsoft SQL
Server 2008 database.
The application can access a high-resolution timer. You need to display the elapsed time, in sub-
milliseconds (<1 millisecond),
that a database query takes to execute. Which code segment should you use?

（A）DateTime Start = DateTime.UtcNow; command.ExecuteNonQuery(); TimeSpan Elapsed = DateTime.UtcNow - Start; Console.WriteLine("Time Elapsed: {0:N} ms", Elapsed.Milliseconds);

（B）Stopwatch sw = Stopwatch.StartNew(); command.ExecuteNonQuery() ; sw.Stop() ; Console.WriteLine("Time Elapsed: {0:N} ms", sw.Elapsed.TotalMilliseconds);

（C）Stopwatch sw = new Stopwatch(); sw.Start() ; command.ExecuteNonQuery(); sw.Stop(); Console.WriteLine("Time Elapsed: {0:N} ms", sw.Elapsed.Milliseconds);

（D）int Start = Environment.TickCount; command.ExecuteNonQuery(); int Elapsed = (Environment.TickCount) - Start; Console.WriteLine("Time Elapsed: {0:N} ms", Elapsed);

正解：C 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 10

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create a Windows
Communication Foundation (WCF) Data Services service.
WCF Data Services uses an authentication scheme that requires an HTTP request that has the following
header format:
GET /Odata.svc/Products(1)
Authorization: WRAP access_token="123456789"
The application includes the following code. (Line numbers are included for reference only.)
01 public class program
02 {
03 Public void GetProducts()
04 {
05 var proxy = new MyDataServiceContext("...");
06 ...
07 }
08 }
You need to ensure that the correct authentication header is present when requests are made by using
MyDataServiceContext.
What should you do?

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

（B）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");
}

（C）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"); }

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

正解：C 解答を投票する

ページ: 1 / 20
トータル 196 問

070-516 の機能をすべて解除する

キャプチャ不要
365日無料更新サービス
希望する合格率を設定できる
時間の割り当てられる（時間：分）
070-516 に2つの練習用モード
サポートサービス対応

完全版を入手する

弊社を連絡する

我々は１２時間以内ですべてのお問い合わせを答えます。

オンラインサポート時間：( UTC+9 ) 9:00-24:00
月曜日から土曜日まで

サポート：現在連絡

トップ試験

CRM-Analytics-and-Einstein-Discovery-Consultant 試験問題集
500-710 試験問題集
ATM 試験問題集
Community-Cloud-Consultant 試験問題集
FCP_FAZ_AD-7.4 試験問題集
B2C-Commerce-Architect 試験問題集

070-516 無料問題集「Microsoft TS: Accessing Data with Microsoft .NET Framework 4」

弊社を連絡する

関連リンク

トップ試験