nerdexam
Microsoft

70-465 · Question #83

You need to meet the design requirement for the ProductTypes table in the Product database. Which of the following would be the best solution?

The correct answer is B. A CHECK constraint. The best solution to meet a design requirement for the ProductTypes table is a CHECK constraint, as it enforces domain integrity by restricting the allowed values in a column.

Submitted by certguy· Mar 5, 2026Design and implement database solutions for SQL Server

Question

You need to meet the design requirement for the ProductTypes table in the Product database. Which of the following would be the best solution?

Options

  • AA PRIMARY KEY constraint.
  • BA CHECK constraint.
  • CA UNIQUE constraint.
  • DA Data Definitions Language (DDL) trigger.
  • EA FOREIGN KEY constraint.

How the community answered

(20 responses)
  • A
    5% (1)
  • B
    75% (15)
  • D
    5% (1)
  • E
    15% (3)

Why each option

The best solution to meet a design requirement for the ProductTypes table is a CHECK constraint, as it enforces domain integrity by restricting the allowed values in a column.

AA PRIMARY KEY constraint.

A PRIMARY KEY constraint ensures that each row in the ProductTypes table is uniquely identified and prevents NULL values in the key column(s), but it does not enforce specific domain rules on the values themselves beyond uniqueness and non-nullability.

BA CHECK constraint.Correct

A CHECK constraint directly enforces domain integrity by limiting the range of values that can be entered into a column within the ProductTypes table. This allows the database designer to ensure that data conforms to specific business rules or predefined criteria, such as a value being within a certain range or matching a specific pattern.

CA UNIQUE constraint.

A UNIQUE constraint ensures that all values in a specified column or set of columns in the ProductTypes table are distinct, but it does not enforce specific data value criteria or ranges.

DA Data Definitions Language (DDL) trigger.

A Data Definition Language (DDL) trigger responds to DDL events (e.g., CREATE TABLE, ALTER TABLE) and is used for auditing or controlling schema changes, not for enforcing data integrity rules on values inserted or updated within a table.

EA FOREIGN KEY constraint.

A FOREIGN KEY constraint enforces referential integrity by linking columns in the ProductTypes table to a primary or unique key in another table, ensuring consistency between related tables, but it does not define the valid range or format for values within ProductTypes columns independently.

Concept tested: Database constraints for domain integrity (CHECK constraint)

Source: https://learn.microsoft.com/en-us/sql/relational-databases/tables/create-check-constraints?view=sql-server-ver16

Topics

#Database design#Data integrity#CHECK constraint

Community Discussion

No community discussion yet for this question.

Full 70-465 Practice