I believe that paying $19.90 annually for the PRO version will allow me to easily ignore the excessive queries from dns.msftncsi.com. However, these types of excessive queries account for 60% of the total, affecting the accuracy of the NextDNS statistics report.
Fortunately, you provided the first option, and I also discovered a solution. By adding the following two lines to the /etc/hosts file, dns.msftncsi.com will no longer send excessive queries to the upstream NextDNS.
Edit the /etc/hosts file and add the following at the end, The NextDNS logs no longer show any queries for dns.msftncsi.com.
Code:
# Forcing dns.msftncsi.com to use Google DNS (ipv4 and ipv6)
8.8.8.8 dns.msftncsi.com
2001:4860:4860::8888 dns.msftncsi.com
My own observations of combining NextDNS with Unbound have the following advantages:
1. Unbound has caching capabilities, so most queries are resolved locally with speeds between 0-1 microseconds. Only when an upstream query to NextDNS is needed will the response time range from 1 millisecond to 4 seconds.
2. This significantly reduces the number of queries to the upstream NextDNS. According to the Unbound statistics report, the caching system is functioning well, with over 90% of DNS queries being resolved directly from the local cache. Specifically, there were a total of 1,433,210 queries, of which only 137,204 were cache misses that required querying the upstream DNS.
3. NextDNS offers features like Threat Intelligence Feed and AI threat detection without requiring additional installation or consuming extra router resources, along with some protection measures that I don't fully understand but seem quite powerful. Even if the 300,000 query limit is exceeded, Skynet and Diversion on the router will still provide basic protection, which should be sufficient for home use. I suspect the impact won't be significant.
Update:
After editing /etc/hosts, I observed the NextDNS statistics report and noticed that the daily query count dropped from tens of thousands to just over a thousand. The effect is remarkable.