NTILE — Concept Check
Questions on NTILE. NTILE(n) distributes rows into n ranked buckets as evenly as possible, enabling quartile, decile, and percentile segmentation directly in SQL.
Questions in this quiz
8 questions on NTILE — Concept Check. Work through them here, then start the quiz to answer them and see your score.
1.A company wants to divide its customers into four spending groups. Which SQL function can they use to achieve this segmentation?
- APERCENT_RANK()
- BCUME_DIST()
- CNTILE(4)
- DRANK()
2.A retailer uses NTILE(10) to analyze sales data. What does each bucket represent?
- AA decile of sales data
- BA quartile of sales data
- CA rank of sales data
- DA percentile of sales data
3.A report shows customers in quartile 1 spend the least. What SQL function likely produced this grouping?
- ANTILE(4)
- BPERCENT_RANK()
- CROW_NUMBER()
- DCUME_DIST()
4.In a sales analysis, NTILE(10) is used. If there are 102 products, how many products are in the first decile?
- A10
- B11
- C12
- D9
5.A manager wants to find the top 10% spenders. Which function should they use?
- ANTILE(10)
- BPERCENT_RANK()
- CCUME_DIST()
- DROW_NUMBER()
6.A developer uses NTILE(4) but notices uneven group sizes. What might be the reason?
- ANTILE(4) is only for quartiles
- BThe total rows are not divisible by 4
- CNTILE always creates equal groups
- DNTILE requires a perfect division
7.A team uses PERCENT_RANK to evaluate performance. What does a rank of 0.9 indicate?
- AThe row is in the top 10%
- BThe row is in the bottom 10%
- CThe row is in the middle 50%
- DThe row is tied with 90%
8.Which function would you use to determine the cumulative distribution of a dataset?
- ARANK()
- BNTILE(n)
- CCUME_DIST()
- DPERCENT_RANK()