One benefit of adding a second table source that is joined to the first table source in the Physical Layer by a foreign key relationship is that______.

The correct answer is C. A single SQL query is performed to get data from both tables. A single query can be performed accessing data from both tables through a join on the columns in the foreign key relation.

Adding Multiple Logical Table Sources to a Logical Table

Question

Options

AMultiple SQL queries are performed
BTwo SQL queries are performed to get data from both tables
CA single SQL query is performed to get data from both tables
DNo SQL queries are performed against the source tables

How the community answered

(49 responses)

A
2% (1)
B
4% (2)
C
86% (42)
D
8% (4)

Explanation

A single query can be performed accessing data from both tables through a join on the columns in the foreign key relation.

Topics

#multiple table sources#foreign key joins#SQL generation#logical table sources

Community Discussion

No community discussion yet for this question.

Full 1Z0-591 Practice