Microsoft Exam AZ-303 Topic 16 Question 12 Discussion

Table1 references Table4. Therefore Table4 must be created before Table1.

Table2 references Table1 and Table3. Therefore Table1 and Table3 must be created before Table2.

Note: FOREIGN KEY REFERENCES is a constraint that provides referential integrity for the data in the column or columns. FOREIGN KEY constraints require that each value in the column exists in the corresponding referenced column or columns in the referenced table. FOREIGN KEY constraints can reference only columns that are PRIMARY KEY or UNIQUE constraints in the referenced table or columns referenced in a UNIQUE INDEX on the referenced table.

Incorrect Answers:

A: Table1 is referenced by Table2 and should be crated before Table2.

C: Table3 is referenced by Table2 and should be crated before Table2.

D: Table4 is referenced by Table1 and should be crated before Table1.

https://docs.microsoft.com/en-us/sql/t-sql/statements/create-table-transact-sql?view=sql-server-ver15