Prepare for and practice interview questions from Twitch across topics like SQL, Python, A/B Testing and more.

Twitch Interview Questions

<p>Twitch is an american video game streaming service formerly known as Justin.tv</p>

Twitch is an american video game streaming service formerly known as Justin.tv

Overview

A/B Testing

Algorithms

Analytics

Machine Learning

Probability

Product Metrics

Python

Statistics

Twitch Interview Guides

<p>Meta aims to integrate its live streaming services across Instagram, Facebook, Facebook Gaming, and WhatsApp. The goal is to enable simultaneous video viewing across these platforms, while also offering a cohesive experience for live comments.</p>

<p>This unified commenting system requires the capability for comments to be persistent (i.e., they can be reviewed later for analytics) and support interactive features such as reactions (likes, hearts, cares, etc.) from users across all platforms. Additionally, it’s crucial that the reaction counts are updated and displayed in real-time to all viewers.</p>

<p>How would you approach designing a system capable of processing and displaying real-time data across multiple platforms?</p>


How would you approach designing a system capable of processing and displaying real-time data across multiple platforms?

Unified Live Comments

<p>Let’s say we have a table with an <code>id</code> and <code>name</code> fields. The table holds over 100 million rows and we want to sample a random row in the table without throttling the database.</p>

<p>Write a query to randomly sample a row from this table.</p>

<p><strong>Input:</strong></p>

<p><code>big_table</code> table</p>

<table>
<thead>
<tr>
<th>Columns</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>name</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>


Write a query to randomly sample a row from a big table.

Random SQL Sample

<p>Given a table of user sessions, write a query to get the number of days between each user’s first session and last session for the year 2020. </p>

<p><strong>Example:</strong></p>

<p><strong>Input:</strong></p>

<p><code>user_sessions</code> table</p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>session_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>created_at</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>user_id</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>user_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>no_of_days</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>


Find the difference between users' first and last sessions in the year

Twitch Interview Questions

Overview

Twitch Interview Guides

Twitch Interview Questions

Twitch Salaries by Position