Prepare for and practice interview questions from Apptio.

Apptio Interview Questions

Apptio Interview Guides

<p>What are time series models? Why do we need them when we have less complicated regression models?</p>


<p>What can happen if a traditional regression model is used on data that has autocorrelation?</p>

What can happen if a traditional regression model is used on data that has autocorrelation?

Why Do We Need Time Series Models? I

<p>Why can't standard regression models be used effectively for data points where current values are influenced by past values?</p>

Why can't standard regression models be used effectively for data points where current values are influenced by past values?

Why Do We Need Time Series Models? II

Why Do We Need Time Series Models?

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

Apptio Interview Questions

Apptio Interview Guides

Apptio Interview Questions

Apptio Salaries by Position

Apptio Opening Jobs