Prepare for and practice interview questions from Cognizant Technology Solutions across topics like Algorithms, SQL, Python and more.

Cognizant Technology Solutions Interview Questions

A/B Testing

Algorithms

Analytics

Machine Learning

Probability

Product Metrics

Python

Statistics

Cognizant Technology Solutions 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>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>There was a robbery from the ATM at the bank where you work. Some unauthorized withdrawals were made, and you need to help your bank find out more about those withdrawals.</p>

<p>However, the only information you have is that there was more than 1 withdrawal, they were all performed in 10-second gaps, and no legitimate transactions were performed in between two fraudulent withdrawals.</p>

<p>We’re given a table of bank transactions with three columns, <code>user_id</code>, a deposit or withdrawal value <code>transaction_value</code>, and <code>created_at</code> time for each transaction.</p>

<p>Write a query to retrieve all user IDs in ascending order whose transactions have exactly a 10-second gap from one another.</p>

<p><em>Note: Assume that there are only withdrawals from the ATM, which are denoted with a positive <code>transaction_value</code></em></p>

<p><strong>Example:</strong> </p>

<p><strong>Input:</strong></p>

<p><code>bank_transactions</code> table</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>created_at</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>transaction_value</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>
<p>For given table <code>bank_transactions</code>:</p>

<table>
<thead>
<tr>
<th><code>user_id</code></th>
<th><code>created_at</code></th>
<th><code>transaction_value</code></th>
</tr>
</thead>

<tbody>
<tr>
<td>1</td>
<td>2017-01-01 10:10:15</td>
<td>10</td>
</tr>

<tr>
<td>2</td>
<td>2017-01-01 11:11:11</td>
<td>20</td>
</tr>

<tr>
<td>3</td>
<td>2017-01-01 12:12:12</td>
<td>10</td>
</tr>

<tr>
<td>4</td>
<td>2017-01-01 10:10:20</td>
<td>30</td>
</tr>

<tr>
<td>5</td>
<td>2017-01-01 10:10:34</td>
<td>40</td>
</tr>

<tr>
<td>6</td>
<td>2017-01-01 11:11:21</td>
<td>50</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

<table>
<thead>
<tr>
<th><code>user_id</code></th>
</tr>
</thead>

<tbody>
<tr>
<td>2</td>
</tr>

<tr>
<td>6</td>
</tr>
</tbody>
</table>


There was a robbery from the ATM at the bank where you work. Some unauthorized withdrawals were made, and you need to help your bank find out more about those withdrawals.

Cognizant Technology Solutions Interview Questions

Cognizant Technology Solutions Interview Guides

Cognizant Technology Solutions Interview Questions

Cognizant Technology Solutions Salaries by Position