MCSD Entity Framework and Data Access

Question 1

What is Entity Framework (EF) in the context of .NET development?

Accepted Answer

An ORM that maps .NET objects to database tables

Answer

A UI rendering framework

Answer

A dependency injection container

Answer

A testing framework

Question 2

In Entity Framework Code-First, what triggers a database schema migration?

Accepted Answer

Running `Add-Migration` after modifying the model classes

Answer

Changing the connection string

Answer

Restarting the application

Answer

Changing the DbContext constructor

Question 3

What does `DbContext` represent in Entity Framework?

Accepted Answer

The session with the database, exposing DbSet properties for querying

Answer

A database connection string

Answer

A model validation class

Answer

A stored procedure wrapper

Question 4

Which Entity Framework loading strategy fetches related entities in separate queries on demand?

Accepted Answer

Lazy loading

Answer

Eager loading

Answer

Explicit loading

Answer

Batch loading

Question 5

What does the `[Key]` data annotation do in Entity Framework Code-First?

Accepted Answer

Designates the property as the primary key of the entity

Answer

Encrypts the property value

Answer

Makes the property required

Answer

Sets a foreign key relationship

Question 6

What is the N+1 query problem in Entity Framework?

Accepted Answer

Loading N entities with lazy loading triggers N additional queries for related data

Answer

Inserting N rows requires N+1 transactions

Answer

Migrations run N+1 times on startup

Answer

N connections open simultaneously