FastPrepEmployee Names With Access Records
Problems/Employee Names With Access Records

Employee Names With Access Records

Palantir logoPalantir● EasyNEW GRADOA

Updated Nov 2026

QuestionConstraints

Problem statement

Source note: Reported in a Palantir new grad online assessment. The FDSE author describes two tables. The task asks for the names of employees whose ID has at least one record in the second table. This suggests an inner join and grouping.

We named the tables employees and access_logs, and we wrote their schemas and test data. The result has one row per employee. Different employees may share a name. The result order is free.

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

Find employees who have used an access token at least once. The employees table has columns id and name. The access_logs table has columns employee_id and access_token.

Return one column named name. Include each employee whose ID has at least one matching access-log row, exactly once per employee. Several logs for the same employee do not add result rows. Different employees with the same name remain separate rows, so their name may appear more than once.

Return rows in any order. Employee IDs are unique and non-null. All names, log references and tokens are non-null, and every log refers to an existing employee.

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.

employees

ColumnTypeNullableDescription
idPKIntegerNo—
nameTextNo—

access_logs

ColumnTypeNullableDescription
employee_idIntegerNo—
access_tokenTextNo—

Foreign key: employee_id → employees(id)

Expected result

Your query or function must return these columns.

ColumnTypeNullableDescription
nameTextNo—

Row order: any order is accepted. Numeric tolerance: 0.

Constraints

  • employees has 0 to 200 rows and access_logs has 0 to 500 rows.
  • Employee IDs are signed 32-bit integers from -2147483648 to 2147483647.
  • Names have 1 to 60 ASCII letters or spaces. Tokens have 1 to 32 ASCII letters or digits.
  • Repeated log rows and repeated tokens are allowed.

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
  • Benchmarking Tool ReportOA · Seen Sep 2023
  • Count Fit Records Across PagesOA · Seen Sep 2023

Similar questions at other companies

  • Students Scoring Above AverageCapstone Investment Advisors · OA
  • Bond Interest Summary Above 3%Wells Fargo · OAWells Fargo interview questions
  • Employee Promotion OpportunitiesIntuit · OAIntuit interview questions
  • Students and Their SubjectsBirla Pivot · OA
  • Companies with Average Salary Above 40000AT&T · OAAT&T interview questions
  • Build Taxi Driver Performance FeaturesBoston Consulting Group · OABoston Consulting Group interview questions
  • Weekend Appointments for Consular Services ReschedulingMcKinsey & Company · OAMcKinsey & Company interview questions
  • Companies Above a Salary ThresholdVerisk · OA
  • Customer Resource Usage AnalysisIBM · OAIBM interview questions
  • Customers Who Never OrderedAccenture · OAAccenture interview questions

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