MCSD Entity Framework and Data Access 2

Question 1

Which Entity Framework method is used to eagerly load a related entity in a query?

Accepted Answer

.Include()

Answer

.Join()

Answer

.Attach()

Answer

.Load()

Question 2

What is the Repository pattern used for in .NET data access?

Accepted Answer

Abstracting data access logic behind an interface to decouple it from business logic

Answer

Caching database results

Answer

Managing database migrations

Answer

Pooling database connections

Question 3

In Entity Framework, what does `SaveChanges()` do?

Accepted Answer

Persists all tracked entity changes to the database in a single transaction

Answer

Rolls back the transaction

Answer

Reloads entities from the database

Answer

Validates all entity data annotations

Question 4

What does the `AsNoTracking()` method do in Entity Framework?

Accepted Answer

Returns entities without change tracking, improving performance for read-only queries

Answer

Disables lazy loading

Answer

Prevents SQL injection

Answer

Disables migrations

Question 5

Which approach in Entity Framework generates database tables from existing C# classes?

Accepted Answer

Code-First

Answer

Database-First

Answer

Model-First

Answer

Schema-First

Question 6

What is the purpose of a DbSet<T> property in a DbContext class?

Accepted Answer

Represents a table in the database and provides querying capabilities for that entity

Answer

Defines a stored procedure

Answer

Configures the database connection

Answer

Maps enum values to strings