Mini Case Interview: Cloud technology - File Sharing Business (e.g., Dropbox or AWS)
Q1. What factors do you need to determine the business is profitable
A1.
Q2. Interviewer put in the chat-box the number of users, available storage per user, average storage usage per user, and total storage capacity on servers, price of servers, monthly subscription fee, and marketing cost, can you calculate the amount of profit or loss? Allowed to use calculator.
A2.
Q3. Interviewer read numbers about a freemium marketing campaign, which resulted in 1 million free users, each with 10 gigabytes free storage and 10% usage on average. The campaign spent 4.8 million dollars on marketing, in hopes of converting users to paid customers for 1 terabyte of space. Each paid customer remain with the company for 2 month, with the monthly subscription fee of 24 dollars. What percentage of the free users have to convert to paid subscribers so that the company to break even? What happens to the amount of storage we need if we go ahead with the campaign.. check 1point3acres for more.
A3.
SQL interview
Q1. We want to select a destination for our vacation and we only care about the percentage of days that the destination is sunny. Write a query to determine our destination.
A1.