@prefix dcterms: <http://purl.org/dc/terms/> .
@prefix edu: <https://knobit.org/def/> .
@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/dm-ddl-review-deploy/I7> a edu:Question ;
    rdfs:label "I7 (2 points)"@en ;
    dcterms:license <https://creativecommons.org/licenses/by/4.0/> ;
    schema:hasPart <https://knobit.org/id/register/data-modelling#I-827> ;
    schema:identifier "I7" ;
    schema:position 10 ;
    schema:text "Time zone and business dates, 1 each: (a) dim_account.created_at is a TIMESTAMP with no zone written in local time by load jobs in Tallinn and Stockholm, so it is ambiguous and incomparable - TIMESTAMP WITH TIME ZONE, or UTC with the convention in the column comment; (b) fact_payment.payment_value_date is a TIMESTAMP although a value date is a business date, so the reconciliation's = DATE '2026-03-31' misses rows loaded at 23:30 - DATE."@en .

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

<https://knobit.org/id/register/data-modelling#I-827> rdfs:label "dm-ddl-review-deploy I7: event timestamp without a zone, value date as a timestamp"@en .