Prepare for and practice interview questions from Deloitte across topics like SQL, Product Metrics, Presentation and more.

Deloitte Interview Questions

Python

Machine Learning

Product Metrics

A/B Testing

Analytics

Statistics

Probability

Algorithms

Deloitte Interview Guides

Write a query that, for each page, it gets the percentage of the users who recommended it that are in the same postal code as the page.

Note: A page can sponsor multiple postal codes.

Example:

Input:

<code>page_sponsorships</code> table

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>page_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>postal_code</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>price</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>
<code>recommendations</code> table 

<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>page_id</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<code>users</code> table

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>postal_code</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>
Output:

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>page</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>postal_code</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>percentage</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>

Page Recommendations

Suppose you work for an artificial intelligence team at ABC Neural Inc.

Your team’s task is to create a product that predicts the number of daily transit riders of the New York City Subway at a given hour. You’ll receive hourly data supplied from your client’s database to use as training data for supplementing your current AI’s working dataset. Predictions should be delivered on an hourly basis.

To start off your project, what are the product’s requirements?

Identify requirements for a machine learning model that predicts subway transit

Subway Machine Learning Model

Given a list of integers, identify all the duplicate values in the list. Assume that the list can contain both positive and negative numbers, and the order of the list does not matter. A number is considered a duplicate if it appears more than once in the list. Return a list of the duplicate numbers.

Example 1:

Input:

<pre tabindex="0" class="chroma"><code>nums = [1, 2, 3, 1, 2, 3]
</code></pre>

Output:

<pre tabindex="0" class="chroma"><code>find_duplicates(nums) -&gt; [1, 2, 3]
</code></pre>

The numbers 1, 2, and 3 all appear more than once in the list, so they are considered duplicates.

Example 2:

Input:

<pre tabindex="0" class="chroma"><code>nums = [1, -1, 2, 3, 3, -1]
</code></pre>

Output:

<pre tabindex="0" class="chroma"><code>find_duplicates(nums) -&gt; [-1, 3]
</code></pre>

The numbers -1 and 3 both appear more than once in the list, so they are considered duplicates. Note that the order of the output does not matter.

Example 3:

Input:

<pre tabindex="0" class="chroma"><code>nums = [1, 2, 3, 4, 5]
</code></pre>

Output:

<pre tabindex="0" class="chroma"><code>find_duplicates(nums) -&gt; []
</code></pre>

None of the numbers in the list appear more than once, so there are no duplicates.

This problem involves identifying duplicate numbers in a list of integers. The function should return a list of the duplicate numbers.

Deloitte Interview Questions

Deloitte Interview Guides

Deloitte Interview Questions

This feature requires a user account

Deloitte Salaries by Position