Artefact Interview Questions
The questions to prepare for Artefact interviews, across all roles. Questions from real interview reports rank first. Updated weekly.
Compute daily active users and a 7-day rolling average using a CTE, distinct counts, and window functions.
ArtefactFind the first non-repeating character in a string using frequency counting and a second pass in O(n) time.
ArtefactSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Approach for maintaining data quality and integrity across ETL pipelines.
ArtefactIdentify the main pitfalls that can distort A/B test interpretation and explain how to guard against them.
ArtefactAssess the 15% drop in user engagement after a new app feature release and propose metric decomposition strategies.
ArtefactReason about sample size, power, and minimum detectable effect before launching an experiment.
ArtefactApproach for monitoring a model in production and spotting drift, threshold issues, and calibration loss.
ArtefactExplain how to choose between a simpler interpretable model and a more accurate black-box model.
Artefact