시험 출제 기준은 수시로 바뀌기 때문에 학습 자료의 최신성이 중요합니다. DumpTOP은 2026년에도 70-516 연습문제를 지속적으로 업데이트하며, 구매 후 365일 동안 무료 업데이트를 제공합니다.

Microsoft 70-516 시험 개요:

Microsoft 70-516 시험 요강 주제:

Microsoft 70-516 응시 전 꼭 확인해야 할 질문들

최신 MCTS 70-516 무료샘플문제

문제 #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 following SQL statement to retrieve an instance of a DataSet object named ds:
SELECT CustomerID, CompanyName, ContactName, Address, City FROM dbo.Customers
You need to query the DataSet object to retrieve only the rows where the ContactName field is not NULL. Which code segment should you use?

A. from row in ds.Tables[0].AsEnumerable() where (string)row["ContactName"] != null select row;
B. from row in ds.Tables[0].AsEnumerable() where !Convert.IsDBNull(row.Field<string>("ContactName")) select row;
C. from row in ds.Tables[0].AsEnumerable() where row.Field<string>("ContactName") != null select row;
D. from row in ds.Tables[0].AsEnumerable() where !row.IsNull((string)row["ContactName"]) select row;

문제 #2

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
You use Microsoft ADO.NET Entity Data Model (EDM) to model entities.
You create an entity named Person with a schema defined by the following XML fragment.
<EntityType Name="CPerson"> <Key> <PropertyRef Name="PersonId" /> </Key>
<Property Name="PersonId" Type="Int32" Nullable="false" />
<Property Name="CompanyName" Type="String" />
<Property Name="ContactName" Type="String" />
<Property Name="ContactTitle" Type="String" />
<Property Name="Address" Type="String" />
</EntityType>
You need to ensure that entities within the application are able to add properties related to the city, region,
and country of Person's address.
What should you do?

A. Create a new complex type named CAddress that contains the properties for city, region, and country. Change the Type of the Address property in CPerson to "Self.CAddress".
B. Create a view named Name that returns city, region, and country along with person IDs. Add a WHERE clause to filter the results to display only the City, Region and Country properties for a specific Person entity.
C. Create a new entity named Address. Add a person ID property to filter the results to display only the City, Region, and Country properties for a specific Person entity.
D. Create a SubEntity named Address. Map the SubEntity to a stored procedure that retrieves city, region, and country.

문제 #3

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)
{
....
try
{
.....
using (TransactionScope scope2 = new TransactionScope(TransactionScopeOption))
{ .... }
}
}
}
D. try
{ using (TransactionScope scope1 = new TransactionScope(TransactionScopeOption.Required)) {
....
try
{
.....
using (TransactionScope scope2 = new TransactionScope
(TransactionScopeOption.RequiresNew))
{ .... }
}
}
}

문제 #4

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. Use the ExecuteDynamicDelete method of the DataContext object.
B. Override the Delete operation of the customer entity.
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.

문제 #5

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=AdventureWorksLT; Initial Catalog=SQL01\INSTA; Integrated Security=true;
B. Data Source=SQL01; Initial Catalog=AdventureWorksLT; Integrated Security=true; Application Name=INSTA;
C. Data Source=SQL01; Initial Catalog=INSTA; Integrated Security=true; Application Name=AdventureWorksLT;
D. Data Source=SQL01\INSTA; Initial Catalog=AdventureWorksLT; Integrated Security=true;

질문과 대답: