SNOW-CAD Creating and customizing tables and data — 15 Questions

Question 1

You are a ServiceNow developer at a large healthcare organization. You have created a custom table 'u_medical_device' to track medical equipment. The table has fields: 'u_device_id' (string), 'u_device_type' (choice: 'Monitor', 'Ventilator', 'Pump'), 'u_location' (reference to 'u_location' table), 'u_status' (choice: 'Active', 'Inactive', 'Maintenance'), and 'u_last_calibration_date' (date). You need to implement a business rule that, when a device's status is changed to 'Maintenance', automatically sets the 'u_last_calibration_date' to the current date and creates a 'u_maintenance_log' record with a reference to the device. Additionally, you want to ensure that only users with the 'medical_device_admin' role can change the status to 'Maintenance'. You have written the business rule but it is not firing correctly. The sys_script table shows the rule is active, order 100, when 'before' query and 'after' update. The condition is: current.status.changes() && current.status == 'Maintenance'. The script sets current.u_last_calibration_date = gs.now(); and creates a GlideRecord for u_maintenance_log. However, the calibration date is not updated, and no log record is created. What is the most likely cause?

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

Accepted Answer

The business rule is set to run 'before' query instead of 'before' update or 'after' update.. The business rule is configured to run on both 'before query' and 'after update' phases. The 'before query' phase only fires when a record is retrieved from the database, not during updates. The 'after update' phase fires after the record is saved, but setting 'current.u_last_calibration_date' at that point does not persist because the record is already committed; the script would need an explicit 'current.update()' to save the change, which is not present. Therefore, the rule should be set to run on 'before update' (to set the date before save) and optionally 'after update' (to create the log). The current configuration fails to execute the intended logic during the update operation, making option B correct: the rule is set to 'before query' instead of 'before update' (or 'after update' alone is insufficient for the date update).

Answer

The script uses 'gs.now()' which returns a date-time string, but 'u_last_calibration_date' is a date field, causing a type mismatch and silent failure.

Answer

The user executing the update does not have the 'medical_device_admin' role, and the business rule lacks an ACL check.

Answer

The condition 'current.status.changes() && current.status == 'Maintenance'' is invalid because 'changes()' returns a boolean and cannot be combined with '=='.

Question 2

A developer creates a new custom table 'u_ticket' by extending the 'Task' table. Which field will be automatically inherited from the Task table?

Accepted Answer

State. When a custom table extends the Task table, it automatically inherits all fields from the Task table, including State, Number, Assignment group, and Short description. Therefore, every option listed is a field that is automatically inherited.

Question 3

A developer is creating a custom table for tracking hardware assets. The table must have fields for asset tag, serial number, and purchase date. The developer wants to ensure that the asset tag is automatically generated using a prefix followed by an incrementing number. Which approach should the developer use?

Accepted Answer

Create a business rule that calculates the asset tag using a script that increments a counter. ServiceNow does not have a built-in auto-increment field type, so a business rule must be used to generate a sequential asset tag. The script typically queries the table for the maximum existing number, increments it, and prepends the prefix (e.g., 'AST-0001'). This ensures uniqueness and proper sequencing without relying on sys_id, which is not sequential.

Answer

Use a calculated value that dot-walks to a number table

Answer

Set the default value of the asset tag field to 'AST-' + sys_id

Answer

Configure a dictionary override on the asset tag field to auto-generate

Question 4

An organization has a custom table 'u_incident_task' that extends 'task'. They need to allow users to create records in this table from the 'Incidents' module. The 'u_incident_task' table should appear as a related list on the incident form. However, the related list is not showing the 'New' button. What is the most likely cause?

Accepted Answer

There is no reference field on 'u_incident_task' pointing to the incident table. The 'New' button appears on a related list only when there is a reference field on the target table (u_incident_task) that points back to the source table (incident). Without this reference field, the platform cannot automatically populate the parent record's sys_id when creating a new child record, so it suppresses the 'New' button. This is a core requirement for related list creation in ServiceNow.

