What happens if DPI is too high?

Could you please elaborate on what potential consequences might arise if the DPI, or dots per inch, is set too high in a given context, such as digital imaging, printing, or display technology? Are there any noticeable drawbacks to having an excessively high DPI, and how might it impact the quality of the final output or the performance of the system in question? It would be helpful to understand the specific scenarios where this could be a concern and the potential trade-offs involved.