[2026] Microsoft TS: Accessing Data with Microsoft .NET Framework 4

문제1

You use Microsoft Visual Studio 2010 and .NET Framework 4.0 to create an application.
The application connects to a Microsoft SQL Server 2008 database. The application contains the following
code segment.
string SQL = string.Format("SELECT * FROM Customer WHERE CompanyName LIKE '%
{0}%', companyName);
var cmd = new SqlCommand(SQL, con);
You need to reduce the vulnerability to SQL injection attacks. Which code segment should you use?

A. string SQL = "SELECT * FROM Customer Where " + "CompanyName LIKE @companyName"; var cmd = new SqlCommand(SQL,con); cmd.Parameters.AddWithValue("@companyName", string.Format("%{0}%", companyName));

B. string SQL = string.Format("SELECT * FROM " + " Customer Where CompanyName LIKE {0}",
new SqlCommand("@companyName", string.format("%{0}%", companyName))); var cmd = new SqlCommand(SQL, con);

C. string SQL = "SELECT" * FROM Customer @companyName; var cmd = new sqlcommand(SQL,con); cmd.Parameters.AddWithValue("companyName", string.format("where companyName LIKE '%{0}%'", companyName));

D. string SQL = "SELECT * FROM Customer Where " + "CompanyName LIKE @companyName"; var cmd = new SqlCommand(SQL,con); var param = new SqlParameter ("@companyName", string.Format("%{0}%", companyName));

정답: A

설명: (Fast2test 회원만 볼 수 있음)

문제2

You use Microsoft .NET framework 4.0 to develop an application that connects to a Microsoft SQL Server
2008 database named AdventureWorksLT.
The database resides on an instance named INSTA on a server named SQL01.
You need to configure the application to connect to the database. Which connection string should you add
to the .config file?

A. Data Source=SQL01; Initial Catalog=AdventureWorksLT; Integrated Security=true; Application Name=INSTA;

B. Data Source=AdventureWorksLT; Initial Catalog=SQL01\INSTA; Integrated Security=true;

C. Data Source=SQL01; Initial Catalog=INSTA; Integrated Security=true; Application Name=AdventureWorksLT;

D. Data Source=SQL01\INSTA; Initial Catalog=AdventureWorksLT; Integrated Security=true;

정답: D

설명: (Fast2test 회원만 볼 수 있음)

문제3

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application that
connects to a Microsoft SQL Server 2008 database.
You use the ADO.NET Entity Framework Designer to model entities. You add the following stored
procedure to the database, and you add a function import to the model.
CREATE PROCEDURE [dbo].[InsertDepartment] @Name nvarchar(50), @ID int NULL OUTPUT
AS INSERT INTO Department (Name) VALUES (@Name) SELECT @ID = SCOPE_IDENTITY()
You need to insert a new department and display the generated ID. Which code segment should you use?

A. using (SchoolEntities context = new SchoolEntities())
{
ObjectParameter id = null;
context.InsertDepartment("Department 1", id);
Console.WriteLine(id.Value);
}

B. using (SchoolEntities context = new SchoolEntities())
{
var id = new ObjectParameter("ID", typeof(int));
context.InsertDepartment("Department 1", id);
Console.WriteLine(id.Value);
}

C. using (SchoolEntities context = new SchoolEntities())
{
var id = new ObjectParameter("ID", null));
context.InsertDepartment("Department 1", id);
Console.WriteLine(id.Value);
}

D. using (SchoolEntities context = new SchoolEntities())
{
var id = context.InsertDepartment("Department 1", null);
Console.WriteLine(id);
}

정답: B

설명: (Fast2test 회원만 볼 수 있음)

문제4

You have an existing ContosoEntities context object named context.
Calling the SaveChanges() method on the context object generates an exception that has the following inner exception:
System.Data.SqlClient.SqlException: Cannot insert duplicate key row in object 'dbo.Colors' with unique index 'IX_Colors'.
You need to ensure that a call to SaveChanges() on the context object does not generate this exception. What should you do?

A. Override the SaveChanges() method on the ContosoEntities class, call the ObjectStateManager.GetObjectStateEntries(System.Data.EntityState.Added) method, and call the AcceptChanges() method on each ObjectStateEntry object it returns

B. Examine the code to see how Color objects are allocated. Replace any instance of the new Color() method with a call to the ContosoEntities.LoadOrCreate() method.

C. Remove the unique constraint on the Name column in the Colors table.

D. Add a try/catch statement around every call to the SaveChanges() method.

정답: B

문제5

You use Microsoft .NET Framework 4.0 to develop an application that uses WCF Data Services to persist entities from the following Entity Data Model.

You create a new Blog instance named newBlog and a new Post instance named newPost as shown in the
following code segment.
(Line numbers are included for reference only.)
01 Blog newBlog = new Blog();
02 Post newPost = new Post();
03 ....
04 Uri serviceUri = new Uri("...");
05 BlogsEntities context = new BlogsEntities(serviceUri);
06 ....
You need to ensure that newPost is related to newBlog through the Posts collection property and that
newPost and newBlog are sent to the service.
Which code segment should you insert at line 06?

A. newBlog.Posts.Add(newPost); context.AddToBlogs(newBlog); context.AddToPosts(newPost); context.SaveChanges(SaveChangesOptions.Batch);

