WorksheetsAdvanced SQL Quiz
Total questions: 15
Worksheet time: 8mins
Name
Class
Date
1.
What is the first step in a typical data pipeline?
a)
Analyze
b)
Transform
c)
Extract and Load
d)
BI
2.
Data is always stored in views.
a)
True
b)
False
3.
Which of the following are part of the transformation steps in a data pipeline?
a)
Cleaning
b)
Enrichment
c)
Aggregation
d)
Billing
4.
What is the main goal of the 'Transform' step in a data pipeline?
a)
To delete old data
b)
To create dashboards
c)
To clean and structure data
d)
To back up the database
5.
What is the main advantage of using views in SQL pipelines?
a)
They store data permanently
b)
They improve compression
c)
They automatically run faster
d)
They reduce storage use
6.
Which table layer typically stores enriched, business-level data?
a)
Bronze
b)
Silver
c)
Gold
d)
Raw
7.
What is one benefit of using materialized views?
a)
Automatically updates real-time data
b)
Faster performance due to stored results
c)
Can only be used with raw data
d)
Avoids any SQL queries
8.
What does “EL” stand for in ELT?
a)
Evaluate & Load
b)
Extract & Load
c)
Edit & Log
d)
Extract & Label
9.
In the View + Table method, where is the SQL logic stored?
a)
Only in tables
b)
In external scripts
c)
In views
d)
In BI tools
10.
What type of table temporarily stores data between steps in a pipeline?
(a)
11.
In the view-only method, each view stores results permanently.
a)
True
b)
False
12.
What are the two primary billing components of a data warehouse?
a)
Columns and queries
b)
Storage and processing
c)
Reports and partitions
d)
Tables and scripts
13.
Which SQL clause is used to filter rows before aggregation?
a)
ORDER BY
b)
WHERE
c)
HAVING
d)
GROUP BY
14.
Why is it best to avoid SELECT * in BigQuery?
a)
It returns empty tables
b)
It filters out rows
c)
It hides null values
d)
It increases processing costs
15.
Why is partitioning used in BigQuery tables?
a)
To compress data
b)
To reduce storage cost
c)
To improve query performance
d)
To format table names
100 %
