Prepare for and practice interview questions from Syracuse University.

Syracuse University Interview Questions

Syracuse University Interview Guides

<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 that your company is running a standard control and variant AB test on a feature to increase conversion rates on the landing page. The PM checks the results and finds a .04 p-value.</p>

<p>How would you assess the validity of the result?</p>


Experiment Validity

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

Syracuse University Salaries by Position

<p>The Functional Business Analyst will work with members of the Comptroller's Office and Information Technology Services (ITS) to support, analyze, design, and implement the financial applications and systems. This position serves as the primary liaison between departmental users and ITS, and although this is not considered a technical role, data analysis and report writing experience is an essential part of this position. The Functional Business Analyst identifies organizational strengths and weaknesses and offers strategic solutions and initiatives by staying current with emerging industry best practices. This is an extremely fast paced, varied, cross-functional position requiring the ability to learn new processes on demand, while acting as an additional resource to assume the business analyst role on projects as required. In this role the candidate will work to ensure that projects align with theUniversity, Comptroller's Office, and Office of Sponsored Accounting strategic goals.</p>

Syracuse University Interview Questions

Syracuse University Interview Guides

Syracuse University Interview Questions

Syracuse University Salaries by Position

Syracuse University Opening Jobs