Translucent things line jello and juice maybe?
False
Anything is possible with a constitutional amendment.
I'd be more concerned about your computer making the room even hotter personally. To put it in AC terms, 500W of component power draw is 1700 BTU. May want to err on the side of more power efficient components.
But yeah, should run fine as long as you have good air cooling even if it's not ideal. Data centers are often run hot these days.
90F should be fine. A lowish CPU temp is like 40C (104F) and that's typically the hottest component. CPUs are often made to go up to around 90C under load.
Nothing is going to get it lower than ambient aside from something with a condenser because physics.
Sometimes I think this community should be called homelab instead of selfhosted based on the kinds of questions
What's the cost and impact of downtime for you? If you're doing this for personal use it's probably minimal for both so doesn't really matter. If you want to try the new thing and you're not afraid of the time investment or potential downtime then go for it
I used to play this with my dad. I always kind of thought it was something he made up but "has been played on US naval and marine ships since the early 1900s." tracks because he was in the navy.
It's been a long time since I took it but these are two I recall being helpful. There is a ton of material out there on this cert. I think I recall the official book being helpful too.
https://www.professormesser.com/network-plus/n10-008/n10-008-video/n10-008-training-course/
https://youtu.be/_QBY29dmr-M?si=hmUo22xwjU6oa7Aj
Part 1 and part 5 look most applicable to you. You're unlikely to ever need or want to mess with dynamic routing unless you're doing networking for very large networks for example.
What you're looking for is a backup. RAID is not a backup, as another poster said it's a tool for enduring high availability, and possibly higher throughput.
Buy a second pi and put it in another location in your house or even better at friends house then configure regular backups of your important data to it. There are also cloud services for doing backups which are great because having a location to do off-site backups to can be really hard to get as an individual.
A lot of this is being complicated for you by not understanding networking fundamentals. I'd suggest looking into a Network+ certification which will cover all of these basics like DNS. You don't have to actually get the cert, just going through the motions on learning the material should help a lot.
You seem to be close on grokking the whole picture and just need some of the basics that are hard to pick up from just doing things at home. A lot of work has been done to try abstract that away from consumers in order to make things easier which is making it harder for you.
This would be a mixed bag because it could open the door on more conventional wars since it would left the threat of MAD.