Task 7:

Build a unified customer view across systems

A pipeline loads customer data from a CRM, billing system, and product database, but the same customer has different IDs in each system. How would you design the data model and matching logic so analytics teams can use one reliable customer view?

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: $37.07 Goal: $100.00

Progress: 37%

Head First SQL: A Learner's Guide to Querying and Managing Data by Kimberly Fessel

Do you have an abundance of data but don't know how to make sense of it? Do you want to gain useful insights from your data, but you're not sure where to begin? Mining data is a vital, well-paying skill, and SQL provides the most fundamental way to query and manage data. But learning SQL can be intimidating. This thoroughly revised book teaches you SQL fundamentals in a painless and enjoyable manner. With the Head First series’ hands-on, conversational style, you'll quickly grasp SQL concepts, then move to intermediate topics, including subqueries and joins. You'll gain the knowledge, skills, and confidence necessary to get the most out of your data with SQL.

Practice

Lessons

Playground

Test

Build a unified customer view across systems

Login

Register

Build a unified customer view across systems