it is not 100% accurate ,Even with exclusive access it does not do full scan by default.So the row count is close, but not guaranteed exact.you can rely on it when need approximate row counts.
if you want fast and accurate counts,then maintain row count using trigger