Answer

The table is in a different application scope

Answer

The table does not extend 'incident'

Answer

The user does not have the required role

Question 5

A developer needs to create a new table to store custom survey responses. The table should have a field to store the survey name and a field to store the response text. The developer wants to ensure that the table is available in the 'Surveys' application module. Which property must be set on the table?

Accepted Answer

Application module. The Application module property determines which application module a table belongs to, making it visible and accessible within that module's scope. Setting this to 'Surveys' ensures the table appears in the Surveys application module, as required by the developer.

Answer

Application scope

Answer

Table name

Answer

Table label

Question 6

A developer is working with a custom table 'u_project_task' that has a reference field 'u_project' pointing to the 'project' table. The developer wants to create a new field 'u_category' that lists values from a choice list, but the list should be filtered based on the value of 'u_project.u_type'. Which field type should be used?

Accepted Answer

Choice field with a dependent choice list. A choice field with a dependent choice list allows the list of values in 'u_category' to be dynamically filtered based on the value of another field, in this case 'u_project.u_type'. This is the standard ServiceNow approach for creating cascading or conditional choice lists without custom scripting.

Answer

Choice field with a static choice list

Answer

Calculated value using a script

Answer

Reference field to a table of categories

Question 7

A company has a custom table 'u_employee' with fields: 'first_name', 'last_name', 'department'. They want to create a unique index on the combination of 'last_name' and 'department' to prevent duplicate entries. Where should this index be defined?

Accepted Answer

In the table's dictionary record via the Indexes related list. In ServiceNow, a unique index on a custom table is defined in the table's dictionary record via the Indexes related list. This is the correct location because ServiceNow uses the table's dictionary metadata to manage indexes, and the Indexes related list allows you to specify unique constraints directly on the table definition, ensuring the database enforces uniqueness on the combination of 'last_name' and 'department'.

Answer

In the table schema map

Answer

In the dictionary entry for each field

Answer

In the sys_dictionary table directly

Question 8

A developer needs to create a new table that will store confidential employee feedback. The table must have the following characteristics: (1) Only authorized HR users can read the records. (2) The table should use the 'task' model to leverage assignment and state fields. (3) The table should be accessible via web services for integration. Which TWO actions are required to meet these requirements?

Accepted Answer

Extend the 'task' table. Extending the 'task' table allows the new table to inherit the assignment and state fields required by the 'task' model. This is the standard approach in ServiceNow for creating tables that leverage task-related functionality, such as assignments and workflow states.

Answer

Set the 'table' access policy to 'Internal'

Answer

Extend the 'incident' table instead of 'task'

Answer

Enable the 'Allow web service access' property on the table

Question 9

A developer is creating a custom table 'u_project_risk' to track risks associated with projects. The table must: (1) Automatically set the 'state' field to 'Open' when a new record is created. (2) Prevent deletion of records if the state is 'Closed'. (3) Display a warning message when a user changes the state from 'In Progress' to 'Closed'. Which THREE approaches should the developer use?

Accepted Answer

Set a default value for the 'state' field to 'Open'. Setting a default value on the 'state' field to 'Open' ensures that whenever a new record is created in the 'u_project_risk' table, the field automatically populates with 'Open' without requiring any script or business rule. This is a declarative, low-code approach that leverages the platform's built-in default value functionality at the field level, guaranteeing the requirement is met even if the record is created via web services or import sets.

Answer

Create a before business rule to check state on update

Answer

Define a reference qualifier on the 'project' field

Question 10

A developer created the business rule shown in the exhibit to auto-generate asset tags. However, when a new asset is created, sometimes the generated tag is a duplicate of an existing tag. What is the most likely cause?

Accepted Answer

The query uses 'CONTAINS' which may match unintended tags, and ordering by sys_created_on may not guarantee the highest number. The script uses a glide query with 'CONTAINS' to find the highest existing asset tag number, which can match unintended tags (e.g., 'TAG-10' matching 'TAG-1001'), and ordering by 'sys_created_on' does not guarantee the highest numeric suffix. This leads to duplicate tags when the generated number is already in use but not detected as the maximum.

