SNOW-CAD Creating and customizing tables and data Practice Test 4 — 15 Questions

Question 1

An organization wants to store customer feedback data in a custom table. The feedback will have a large text field for comments, a reference to the customer, and a date field. Which data type should be used for the comments field to support rich text including HTML?

Choose an answer to begin — your selection is scored in the full session.

Accepted Answer

HTML. The 'HTML' data type stores rich text with HTML formatting. Option A is wrong because 'String' does not support HTML rendering. Option B is wrong because 'Journal Entry' is for audit trail. Option D is wrong because 'Report Text' is not a valid data type.

Answer

Report Text

Answer

String

Answer

Journal Entry

Question 2

When creating a new table using the 'Create Table' module, which setting determines whether the table will inherit fields from an existing table?

Accepted Answer

Extends. 'Extends,' is correct because it allows the new table to inherit fields from an existing parent table. Option A, 'Application,' defines the application scope, not inheritance. Option C, 'Table name,' is the system name. Option D, 'Table label,' is the display name.

Answer

Application

Answer

Table name

Answer

Table label

Question 3

A custom table 'u_asset' stores asset data. The developer wants to add a field that calculates the depreciation value based on acquisition date and cost. Which field type should be used?

Accepted Answer

Calculated. A Calculated field type in ServiceNow computes its value dynamically from other fields using a calculation script or formula, which is exactly what is needed to derive depreciation from acquisition date and cost. Calculated fields are read-only and recalculate on display or on record update depending on configuration. This makes them ideal for derived values like depreciation.

Answer

Lookup select

Answer

Currency

Answer

Condition string

Question 4

A table 'u_inventory' has a reference field to the 'Location' table. The developer wants the reference field to display the location name instead of the sys_id in the form. Which attribute should be configured?

Accepted Answer

Reference display field. 'Reference display field'. This attribute on the dictionary entry of the reference field specifies which field from the referenced table (Location) to display in the form. Option A is wrong because 'Default value' sets a default value for the field, not the display. Option B is wrong because 'Reference qualifier' filters which records are available in the reference field. Option D is wrong because the 'Display' field on the Location table controls the default display of that table's records globally, but for a specific reference field, the 'Reference display field' overrides it.

Answer

Default value

Answer

Reference qualifier

Answer

Display field in the Location table

Question 5

Which table property can be set to limit the creation of new records to certain roles?

Accepted Answer

Create access. The 'Create access' property on a table specifies which roles are allowed to create new records. Option A is incorrect: 'Allow attachment' controls whether users can add attachments to records, not creation. Option B is incorrect: 'Abbreviated table' sets a short name or prefix for the table, not access control. Option D is incorrect: 'Effective access' is a read-only property showing the user's current access rights, not a setting to restrict creation.

Answer

Allow attachment

Answer

Abbreviated table

Answer

Effective access

Question 6

An administrator needs to create a custom table to store project-related information. The table must allow records to be assigned to a specific user. Which field type should be used for the assignment field to ensure proper integration with ServiceNow's assignment rules and notifications?

Accepted Answer

Reference to the User table. A Reference field to the User table (sys_user) is the correct field type because it creates a relationship to user records, enabling ServiceNow's assignment rules, notifications, and assignment logic to function properly. Reference fields store a sys_id pointing to the referenced record and are the standard way to assign records to users. This ensures integration with user-based workflows and access controls.

Answer

Manager

Answer

Integer

Answer

Assignment group

Question 7

A developer writes a script to display the department name of the caller on a custom form. The script uses: gs.getUser().getDepartment().getName(). However, the script throws a null pointer exception for some users. Which is the most likely cause and solution?

Accepted Answer

Some users do not have a department assigned, and the script does not check for null. The script gs.getUser().getDepartment().getName() performs a dot-walk from the user record to the referenced Department record. If a user has no department assigned, getDepartment() returns null, and calling .getName() on null throws a NullPointerException. The correct fix is to null-check the department reference before dereferencing it, for example: var dept = gs.getUser().getDepartment(); return dept ? dept.getName() : '';.

Answer

The Department table is empty

Answer

The script uses incorrect dot-walking syntax; use getValue('department') instead

Answer

The user table does not have a department reference field

Question 8

A large enterprise runs a ServiceNow instance with a heavily customized Task table. The 'Task' table has been extended to create 'u_WorkOrder', which is used by over 50,000 active records. Recently, users complain that when they open a WorkOrder record, the form takes more than 10 seconds to load. On investigation, you discover that the 'u_WorkOrder' table has 150 fields, many of which are UI policies and client scripts that trigger on load. Additionally, there is a business rule that runs 'after query' and dot-walks through multiple related tables (e.g., calling 'current.assigned_to.department.manager.email' in a loop for each record). The instance uses SQL Server as its database. Which action would most effectively reduce the form load time without losing required functionality?

Accepted Answer

Rewrite the after query business rule to use GlideAggregate or avoid dot-walking in loops, and consider caching the dot-walked data. The 10-second form load is dominated by the after-query business rule that dot-walks through related tables for each record, causing N+1 query patterns and repeated database round-trips. Rewriting it to use GlideAggregate (which performs set-based aggregation in a single query) or to avoid dot-walking in loops, plus caching the resolved data, eliminates the redundant queries while preserving functionality. This directly targets the root cause.

Answer

Change the order of the business rule to 100 so that it runs after other rules

Answer

Remove 50 of the 150 fields from the table to reduce data retrieval

