A large e-commerce platform needs to display on its dashboard the number of unique visitors per day for the last 90 days. The events table has 10 billion rows. The dashboard must load within seconds, and an exact count is not required. The team also needs to compare daily counts to identify trends. Which approach best meets these requirements?

Use APPROX_COUNT_DISTINCT(user_id) grouped by date in a live query.

Use COUNT(DISTINCT user_id) grouped by date in a live query.

Use COUNT(user_id) grouped by date in a live query.

Precompute daily approximate distinct counts in a scheduled job and have the dashboard query the precomputed table.

A data analyst needs to count the number of distinct IP addresses that accessed a web server over the last month. The log table has over 2 billion rows. The exact count is not critical; a fast estimate is preferred. Which approach should the analyst use?

APPROX_COUNT_DISTINCT(ip_address)

DatabricksCertified Data Analyst Associate

Domain 4Objective 5

Perform Aggregate Operations Such as Count, Approximate Count Distinct, Mean, and Summary Statistics. DATA-ANALYST-ASSOCIATE Practice Questions (Page 2)

Part of the Section 4: Executing queries using Databricks SQL and Databricks SQL Warehouses domain, which makes up ~22% of our current practice bank. Databricks does not publish an official question count, but from its 90-minute exam (~35–60 total, ~8–13 in this domain), expect 1–1 from this objective — we provide 16 practice questions to prepare you well beyond it. (estimate)

16questions here

4free pages

6concepts

Questions 6–10

6foundation · easy
Which function would you use to compute the standard deviation of a numeric column, a measure of how spread out the values are?
Select an answer first
7foundation · easy
In Databricks SQL, which two function names can be used interchangeably to compute the average of a numeric column?
Select an answer first
8foundation · easy
Which pair of functions can be used together to find the smallest and largest values in a numeric column?
Select an answer first
9expert · hard
A large e-commerce platform needs to display on its dashboard the number of unique visitors per day for the last 90 days. The events table has 10 billion rows. The dashboard must load within seconds, and an exact count is not required. The team also needs to compare daily counts to identify trends. Which approach best meets these requirements?
Select an answer first
10application · medium
A data analyst needs to count the number of distinct IP addresses that accessed a web server over the last month. The log table has over 2 billion rows. The exact count is not critical; a fast estimate is preferred. Which approach should the analyst use?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DATA-ANALYST-ASSOCIATE

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Databricks. “DATA-ANALYST-ASSOCIATE” is a trademark of its owner, used for identification only.

Perform Aggregate Operations Such as Count, Approximate Count Distinct, Mean, and Summary Statistics. DATA-ANALYST-ASSOCIATE Practice Questions (Page 2)

Questions 6–10

Which function would you use to compute the standard deviation of a numeric column, a measure of how spread out the values are?

In Databricks SQL, which two function names can be used interchangeably to compute the average of a numeric column?

Which pair of functions can be used together to find the smallest and largest values in a numeric column?

A data analyst needs to count the number of distinct IP addresses that accessed a web server over the last month. The log table has over 2 billion rows. The exact count is not critical; a fast estimate is preferred. Which approach should the analyst use?

Keep studying — Section 4: Executing queries using Databricks SQL and Databricks SQL Warehouses