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

質問 1

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 stores user names and
passwords in the database.
You need to ensure that users cannot read passwords extracted from the database. What should you do?

（A）Encrypt stored passwords by using the RC2CryptoServiceProvider class.

（B）Append a random salt to the password by using the RNGCryptoServiceProvider class. Encrypt stored passwords by using the RijndaelManaged class.

（C）Append a random salt to the password by using the RNGCryptoServiceProvider class. Hash stored passwords by using the SHA1CryptoServiceProvider class.

（D）Encrypt stored passwords by using the TripleDESCryptoServiceProvider class.

正解：C 解答を投票する

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

質問 2

You use Microsoft .NET Framework 4.0 to develop an application that connects to a Microsoft SQL Server
2008 database.
The application uses nested transaction scopes. An inner transaction scope contains code that inserts
records into the database.
You need to ensure that the inner transaction can successfully commit even if the outer transaction rolls
back.
What are two possible TransactionScope constructors that you can use for the inner transaction to achieve
this goal?
(Each correct answer presents a complete solution. Choose two.)

（A）TransactionScope(TransactionScopeOption.Suppress)

（B）TransactionScope(TransactionScopeOption.Required)

（C）TransactionScope(TransactionScopeOption.RequiresNew)

（D）TransactionScope()

正解：A、C 解答を投票する

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

質問 3

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create a Windows Forms
application.
The application connects to a Microsoft SQL Server database.
You need to find out whether the application is explicitly closing or disposing SQL connections. Which code
segment should you use?

（A）string instanceName = Assembly.GetEntryAssembly().FullName; PerformanceCounter perf = new PerformanceCounter( ".NET Data Provider for SqlServer",
"NumberOfNonPooledConnections", instanceName, true); int leakedConnections = (int)perf.NextValue();

（B）string instanceName = Assembly.GetEntryAssembly().GetName().Name; PerformanceCounter perf = new PerformanceCounter( ".NET Data Provider for SqlServer",
"NumberOfNonPooledConnections", instanceName, true); int leakedConnections = (int)perf.NextValue();

（C）string instanceName = Assembly.GetEntryAssembly().FullName; PerformanceCounter perf = new PerformanceCounter( ".NET Data Provider for SqlServer",
"NumberOfReclaimedConnections", instanceName, true); int leakedConnections = (int)perf.NextValue();

（D）string instanceName = Assembly.GetEntryAssembly().GetName().Name; PerformanceCounter perf = new PerformanceCounter( ".NET Data Provider for SqlServer",
"NumberOfReclaimedConnections", instanceName, true); int leakedConnections = (int)perf.NextValue();

正解：C 解答を投票する

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

質問 4

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 メンバーにのみ表示されます)

質問 5

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application. The application contains the following XML document:
<bib> <book title="TCP/IP Illusrated" year="1994">
<author>Author1</author>
</book>
<book title="Programming in UNIX" year="1992">
<author>Author1</author>
<author>Author2</author>
<author>Author3</author>
</book>
<book title="Data on the web" year="2000">
<author>Author4</author>
<author>Author3</author>
</book> </bib>
You add the following code fragment. (Line numbers are included for reference only.)
01 public IEnumerable<XElement> GetBooks(string xml)
02 {
03 XDocument doc = XDocument.Parse(xml);
04 ...
05 }
You need to return a list of book XML element that are authored by Author1. Which code segment should you insert at line 04?

（A）return doc.Elements("bib").Elements() .Where(e1 => e1.Elements().Any(e2 => (string)e2 == "Author1"));

（B）return doc.Elements("bib").Elements()
.Where(e1 => e1.Elements().Any(e2 => e2.Equals(new XElement("author", "Author1"))));

（C）return doc.Element("bib").Elements() .SelectMany(el => el.Elements() .Where(e2 => (string)e2 == "Author1"));

（D）return doc.Element("bib").Elements() .SelectMany(el => el.Elements() .Where(e2 => e2.Equals(new XElement("author", "Author1"))));

正解：A 解答を投票する

質問 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 use the ADO.NET Entity Framework to model your entities. You use ADO.NET self-tracking entities.
You need to ensure that the change-tracking information for the self-tracking entities can be used to update
the database.
Which ObjectContext method should you call after changes are made to the entities?

