All 40 questions

  1. How would you design Salesforce data storage to handle millions of records?

    Asked in 3 of 362 interviews · last asked Oct 1 · Design · Senior

    Show answer

    I would keep active Accounts, Contacts, and Cases in standard objects, with relationships based on business needs. I would plan for yearly growth, storage limits, access rules, and retention, then archive older records or store them outside Salesforce. I would test queries and bulk operations at the expected scale.

    • Use selective filters on indexed fields, and check query plans with realistic data.
    • Avoid concentrating too many records under one parent or owner; this can cause locking and sharing problems.
    • Consider Big Objects or external storage, but check their query, reporting, and access limits first.
    • For migration, use Bulk API and external IDs for upserts; load parents first and validate results.

    What the interviewer checks: The interviewer checks whether you can balance Salesforce storage, performance, access, and data lifecycle needs at large scale.

    Other ways it was asked
    • “What should you consider when designing a Salesforce data model for millions of Account, Contact, and Case records?”
    • “What should you consider when designing a Salesforce data model for millions of Account, Contact, and Case records created annually?”
    • “How would you migrate millions of records from a legacy CRM to Salesforce, and how would you model and store very large data volumes in Salesforce?”
  2. How would you decide whether to partition a table, and how would you choose or change its partitioning strategy?

    Asked in 2 of 362 interviews · last asked Nov 16 · Design · Mid-level

    Other ways it was asked
    • “How do you decide the right partition key or partitioning strategy?”
  3. Can you tell me about partitioning and how you select the right column for partitioning a table?

    Asked in 2 of 362 interviews · last asked Sep 10 · Concept · Mid-level

    Other ways it was asked
    • “How would you choose columns for partitioning and clustering in a table?”
  4. How would you choose between shared tables and separate databases or tables for a multi-tenant application?

    Asked in 2 of 362 interviews · last asked Oct 2 · Design · Senior

    Other ways it was asked
    • “How would you manage tenant data in a multi-tenant application?”
    • “How would you manage the database for a multi-tenant application?”
    • “Which database would you choose for a new multi-tenant project, and how would you implement the multi-tenancy?”
  5. In a query joining a large fact table to multiple dimensions, what indicators tell you the plan is inefficient?

    Asked once · last asked Aug 23 · Scenario · Senior

    Other ways it was asked
    • “When a query joining a large fact table to multiple dimensions has an inefficient execution plan, what indicators would you look for, and what indexing or partitioning changes would you try first?”
  6. What multitenancy patterns or data-segmentation approaches can you use besides assigning a tenant ID?

    Asked once · last asked Feb 10 · Concept · Senior

  7. How would you design passport-number lookups and candidate score updates to avoid searching every company?

    Asked once · last asked Mar 6 · Design · Senior

  8. When building a secondary index for candidates by passport number, what should each index entry store?

    Asked once · last asked Mar 6 · Concept · Mid-level

  9. For a read-only REST service that retrieves records containing a BLOB and fails under 30 to 100 simultaneous requests, what changes would you consider to the database table structure?

    Asked once · last asked Mar 17 · Scenario · Senior

  10. How would you approach database schema design and performance tuning?

    Asked once · last asked Apr 9 · Concept · Mid-level

    Other ways it was asked
    • “Can you tell me more about your schema design and any performance tuning you've done with your databases?”
  11. How would you design a rough architecture for an image management system used by more than 50,000 merchants with over 4 billion images? What data would you need to manage, and how would you manage it?

    Asked once · last asked Apr 13 · Design · Senior

  12. When might hash-based sharding be unsuitable, even if it distributes data evenly across shards?

    Asked once · last asked Apr 13 · Scenario · Senior

  13. Explain your strategy for partitioning in Azure Data Lake Storage to account for large-scale enterprise projects.

    Asked once · last asked May 9 · Design · Senior

  14. When you're designing endpoints and data models for a web application, how do you ensure that they're efficient and scalable for future growth?

    Asked once · last asked Jul 16 · Design · Mid-level

  15. How do you handle very large JSON columns in a frequently read table? When do you keep JSON inline versus moving fields into typed columns or a side table, and why?

    Asked once · last asked Jul 27 · Design · Senior

  16. Would a 30-day time-to-live policy be appropriate for dropping old data partitions, and what factors would you consider?

    Asked once · last asked Jul 29 · Scenario · Mid-level

  17. How would you scale data pipelines and enterprise data warehouse solutions?

    Asked once · last asked Jul 29 · Design · Senior

  18. What are the considerations for using indexes in Greenplum and other MPP systems?

    Asked once · last asked Jul 31 · Concept · Senior

  19. How would you structure data and use serverless SQL pools to ensure cost-effective query performance in Azure Synapse Analytics?

    Asked once · last asked Aug 11 · Design · Senior

  20. If most queries filter on order date, what would be your partitioning strategy for the orders table?

    Asked once · last asked Aug 14 · Scenario · Mid-level

  21. If both partitioning and liquid clustering are available, when would partitioning be the better choice?

    Asked once · last asked Aug 14 · Scenario · Senior

  22. If you need to delete historical data, would you prefer partitioning or liquid clustering, and why?

    Asked once · last asked Aug 14 · Scenario · Senior

  23. How would you structure tenant data if you did not want to store it all in one table?

    Asked once · last asked Aug 20 · Design · Senior

  24. When processing data in Databricks, what considerations would you account for with Delta Lake, partitioning, and performance optimization?

    Asked once · last asked Aug 22 · Design · Senior

  25. How would you prevent data science and BI workloads from interfering when they query the same underlying tables?

    Asked once · last asked Aug 26 · Scenario · Senior

  26. How would you handle tenant isolation so customer data doesn’t leak across tenants?

    Asked once · last asked Sep 1 · Scenario · Senior

  27. Can you explain why ClickHouse is good for analytics, and how it differs from Postgres?

    Asked once · last asked Sep 2 · Concept · Mid-level

  28. How would you choose an approach for working with a Power BI dataset containing millions of rows?

    Asked once · last asked Sep 4 · Scenario · Senior

  29. What problems can occur if a table is partitioned by country and one country has much more data than the others?

    Asked once · last asked Sep 10 · Scenario · Senior

  30. How can you fine-tune a Power BI dashboard with 10 million rows, a 3.5-hour refresh, and an 8 GB file size?

    Asked once · last asked Sep 14 · Scenario · Senior

  31. You are designing an org with 20,000,000 records and a few accounts will each have hundreds of thousands of related records. What risks would you assess and how will they influence your data model and sharing design?

    Asked once · last asked Sep 18 · Design · Senior

  32. Which metric would you track over a month to determine whether a data model optimization is holding up over time?

    Asked once · last asked Sep 22 · Concept · Mid-level

  33. If a database table is partitioned, when might splitting the data into separate tables still be necessary?

    Asked once · last asked Sep 24 · Concept · Senior

  34. How would you handle enterprise data architecture for millions of records across Salesforce and analytics needs?

    Asked once · last asked Sep 30 · Design · Senior

  35. How would you design data isolation and a single point of entry in a SaaS solution?

    Asked once · last asked Oct 26 · Design · Senior

  36. How would you estimate the storage requirements for an online ticket booking system?

    Asked once · last asked Oct 29 · Design · Senior

  37. How do you decide when to refresh a materialized view?

    Asked once · last asked Nov 15 · Scenario · Senior

  38. How would you solve data skew when one join key value makes up 90% of the rows?

    Asked once · last asked Nov 16 · Scenario · Senior

  39. How would you identify and fix a partition that processes 90% of the data?

    Asked once · last asked Nov 18 · Scenario · Senior

  40. How would you partition a very large dataset?

    Asked once · last asked Jul 22 · Scenario · Mid-level

More Data Modeling 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.

362 interviews, 213 candidates, Dec 2025 to Nov 2026. Updated every month with new interviews.