Data Analyst interview questions
SQL, Excel, statistics, dashboards and BI, Python pandas and business case questions.
186 questions · 6 topics · 12 free answers
0 of 186 practised · 0 bookmarked · saved on this device
44 questions match
SQL#1What does DISTINCT do and what does it cost on a large table?EasyConceptSQL Pro answer
This answer is part of Pro
10 of 186 Data Analyst answers are free. A Pro pass opens the rest, including hands-on task steps.
#2When should you pick UNION ALL over UNION when stacking query results?EasyConceptSQL Pro answer
This answer is part of Pro
10 of 186 Data Analyst answers are free. A Pro pass opens the rest, including hands-on task steps.
#3How does NULL behave in comparisons and what is IS NULL for?EasyConceptSQL Pro answer
This answer is part of Pro
10 of 186 Data Analyst answers are free. A Pro pass opens the rest, including hands-on task steps.
#4What is a primary key and how does it differ from a foreign key?EasyConceptSQL Pro answer
This answer is part of Pro
10 of 186 Data Analyst answers are free. A Pro pass opens the rest, including hands-on task steps.
#5What does GROUP BY do?EasyConceptSQL Pro answer
This answer is part of Pro
10 of 186 Data Analyst answers are free. A Pro pass opens the rest, including hands-on task steps.
#6How do DELETE, TRUNCATE and DROP differ in what they remove and whether they can be undone?EasyConceptSQL Pro answer
This answer is part of Pro
10 of 186 Data Analyst answers are free. A Pro pass opens the rest, including hands-on task steps.
#7What is an alias and why use one?EasyConceptSQL Pro answer
This answer is part of Pro
10 of 186 Data Analyst answers are free. A Pro pass opens the rest, including hands-on task steps.
#8What does LIMIT or TOP do and why pair it with ORDER BY?EasyConceptSQL Pro answer
This answer is part of Pro
10 of 186 Data Analyst answers are free. A Pro pass opens the rest, including hands-on task steps.
#9What is the difference between a CROSS JOIN and an INNER JOIN?EasyConceptSQL Pro answer
This answer is part of Pro
10 of 186 Data Analyst answers are free. A Pro pass opens the rest, including hands-on task steps.
#10How do you filter on a pattern in SQL?EasyConceptSQL Pro answer
This answer is part of Pro
10 of 186 Data Analyst answers are free. A Pro pass opens the rest, including hands-on task steps.
Hunting for a Data Analyst role too? See open Data Analyst jobs.