Search
58 results for “SQL Joins”
How would you report typical order value, and how do you compute it in SQL?
Role interview QA for Data Analyst
Interview QALegal wants the email gone from Parquet that snapshot 12 still references. Is a SQL DELETE enough if you also expire snapshot 12's metadata?
Role interview QA for Data Engineer
Interview QApandas.read_sql pulls 9 million rows into one DataFrame on the extractor box. What is the production pattern?
Role interview QA for Data Engineer
Interview QAPrevent injection across SQL, shell, templates, LDAP, and rendered browser content.
Interview QA in Common Web Vulnerabilities (OWASP Top 10)
Interview QAThe KPI SQL is SELECT COUNT(DISTINCT user_id) FROM events WHERE type IN (...12 types). Why is this a product smell?
Role interview QA for Technical Product Manager
Interview QAWalk through SQL's logical processing order and explain why it matters in practice.
Interview QA in SQL Fundamentals
Interview QAWhat are transactions in SQL, and what does ACID guarantee in a relational database?
Interview QA in SQL Fundamentals
Interview QAWhen would you reach for a document or graph store instead of SQL for an analytical question?
Role interview QA for Data Scientist
Interview QAWhen would you use a graph database rather than expressing relationships in SQL?
Role interview QA for Cloud Architect
Interview QAYou need the top transcript per gene by TPM. Why does ORDER BY TPM LIMIT 1 per gene in a loop fail at 60k transcripts, and which SQL pattern is right?
Role interview QA for Computational Biologist
Interview QAYour training set is defined by a SQL query. What is wrong with that?
Role interview QA for MLOps Engineer
Practice MCQA forward deployed engineer is asked to justify their handling of answering a customer question with SQL live. Which justification is sound?
Role practice MCQ for Forward Deployed Engineer (FDE)
Practice MCQA full-stack developer owns SQL injection through a search box for a product going live. Which approach should the team accept?
Role practice MCQ for Full-Stack Developer
Practice MCQA load incident is traced to warehouse SQL after landing. What is the correct remediation?
Role practice MCQ for Data Engineer
Practice MCQA proposed analysis plan covering funnel analysis in SQL is under assessment. Which option would survive peer review?
Role practice MCQ for Data Scientist
Practice MCQA ride-pricing model scores each request independently: offline, `trips_last_30d` is computed from a nightly SQL table; online, from the live event stream. Offline RMSE is 0.18 against 0.26 online for the same model version. The pricing decision is fully automated at a 45 ms p99 budget, the model runs unchanged for at least a year, and a feature spec defines the maximum train/serve distribution gap. Which train/serve skew policy should the team adopt?
Role practice MCQ for AI Engineer
Practice MCQA team is standing up a new BI platform: dashboard and analyst SQL over fact tables of a few hundred million rows, dimensions of 40 to 150 attributes that change rarely, and no requirement for attribute-level history. Which modelling choice is defensible for this workload?
Role practice MCQ for Data Architect
Practice MCQAn incident is traced to SQL COUNT DISTINCT samples. What is the correct remediation?
Role practice MCQ for Computational Biologist
Practice MCQAn incident traced to a feature mismatch: three teams each reimplement the same customer aggregates for four models, a replay shows 6% of scored rows used values differing from the training-time computation, and training sets need as-of joins the snapshot export cannot express. Which remediation do you adopt?
Role practice MCQ for AI Engineer
Practice MCQAn interviewer asks how you would handle SQL injection. Which answer holds up?
Role practice MCQ for Backend Engineer