All 40 questions
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?”
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?”
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?”
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?”
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?”
What multitenancy patterns or data-segmentation approaches can you use besides assigning a tenant ID?
Asked once · last asked Feb 10 · Concept · Senior
How would you design passport-number lookups and candidate score updates to avoid searching every company?
Asked once · last asked Mar 6 · Design · Senior
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
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
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?”
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
When might hash-based sharding be unsuitable, even if it distributes data evenly across shards?
Asked once · last asked Apr 13 · Scenario · Senior
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
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
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
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
How would you scale data pipelines and enterprise data warehouse solutions?
Asked once · last asked Jul 29 · Design · Senior
What are the considerations for using indexes in Greenplum and other MPP systems?
Asked once · last asked Jul 31 · Concept · Senior
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
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
If both partitioning and liquid clustering are available, when would partitioning be the better choice?
Asked once · last asked Aug 14 · Scenario · Senior
If you need to delete historical data, would you prefer partitioning or liquid clustering, and why?
Asked once · last asked Aug 14 · Scenario · Senior
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
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
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
How would you handle tenant isolation so customer data doesn’t leak across tenants?
Asked once · last asked Sep 1 · Scenario · Senior
Can you explain why ClickHouse is good for analytics, and how it differs from Postgres?
Asked once · last asked Sep 2 · Concept · Mid-level
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
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
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
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
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
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
How would you handle enterprise data architecture for millions of records across Salesforce and analytics needs?
Asked once · last asked Sep 30 · Design · Senior
How would you design data isolation and a single point of entry in a SaaS solution?
Asked once · last asked Oct 26 · Design · Senior
How would you estimate the storage requirements for an online ticket booking system?
Asked once · last asked Oct 29 · Design · Senior
How do you decide when to refresh a materialized view?
Asked once · last asked Nov 15 · Scenario · Senior
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
How would you identify and fix a partition that processes 90% of the data?
Asked once · last asked Nov 18 · Scenario · Senior
How would you partition a very large dataset?
Asked once · last asked Jul 22 · Scenario · Mid-level
More Data Modeling interview questions
- All Data Modeling interview questions
- Data Modeling Basics Interview Questions
- Database Schema Design Interview Questions
- Slowly Changing Dimensions and Historical Data Interview Questions
- Data Warehouse Architecture Interview Questions
- Lakehouse, Apache Iceberg, and Delta Lake Interview Questions
- Semantic Modeling and Power BI Interview Questions
- Data Quality and Governance 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.
Or add the Chrome extension