Consultancy
Deloitte interview themes
What people report studying for — not a take-home dump. Last editorial update 2026-06-01.
Rounds you should expect
Case
Draw bronze/silver/gold for a client who already has Synapse and wants Fabric. What you would not migrate first.
From the question bank
medium · Warehouse · Snowflake
Someone DELETED gold.orders. What do you do in the first ten minutes?
Practice →medium · Warehouse · Snowflake
Zero-copy clone of prod for a destructive test. What do you warn finance?
Practice →easy · Warehouse · Snowflake
Cortex Analyst returns doubled revenue. First check?
Practice →hard · Warehouse · Snowflake
Secure view vs masking policy vs row-access policy. One sentence each.
Practice →easy · Warehouse · Databricks
Unity Catalog vs Hive metastore. Why do interviewers care in 2026?
Practice →easy · Warehouse · Databricks
Unity Catalog volume vs a DBFS path in a notebook. What do you refuse to merge?
Practice →medium · Cloud · AWS
Redshift DISTKEY / SORTKEY (or AUTO). What mistake shows up as a broadcast of a 2 TB table?
Practice →hard · Cloud · AWS
Lake Formation LF-Tags vs bucket policy. When is LF worth the ticket?
Practice →easy · Cloud · Azure
Self-hosted IR versus Azure IR. When is on-prem the only answer?
Practice →medium · Cloud · Azure
Purview vs “the pipeline wiki.”
Practice →medium · Cloud · Azure
Fabric Direct Lake vs Import. When is Direct Lake the wrong choice?
Practice →medium · Cloud · Azure
Purview scan never sees your gold tables. First three causes?
Practice →