Answer

Convert the after query business rule to an after update business rule

Question 9

A new custom table is being created in ServiceNow. Which two attributes must be defined during table creation? (Choose two.)

Accepted Answer

Table label. The table label (A) is the human-readable name displayed in the ServiceNow UI, such as in lists and forms, and is required for user interaction. The table name (E) is the system name used internally in the database (e.g., 'u_custom_table'), and it must be unique within the instance. Both are mandatory fields when creating a new custom table in ServiceNow.

Answer

Access control rules

Answer

Extensible checkbox

Answer

Application scope

Question 10

A large enterprise manages its IT assets using a custom table 'u_asset_tracking', which includes a reference field 'u_location' pointing to the 'cmn_location' table. After a recent application upgrade, users report that the location is not being displayed for assets older than six months, although it works for newer assets. A client script uses GlideAjax to fetch the location via a Script Include called 'AssetUtils'. The Script Include performs a GlideRecord query on 'u_asset_tracking' and then dot-walks to 'u_location.sys_id' to retrieve the location name. The upgrade included changes to the application's access controls. The logs show no errors, but the Ajax call returns null for the location. What should the developer do to resolve this issue?

Accepted Answer

Ensure the 'read' role on the 'cmn_location' table is granted to the application's scope or the user's role.. The issue is that after the upgrade, access controls (ACLs) were changed, and the Script Include's GlideRecord query dot-walks to 'cmn_location' to retrieve the location name. Even though the query on 'u_asset_tracking' succeeds, the dot-walk to 'cmn_location' fails silently because the script's execution context (or the user's session) lacks the 'read' role on the 'cmn_location' table. Granting the 'read' role ensures the GlideRecord can access the referenced record, resolving the null return.

Answer

Modify the Script Include to use addNullQuery('u_location') to skip empty location fields.

Answer

Change the client script to use a UI Policy instead of GlideAjax to handle the location display.

Answer

Write a fix script to update the 'u_location' field for all assets older than six months.

Question 11

A developer is building a custom scoped application for facilities management. The application needs a new table to store maintenance requests, and records must be visible in the ServiceNow Task-based workflow engine so they can be assigned to users and tracked with SLA timers. Which base table should the custom table extend to meet this requirement?

Accepted Answer

The Task [task] table. Task [task] is the generic base table that provides assignment, state, priority, and SLA fields, and it integrates with Task-based workflow and assignment rules. Extending Task means the new maintenance table inherits this behavior immediately, so users can be assigned records and SLAs can be applied without manually building those capabilities.

Answer

The Configuration Item [cmdb_ci] table

Answer

The Incident [incident] table

Answer

The User [sys_user] table

Question 12

A developer creates a custom table 'u_vehicle' that must reference the 'core_company' table to identify the manufacturer. The developer adds a new field of type Reference and selects 'core_company' as the reference table. Which additional configuration is required to ensure that only companies with the 'Manufacturer' type are selectable in the reference field?

Accepted Answer

Create a reference qualifier on the field using the condition 'type=Manufacturer'.. A reference qualifier is the correct mechanism to limit the records available in a reference field. By applying a condition such as 'type=Manufacturer', the lookup only displays companies of that type. This is declarative, maintainable, and scoped to the field, unlike business rules that affect the entire table or client scripts that only validate after selection.

Answer

Create a UI policy on the 'u_vehicle' form to hide companies that are not manufacturers.

Answer

Use a client script to validate the selected company and clear the field if the type is not 'Manufacturer'.

Answer

Add a before query business rule on the 'core_company' table that filters records based on the type.

Question 13

A developer needs to add a new field 'u_department' to the 'sys_user' table. The field should be a reference to the 'cmn_department' table and must be displayed on the user form. The developer does not have access to the base 'sys_user' table configuration. Which approach should the developer take?

Accepted Answer

Create a new dictionary entry for the 'sys_user' table with the required field properties.. To add a field to an existing table, you create a new dictionary entry for that table. This is the standard method and does not require direct modification of the base table's schema. The field becomes part of the table and can be added to forms and lists. Other options either create new tables or attempt to use scripting without a field, which is not feasible.

Answer

Use a business rule to populate the field on the fly without adding it to the table.

Answer

Create a new table that extends 'sys_user' and add the field there.

Answer

Create a new form section on the 'sys_user' form and add the field via a UI action.

Question 14

A developer needs to add a new field to the 'u_vehicle' table that stores a calculated value: the number of days since the vehicle's last service date. The calculation must always be available when the record is queried via REST API and should not be stored in the database. Which field type should the developer use?

Accepted Answer

Calculated. A Calculated field is designed to compute values on the fly using a script without storing data in the database. Because it is evaluated at query time, the days-since-service value remains accurate and is accessible through the REST API. Storing the value in an Integer field would require updates and could become stale, while Formula and UI policy approaches do not provide a server-side computed field.

Answer

Integer with a business rule

Answer

String with a UI policy

Answer

Formula

Question 15

A developer needs to add a field to a custom table 'u_loan_application'. The field must store the date and time when the application was submitted, and it must be read-only after submission. Which field type should be used for the submission timestamp?

Accepted Answer

Date/Time. A submission timestamp needs both date and time, and the Date/Time field type captures both while supporting time zone handling and native reporting. Read-only behavior after submission can be enforced with a UI policy or dictionary attribute, so Date/Time is the correct field type for this requirement.

Answer

Date

Answer

String

Answer

Integer