FastPrepBenchmarking Tool Report
Problems/Benchmarking Tool Report

Benchmarking Tool Report

Palantir logoPalantir● EasyNEW GRADOA

Updated Nov 2026

QuestionConstraints

Problem statement

Source note: Reported in a Palantir new grad online assessment. The photos in the report show the table, the class bands, the exact text of the result, and the row order.

This exercise uses scores that are never null, up to 200 rows, and signed 32-bit integers. The extra example tables are our own data.

Our version is about 95% the same as the reported question.

A benchmarking tool stores each device's score in devices. Its columns are id, an integer primary key, and score, an integer.

Return one column named device. Each device gets one row in the exact format Device <id> has class: <letter>, with the spaces, capital letters and colon shown.

  • A when the score is at least 80.
  • B when the score is at least 60 and below 80.
  • C when the score is at least 40 and below 60.
  • D when the score is at least 20 and below 40.
  • F when the score is below 20.

Sort the result by numeric device ID in ascending order. Keep separate rows for devices with the same score.

For this exercise, assume every score is non-null. Device IDs are unique and cannot be null. An empty table produces no result rows.

Table schema

MySQLPostgreSQLPandas

Use the same input data with any supported language. Open the Schema tab in the editor to see the generated SQL setup or Pandas DataFrames.

devices

ColumnTypeNullableDescription
idPKIntegerNo—
scoreIntegerNo—

Expected result

Your query or function must return these columns.

ColumnTypeNullableDescription
deviceTextNo—

Row order: must match exactly. Numeric tolerance: 0.

Constraints

  • devices contains 0 to 200 rows.
  • id and score are non-null signed 32-bit integers, from -2147483648 to 2147483647.
  • id is the primary key.

More Palantir Online Assessment questions

  • Basic Item DiscountsOA · Seen Nov 2026
  • Optimize Discount Selection Under a Point BudgetOA · Seen Nov 2026
  • Stacked Item and Category DiscountsOA · Seen Nov 2026
  • Minimize Path ValueOA · Seen Sep 2024
  • No Pairs AllowedOA · Seen Sep 2024
  • REST API: Country CodesOA · Seen Feb 2024
  • Swap ParityOA · Seen Feb 2024
  • Freelance Candidate ReviewOA · Seen Nov 2023
  • Count Fit Records Across PagesOA · Seen Sep 2023
  • Network FormationOA · Seen Sep 2023

Similar questions at other companies

  • Weekend Appointments for Consular Services ReschedulingMcKinsey & Company · OAMcKinsey & Company interview questions
  • Prepare Taxi Driver Classification DataBoston Consulting Group · OABoston Consulting Group interview questions
  • Clean the TapeMillennium · OAMillennium interview questions
  • Summarize Customer RecordsAgoda · OAAgoda interview questions
  • Latest New JobSphere · ONSITE INTERVIEW
  • Second Highest SalaryHartford Financial Services · ONSITE INTERVIEWHartford Financial Services interview questions
  • In-Memory Database QueriesOpenAI · PHONE SCREEN · ONSITE INTERVIEWOpenAI interview questions
  • Count User Mentions in Chat MessagesRamp · OARamp interview questions
  • Catch Fish with Reusable BaitsSusquehanna International Group (SIG) · OASusquehanna International Group (SIG) interview questions
  • Students Scoring Above AverageCapstone Investment Advisors · OA

Interview reports that mention this question

  • Palantir FDSE New Grad OA Questions: 6 Experiences (Part 2 of 2)

Palantir interview experiences

  • Palantir FDSE Experienced-Hire Interviews: 5 Experiences
  • Palantir FDSE New Grad Interviews: 5 Experiences (Part 1 of 2)
  • Palantir FDSE Intern OA and Interviews: 3 Experiences
  • Palantir FDSE Karat and Learning: 7 Experiences (Part 2 of 2)
  • Palantir FDSE OA and Interviews: 16 Experiences (Part 1 of 2)
All Palantir interview questionsSee Palantir hiring insights