CSA Collaboration & Database Administration 3 — Questions and Answers
Question 1: What is the role of a 'Database Rotation' table in ServiceNow?
- It rotates encryption keys for secure fields
- It archives old records by moving them to extension tables on a schedule (Correct answer)
- It routes database queries to different nodes
- It manages read/write load balancing
Correct answer: It archives old records by moving them to extension tables on a schedule
Database Rotation tables automatically archive older records to extension tables to keep the main table performant.
Question 2: In ServiceNow, which feature lets administrators view all fields on a table including those inherited from parent tables?
- Table Schema Map
- Dictionary Entry
- Schema Map (Correct answer)
- Field Navigator
Correct answer: Schema Map
The Schema Map visually displays all fields on a table, including inherited fields from parent tables in the hierarchy.
Question 3: Which ServiceNow collaboration tool sends automated email digests of watched record activity?
- Subscriptions (Correct answer)
- Notifications
- Live Feed
- Work Notes Digest
Correct answer: Subscriptions
Subscriptions allow users to follow records and receive email digests summarizing activity on those records.
Question 4: When configuring a Many-to-Many (M2M) relationship in ServiceNow, what is automatically created?
- A new form view for both tables
- A junction table and relationship definitions for both tables (Correct answer)
- A reference field on each table pointing to the other
- A database trigger that enforces referential integrity
Correct answer: A junction table and relationship definitions for both tables
Creating an M2M relationship in ServiceNow automatically generates a junction/intersection table and adds relationship definitions to both involved tables.
Question 5: What does the 'Audit' checkbox on a Dictionary entry control?
- Whether the field is included in database backups
- Whether changes to that field are tracked in the sys_audit table (Correct answer)
- Whether the field requires admin approval to edit
- Whether the field is visible in audit reports
Correct answer: Whether changes to that field are tracked in the sys_audit table
Enabling Audit on a Dictionary entry causes every change to that field to be recorded in the sys_audit table for compliance tracking.
Question 6: Which ServiceNow table stores all field-level change history for audited records?
- sys_log
- sys_journal_field
- sys_audit (Correct answer)
- sys_history_line
Correct answer: sys_audit
The sys_audit table stores field-level change history for all records where auditing has been enabled on the field.
Question 7: In ServiceNow Live Feed, what is the purpose of 'Groups'?
- To define database query groups for reporting
- To create shared collaboration spaces for team discussions (Correct answer)
- To group notification rules by priority
- To manage assignment group memberships
Correct answer: To create shared collaboration spaces for team discussions
Live Feed Groups are shared discussion spaces where teams can post updates, links, and collaborate outside of specific records.
CSA Collaboration & Database Administration 3
What is the role of a 'Database Rotation' table in ServiceNow?