Databricks Assessment

Learning Objectives

Assess the ability to query and filter data using various SQL clauses and functions.

Evaluate skills in joining tables, using aggregate functions, and grouping data correctly.

Ensure understanding of data types and error handling

Test proficiency in using window functions

Overview

At GlobalMart, a retail company, data engineers solve real-world problems using Python, PySpark, and SQL. This assessment simulates practical scenarios they face, like transforming data, analyzing performance, and managing datasets, using essential data processing and querying skills.

Prerequisites

Familiarity with aggregations and different join types
Basic knowledge of DDL and DML statements
Understanding of core SQL clauses: SELECT, WHERE, HAVING, ORDER BY
Familiarity with basics of data types
Understanding of list and text processing
Basic knowledge of dataframe processing
Knowledge of group-by and aggregation, sorting, derived columns, and joins
Basic understanding of common file formats (CSV, JSON)

Databricks Assessment | Set - 01

Learning Objectives

Overview

Prerequisites