Row Level Security vs Column Level Security in Tableau? When to use ELT vs ETL? Snowflake vs Star?
Intelligence Analyst Interview Questions
6,979 intelligence analyst interview questions shared by candidates
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
Q: Difference between UNION and UNION ALL
Why you want to join Amazon?
Technical SQL questions like joins (How would you use them and a specific query structure for a simple use case) how many rows might this query return if we are using a particular join
1. what are views? 2. SQL query using Group by and aggregations 3. cartesian product conceptual questions
SQL and behavioral questions
Questions regarding ranking and metrics.
What is t-test
Viewing 6721 - 6730 interview questions