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

Question 1

A custom table 'u_incident' has a 'priority' field that should be set to 1 when the 'category' is 'Critical', otherwise 3. Which is the most efficient way to implement this default?

Accepted Answer

Define a default value script in the dictionary for the priority field. Option B is correct because a default value script in the dictionary runs server-side during record insertion and is efficient. Option A (Business Rule) also works but adds unnecessary overhead. Option C (Client Script) is client-side and can be bypassed. Option D (UI Policy) does not set field values.

Answer

Create a Business Rule on 'Before Insert' that sets the priority

Answer

Create a Client Script that runs onLoad and sets priority

Answer

Use a UI Policy to set priority based on category

Question 2

A custom table 'u_asset' extends the 'cmdb_ci' table. Users report that the 'manufacturer' field is not visible on the 'u_asset' form. What is the most likely cause?

Accepted Answer

The u_asset form layout does not include the manufacturer field. Option C is correct because when a child table inherits fields from a parent, the form layout must be configured to display them; often the child table form layout is separate and may not include all parent fields. Option A is unlikely because ACLs would affect visibility but usually not hide fields without explicit reason. Option B is irrelevant because mandatory does not affect visibility. Option D is false because manufacturer exists on cmdb_ci.

Answer

The manufacturer field is not part of the cmdb_ci table

Answer

An ACL on the u_asset table hides the manufacturer field

Answer

The dictionary entry for manufacturer has mandatory set to false

Question 3

Which TWO are required for a reference field to automatically filter its choices based on the value of another field on the form (cascading)?

Accepted Answer

The reference qualifier must be a script that uses the parent field's value. Options B and E are correct. The reference qualifier must be a script that references the parent field (B), and the parent field must be present on the form (E) for the script to evaluate. Option A is partially true but not sufficient without the qualifier. Option C is false because the dependent field (parent) can be any type, not necessarily a reference. Option D is false because there is no requirement for matching field names.

Answer

The dependent field (parent) must be a reference field

Answer

Both fields must be on the same form

Answer

The reference table must have a field with the same name as the parent field

Question 4

Which THREE are benefits of extending a table rather than creating a new table from scratch?

Accepted Answer

Supports creating multiple child tables from the same parent. Options A, B, and D are correct. Extending inherits all fields (A), allows adding new child-specific fields (B), and supports creation of multiple child tables from the same parent (D). Option C is false because business rules are inherited but can be overridden; more importantly, not all rules automatically apply without configuration. Option E is false because child records do not automatically appear in parent table reports unless the report is configured to include child tables.

Answer

Automatically inherits all business rules and client scripts from the parent

Answer

Child records automatically appear in reports on the parent table

Question 5

Which THREE statements are true about database views in ServiceNow?

Accepted Answer

Database views can have fields from multiple tables. Options B, C, and E are correct. Database views are read-only (B), can be used as report sources (C), and can combine fields from multiple tables (E). Option A is false because views cannot reference external databases. Option D is false because views are read-only and cannot be updated via business rules.

Answer

Database views can reference tables from different instances or databases

Answer

Database views can be updated via business rules

Question 6

Refer to the exhibit. A developer created this dictionary override for a new field. When saving, an error occurs. What is the cause?

Accepted Answer

Integer fields do not support the max_length property. Option C is correct. Integer fields do not have a max_length attribute; that property is only for string fields. The system rejects the combination. Option A is wrong because label is valid. Option B is wrong because internal_type is correctly spelled. Option D is wrong because dictionary overrides do not require a specific order.

Answer

The label 'Custom Count' contains spaces

Answer

internal_type should be 'integer' not 'integer' (typo)

Answer

The JSON properties must be in alphabetical order

Question 7

Refer to the exhibit. After creating this database view, the view contains fewer records than the sum of records in incident and problem tables. What is the most likely cause?

Accepted Answer

UNION should be UNION ALL to retain duplicate rows. Option A is correct. UNION removes duplicate rows; if there are overlapping records (same sys_id, number, short_description), they are eliminated. Using UNION ALL would keep all rows. Option B (DISTINCT) is already implied by UNION. Option C is false because views can combine tables. Option D is false because the 'active' field is not required.

