Questions regarding ranking and metrics.
Intelligence Interview Questions
6,924 intelligence interview questions shared by candidates
Tell me about a time you had to overcome pushback from your Manager
From a scale of 1 to 5, what would you say is your fluency with SQL?
SQL Table with the columns: UserID, TransactionID, DepartmentID, TransactionDate, UserName, DepartmentName 1. Do not remember the question. 2. For each department , show the users who make at least 3 transactions 3. For each department, select the user with the most Transaction (the result should contain the following fields: DepartmentName, UserName, number of interactions) 4. Difference between RowNumber and Rank Business question: Conversion ratio: x / (y + z) x = sales y = searches z = Searches in Alexa Given: The conversion rate increased, and the number of searches in Alexa (z) decreased. Question: Should I remove the Alexa search function? Answer: Not necessarily - need to check if y dropped more than z
3. SQL query to get all order lines and average of category on each record and return only top 10 categories
Q: Difference between UNION and UNION ALL
Why you want to join Amazon?
Row Level Security vs Column Level Security in Tableau? When to use ELT vs ETL? Snowflake vs Star?
(1) Oracle Partition/ Oracle Indexing (2) Types of joins (3) Difference between delete and truncate (4) Find customer who ordered this year and last year (5) Other SQL Coding questions
How do you work with stakeholders?
Viewing 6801 - 6810 interview questions