knobit.org

Q1 (2 points)

edu:Question

https://knobit.org/id/task/dm-ddl-review-deploy/Q1

Also as Turtle · JSON-LD · RDF/XML

dcterms:licensehttps://creativecommons.org/licenses/by/4.0/
owl:sameAshttps://bitbucket.org/reffa/ontology/id/task/dm-ddl-review-deploy/Q1
rdfs:labelQ1 (2 points) en
schema:identifierQ1
schema:position11
schema:textNo false positives: 2 points with none, 1 with one, 0 with more. Clean cases: ck_dim_card_expiry_month and ck_fact_payment_status are portable; fact_payment.booked_at is UTC with the convention stated in its comment; valid_from_date, valid_to_date and issue_date are DATE; fk_fact_payment_account and fk_dim_account_party are one-directional, not part of the cycle; the Databricks header warning is closed; the Postgres script was executed. en

Used by

has questionCard and account mart DDL on five engines, with its release evidence (DDL review skills)