Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Databricks Certified Data Analyst Associate · Databricks
Hotspot Scenario
Select the appropriate option to complete the statement. Click Check Answer below to see the marked solution.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
B give the following errore [MISSING_AGGREGATION] The non-aggregating expression "sales" is based on columns which are not participating in the GROUP BY clause. Add the columns or the expression to the GROUP BY, aggregate the expression, or use "any_value(sales)" if you do not care which of the values within a group is returned. SQLSTATE: 42803
Percent_rank is used to have ranking from 0 . Rank() returns 1 as the first number. B would be correct without GROUP BY clause. But looks better than other options ;/
Given all the other answers, B is the one that makes more sense However the GROUP BY clause does not make sense, we are not aggregating anything in this case, and it is not even possible to run that query without having an error. Anyone with a different idea?