Free COMPTIA Datasys+ DS0-001 Actual Exam Questions - Question 6 Discussion
(Choose two.)
B/D? Master handles system-level info, and Model is the template for new DBs, so they’re definitely created by default. Root and Log don’t sound like standard SQL Server databases, and View and Index aren’t even databases, just objects within them. So B and D are the logical picks here.
It’s B and D for sure. Master is the main system database, and Model serves as a template for new databases. The others don’t fit standard default databases in SQL Server.
Not A, B and D are the ones created by default. Root, Log, View, and Index aren’t actual default databases in SQL Server. Master and Model are definitely standard system databases.
Good point about the wording. Since “instance” usually means the whole server setup, not individual databases, B and D make sense as default system databases that come with the instance. So I’d pick B and D too.
I think the answer is B and D. Master and Model are system databases created by default during SQL Server installation. The others don’t seem like default database instances. Anyone else agree?