Manage data schema, CMDB, access controls, and data import/export operations.
Covers data schema concepts, tables, fields, and relationships, Configuration Management Database (CMDB), Common Service Data Model (CSDM), application and access controls, import sets, transform maps, data policies, and data management best practices. This is the largest domain representing approximately 30% of the CSA exam.
5 minutes
5 Questions
Database Administration in ServiceNow refers to the management and maintenance of the underlying database that powers the ServiceNow platform. As a Certified System Administrator, understanding database administration concepts is essential for maintaining system health and performance.
ServiceNow operates on a single-database, multi-instance architecture where all data is stored in tables. The platform uses a relational database management system (RDBMS) to store configuration items, incident records, user information, and all other data types.
Key aspects of Database Administration in ServiceNow include:
**Table Management**: ServiceNow stores data in tables, which can be viewed and managed through the Tables module. Administrators can create custom tables, modify existing ones, and establish relationships between tables using reference fields and related lists.
**Data Dictionary**: The data dictionary contains metadata about all tables and their fields. It defines field types, lengths, default values, and other properties that determine how data is stored and displayed.
**Indexes**: Proper indexing improves query performance. ServiceNow automatically creates indexes on certain fields, but administrators can add custom indexes for frequently searched columns.
**Data Archiving and Deletion**: To maintain optimal performance, administrators should implement data retention policies. The Table Rotation and Archive features help manage historical data by moving older records to archive tables or removing them entirely.
**Database Views**: These allow administrators to create virtual tables that combine data from multiple sources for reporting and analysis purposes.
**Performance Monitoring**: Using tools like the System Diagnostics module, administrators can monitor database performance, identify slow queries, and optimize system resources.
**Access Control**: Database-level security is managed through Access Control Lists (ACLs), which determine who can read, write, create, or delete records in specific tables.
Understanding these concepts enables administrators to maintain a healthy, performant ServiceNow instance while ensuring data integrity and security across the platform.Database Administration in ServiceNow refers to the management and maintenance of the underlying database that powers the ServiceNow platform. As a Certified System Administrator, understanding database administration concepts is essential for maintaining system health and performance.
ServiceNow …