🔥 3-day streak
Databricks Certified Data Engineer Associate107 / 150
Question 107 of 150

A data engineer is building a Gold-layer daily reporting table that must report the number of unique customers who placed orders per region. The source Silver table has hundreds of millions of rows, and the business requires the counts to be exact for financial auditing. Which Spark SQL aggregation should the engineer use in the GROUP BY query?

Reviewed for accuracy · Report an issueNext question