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

Question 1

A company needs to store data about employee certifications. Each employee may have multiple certifications. Which approach is best practice?

Accepted Answer

Create a new custom table with a reference field to the User table. Creating a new table with a reference field to the User table allows storing multiple certification records per employee without adding unnecessary fields. Option A is wrong because a multi-select field on the User table cannot effectively store multiple certification records and lacks relational integrity. Option C is wrong because extending the User table would add many unwanted fields from the User table and complicate data management. Option D is wrong because database views are read-only and cannot be used for storing data.

Answer

Add a multi-select field to the User table to store certification IDs

Answer

Extend the User table to store certification fields directly

Answer

Create a database view that joins User and certification data

Question 2

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. The most efficient way is to define a default value script in the dictionary for the 'priority' field. This script runs server-side during record insertion and sets the priority based on the category without additional database operations. Option A (Business Rule) works but adds overhead compared to a dictionary default. Option B (Client Script) is client-side and can be bypassed or not execute. Option C (UI Policy) only affects client-side behavior and does not set field values on the server.

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 3

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. The form layout for the custom table 'u_asset' is separate from the parent 'cmdb_ci' form layout. Even though 'manufacturer' is inherited from 'cmdb_ci', it must be explicitly added to the u_asset form layout. Option A is wrong because the manufacturer field is indeed part of the cmdb_ci table. Option C is incorrect because ACLs control access but do not hide fields from the form layout unless configured; ACLs are not the likely cause. Option D is irrelevant because mandatory setting does not affect visibility.

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 4

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. For a reference field to filter its choices based on the value of another field (cascading), the reference qualifier must be a script that uses the parent field's value (B). Additionally, the parent field must be present on the form containing the reference field (E). Option A is incorrect because the parent field does not need to be a reference field; it can be any field type. Option C is incorrect because, although the fields are on the same form, this condition is already covered by E. Option D is incorrect because there is no requirement for matching field names on the reference table.

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 5

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 B, C, and E are correct. Extending a table allows the child table to inherit all fields and relationships from the parent (C), enables adding new fields specific to the child without modifying the parent (E), and supports creating multiple child tables from the same parent (B). Option A is incorrect because although business rules and client scripts are inherited, they can be overridden and not all automatically apply without configuration. Option D is incorrect because child records do not automatically appear in parent table reports; reports must be 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 6

Which THREE statements are true about database views in ServiceNow?

Accepted Answer

Database views can have fields from multiple tables. Options A, C, and D are correct. Database views are read-only (D), can combine fields from multiple tables (A), and can be used as a source for reports (C). Option B is false because database views cannot reference tables from different instances or databases; they can only combine tables within the same instance. Option E is false because database 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 7

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. Integer fields in ServiceNow do not support the max_length attribute; that property is only applicable to string fields. The system rejects the dictionary override because max_length is invalid for an integer. Option A is wrong because labels can contain spaces. Option C is wrong because 'integer' is correctly spelled; the issue is not a typo. Option D is wrong because the order of JSON properties does not matter in dictionary overrides.

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 8

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. The UNION operator by default removes duplicate rows. If there are overlapping records between the incident and problem tables (e.g., same sys_id, number, or short_description), UNION eliminates them, resulting in fewer records than the sum of the two tables. Using UNION ALL would retain all rows, including duplicates. Option A is incorrect because the 'active' field is not required for the view to include all records. Option C is false because database views can combine records from multiple tables. Option D is incorrect because DISTINCT is already implied by UNION and would further reduce rows, not increase them.

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 9

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. If the 'u_field' is defined as read-only (e.g., via dictionary attribute or ACL), the setValue method fails silently, meaning the value is not saved but no error is thrown. Option A is incorrect because the script appears syntactically correct. Option B is incorrect because setValue does exist on GlideElement. Option D is incorrect because setValue is the appropriate method for setting field values; setDisplayValue is used for setting display values, not database values.

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 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.. The best approach is to create a custom table with a reference field to the Incident table (Option D). This allows storing metadata related to incidents without inheriting Incident's workflow, assignments, or other behaviors. Option A is incorrect because a database view is read-only and cannot store new data. Option B is incorrect because extending the Attachment table would inherit attachment-specific behaviors and is not appropriate for custom metadata. Option C is incorrect because extending the Incident table would inherit all Incident's features, including workflow and assignments, which the requirement specifically avoids.

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.. The 'Extensible' property controls whether other tables can extend this table, not the menu. 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 C is incorrect because the 'Allow Configuration' property affects dictionary attributes, not the new record menu. Option D is incorrect 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. 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. '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 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. 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 Lookup select is for selection lists, not dynamic calculation. Option B is wrong because Currency is just a data type, not dynamic calculation. 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. '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