Advanced SQL Quiz

What is the first step in a typical data pipeline?

• Analyze
• Transform
• Extract and Load
• BI

Data is always stored in views.

• True
• False

Which of the following are part of the transformation steps in a data pipeline?

• Cleaning
• Enrichment
• Aggregation
• Billing

What is the main goal of the 'Transform' step in a data pipeline?

• To delete old data
• To create dashboards
• To clean and structure data
• To back up the database

What is the main advantage of using views in SQL pipelines?

• They store data permanently
• They improve compression
• They automatically run faster
• They reduce storage use

Which table layer typically stores enriched, business-level data?

• Bronze
• Silver
• Gold
• Raw

What is one benefit of using materialized views?

• Automatically updates real-time data
• Faster performance due to stored results
• Can only be used with raw data
• Avoids any SQL queries

What does “EL” stand for in ELT?

• Evaluate & Load
• Extract & Load
• Edit & Log
• Extract & Label

In the View + Table method, where is the SQL logic stored?

• Only in tables
• In external scripts
• In views
• In BI tools

What type of table temporarily stores data between steps in a pipeline?