AZ-303 Exam - Question 62

Question

You have an Azure SQL database named DB1.

You plan to create the following four tables in DB1 by using the following code.

Table1.

Table2.

Table3.

Table4.

You need to identify which table must be created last.

What should you identify?

Examice · Accepted Answer

Table2 should be created last because it contains foreign key references to both Table1 and Table3. For these references to be valid, Table1 and Table3 need to exist before Table2 is created. Table1 references Table4, so Table4 must be created before Table1. Therefore, the order of creation should start with Table4, followed by Table1 and Table3, and finally Table2.

xaccan · Answer

correct

pentium75 · Answer

Of course the answer is correct, but this is pure SQL, has nothing to do with Azure architecture and is also not part of the official training material.

sujeetkb2021 · Answer

Table2 is the correct answer as it references to Table 1 and Table 3 so these 2 tables should be created first

Rockers · Answer

Correct. Sequence of table creation will be .... Table 4 | Table 1, 3 | Table 2

mactone · Answer

obviously table 4. correct answer

syu31svc · Answer

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

Answer is B

Ramkid · Answer

yes, logically table 2 is correct

asemaan · Answer

Yes the answer is correct . . . logically. But because no foreign key constraints are defined as part of the create table means you can create the tables in any order!

Ansh27feb · Answer

Answer is Correct

KemalM · Answer

Table2 should be the last one

AZ-303 Exam - Question 62

Discussion