Analyst Interview Questions in Seattle, WA

First, try and reproduce the problem and if the problem could be reproduced acknowledge there was an issue, give thanks for bringing this to the company's attention, and apologize for the customer's encounter with the issue. Offer possible solutions or workarounds while the team worked to correct the issue.

MS-SQL lets assume two tables - City and State each having common column called population here is the join on population field Select * from City Inner join State ON city.population = state.population Done :-)

MS-SQL lets assume two tables - City and State each having common column called population here is the join on population field Select * from City Inner join State ON city.population = state.population Done :-)

another answer. select * from table_A a, table_B a where a.population = b.population; pick one old or new school :-)

I only know of select count(*). I think there are other ways.

Can pivot table perform this function?

Can you please list as many technical questions as you remember? I have interview with MS for a similar position and I hope your questions would help me?.

select top 10 percent topsalaries.salary from (select top 10 Salary from Employee order by Salary desc) as topsalaries order by topsalaries.Salary asc

SELECT TOP 1 SALARY FROM ( SELECT DISTINCT TOP 6 ORDER BY SALARY DESC) AS TENTHSALARY ORDER BY SALARY

Glass door wont let me edit but switch 6 to 10 as shown below SELECT TOP 1 SALARY FROM ( SELECT DISTINCT TOP 10 ORDER BY SALARY DESC) AS TENTHSALARY ORDER BY SALARY

The most common answer, and the one I gave, is eliminate half of the smith, then half of the remaining and so on. However, there is a way to determine the culprit by measuring only once.

You need only one measurement; together, measure 1 coin from smith A, 2 coins from smith B, 3 coins from smith C,..., and 10 coins from smith J. You know which smith ripped you off by the amount missing; total weight with accurate coins would be 55 grams. For example, if the scale read 54.7 grams you would know that smith C was the culprit since exactly .3 grams were missing (3 coins).

You can do this with maximum 3 measurements. Weight 5 coins on each balance and see which one is lighter. So now you know out of which 5 coins you have the culprit. Now again weigh 2 coins on each balance, keeping one left coin with you. If they weight equal, you know the lightest coin is the one in your hand. If not, then you know out of which 2 coins is the lightest one. You can weigh them and see which is the one.

This would depend on which flight paths and the customer information given, but the test ultimately determined whether the interviewee was analytical.

Just out of curiosity, are the fraudsters using their tickets themselves or are they selling them? I guess I don't understand how they would make money out of it.

This is when you need to bring up specific school projects and assignments that dealt with problems in a similar way.

I would take the assignment or project and work on it in smaller, more managable portions which would allow me to complete the assignment within the required timeframe. If the assignment or project could not be completed within the required timeframe, it would be my responsibility to raise the issue to coworkers in order to complete the work as required.