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>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

Session Difference

<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>You are testing hundreds of hypotheses with many <em>t</em>-tests. What considerations should be made?</p>


<p>What is a key disadvantage of the F-test when compared to multiple t-tests?</p>

What is a key disadvantage of the F-test when compared to multiple t-tests?

Hundreds of Hypotheses

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

Twitch Interview Questions

Overview

Twitch Interview Guides

Twitch Interview Questions

Twitch Salaries by Position