Data Engineer

# what does it output s = 'abracadabra' print(s[5][0][0][0]) print(s[::-2]) s = [1, 2, 3] print(s * 2)

What will happen when applying `s ** 2` to the list `s = [1, 2, 3]`?

How does list comprehension differ from a regular loop in Python?

What are decorators used for in Apache Airflow?

What is a decorator in Python?

# what it outputs s = 'Abracadabra' print(s[5][0][0]) b = 'a' print(b[0][0]) print(s[::-2]) #Arcd s = [1, 2, 3] print(s ** 2) def foo(*args, **kwargs): print(args) print(kwargs)

Compare ETL and ELT approaches: what are the differences and when is each used?

What is an RDD in Apache Spark and how does it differ from other Spark abstractions?

# what does it output s = 'Abracadabra' print(s[5][0]) b = 'a' b[0] print(s[::2]) s = [1, 2, 3] print(s * 2)

For each row in the salaries table, output the employee's name, date, salary, and using a window function, add a column "average salary by department on this date".

How do the resource requirements differ for storage during ETL and ELT?