Databricks
CERTIFIED-DATA-ANALYST-ASSOCIATE · Question #12
A data analyst has been asked to count the number of customers in each region and has written the following query: If there is a mistake in the query, which of the following describes the mistake?
Sign in or unlock CERTIFIED-DATA-ANALYST-ASSOCIATE to reveal the answer and full explanation for question #12. The question stem and answer options stay visible for context.
Question
A data analyst has been asked to count the number of customers in each region and has written the following query:
If there is a mistake in the query, which of the following describes the mistake?
Options
- AThe query is using count('). which will count all the customers in the customers table, no matter
- BThe query is missing a GROUP BY region clause.
- CThe query is using ORDER BY. which is not allowed in an aggregation.
- DThere are no mistakes in the query.
- EThe query is selecting region but region should only occur in the ORDER BY clause.
Unlock CERTIFIED-DATA-ANALYST-ASSOCIATE to see the answer
You've previewed enough free CERTIFIED-DATA-ANALYST-ASSOCIATE questions. Unlock CERTIFIED-DATA-ANALYST-ASSOCIATE for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.