📊 Analytics Engineering Quest
Welcome, Data Analyst! Your company is building a modern data warehouse.
You need to understand data modeling, SQL queries, dbt transformations, and database design to ensure the system works efficiently.
Prove your skills by completing the following analysis test.
✍ Enter Your Name
Question 1
Which type of table stores metrics like total sales?
Dimension Table
Fact Table
Staging Table
Question 2
What is the main purpose of dbt in analytics engineering?
Data visualization
Transforming data in warehouse
Extracting data from APIs
Question 3
Which SQL command is used to create a table?
CREATE TABLE
INSERT INTO
UPDATE
Question 4
In star schema, which table contains foreign keys to dimensions?
Fact Table
Dimension Table
Staging Table
Question 5
Which technique ensures data integrity during transformations in dbt?
Snapshots
Documentation
Tests
🎉 Congratulations
This certifies that
successfully completed the Analytics Engineering Test.