Support the project! The site exists thanks to the community. If the help covers the expenses - the platform remains free. ☕ Support →
SQL code copied to buffer

SQLtest.online
Task 10:
How would you model data for analytics in a warehouse: for example, using fact and dimension tables? Explain how you would choose grain, define keys, and avoid common mistakes that make reporting unreliable.

Write your answer in the field below and click the "Check!" button.

Get hint Voice input Stop listening Clear answer

Who is a Data Engineer?

A Data Engineer designs and maintains systems that collect, transform, and deliver data for analytics and business decisions.

What does a Data Engineer do?

  • Builds reliable ETL/ELT pipelines from multiple data sources.
  • Prepares clean and structured datasets for analysts and data scientists.
  • Designs data warehouse schemas (fact and dimension tables).
  • Monitors data quality, freshness, and pipeline failures.
  • Optimizes query performance and data processing costs.

What should a Data Engineer know?

  • Strong SQL: joins, aggregations, window functions, and query tuning.
  • Data modeling: normalization, denormalization, star and snowflake schemas.
  • Pipeline orchestration and scheduling principles.
  • Batch and streaming concepts, incremental loading, and idempotency.
  • Cloud storage, data warehouses, and observability basics.

This page helps you practice interview-style Data Engineering questions on SQLTest.online.

Support SQLtest.online

This project has only one funding source: your donations. The monthly maintenance cost is $100.

Last month I added a new MariaDB database with a preloaded University DB, 9 new questions, and refactored many questions and lessons.

With your support, I plan to continue this work: write new lessons and tasks, and improve existing lessons.

To keep the project running next month, we need to collect at least this amount by the end of this month. Anything above it goes to new lessons, exercises, and features.

Received: $29.58 Goal: $100.00
Progress: 30%
Learning SQL: Generate, Manipulate, and Retrieve Data by Alan Beaulieu
Learning SQL: Generate, Manipulate, and Retrieve Data by Alan Beaulieu
As data floods into your company, you need to put it to work right away―and SQL is the best tool for the job. With the latest edition of this introductory guide, author Alan Beaulieu helps developers get up to speed with SQL fundamentals for writing database applications, performing administrative tasks, and generating reports. You’ll find new chapters on SQL and big data, analytic functions, and working with very large databases.