70-516最も有効な質問と解答で勉強

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application. You create stored procedures by using the following signatures:
CREATE procedure [dbo].[Product_Insert](@name varchar(50),@price float)
CREATE procedure [dbo].[Product_Update](@id int, @name varchar(50), @price
float)
CREATE procedure [dbo].[Product_Delete](@id int)
CREATE procedure [dbo].[Order_Insert](@productId int, @quantity int)
CREATE procedure [dbo].[Order_Update](@id int, @quantity int,@originalTimestamp
timestamp)
CREATE procedure [dbo].[Order_Delete](@id int)
You create a Microsoft ADO.NET Entity Data Model (EDM) by using the Product and Order entities as shown in the exhibit:

You need to map the Product and Order entities to the stored procedures. To which two procedures should
you add the @productId parameter?
(Each correct answer presents part of the solution. Choose two.)

• A. Product_Delete
• B. Product_Update
• C. Order_Delete
• D. Order_Update

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.SchemaOnly);
• B. var reader = cmd.ExecuteReader(CommandBehavior.Default);
• C. var reader = cmd.ExecuteReader(CommandBehavior.SequentialAccess);
• D. var reader = cmd.ExecuteReader(CommandBehavior.KeyInfo);

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 application uses a Microsoft ADO.NET SQL Server managed provider.
"Data Source=myServerAddress; Initial Catalog=myDataBase; User Id=myUsername; Password=secret;"
You need to ensure that the database credentials are secure. Which is the correct Property to insert?

• A. Integrated Security=false;
• B. Integrated Security=SSPI;
• C. Persist Security Info=true;
• D. Persist Security Info=false;

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 associate a previously deserialized entity named person1 to an object context named model
and persist changes to the database.
Which code segment should you use?

• A. person1.AcceptChanges(); model.SaveChanges();
• B. model.People.Attach(person1); model.SaveChanges();
• C. model.People.ApplyChanges(person1) ; model.SaveChanges();
• D. model.AttachTo("People", person1); model.SaveChanges();

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( "Initial Catalog=AdventureWorks; Integrated Security=SSPI; MultipleActiveResultSets=True")) {
  connection.Open();
  command.ExecuteNonQuery();
  }
• B. command.CommandText = "exec uspLoginAudit;";
  using (SqlConnection connection = new SqlConnection( "Integrated Security=SSPI;")) {
  connection.Open();
  command.ExecuteNonQuery();
  }
• C. command.CommandText = "exec uspLoginAudit;"; using (SqlConnection connection = new SqlConnection( "Integrated Security=SSPI; Initial Catalog=pubs")) {
  connection.Open();
  command.ExecuteNonQuery();
  }
• D. command.CommandText = "USE [pubs]; exec uspLoginAudit;"; using (SqlConnection connection = new SqlConnection( "Integrated Security=SSPI; Initial Catalog=AdventureWorks")) {
  connection.Open();
  command.ExecuteNonQuery();
  }