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>In an A/B test, how can you check if assignment to the various buckets was truly random?</p>


<p>In an A/B test, which of the following is a common method to determine if the assignment to the test groups was truly random?</p>

In an A/B test, which of the following is a common method to determine if the assignment to the test groups was truly random?

Random Bucketing

<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