JavaScript is required to use this application. Please enable JavaScript in your browser settings or disable any extensions that may be blocking scripts.
Questions tagged sql · hard
Data Warehouse Design from scratch
Describe a situation where you had to redesign a data model to meet changing business needs
Describe how metadata is stored and accessed for internal tables in a relational database.
Design a Custom API that can query a backend server and return customer data such as the number of orders placed by a user based on their user ID
Design a daily ETL pipeline to ingest API data into BigQuery.
Design a financial database system focusing on database models, schema design, partition keys, and query optimization techniques.
Design a relational data model for a sales database, incorporating normalization techniques
Design a structure (data model) that allows efficient querying of movies based on multiple search criteria (title, genre, actor, director).
Get the complete 1,800+ question library with detailed, expert-level answers covering SQL, Spark, System Design, Python, Cloud, and Behavioral topics.