geographically, can or not work in other place?
Support Analyst Interview Questions
5,370 support analyst interview questions shared by candidates
First, the day after I submitted my resume, they called me to make an appointment for phone interview and asked me about basic information like school, major, interests. Phone interview: They asked me about FMD GROUP, the business model and five years plan. And then we set up the day for assessment day. Assessment Day: IT Aptitude Test, pseudocode for loop, HTML stands for? UNIX egrep stuff. Math Test, super easy and nothing to worry about if you feel confident about HS math. Logic Test, super easy with Venn Diagram. 2 Interviews: Tech, basic SQL, join, primary key, foreign key, what do you know about for loop Behaviour, Project, interests, how do you know about us. Remember to make them feel you really wanna join and love the business mode.
Table 1: Analysis.dimProducts Column DataType ProductID INT(PK) Identity Name Varchar(100) Cost money Table 2: Analysis.dimCustomers Column DataType CustomerID Int (PK) IDENTITY FirstName Varchar(100) LastName Varchar(100) Table 3: Analysis.dimSales Column DataType SalesID INT (PK) IDENTITY ProductID INT (FK) CustomerID INT (FK) Quantity INT Questions 1. Write a query that would return the cost associated with a product of the name of “Shampoo” 2. Write a query that would return the first and last name (with one column as the return set instead of two) of all customers 3. Write a query that would return all sales associated with a customer with the first name of “Bob” and the last name of “Smith” 4. Write a query that would return the total number of products purchased by a customer with the first name of “Bob” and the last name of “Smith”. 5. Alter the query in question #4 to return the total number of products purchased by a customer with the first name of “Bob” and the last name of “Smith”, but still returning a value of zero if that name had no sales 6. Write a query that would return the amount of money made in revenue total based on the sales made of products. The result should be just one column. 7. Insert a new customer with the name of “Phil” and the last name of “Frank” 8. Delete a product with the name of “Shampoo” (make sure to incorporate all tables that would need to be validated before you do this delete) 9. Using joins, update the amount of the product “Shampoo” ordered by a customer with the name “Bob Smith” to 5 (assume there’s only one SaleID that represents this customer)
- Provide an example of a problem solved outside the box
- What is the worst you did at work
"What's something that you are known for outside your career? Something you are really knowledgeable about...If I came to you about this what are some questions you would ask me?"
Why Ross?
Detailed scenarios about my previous work experience.
Do you have experience in handling tickets?
Experience using Warehouse Management System
Viewing 1181 - 1190 interview questions