Cyber Monday 2024! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

CompTIA Exam DS0-001 Topic 1 Question 8 Discussion

Actual exam question for CompTIA's DS0-001 exam
Question #: 8
Topic #: 1
[All DS0-001 Questions]

Which of the following database instances are created by default when SQL Server is installed? (Choose two.)

Show Suggested Answer Hide Answer
Suggested Answer: B, D

The two database instances that are created by default when SQL Server is installed are master and model. Master is a system database that contains the information and settings of the SQL Server instance, such as the configuration, logins, endpoints, databases, etc. Master is essential for the operation and management of the SQL Server instance, and it should be backed up regularly. Model is a system database that serves as a template for creating new user databases. Model contains the default settings and objects, such as tables, views, procedures, etc., that will be inherited by the new user databases. Model can be modified to customize the new user databases according to specific needs or preferences. The other options are either not database instances or not created by default when SQL Server is installed. For example, root is not a database instance, but a term that refers to the highest level of access or privilege in a system; log is not a database instance, but a file that records the changes made by transactions on a database; view is not a database instance, but an object that represents a subset or a combination of data from one or more tables; index is not a database instance, but a data structure that stores the values of one or more columns of a table in a sorted order.Reference:CompTIA DataSys+ Course Outline, Domain 2.0 Database Deployment, Objective 2.3 Given a scenario, update database systems.


by Bernardine at Dec 27, 2023, 01:58 AM

Limited Time Offer

25%

Off

Get Premium DS0-001 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel
Nadine
8 months ago
I'm going to go with Master and Model. Those just feel like the most logical default database instances to me. Although, to be honest, I'm not entirely confident in my answer. These SQL Server installation questions can be tricky.
upvoted 0 times
...
Effie
8 months ago
Hmm, I was thinking Master and Log, since the log is such a crucial component of any database system. But you both make good points about Model being a default as well. This is a tough one.
upvoted 0 times
Rosendo
8 months ago
D) Model
upvoted 0 times
...
Kindra
8 months ago
B) Master
upvoted 0 times
...
...
Corinne
8 months ago
I agree, it's a bit confusing. I'm leaning towards Master and Model, as those seem to be the core database instances that are commonly referenced. But I'm not 100% certain.
upvoted 0 times
...
Ressie
8 months ago
This is a tricky question. I'm not entirely sure about the default database instances created during SQL Server installation. I'm thinking either Model and Master, or Master and Log. What do you all think?
upvoted 0 times
...

Save Cancel