Skip to content

python-session-09-homework-quiz.md

Latest commit

 

History

History
141 lines (101 loc) · 2.62 KB

python-session-09-homework-quiz.md

File metadata and controls

141 lines (101 loc) · 2.62 KB
Raw

Session 9 Homework Quiz (Advanced Spark Practice)

Question 1

What should the homework use for the main analytics work?

  • pandas only
  • PySpark
  • spreadsheet formulas only
  • manual counting only

Answer: 2 Type: single Time: 40 Explanation: The homework practices advanced Spark analytics.

Question 2

Which view name is required in the homework?

  • market_data
  • orders
  • service_events_enriched
  • raw_python_list

Answer: 3 Type: single Time: 40 Explanation: The homework asks for a temporary view named service_events_enriched.

Question 3

How many Spark SQL queries are required at minimum?

  • One
  • Two
  • Zero
  • Six

Answer: 4 Type: single Time: 40 Explanation: The homework requires at least six Spark SQL queries.

Question 4

Which output file should the homework save?

  • results/spark_market_summary.csv
  • results/service_summary.csv
  • data/messy/service_summary.csv
  • reports/service_summary.docx

Answer: 2 Type: single Time: 45 Explanation: The Session 9 homework saves results/service_summary.csv.

Question 5

Which feature is required for time-based analysis?

  • README
  • quiz_score
  • event_hour or event_date
  • git_branch

Answer: 3 Type: single Time: 45 Explanation: Time-based queries need a time feature such as hour or date.

Question 6

Which technique is required for at least one ranking?

  • A Python print-only loop
  • A pandas-only groupby
  • A spreadsheet pivot table
  • A Spark window function

Answer: 4 Type: single Time: 50 Explanation: The homework requires a Spark window function for ranking.

Question 7

Which column belongs in the final homework summary?

  • close
  • latency_stddev
  • open_time
  • symbol

Answer: 2 Type: single Time: 45 Explanation: The service summary includes latency variability.

Question 8

What should students explain in the markdown submission?

  • Only the PySpark install command
  • Only the first raw row
  • Three findings in plain English
  • Nothing after saving CSV

Answer: 3 Type: single Time: 50 Explanation: Good analytics includes interpretation, not only code.

Question 9

Why is this homework useful for the final project?

  • It gives the exact final project answers
  • It replaces Team 2 cleaning
  • It avoids Spark entirely
  • It practices the same Spark workflow with a different dataset

Answer: 4 Type: single Time: 50 Explanation: The domain is different, but the Spark techniques are similar.

Question 10

What should happen at the end of the Spark notebook?

  • Delete the dataset
  • Call spark.stop()
  • Remove the schema
  • Convert all code to markdown

Answer: 2 Type: single Time: 40 Explanation: spark.stop() releases Spark resources.