Q4 You attempt to load a cvs file with 100 columns into a table and it fails because 1 row has too few values, how do you find the offending row?
Marketing Intelligence Interview Questions
6,927 marketing intelligence interview questions shared by candidates
How good you are on SQL from 1-10? Which platform have you used for SQL?
why are you moving on
DS, DA, big data, SQL
Data warehousing concepts, ETL fundamentals
Questions regarding ranking and metrics.
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
Viewing 6771 - 6780 interview questions