@prefix dcterms: <http://purl.org/dc/terms/> .
@prefix edu: <https://knobit.org/def/> .
@prefix owl: <http://www.w3.org/2002/07/owl#> .
@prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> .
@prefix schema: <https://schema.org/> .
@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .

<https://knobit.org/id/task/ddl-review/C2> a edu:Question ;
    rdfs:label "C2 (3 points)"@en ;
    dcterms:license <https://creativecommons.org/licenses/by/4.0/> ;
    owl:sameAs <https://bitbucket.org/reffa/ontology/id/task/ddl-review/C2> ;
    schema:hasPart <https://knobit.org/id/register/data-modelling#I-803>,
        <https://knobit.org/id/register/data-modelling#I-804> ;
    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 .

edu:Question rdfs:label "Question"@en,
        "Küsimus"@et .

<https://knobit.org/id/register/data-modelling#I-803> rdfs:label "ddl-review C2a and C2b: unenforced keys on Snowflake, enforced on Postgres"@en .

<https://knobit.org/id/register/data-modelling#I-804> rdfs:label "ddl-review C2c: CREATE INDEX on Snowflake"@en .