Top 20 Data Analysts Question and Answer
11. What is a foreign key in a database? A unique identifier for a record A field that links to a primary key in another table A field that can be left empty A table used for foreign data Submit 12. What is the purpose of the COUNT function in SQL? To find the maximum value To count the number of rows To return the sum of values To find the average value Submit 13. What is the role of a data analyst? Writing machine learning algorithms Interpreting and analyzing data to help business decisions Developing software applications Managing databases Submit 14. What does a VLOOKUP function in Excel do? It returns the smallest value in a range It looks for a value in a column and returns a value from a different column It sorts data by ascending order It averages values from multiple columns Submit 15. What is a JOIN operation in SQL? It filters rows by a condition It combines rows from two or more tables based on a related column It