B. context.AttachLink(newBlog, "Posts", newPost); context.SaveChanges(SaveChangesOptions.Batch) ;

C. newBlog.Posts.Add(newPost); context.AttachTo("Blogs", newBlog); context.AttachTo("Posts", newPost); context.SaveChanges(SaveChangesOptions.Batch);

D. newBlog.Posts.Add(newPost); context.UpdateObject(newBlog); context.UpdateObject(newPost); context.SaveChanges(SaveChangesOptions.Batch);

정답: C

설명: (Fast2test 회원만 볼 수 있음)

문제6

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application that connects to a Microsoft SQL Server 2008 database. You add the following table to the database.
CREATE TABLE ObjectCache ( Id INT IDENTITY PRIMARY KEY, SerializedObjectData XML)
You write the following code segment to retreive records from the ObjectCache table. (Line numbers are included for reference only.)
01 string s = GetConnectionStringFromConfigFile("xmldb");
02 using (SqlConnection conn = new SqlConnection(s))
03 using (SqlCommand cmd = new SqlCommand("select * from ObjectCache",
conn))
04 {
05 conn.Open();
06 SqlDataReader rdr = cmd.ExecuteReader();
07 while(rdr.Read())
08 {
09 ...
10 DeserializeObject(obj);
11 }
12 }
You need to retreive the data from the SerializedObjectData column and pass it to a method named
DeserializeObject.
Which line of code should you insert at line 09?

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

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

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

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

정답: C

문제7

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create a Windows
Communication
Foundation (WCF) Data Services service. You deploy the data service to the following URL: http://
contoso.com/Northwind.svc.
You need to update the City property of the Customer record that has its ID value as 123.
You also need to preserve the current values of the remaining properties. Which HTTP request should you
use?

A. PUT /Northwind.svc/Customers(123) Host: contoso.com Content-Type: application/json { City: 'Seattle' }

B. MERGE /Northwind.svc/Customers(123) Host: contoso.com
Content-Type: application/json { City: 'Seattle' }

C. MERGE /Northwind.svc/Customers(123) Host: contoso.com Accept: application/json { City: 'Seattle' }

D. PUT /Northwind.svc/Customers(123) Host: contoso.com Accept: application/json { City: 'Seattle' }

정답: B

설명: (Fast2test 회원만 볼 수 있음)

문제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. The database includes a table named
dbo.Documents
that contains a column with large binary data. You are creating the Data Access Layer (DAL).
You add the following code segment to query the dbo.Documents table. (Line numbers are included for
reference only.)
01 public void LoadDocuments(DbConnection cnx)
02 {
03 var cmd = cnx.CreateCommand();
04 cmd.CommandText = "SELECT * FROM dbo.Documents";
05 ...
06 cnx.Open();
07 ...
08 ReadDocument(reader);
09 }
You need to ensure that data can be read as a stream. Which code segment should you insert at line 07?

A. var reader = cmd.ExecuteReader(CommandBehavior.KeyInfo);

B. var reader = cmd.ExecuteReader(CommandBehavior.SequentialAccess);

C. var reader = cmd.ExecuteReader(CommandBehavior.SchemaOnly);

D. var reader = cmd.ExecuteReader(CommandBehavior.Default);

정답: B

설명: (Fast2test 회원만 볼 수 있음)

문제9

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application. The application contains the following XML fragment:
<ApplicationMenu> <MenuItem name="File">
<MenuItem name="New">
<MenuItem name="Project" />
<MenuItem name="Web Site" />
</MenuItem>
<MenuItem name="Open">
<MenuItem name="Project" />
<MenuItem name="Web Site" />
</MenuItem>
<MenuItem name="Save" />
</MenuItem>
<MenuItem name="Edit">
<MenuItem name="Cut" />
<MenuItem name="Copy" />
<MenuItem name="Paste" />
</MenuItem>
<MenuItem name="Help">
<MenuItem name="Help" />
<MenuItem name="About" />
</MenuItem> </ApplicationMenu>
The application queries the XML fragment by using the XmlDocument class. You need to select all the descendant elements of the MenuItem element that has its name attribute as File. Which XPath expression should you use?

A. /ApplicationMenu/MenuItem/descendant::MenuItem['File']

B. /ApplicationMenu/MenuItem[@name='File']/descendant::MenuItem

C. //*[@name='File'][name()='MenuItem']

D. /ApplicationMenu/MenuItem['File']//MenuItem

정답: B

설명: (Fast2test 회원만 볼 수 있음)

문제10

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 => e2.Equals(new XElement("author", "Author1"))));

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

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

정답: D

문제11

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application that
connects to a database by using the Entity Framework.
You create an Entity Data Model (EDM) by using the Generate from database wizard for the following
tables.

You need to ensure that the EDM contains an entity type named Employee that contains all of the data from
both tables.
What should you do?

A. Delete the EmployeeAccess entity, create a new property named CanAccessBuildings on the Employee entity, and add a mapping for the new property.

B. Create an inheritance relationship between the Employee and EmployeeAccess entities, and use CanAccessBuildings as an inheritance condition.

C. Modify the .edmx file to include the following line of code. <NavigationProperty Name="Type" FromRole="EmployeeAccess" ToRole="Employee" />

D. Create a one-to-one association named CanAccessBuildingsAssociation between the EmployeeAccess entity and the Employee entity.

정답: A

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

우리와 연락하기

유용한 링크

최신 업데이트