FEFreeExamDumps.in

SQL AI Developer Associate

Topic 1

Question 3

DP-800 is a newly released exam. These practice questions reflect our best current understanding — the exact wording and question formats may change in the live exam until the certification matures. Use them to learn the concepts, not to memorize.

DP-800 voucher + Udemy course (lifetime access) = ₹3,500 for Indian ID card holders.

Details →

A logistics company needs to enforce valid shipment states and prevent orphaned delivery records. Which table design should you recommend?

  • AUse primary keys, foreign keys, and check constraints to enforce valid relationships and states.
  • BStore all deliveries in a free-form notes column.
  • CAllow null foreign keys so inserts always succeed.
  • DDuplicate shipment rows across multiple tables without constraints.