Search
58 results for “SQL Joins”
Practice MCQ
In an analytical SQL query computing category totals, what is the key functional difference between placing a filter predicate in WHERE versus placing it in HAVING?
Practice MCQ in Aggregations & GROUP BY
Practice MCQThe team must agree how to treat joins that silently multiply rows before the readout goes to leadership. Which choice holds up?
Role practice MCQ for Data Scientist
Practice MCQThe team must agree how to treat point-in-time joins against a changing dimension before the readout goes to leadership. Which choice holds up?
Role practice MCQ for Data Scientist
Practice MCQThe team must choose an approach to joins that silently drop rows before the report goes to the executive audience. Which one is defensible?
Role practice MCQ for Business Intelligence Developer
Practice MCQThe team must choose an approach to SQL window grain before the next backfill. Which one is defensible?
Role practice MCQ for Data Engineer
Practice MCQWhat is point-in-time correctness for feature joins?
Practice MCQ in Automated Retraining Pipelines
Practice MCQWhat is the correct defence against SQL injection?
Practice MCQ in SQL Fundamentals
Practice MCQWhat is the preferred primary defense against SQL injection?
Practice MCQ in Common Web Vulnerabilities (OWASP Top 10)
Practice MCQWhat must be defined before measures and joins?
Practice MCQ in Semantic Data Modeling for BI
Practice MCQWhen generating historical training datasets via point-in-time 'as-of' joins across high-frequency entity observation logs, what is the primary computational bottleneck for query engines like Spark, Snowflake, or BigQuery?
Practice MCQ in Feature Stores
Practice MCQWhich clause is evaluated first in SQL's logical processing order?
Practice MCQ in SQL Fundamentals
Practice MCQWhich combination of attributes is required on an SCD Type 2 dimension record to ensure unambiguous point-in-time fact joins without interval collision?
Practice MCQ in Data Warehousing & Modeling
Practice MCQWho should receive direct SQL exploration access?
Practice MCQ in Self-Service Analytics Enablement
Practice MCQWhy avoid quoted mixed-case SQL identifiers?
Practice MCQ in Data Modeling Standards
Interview QAA broadcast join hangs until spark.sql.broadcastTimeout. The dimension is 900 MB. What is actually timing out?
Role interview QA for Data Engineer
Interview QAA fact arrives 3 minutes before the dimension row. The stream inner-joins. Where did the fact go?
Role interview QA for Data Engineer
Interview QAPrevent metric fanout across semantic joins.
Interview QA in Semantic Data Modeling for BI
Interview QAspark.sql.shuffle.partitions is still 200 on a 12 TB join. What are you waiting for?
Role interview QA for Data Engineer