C2 (3 points)
https://knobit.org/id/task/ddl-review/C2
Also as Turtle · JSON-LD · RDF/XML
| dcterms:license | https://creativecommons.org/licenses/by/4.0/ |
|---|---|
| owl:sameAs | https://bitbucket.org/reffa/ontology/id/task/ddl-review/C2 |
| rdfs:label | C2 (3 points) en |
| schema:hasPart | ddl-review C2a and C2b: unenforced keys on Snowflake, enforced on Postgres |
| schema:hasPart | ddl-review C2c: CREATE INDEX on Snowflake |
| schema:identifier | C2 |
| schema:position | 2 |
| schema:text | The same object is a defect on one target and correct on the other, 1 point each: (a) on Snowflake the primary keys and the unique constraint are not enforced, so each one the design relies on is named as needing a DQ rule, and the constraints are kept rather than dropped; (b) the same keys on Postgres are NOT reported as a defect - reporting them there is a false positive; (c) CREATE INDEX cannot exist on Snowflake at all, and the answer says so and names a clustering key as the lever instead. en |