BenchMark Quizzes by MDFT Pro

Identify Duplicate Email Addresses

You work for MDFT Pro, a well-known training agency. Your organization has a Fabric tenant that contains a data warehouse with a table named DimStudent.

DimStudent contains the following fields:

ID	StudentKey	StudentAltKey
1	29546	christopher@mdft.academy
2	29587	john@mdft.academy
3	29612	richard@mdft.academy

You need to run a sql query to perform the following analysis:

Identify duplicate email addresses in DimStudent
Return a maximum of 1,000 records

Which T-SQL query should you run? Select each correct answer to build up the query in the correct order.

Choose all correct answers from the options below.

Explanations for each answer:

SELECT TOP(1000) StudentAltKey, COUNT(*) is correct.
SELECT StudentAltKey, COUNT(*) is incorrect. This statement is missing the TOP clause to limit the results to 1,000 records as required by the question.
FROM DimStudent is correct.
WHERE COUNT(*) > 1 is incorrect. The WHERE clause cannot be used with aggregate functions like COUNT(). The HAVING clause must be used instead to filter on aggregate results.
GROUP BY StudentAltKey is correct.
HAVING COUNT(*) > 1 is correct.
LIMIT 1000 is incorrect. LIMIT is not a valid T-SQL keyword. In T-SQL, we use TOP to limit the number of rows returned.

Learn more about SELECT statement syntax:

SELECT Statement

Exam Preparation Quiz

Identify Duplicate Email Addresses