CSA Collaboration & Database Administration 2 — Questions and Answers
Question 1: Which ServiceNow feature allows users to share a filtered list view with colleagues via a URL?
- Bookmarks
- Saved Filters
- Filter Breadcrumbs
- Permalink (Correct answer)
Correct answer: Permalink
Permalinks capture the current list filter and view state in a URL that can be shared with other users.
Question 2: In ServiceNow, what is the purpose of the 'Connect' sidebar?
- Managing database indexes
- Real-time team chat and collaboration within records (Correct answer)
- Scheduling maintenance windows
- Creating workflow approvals
Correct answer: Real-time team chat and collaboration within records
The Connect sidebar provides real-time messaging and collaboration tools directly within ServiceNow records and list views.
Question 3: What database operation does the 'db_object.db_count' script include utility perform?
- Counts rows in a specified table (Correct answer)
- Returns the size of a database object in bytes
- Lists all columns in a table
- Checks foreign key integrity
Correct answer: Counts rows in a specified table
db_object.db_count returns the number of rows in a specified database table, useful for monitoring table growth.
Question 4: Which table stores all user-to-user and user-to-group Connect chat messages in ServiceNow?
- sys_email
- connect_message (Correct answer)
- chat_message
- sys_journal
Correct answer: connect_message
The connect_message table stores all messages sent through ServiceNow's Connect collaboration feature.
Question 5: When a ServiceNow administrator adds a new column to a table using Studio, what happens to existing records?
- Existing records are deleted and must be re-imported
- Existing records retain NULL for the new field until updated (Correct answer)
- The table is locked until a migration script runs
- ServiceNow automatically populates the new field from audit history
Correct answer: Existing records retain NULL for the new field until updated
Adding a new column to a table leaves the field value as NULL on all existing records until they are explicitly updated.
Question 6: Which role is required to create and manage database views in ServiceNow?
- itil
- admin (Correct answer)
- report_admin
- db_view_creator
Correct answer: admin
The admin role is required to create and manage database views, which join multiple tables for reporting purposes.
Question 7: What is the maximum number of characters allowed in a ServiceNow 'String' field by default?
- 40
- 100
- 255 (Correct answer)
- 4000
Correct answer: 255
By default, String fields in ServiceNow are limited to 255 characters, though this can be increased up to 4000 for large text needs.
CSA Collaboration & Database Administration 2
Which ServiceNow feature allows users to share a filtered list view with colleagues via a URL?