DS0-001 practice question 6 of 15
Which of the following database instances are created by default when SQL Server is installed? (Choose two.)
Full set: 80 questionsWhen Microsoft SQL Server is installed, it creates several system databases that are essential for its operation. Among the options provided, master and model are two of these default system databases. The master database contains all the system-level information for the SQL Server instance, including metadata about all other databases, login accounts, and system configuration settings. The model database serves as the template for any new user-defined databases created on the instance; its contents are copied to form the new database's initial structure and objects.
A. Root: 'Root' is not a standard database in SQL Server. The term typically refers to a superuser account or the top-level directory in a file system.
C. Log: A transaction log is a critical component (a file) of every database that records all transactions, but it is not a standalone database instance itself.
E. View: A view is a database object that represents a stored query as a virtual table. It is not a complete database.
F. Index: An index is a database object associated with a table or view that improves query performance. It is not a database.
1. Microsoft Corporation. (2023). System Databases - SQL Server. Microsoft Learn. Retrieved from https://learn.microsoft.com/en-us/sql/relational-databases/databases/system-databases. (This document explicitly lists and describes the system databases, including master and model.)
2. Microsoft Corporation. (2023). master Database - SQL Server. Microsoft Learn. Retrieved from https://learn.microsoft.com/en-us/sql/relational-databases/databases/master-database. (See the first paragraph: "The master database records all the system-level information for a SQL Server system.")
3. Microsoft Corporation. (2023). model Database - SQL Server. Microsoft Learn. Retrieved from https://learn.microsoft.com/en-us/sql/relational-databases/databases/model-database. (See the first paragraph: "The model database is used as the template for all databases created on an instance of SQL Server.")
Keep practicing
Take the free DS0-001 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other DS0-001 practice questions
- Question 1Which of the following types of RAID, if configured with the same number and type of disk…
- Question 3Which of the following can be used to protect physical database appliances from damage in…
- Question 4A database administrator is updating an organization's ERD. Which of the following is the…
- Question 5Which of the following is the deployment phase in which a DBA ensures the most recent pat…
- Question 7A database administrator manages a database server that is running low on disk space. A l…
- Question 8Which of the following statements contains an error?
