DS0-001 Practice Questions

The correct answers are

D.  

A tablespace can include multiple data files, which allows database administrators to distribute data across different disks or storage systems. This capability supports scalability, performance optimization, and high availability. By adding or resizing data files within a tablespace, administrators can expand storage capacity without restructuring the database schema. DataSys+ highlights this as a key advantage for capacity planning and storage management.

Tablespaces are also used to organize data within a database. Different tablespaces can be created for different purposes, such as separating user data, indexes, temporary data, and system metadata. This organization improves performance tuning, simplifies backup and recovery operations, and enhances manageability. For example, placing indexes in a separate tablespace from table data can reduce I/O contention.

Option A is incorrect because a tablespace belongs to a single database and cannot span multiple databases. Option B is misleading; while tablespaces map to data files, blocks are allocated within files, not mixed arbitrarily across files. Option C is incorrect because segments are allocated in extents, and their sizing behavior is controlled by storage parameters, not defined as a primary purpose of tablespaces. Option E is incorrect because tablespaces represent disk-based storage, not memory-resident structures.

CompTIA DataSys+ emphasizes understanding logical versus physical storage concepts. Tablespaces play a central role in bridging these concepts by organizing data logically while enabling flexible physical storage management. Therefore, the best descriptions of a tablespace are D and F, making them the correct and verified answers.

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. References: CompTIA DataSys+ Course Outline, Domain 2.0 Database Deployment, Objective 2.3 Given a scenario, update database systems.