NEW
Font size
WorksheetsRefresh your knowledge in DE
Total questions: 18
Worksheet time: 10mins
When is ELT better than ETL?
With cloud data warehouses
With on-premise databases
When transforming before loading
When no transformation is needed
What is a common issue when handling large-scale distributed data?
High network latency
Lack of storage space
Excessive manual data entry
Too many relational tables
What is a primary goal of data normalization?
Increase storage usage
Reduce redundancy
Speed up queries
Remove all primary keys
Which data processing model is best for handling large-scale batch data?
Event-driven
Lambda
OLAP
OLTP
Which tool is commonly used for building ETL pipelines?
Apache Kafka
Apache Airflow
Elasticsearch
Apache NIFI
What is the main drawback of data denormalization?
Increased redundancy
Slower queries
More complex joins
Loss of integrity
Which SQL technique improves query performance on large tables?
Joins
Indexing
Normalization
CTEs
What is a key benefit of a data catalog?
Improves query speed
Stores raw data
Tracks metadata and lineage
Automates ETL jobs
Which architecture best supports decentralized data ownership?
OLAP
Data Lake
Data Mesh
Data Warehouse
What is the main trade-off when using materialized views?
Faster reads, but higher storage cost
Slower reads, but less storage usage
Requires primary keys
Reduces data redundanc
What is the main advantage of data modeling?
Makes data real-time
Eliminates data redundancy completely
Reduces the need for storage
Improves query performance
What is the primary use of Azure Data Factory?
Real-time analytics
ETL & data integration
Data storage
Machine learning
Which service is best for big data processing on Azure?
SQL Dedicated Pool
Azure Analysis Services
Azure Databricks
Azure Synapse
Which engine powers Azure Databricks?
Hadoop
Apache Spark
Hive
Apache iceberg
Which tool is best for orchestrating complex data pipelines in Azure?
SQL Dedicated Pool
Azure Analysis Services
Azure Data Factory
Azure Data Lake
Which service supports real-time stream processing in Azure?
Azure Data Factory
Azure Analysis Services
SQL Dedicated Pool
Azure Databricks
Bonus question :)
What is the main advantage of using Python’s logging module?
Prevents code errors
Increases execution speed
Replaces print statements for debugging
Improves API performance
Bonus question :)
What is the main purpose of a window function in SQL?
Filter data like WHERE and HAVING
Speed up queries by indexing data
Aggregate data without collapsing rows
Perform row-by-row operations like loops
