70-516試験無料問題集（196題）「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.
You use the ADO.NET Entity Framework to manage persistence-ignorant entities. You create an
ObjectContext instance named context.
Then, you directly modify properties on several entities. You need to save the modified entity values to the
database.
Which code segment should you use?

A. context.SaveChanges();

B. context.SaveChanges(SaveOptions.None);

C. context.SaveChanges(SaveOptions.AcceptAllChangesAfterSave);

D. context.SaveChanges(SaveOptions.DetectChangesBeforeSave);

正解：D 解答を投票する

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

出題：2

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create a Microsoft ASP.NET
application.
You want to connect the application to a Microsoft SQL Server Express 2008 database named
MyDatabase.
The primary database file is named MyDatabase.mdf and it is stored in the App_Data folder.
You need to define the connection string. Which connection string should you add to the Web.config file?

A. Data Source=localhost; Initial Catalog=MyDataBase; Integrated Security=SSPI; User Instance=True

B. Data Source=.\SQLEXPRESS; AttachDbFilename=|DataDirectory|\MyDatabase.mdf; Integrated Security=True; User Instance=True

C. Data Source=.\SQLEXPRESS; AttachDbFilename=|DataDirectory|\App_Data\MyDatabase.mdf; Integrated Security=SSPI; User Instance=True

D. Data Source=.\SQLEXPRESS; Initial Catalog=MyDataBase; Integrated Security=True; User Instance=True

正解：B 解答を投票する

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

出題：3

You need to write a LINQ query that can be used against a ContosoEntities context object named context to
find all
parts that have a duplicate name. Which of the following queries should you use?
(Each correct answer presents a complete solution. Choose two).

A. context.Parts.Where(p => context.Parts.Any(q => q.Name == p.Name && p.Id != q.Id);

B. context.Parts.SelectMany(p => context.Parts.Select(q => p.Name == q.Name && p.Id != q.Id));

C. context.Parts.GroupBy(p => p.Name).Where(g => g.Count() > 1).SelectMany(x => x);

D. context.Parts.Any(p => context.Parts.Any(q => p.Name == q.Name));

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

出題：4

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
The application updates several Microsoft SQL Server databases within a single transaction.
You need to ensure that after a resource failure, you can manage unresolved transactions. What should
you do?

A. Call the Reenlist method of the TransactionManager class.

B. Call the RecoveryComplete method of the TransactionManager class.

C. Call the EnlistVolatile method of the Transaction class.

D. Call the EnlistDurable method of the Transaction class.

正解：A 解答を投票する

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

出題：5

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application.
You use the ADO.NET Entity Framework Designer to model entities.
You need to ensure that the entities are self-tracking. What should you do in the ADO.NET Entity
Framework Designer?

A. Change the Code Generation Strategy option from Default to None.

B. Add an ADO.NET Self-Tracking Entity Generator to the model.

C. Add an ADO.NET EntityObject Generator to the model.

D. Change the Transform Related Text Templates On Save option to False.

正解：B 解答を投票する

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

出題：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 need to use a spatial value type as a parameter for your database query. What should you do?

A. Set the parameter's SqlDbType to Structured. Set the parameter's TypeName to GEOMETRY.

B. Set the parameter's SqlDbType to Udt. Set the parameter's UdtTypeName to GEOMETRY.

C. Set the parameter's SqlDbType to Variant.

D. Set the parameter's SqlDbType to Binary.

正解：B 解答を投票する

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

出題：7

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create a Windows
Communication Foundation (WCF) Data Services service.
The service connects to a Microsoft SQL Server 2008 database. The service is hosted by an Internet
Information Services (IIS) 6.0 Web server.
The application works correctly in the development environment. However, when you connect to the service
on
the production server, attempting to update or delete an entity results in an error.
You need to ensure that you can update and delete entities on the production server. What should you do?

A. Add the following line of code to the InitializeService method of the service: config.SetEntitySetAccessRule ("*", EntitySetRights.WriteDelete | EntitySetRights.WriteMerge);

B. Add the following line of code to the InitializeService method of the service: config.SetEntitySetAccessRule ("*", EntitySetRights.WriteDelete | EntitySetRights.WriteInsert);

C. Configure IIS to allow the POST and DELETE verbs for the .svc Application Extension.

D. Configure IIS to allow the PUT and DELETE verbs for the .svc Application Extension.

正解：D 解答を投票する

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

出題：8

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 need to ensure that the application calls a stored procedure that accepts a table-valued parameter.
You create a SqlParameter object. What should you do next?

A. Set the SqlDbType of SqlParameter to Variant.

B. Set the SqlDbType of SqlParameter to Structured. Set the TypeName of SqlParameter to Udt.

C. Set the ParameterDirection of SqlParameter to Output.

D. Set the SqlDbType of SqlParameter to Udt.

正解：B 解答を投票する

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

出題：9

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.Element("bib").Elements() .SelectMany(el => el.Elements() .Where(e2 => (string)e2 == "Author1"));

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

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

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

正解：B 解答を投票する

70-516試験無料問題集「Microsoft TS: Accessing Data with Microsoft .NET Framework 4 認定」