Interview Questions

Kedar W. - "with login_data as ( select * from useractivitylog where activity_type = 'LOGIN' ) ,cte as ( select userid, timestamp as currentlogin ,lag(timestamp,1,timestamp) over (partition by user_id order by timestamp asc) as previous_login, round((julianday(timestamp) - julianday(lag(timestamp,1,timestamp) over (partition by user_id order by timestamp asc))) * 24 * 60) as minutes_elapsed from login_data ) select * from cte where currentlogin  previouslogin;"See full answer

Exponent - "This type of question is a Technical problem. Although you will not need to actually code the feature, it's important to understand basic technical concepts. Being able to cover these concisely with clarity shows you're an effective communicator. Here, we'll go over the broad technical steps needed to implement a basic reactions feature on Facebook. Briefly, the steps required are the following: Migrate the database to support reactions Write API code to be able to react to a post, and"See full answer

Anubhav A. - "Clarifying question: We are just interested in facebook's ad rev and not other meta products We are looking at the rev coming per year globally formula = (avg. ads shown per min on fb products) x (avg. time spent per user per day in mins) x (avg. rev that fb makes per view) x (DAU) x 365 assumption all kind of ads give the same rev per view to fb all kind of geographies give the same rev per view to fb avg. ads shown per min -> user can scroll upto 20 posts easily in a min, lets"See full answer

Raunak K. - "Define Groups: Platform where users ( organizers and members) with shared interests can come together and express their thoughts and opinions. Meta's mission: To bring ppl closer together by giving them access to tools and technology. Groups Mission alignment: Gives Organizers and members to come closer together over shared interests and build community. Users : Organizers ( create a group-> invite people on the platform --> can accept or deny a member to the group --> Intera"See full answer

Henil S. - "Clarifying Questions Goal - What is the goal for launching a new recommendation algorithm? (Assume an increase in user engagement) User Persona Using a recommendation system to explore new artists/songs in the same genre Using a recommendation system to explore new genres of songs Using a recommendation system to explore to format of content(Podcasts, Comedy, Stories) Metrics to look at to analyze if we need a new algorithm or not. Metrics Number of songs listened to"See full answer

Arthur Y. - "Clarifying questions: Clarify what Facebook Lite is Assumed answer: It’s a slimmed down version of mobile FB app optimized for slower connections and uses less data than the primary mobile FB app by not offering features like videos and high resolution photos. It is only available on Android and primarily built by FB to the developing world can have access to FB. What is meant by “opens are down”? Assumed answer: The total amount of opens of the app on Android devices"See full answer

Nasit S. - "Depend on the array size and number of 0's theere."See full answer

Tony A. - "Get alignment with interviewer on how Gen AI works, then talk about the automotive space with value chain analysis on high level: 1. Design the automobile 2. Source components 3 assemble 4. Market 5. sell to customer 6 vehicle operation and maintenance. Competition: Hyper competitive industry with ~10 big manufacturers in the world. Trends: EV, Self-driving Potential Goals for the Automotive company Gen AI use case: Gain market share by offering Gen AI driven value to its customers Bi"See full answer

Hamilton D. - "no"See full answer

Jaya S. - "Understood the problem statement by confirming details with interviewer. Approached by listing down all the basic features being provided by the platform. Platform -> Organizations can register themselves. One org can have more than one recruiters. Recruiters create jobs on the org portal. Candidate can apply to the jobs. Recruiters can accept and reject the applications. Categorized 4 parent tables by taking hints in between. The tables were USER -> ID, Name, Phone No, mail ID, Profile Des.("See full answer

Shahnawaz K. - "I am going to assume, the person is 50 years old and uses a basic feature phone. Here is how it goes Local Context: When you come back from morning walk, you are your friends stop at a chai point to rest and have tea, what do you talk about ? (Assume he says everything and anything). Imagine there are no friends but you still want to talk and you want your friends and everyone to listen to your thoughts / rant. Imagine you don’t want to talk but you want only listen to what your frien"See full answer