All 63 questions
How would you define and enforce a consistent metadata schema across teams, collectors, and sessions?
Asked in 2 of 274 interviews · last asked Jul 25 · Scenario · Senior
Other ways it was asked
- “How do you design and enforce a Hindi metadata schema—including speaker demographics, device, environment, and consent—so it stays consistent across many collectors and sessions?”
- “How do you define and enforce a metadata schema, including required fields, naming rules, and controlled vocabulary across a team, so downstream analytics can reliably join sessions, builds, scenarios, and device configurations?”
How would you map platform-specific identifiers to a normalized campaign ID?
Asked once · last asked Jul 20 · Design · Mid-level
Other ways it was asked
- “How would you map platform-specific identifiers, such as Facebook campaign IDs or Google objective IDs, to a normalized campaign ID?”
In an early sprint, should a tester validate a data model's fields and allowed values, or focus on business values and end-to-end process behavior?
Asked once · last asked Apr 20 · Scenario · Mid-level
In production, how do you handle schema evolution, such as added or renamed fields and type changes, across ingestion, transformation, and downstream consumers without breaking the pipeline?
Asked once · last asked May 3 · Scenario · Senior
Analytics, Product, Compliance, and Finance define active player, credit earned, and credit redeemed differently, causing inconsistent reporting. How would you define a canonical dataset and a golden path for consumption?
Asked once · last asked May 12 · Scenario · Senior
How would you select and manage security controls for data products and determine the compliance requirements they must meet?
Asked once · last asked Jun 3 · Scenario · Senior
Other ways it was asked
- “What security controls have you managed for data products, and how do you determine the compliance requirements they must meet?”
What does treating data as a product mean in practice, and how would you ensure people follow raw, work, and published zone standards and use a catalog such as Alation?
Asked once · last asked Jun 16 · Scenario · Senior
How would you create and maintain documentation for data pipelines, data models, or data contracts, including runbooks, schema documentation, pipeline diagrams, quality rules, and information needed to operate and maintain the systems?
Asked once · last asked Jun 24 · Scenario · Mid-level
Other ways it was asked
- “How did you create and maintain documentation for your data pipelines, data models, or data contracts? What information did you include, such as runbooks, schema documentation, pipeline diagrams, quality rules, or details to help your team operate and maintain the systems?”
How do you handle schema changes when consuming CDC events into a lake destination?
Asked once · last asked Jul 16 · Scenario · Senior
How would you handle added, removed, or renamed columns when applying CDC events to Delta Lake?
Asked once · last asked Jul 16 · Scenario · Senior
Suppose your final report must include all fields, but some are valid yet disagree. How would you represent those fields to avoid silently inventing a single truth while keeping the report machine-consumable?
Asked once · last asked Jun 30 · Scenario · Senior
How would you handle versioning and schema evolution for a large-scale graph database in Neo4j or AWS Neptune while ensuring data integrity and minimal downtime?
Asked once · last asked Jul 16 · Design · Senior
In Velo, how would you structure permissions and data for members' area features so private data stays secure?
Asked once · last asked Jul 16 · Design · Senior
What is the ultimate purpose of a system-of-record CRM?
Asked once · last asked Jul 22 · Concept · Mid-level
How would you migrate a field in Odoo that changes from Many2one in version 18 to Many2many in version 19?
Asked once · last asked Jul 23 · Scenario · Senior
How would you version a metadata schema over time, including new and deprecated fields, while keeping older datasets usable and preventing mixed-version confusion in the same study?
Asked once · last asked Jul 25 · Scenario · Senior
How would you approach data governance with Microsoft Purview for lineage and classification?
Asked once · last asked Jul 28 · Scenario · Senior
What Salesforce field should a campaign taxonomy string match to link ad activity with a redemption record identified by patient and date?
Asked once · last asked Jul 31 · Tooling · Senior
When you find duplicate keys in a lookup table, how do you decide how to remediate them while keeping the transformation auditable?
Asked once · last asked Aug 1 · Scenario · Senior
How would you validate and enforce referential integrity between a fact table and a dimension table, such as orders and customers, while keeping the process auditable?
Asked once · last asked Aug 5 · Scenario · Senior
What tools, notations, or techniques do you typically use to create system context diagrams, process flows, interface inventories, and source-to-target data mapping documentation?
Asked once · last asked Aug 6 · Tooling · Senior
What is a data product, and how does it fit within a data domain?
Asked once · last asked Aug 7 · Concept · Mid-level
How do you ensure data consistency and correctness across the bronze, silver, and gold layers, especially when source schemas change frequently or source files are corrupted?
Asked once · last asked Aug 10 · Scenario · Senior
How would you handle frequent schema evolution in Azure Synapse Analytics without breaking existing queries or pipelines, and what features or techniques would you use to ensure seamless schema evolution?
Asked once · last asked Aug 11 · Scenario · Senior
Why is it critical to align feature logic to business definitions, and how does it impact the overall effectiveness of data models?
Asked once · last asked Aug 31 · Concept · Senior
How would you handle changes to business rules that affect an existing data model?
Asked once · last asked Sep 5 · Scenario · Mid-level
How do you decide which system should be the source of truth for a critical revenue field such as ARR or invoice amount, and who should approve that decision?
Asked once · last asked Sep 14 · Scenario · Senior
What should a system do if a sensor dataset is deleted?
Asked once · last asked Sep 18 · Scenario · Mid-level
How would you add one more column to a production pipeline and backfill the data?
Asked once · last asked Sep 18 · Scenario · Mid-level
How would you work with teams to define schemas before moving data into Microsoft Fabric?
Asked once · last asked Sep 18 · Scenario · Mid-level
What is data skew, and how do you support a data subject deletion request?
Asked once · last asked Sep 18 · Scenario · Senior
How do you handle schema or column changes from a vendor in an Informatica job, and what change management process do you follow?
Asked once · last asked Sep 21 · Scenario · Senior
How would you choose a business key for deduplication, and how would you handle late-arriving data?
Asked once · last asked Sep 22 · Scenario · Senior
How would you ensure that reloading data does not break downstream aggregates and that final tables remain consistent?
Asked once · last asked Sep 22 · Scenario · Senior
A region mapping table contains two rows for the same region key. How could that affect the report, and what would you do?
Asked once · last asked Sep 23 · Scenario · Mid-level
How would you manage database schema evolution as features are added and data grows, and what challenges can arise during migrations?
Asked once · last asked Sep 23 · Scenario · Senior
A report’s overall interaction count is correct, but its figures by region are wrong. How would you investigate where the difference is coming from?
Asked once · last asked Sep 23 · Scenario · Mid-level
What would you do if an external provider has capabilities or data that do not fit the common internal model?
Asked once · last asked Sep 25 · Scenario · Senior
If a source legitimately includes summary rows, how would you define and use control totals? Where would you keep those rows, and how would you prevent them from entering the fact table while retaining the evidence needed for reconciliation?
Asked once · last asked Sep 28 · Design · Senior
Suppose a product’s warehouse location or cost differs between ERP and WMS. How would you align the metadata keys for a dimensional model, and what would you do with records you cannot match confidently?
Asked once · last asked Sep 28 · Scenario · Senior
Suppose ERP product code A100 means one carton of 12 units, while WMS code A100 means one individual unit. A naïve join matches the codes and reports the wrong number of units received. How would you correct the models and their data quality controls?
Asked once · last asked Sep 28 · Scenario · Senior
If two WMS platforms both use production code P100, but one records cases of 12 units and the other records individual units, how would you model and reconcile their inventory movements without inflating the combined stock number?
Asked once · last asked Sep 29 · Scenario · Senior
If two WMS records describe the same receipt of 120 units, but one records arrival on Monday and the other posting on Tuesday, which record should contribute to the combined inventory balance, and how would you explain the one-day difference in daily reports?
Asked once · last asked Sep 29 · Scenario · Senior
Other ways it was asked
- “If two WMS records describe the same physical receipt of 120 units, but one says it arrived Monday and the other says it was posted Tuesday, which record should contribute to the combined inventory balance, and how would you explain the one-day difference in daily reports?”
If finance says monthly totals must match exactly while operations says canceled and partially received shipments should appear in its planning view, how would you resolve the definition conflict and communicate the rules to engineering?
Asked once · last asked Sep 29 · Scenario · Senior
If a summary row represents a control total the business still needs, where would you keep it, how would you reconcile it against the detail, and how would you prevent it from entering the order-level fact table again?
Asked once · last asked Sep 29 · Scenario · Senior
If a daily customer dimension suddenly contains duplicate customer keys but the transaction fact loaded successfully and the service owner needs a feed within an hour, what would you check first, what would you hold, and what evidence would you use?
Asked once · last asked Sep 29 · Scenario · Senior
If a source export contains summary rows mixed in with detail-level data, what permanent control would you implement, where would you classify those rows, what test would block them, and how would you prove the control works without losing valid data?
Asked once · last asked Sep 29 · Scenario · Senior
If 800 of 1,000 missing shipment IDs have documented exclusion reasons and the other 200 disappeared after a join to the customer dimension, what would you change in the model, and would you release the report with those 200 shipments missing?
Asked once · last asked Sep 29 · Scenario · Senior
A transaction was received at 11:58 p.m. Monday, validated at 12:02 a.m. Tuesday, and settled Wednesday. If the stakeholder asks for transactions processed on Tuesday, which event would you count, and what would you put in the acceptance criteria?
Asked once · last asked Sep 29 · Scenario · Mid-level
How would you diagnose doubled dashboard totals after a dimension change, protect reports, and prevent recurrence?
Asked once · last asked Sep 29 · Scenario · Senior
Other ways it was asked
- “If a dashboard total doubled after a new customer dimension was deployed even though the transaction facts have the expected number of rows, how would you assess the impact and prevent it from happening again?”
- “If a new customer dimension causes the Power BI shipment total to double even though the raw shipment count is unchanged, how would you escalate the issue, protect the report, and prove your diagnosis is correct?”
How do you design and govern external IDs and upsert keys across multiple integrated systems to prevent record fragmentation, especially when source systems disagree on system of record?
Asked once · last asked Oct 1 · Design · Senior
If the data owner confirms that a new code refers to the same region, but the mapping table contains two rows for that code, how would you decide which mapping to use and verify that the fix is safe?
Asked once · last asked Oct 1 · Scenario · Senior
When you find duplicate business keys, what criteria do you use to decide whether to deduplicate, merge records, or treat them as valid repeated events?
Asked once · last asked Oct 9 · Scenario · Senior
What identifier would you use to associate a calculation event with its source?
Asked once · last asked Oct 9 · Concept · Mid-level
If a legacy system uses one status, "closed," while a new domain model distinguishes completed work from canceled work, how should the boundary handle that status?
Asked once · last asked Oct 18 · Scenario · Senior
What effect can direct dependence on legacy database fields and their meanings have on new services?
Asked once · last asked Oct 18 · Concept · Senior
How could AI tools help teams agree on shared definitions, such as the meaning of “active”?
Asked once · last asked Oct 23 · Scenario · Senior
When an integration is decommissioned or a term's meaning changes, how do you detect the change and update the knowledge graph?
Asked once · last asked Oct 23 · Scenario · Senior
Who should make the final decision when stakeholders disagree about the meaning of a term in an ontology or knowledge graph?
Asked once · last asked Oct 23 · Scenario · Senior
How would you prevent data-integrity problems when using join tables?
Asked once · last asked Jul 17 · Scenario · Mid-level
How do you validate a knowledge graph?
Asked once · last asked Oct 23 · Scenario · Mid-level
Which roles should participate in validating a knowledge graph, and what perspectives do they contribute?
Asked once · last asked Oct 23 · Scenario · Mid-level
Where should teams discuss and align on shared definitions in a knowledge graph project, and how can they manage the time this takes?
Asked once · last asked Oct 23 · Scenario · Mid-level
More Data Modeling interview questions
- All Data Modeling interview questions
- Data Modeling Basics Interview Questions
- Database Schema Design Interview Questions
- Data Warehouse Architecture Interview Questions
- Lakehouse, Apache Iceberg, and Delta Lake Interview Questions
- Semantic Modeling and Power BI Interview Questions
How this list is made
Every question here was asked by a real interviewer in a real job interview that a candidate ran MeetAssist in. After the call, the interviewer's questions are pulled from the transcript. Practice sessions, tests, exams and anything that was not a job interview are dropped.
Questions are rewritten so they make sense on their own: names of people, employers and clients are removed, and speech-to-text mistakes are fixed. Small talk, logistics and questions about one candidate's own résumé are left out. Rephrasings of the same question are merged, and the count is the number of different interviews it came up in.
The interviews come from candidates who use MeetAssist, so they lean towards software, data and AI roles: the shares describe these interviews, not every Data Modeling interview. Answers to the most asked questions are written and checked by an editor; a "common mistake" is shown only when reviews of real answers in these interviews show it, with the count.
274 interviews, 168 candidates, Dec 2025 to Oct 2026. Updated every month with new interviews.
Or add the Chrome extension