PySpark and AWS: Master Big Data with PySpark and AWS - Quiz (UDFs)

The video tutorial guides students on how to use office data in CSV format for a quiz. It explains how to read the data into a data frame and create a new column for employee increments based on their location. The criteria for increments differ for employees in NY and C states. An example calculation is provided for better understanding. Students are encouraged to solve the problem, with a promise to discuss the solution in the next video.

What is the first step you need to take when starting the quiz?

• Create a new column for increments

• Read data from the office data CSV file

• Calculate the bonus for employees

• Discuss the solution in the next video

How is the increment calculated for an employee in NY state?

• 15% of salary plus 2% of bonus

• 8% of salary plus 6% of bonus

• 10% of salary plus 5% of bonus

• 12% of salary plus 3% of bonus

What is the increment percentage for an employee in C state?

• 15% of salary plus 2% of bonus

• 8% of salary plus 6% of bonus

• 10% of salary plus 5% of bonus

• 12% of salary plus 3% of bonus

If an employee in NY state has a salary of $100 and a bonus of $50, what would be the total increment?

• $10

• $12.5

• $15

• $7.5

What should you do after calculating the increment for employees?

• Load the data into a new CSV file

• Create a graph of the increments

• Solve the problem and prepare for the next video

• Discuss the solution with a colleague