Answer

The condition '!current.u_asset_tag' fails when the field is empty

Answer

The script does not account for records with null asset tags

Answer

The script does not handle the scenario when no asset tag exists

Question 11

A developer implemented the client script shown in the exhibit to auto-populate the assigned-to field based on the task type. However, when the task type is changed, the assigned-to field is not updated. The server-side script 'TaskTypeAjax' is correctly defined and returns a valid sys_id. What is the most likely reason for the failure?

Accepted Answer

The Script Include 'TaskTypeAjax' is not client-callable. The client script attempts to call a Script Include named 'TaskTypeAjax' from the client side. By default, Script Includes are not accessible from client scripts unless the 'Client callable' checkbox is enabled in the Script Include record. Since the script is failing to update the assigned-to field, the most likely cause is that 'TaskTypeAjax' is not marked as client-callable, preventing the GlideAjax request from executing successfully.

Answer

The client script does not check if oldValue is different from newValue

Answer

The client script returns on isLoading, preventing execution

Answer

A UI policy is overriding the assigned-to field

Question 12

A developer is creating a new table 'u_incident_custom' to extend the Incident table. Which TWO configurations will ensure that the new table inherits the correct behavior and displays in the application navigator?

Accepted Answer

Set 'Application' to the desired scope and check 'Display in application navigator'. Setting 'Application' to the desired scope ensures the table belongs to the correct application context, and checking 'Display in application navigator' makes the table visible in the application navigator menu. Option D is correct because setting 'Extends' to 'Incident' establishes the inheritance relationship, allowing the new table to inherit all fields, business rules, and behaviors from the Incident table, which itself extends Task.

Answer

Create a module pointing to the new table

Answer

Set 'Label' to 'Incident Custom'

Answer

Set 'Extends' to 'Task'

Question 13

You are a ServiceNow developer at a company that manages IT assets. You are asked to create a new table called 'u_software_license' to track software licenses. The table must have fields for license name, vendor, purchase date, expiration date, cost, and number of seats. Additionally, the table must be accessible from the 'Software' module in the application navigator. You have created the table with the appropriate fields. However, after creating the table, it does not appear in the 'Software' module. You verify that the table is set to extend 'Task' and that the application scope is correct. What is the most likely reason the table does not appear in the module?

Accepted Answer

A module has not been created to reference the new table.. The table does not appear in the 'Software' module because no module record exists that maps the table to that module. To display a table under a specific module in the application navigator, you must create a module record that references the table. The 'Display in application navigator' checkbox only adds the table as a top-level entry, not under a module. Since the user verified the table extends Task and the application scope is correct, the missing step is creating a module record.

Answer

The table name 'u_software_license' is not compatible with the Software module.

Answer

The 'Display in application navigator' checkbox is not checked on the table configuration.

Answer

The table extends 'Task' instead of 'Software', so it cannot appear in the Software module.

Question 14

Drag and drop the steps to create a UI Action in ServiceNow into the correct order.

Accepted Answer

Navigate to UI Actions, create new, define table and names, set conditions, script, submit. The correct order: navigate to UI Actions, create new, define table and names, set conditions, script and submit.

Answer

Navigate to UI Actions, create new, define table and names, script, set conditions, submit

Answer

Navigate to UI Actions, create new, set conditions, define table and names, script, submit

Answer

Navigate to UI Actions, set conditions, create new, define table and names, script, submit

Question 15

Match each ServiceNow update set state to its meaning.

Accepted Answer

In progress: Changes are currently being made.. Update set states control the lifecycle of change tracking. 'In progress' indicates active work, 'Complete' indicates all changes are added, 'Committed' indicates the set is applied to an instance, and 'Submitted' indicates it is sent for review. Common confusions include swapping 'In progress' and 'Complete' definitions.

Answer

In progress: All changes have been added.

Answer

Complete: Changes are currently being made.