TechBite 06/24

Interview Questions from CoinBase, Snowflake and Anthropic

🚀 Hey folks, this is HT! I was born in China, am currently a junior SDE at Expedia in Seattle.

I received lots of help during my interview preps. I will share some content related to computer science job hunting here, which hopefully increase your chances of passing the tech interview.

🔨 Want to land a tech job in US? It’s not easy, but let’s get to it!

🔥Hot Interview Questions(06/24)

CoinBase

The task involves writing a function to display Bitcoin transaction history. The function must adhere to specific formatting requirements. Follow-up questions include implementing features to cancel and pause transactions, as well as a feature to cancel all transactions for a particular user. There will also be questions about handling streaming data.

You are given a set of transaction histories to filter by time, user, and currency. The interviewer will discuss optimization strategies and then inquire about implementing pagination for the results.

Snowflake

Snowflake has many servers available for user rental, each characterized by a node id, status, and instance type. Instance types are somewhat distinct from EC2 and include categories such as s1, s2, s3, m1, m2, m3, L1, L2, L3, XL1, among a total of 100 types.

For example, server A can serve as m1, m2, L1, L2, while server B can function as s1, m1, L1. When a user requests two servers of types (m1, L1), both A and B can be returned. However, if the request is for two servers of types (m1, m2), server B cannot be returned.

Your task is to design a service to manage server nodes, with the following API: getServer(int reqNumOfServer, String[] instance_types); returnServer(int[] serverNodeIds).

Anthropic

Two System Design Questions:

Course Storage System: Create a storage system for courses with functions to add courses without duplicates (course id, name, credit).

Student Course Registration System: Develop a storage system for student course registrations. Students can only register for courses listed in the course storage and cannot register for more than 24 credits at a time (student id, registered course id, credit). Note that inputs and outputs are strings, but credits are integers, necessitating conversions.

🖼 Meme of the day

Train, Eat, Pray, Repeat