Prepare for and practice interview questions from Flexjobs.

Flexjobs Interview Questions

Flexjobs Interview Guides

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

<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>Let’s say you work for a social media company that has just done a launch in a new city. Looking at weekly metrics, you see a slow decrease in the average number of comments per user from January to March in this city.</p>

<p>The company has been consistently growing new users in the city from January to March.</p>

<p>What are some reasons why the average number of comments per user would be decreasing and what metrics would you look into?</p>


<p>What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?</p>

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

Decreasing Comments

How would you investigate a decline in the average number of comments per user?

Flexjobs Salaries by Position

<p>Subscribe to FlexJobs today and gain access to 25,000 hand-screened remote, work from home, & flexible schedule job listings. FlexJobs makes it easier, faster, and safer to find a job that better fits your life with professional job opportunities from entry-level to executive, startup to Fortune 500 - no ads, junk, or scams. Plus get exclusive access to both Career Coaching and Resume Reviews at a deep discount, as well as expert skills tests, valuable job search tips and articles, webinars with job search advice, educational guides and courses, and more. FlexJobs was founded in 2007 and has been featured on NPR, Good Morning America, Fox Business Channel, and thousands of other media outlets. Join today!</p>

Flexjobs Interview Questions

Flexjobs Interview Guides

Flexjobs Interview Questions

Flexjobs Salaries by Position

Flexjobs Opening Jobs