🔥 3-day streak
Microsoft Fabric Analytics Engineer Associate124 / 150
Question 124 of 150

You are analyzing a Fabric warehouse fact table with over 8 billion rows. A dashboard needs an approximate count of distinct customer IDs per product category, and the business has approved a small margin of error (around 2%) in exchange for faster query performance. Which T-SQL function should you use to meet this requirement most efficiently?

Reviewed for accuracy · Report an issueNext question