Amazon Interview Question
SDE-2sCountry: India
Interview Type: Phone Interview
Search for all the data rows in table corresponding to trials made by the customer in an attempt to use Alexa with Phillips light bulb.
This could mean the rows for example, where the Alexa commanded the bulb to be switched on, but in reality the bulb didn't switch on due to issue and in database, there was a row made for this, when next time the Alexa commanded for it to be switched off then the program could not really find a row where the data matched with the ON state and hence an exception could have been generated.
The fix program could identify such data rows in tables where actual transactions didn't happen in reality and delete those rows.
Looks like Product question,
- Vib February 02, 20191. Educate customer about not sharing the private data.
2. Have agreement with Philips asking for an API to query the voice samples anytime and check from Amazon side. Since its support information, they should not have any objecting to sharing.
3. Work with Philips to understand the issue why customers had to call in first place, if there is a bug force Philips to release fix asap.