Which Component of the SQL Server Database Engine Builds a Physical

question 20

Multiple Choice

Which component of the SQL Server database engine builds a physical execution plan from a SQL query?

• A)query optimizer
• B)query editor
• C)query execution planner
• D)query processor

---

Definitions:

Conflict

A situation or internal state of discord arising from opposing or incompatible forces, desires, or interests.

Effort Justification

A phenomenon in which individuals rationalize the effort they put into a task by increasing their liking for the outcome, even if it's not what they desired.

Conceptual Validation

The process of confirming that a theoretical concept is accurately reflected or represented in a research study or application.

Rationalizing

The process of explaining an attitude, behavior, or event with logical reasons, often to justify or make it seem reasonable.