Because Primary & Foreign Key information is not enforced.
"Primary and foreign keys are informational only and are not enforced" from:
https://docs.databricks.com/en/tables/constraints.html#declare-primary-key-and-foreign-key-relationships
https://www.databricks.com/discover/pages/optimize-data-workloads-guide#delta-data
Delta data skipping automatically collects the stats (min, max, etc.) for the first 32 columns for each underlying Parquet file when you write data into a Delta table. Databricks takes advantage of this information (minimum and maximum values) at query time to skip unnecessary files in order to speed up the queries.
B is correct.
https://docs.delta.io/2.0.0/table-properties.html
upvoted 1 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
PrashantTiwari
9 months, 2 weeks agoguillesd
9 months, 3 weeks agospaceexplorer
10 months agoCrocjun
10 months, 3 weeks agocryptoflam
10 months, 3 weeks agoPatito
11 months agoAndreFR
3 months agoervinshang
11 months agof728f7f
11 months, 1 week agochokthewa
1 year, 1 month ago