（A）ApplyChanges

（B）SaveChanges

（C）Refresh

（D）Attach

正解：A 解答を投票する

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

質問 7

You use Microsoft .NET Framework 4.0 to develop an ASP.NET application. The application uses
Integrated Windows authentication.
The application accesses data in a Microsoft SQL Server 2008 database that is located on the same server
as the application.
You use the following connection string to connect to the database.
Integrated Security=SSPI; Initial Catalog=AdventureWorks;
The application must also execute a stored procedure on the same server on a database named pubs.
Users connect to the ASP.NET application through the intranet by using Windows-based authentication.
You need to ensure that the application will use connection pooling whenever possible and will keep the
number of pools to a minimum.
Which code segment should you use?

（A）command.CommandText = "USE [pubs]; exec uspLoginAudit;"; using (SqlConnection connection = new SqlConnection( "Integrated Security=SSPI; Initial Catalog=AdventureWorks")) {
connection.Open();
command.ExecuteNonQuery();
}

（B）command.CommandText = "exec uspLoginAudit;";
using (SqlConnection connection = new SqlConnection( "Integrated Security=SSPI;")) {
connection.Open();
command.ExecuteNonQuery();
}

（C）command.CommandText = "USE [pubs]; exec uspLoginAudit;"; using (SqlConnection connection = new SqlConnection( "Initial Catalog=AdventureWorks; Integrated Security=SSPI; MultipleActiveResultSets=True")) {
connection.Open();
command.ExecuteNonQuery();
}

（D）command.CommandText = "exec uspLoginAudit;"; using (SqlConnection connection = new SqlConnection( "Integrated Security=SSPI; Initial Catalog=pubs")) {
connection.Open();
command.ExecuteNonQuery();
}

正解：A 解答を投票する

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

質問 8

You use Microsoft Visual Studio 2010 and .NET Framework 4.0 to develop an application.
You use entity Framework Designer to create an Entity Data Model from an existing database by using the
Generate From Database wizard.
The model contains an entity type named Product. The Product type requires an additional property that is
not mapped to database colomn.
You need to add the property to product. What should you do?

（A）Create a comlex type with the name of the property in the Entity Framework Designer.

（B）Add the property in the generated class file, and select Run Custom Tool from the solution menu.

（C）Add the property in a partial class named Product in a new source file.

（D）Create a function import with the name of property in the Entity Framework Designer.

正解：C 解答を投票する

質問 9

The application populates a DataSet object by using a SqlDataAdapter object.
You use the DataSet object to update the Categories database table in the database. You write the
following code segment.
(Line numbers are included for reference only.)
01 SqlDataAdapter dataAdpater = new SqlDataAdapter("SELECT CategoryID,
CategoryName FROM Categories", connection);
02 SqlCommandBuilder builder = new SqlCommandBuilder(dataAdpater);
03 DataSet ds = new DataSet();
04 dataAdpater.Fill(ds);
05 foreach (DataRow categoryRow in ds.Tables[0].Rows)
06 {
07 if (string.Compare(categoryRow["CategoryName"].ToString(), searchValue,
true) == 0)
08 {
09 ...
10 }
11 }
12 dataAdpater.Update(ds);
You need to remove all the records from the Categories database table that match the value of the
searchValue variable.
Which line of code should you insert at line 09?

（A）categoryRow.Delete();

（B）ds.Tables[0].Rows.Remove(categoryRow);

（C）ds.Tables[0].Rows.RemoveAt(0);

（D）ds.Tables[0].Rows[categoryRow.GetHashCode()].Delete();

正解：A 解答を投票する

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

質問 10

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 LINQ to SQL model to retrieve data from the database.
The application will not modify retrieved data. You need to ensure that all the requested data is retrieved.
You want to achieve this goal using the minimum amount of resources. What should you do?

（A）Set ObjectTrackingEnabled to false on the DataContext class.

（B）Set DeferredLoadingEnabled to true on the DataContext class.

（C）Set ObjectTrackingEnabled to true on the DataContext class.

（D）Set DeferredLoadingEnabled to false on the DataContext class.

正解：A 解答を投票する

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

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

弊社を連絡する

関連リンク

トップ試験