Answer

The view must include the 'active' field from both tables

Answer

A database view cannot combine records from incident and problem tables

Answer

The SELECT statement should include DISTINCT

Question 8

Refer to the exhibit. A developer wrote this script in a Business Rule on the 'incident' table. The script runs but the 'u_field' value is not saved. What is the most likely cause?

Accepted Answer

The u_field is defined as read-only. Option B is correct. If the field is read-only (e.g., due to a dictionary attribute or ACL), the setValue method fails silently. Option A is wrong because setValue exists on GlideElement. Option C is wrong because setValue is the correct method. Option D is wrong because the script is syntactically correct.

Answer

The script has a syntax error

Answer

The setValue method does not exist on GlideElement

Answer

The method should be setDisplayValue, not setValue

Question 9

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

Short description. Option C is correct because extending Task inherits all core fields, including 'Short description'. Option A is wrong because Assignment group is not a default field on Task. Option B is wrong because 'Number' is auto-generated but not inherited; it's a system field. Option D is wrong because 'State' is part of Task but not automatically; it's inherited, but the question asks which field is inherited, and State is indeed inherited, but Short description is a more direct example of an inherited field that is always present.

Answer

State

Answer

Number

Answer

Assignment group

Question 10

A senior developer advises an associate to create a new table for storing incident-related attachments metadata. The table should not have its own workflow or assignments but should be related to incidents. Which table creation approach is best?

Accepted Answer

Create a table with a reference field to the Incident table.. Option B is correct because creating a table that extends directly from sys_dictionary with an Integer (numeric) field for the incident reference is not appropriate; instead, using a reference field to the Incident table is standard. Actually, the best approach is to create a new table that extends from the base sys_metadata or use a custom table with a reference field to Incident. The correct answer is to create a table with a reference field to Incident, as it allows linking without inheriting Incident's behavior. Option A is wrong because extending Incident would inherit unwanted features. Option C is wrong because a database view is read-only and not for storing data. Option D is wrong because the 'Attachment' table is a system table that cannot be extended.

Answer

Create a database view that joins Incident and Attachment tables.

Answer

Create a table that extends the Attachment table class.

Answer

Create a table that extends the Incident table.

Question 11

A developer notices that a custom table 'u_project' is not appearing in the 'Create New' menu even though the application scope is set correctly. The table has been created with the 'Create without application' flag unchecked. What is the most likely cause?

Accepted Answer

The 'Create new record' property is set to false.. Option B is correct because the table property 'Create new record' must be enabled for the table to appear in the 'Create New' menu. Option A is wrong because the 'Allow Configuration' property affects dictionary attributes, not the new record menu. Option C is wrong because the 'Extensible' property controls whether other tables can extend this table, not the menu. Option D is wrong because role-based access uses ACLs, but the menu visibility is controlled by the 'Create new record' property.

Answer

The 'Extensible' property is set to false.

Answer

The 'Allow Configuration' property is set to false.

Answer

The table's roles are not assigned to the developer.

Question 12

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?

Accepted Answer

HTML. Option C is correct because 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 13

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. Option A is correct because the option to 'Extends' allows selection of a parent table. Option B is wrong because 'Table label' is just the display name. Option C is wrong because 'Table name' is the sys_name. Option D is wrong because 'Application' sets the scope.

Answer

Application

Answer

Table name

Answer

Table label

Question 14

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. Option C is correct because a calculated field using a script (e.g., calculated value via business rule or calculated field attribute) can compute depreciation. Option A is wrong because Currency is just a data type, not dynamic calculation. Option B is wrong because Lookup select is for selection lists. Option D is wrong because Condition string is for conditions.

Answer

Lookup select

Answer

Currency

Answer

Condition string

Question 15

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. Option A is correct because the 'Reference display field' attribute on the dictionary entry specifies which field from the referenced table to display. Option B is wrong because 'Display' field on the referenced table controls the default display of records. Option C is wrong because 'Reference qual' filters available records. Option D is wrong because 'Default value' sets a default.

Answer

Default value

Answer

Reference qualifier

Answer

Display field in the Location table