Interview Questions

Jaime A. - "I might be missing something but the solution, seems to be incorrect. ... , post_pairings AS ( SELECT ps.user_id, ps.postseqid AS failpostid, ps.postseqid + 1 AS nextpostid FROM post_seq AS ps WHERE ps.issuccessfulpost IS TRUE ) -- here ps.issuccessfulpost IS TRUE the condition should be FALSE -- in that way ps.postseqid is the actual failed post(failpostid) -- Additionally, at the end the join is assumming that the sequence id is going to match the post_id, wh"See full answer

Anonymous Jellyfish - "Thank you for the question! Normally, I would want to ask some clarifying questions to try to better understand the scope of the problem. Below are some of those questions & assumptions I am going to make because I need to submit an answer without getting a response. Question 1: What is Facebook’s north star metric for this exercise? Growth? Engagement? I’m also keeping in mind that because we are talking about building a birthday feature in the earlier stages of Facebook, their north s"See full answer

Abdurhman M. - "Start your stream Use the Post tab to: Choose where to post your live broadcast. Write a description. Select a camera, mic and screen (if screen sharing). Add a title for your live broadcast (optional). Select the primary language of the stream. ... Once everything is set, select Go Live."See full answer

Bravin V. - "I aim to utilize hands-on activities to apply the knowledge I've acquired, safeguard the organization from threat actors, and contribute to its growth."See full answer

Smriti G. - "Product -> Self service Portal North Star Metric-> No. of proposal downloaded Problem-> 15% Decrease in Proposal downloads RCA-> System Health check-> Bugs, errors in pages during session, site crashed, server inavailability, new feature was introduced which made it difficult for user to navigate. If there was problem of server in-availability, is load balancer working fine/server is not available? If problem was with feature-> What feature was introduced? do an A/B test with older feature Fu"See full answer

Greg W. - "Clarifying Questions: Is this for business travel, personal travel, or both? Are there any particular objectives that we want to focus on? Think about why Facebook would want to do this is it because they are thinking about building an external-facing travel product, and want to test it on Facebook employees first? Facebook employees work hard, so they want to make sure that their employees are taking the vacations they need to optimize performance List user types employees trav"See full answer

Bulent K. - "I said we could always revert the production issues. Solve it at DEV environment and then publish again. Interviewer gave me an example of it like a database schema change that may not be possible to revert. I said that we always used SQL scripts to upgrade and downgrade the database schema for each production deployment. So it would not be a problem for us. I guess my answer was not accepted."See full answer

Adrian V. - "What about sharding by Real Estate companies that are listing the homes? Because the homes can span zip codes. Then further shard by zip codes?"See full answer

Kanwal jeet singh L. - " I have told about the challenge I have faced while designing the Automation Framework for Angular and React website and why we have to use 1 library puppeteer sharp over selenium e.g. we need to handle the asynch calls correctly when an object is selected in the UI and result is awaited for it."See full answer

Michael B. - "Problem: Given an input string txt consisting of alphanumeric characters and the parentheses characters '(' & ')', write a function which removes the minimum number of characters to return a version of the string with properly balanced parenthesis. Answer: You can do this with a counter. Psuedo-Python Start with counter = 0 output = [] Iterate through the string, every time you encounter a '(', increment the counter. Add the character to the output. If you encounter a ')', decrement the coun"See full answer

Rishabh L. - "Pizza Ordering System orderdetail - orderdetailid (PK), orderid (FK), itemid (FK), itemqty, itemized_price order - orderid (PK), customerid (FK), orderdate, locationid (FK), ordertype (DINEIN, PICKUP, DELIVERY), refid (dineinid, pickupid, deliveryid), subtotal, tax, tip, totalamount, payment_method (CASH, CARD) location - locationid (PK), locationdesc, city, state, startdate, enddate customer - customer_id (PK), name, address (nullable), phone (nullable), dob (d"See full answer

Coach - "Product "XYZ" explain what it is and which audience it is serving. Goals Ease the anxiety Offer the most comprehensive perspective of Cloud Engagement Democratize Upsell Insights Business Review Deck Slide #1: NPS - Now, Trend & Insights + Call To Action: FYI & solicit feedback Slide #2: User Engagement Update - DAU, WAU, MAU, Actions Completed + Call To Action: FYI & solicit feedback Slide #3: Partnership Update - Share new cross org collabor"See full answer