SNOW-CAD Working with Data Practice Test 4 — 15 Questions

Question 1

Refer to the exhibit. What is the purpose of this transform script?

Accepted Answer

To map the department field only if source department is not empty.. The correct answer is D. The script maps the 'department' field only if the source field 'u_department' is not empty. Option A is incorrect because it does not set a default value. Option B is incorrect because it only maps one field conditionally. Option C is incorrect because it does not ignore records; it just skips the mapping.

Answer

To ignore records with empty department.

Answer

To set a default value for the department field.

Answer

To map all fields from source to target.

Question 2

Refer to the exhibit. What does this ACL condition allow?

Accepted Answer

Users with 'itil' role can update incidents in state 'On Hold'.. The correct answer is A. The ACL grants update access when the incident state is '3' (On Hold) and the user has the 'itil' role. Option B is wrong because state 3 is On Hold, not Resolved. Option C is wrong because it ignores the role requirement. Option D is wrong because it reverses the role condition.

Answer

Any user can update incidents when state is '3'.

Answer

Only users without 'itil' role can update incidents in state '3'.

Answer

Users with 'itil' role can update incidents in state 'Resolved'.

Question 3

A developer needs to update a large number of records in the 'incident' table based on a specific condition. Which approach should be used to minimize performance impact?

Accepted Answer

Use GlideRecord with setWorkflow(false) and setEngine(false) to update records in a loop.. Option A is correct because using GlideRecord in combination with setWorkflow(false) and setEngine(false) prevents unnecessary business rules and workflow execution, reducing overhead. Option B is wrong because GlideAggregate is for aggregation, not updates. Option C is wrong because updateMultiple can be more efficient but still triggers business rules if not disabled. Option D is wrong because export set is not meant for updates.

Answer

Use GlideAggregate to perform the update.

Answer

Use an export set to update records in bulk.

Answer

Use the updateMultiple method on a GlideRecord object.

Question 4

An admin created a new table 'u_custom_asset' with a reference field to 'cmdb_ci'. After creating a form, users report that when they select a CI, additional fields do not auto-populate as expected. What is the most likely cause?

Accepted Answer

The reference field lacks a reference qualifier or default value configuration for auto-population.. Option C is correct because the table might not have a reference qualifier or default values configured, so auto-population does not occur. Option A is wrong because configuration items are standard tables. Option B is wrong because the reference field itself doesn't require a business rule for basic auto-population. Option D is wrong because access controls are not preventing auto-population.

Answer

ACLs are blocking the read operation on the cmdb_ci table.

Answer

A business rule is missing on the reference field to trigger auto-population.

Answer

The cmdb_ci table is a system table and cannot be referenced from custom tables.

Question 5

During a data migration, a developer runs a GlideRecord query to load 100,000 records from an external source into the 'incident' table. The script times out after 60 seconds. Which optimization technique would be most effective to avoid the timeout?

Accepted Answer

Use GlideRecordBatch or a scheduled job to process records in smaller batches.. Option D is correct because using GlideRecordBatch or a scheduled job with incremental processing breaks the workload into manageable chunks, preventing timeout. Option A is wrong because increasing timeout is a workaround, not efficient. Option B is wrong because setLimit reduces the number of records, but data migration requires all records. Option C is wrong because GlideAggregate is not for inserts.

Answer

Use setLimit(1000) to reduce the number of records per execution.

Answer

Use GlideAggregate to count records before insertion.

Answer

Increase the transaction timeout setting in the system properties.

Question 6

A user needs to generate a report that shows the count of incidents by category for the current month. Which table and field combination should be used in a report?

Accepted Answer

Use the 'incident' table with 'category' and 'sys_created_on'.. Option B is correct because 'incident' table with 'category' and 'sys_created_on' provides the necessary data. Option A is wrong because 'task' table may include other task types. Option C is wrong because 'cmdb_ci' is not directly related. Option D is wrong because 'sys_user' is for user data.

Answer

Use the 'cmdb_ci' table with 'install_status' and 'sys_created_on'.

Answer

Use the 'task' table with 'priority' and 'sys_updated_on'.

Answer

Use the 'sys_user' table with 'department' and 'sys_created_on'.

Question 7

An admin notices that a business rule on the 'incident' table that sets the 'assigned_to' field based on the caller's manager is not always firing. The rule is set to run 'Before' and 'Update'. What is the most likely reason?

Accepted Answer

The condition of the business rule is not met because it requires a specific field to change.. Option D is correct because if the field being set is not in the current update, the business rule may not trigger if it depends on a condition. Option A is wrong because the order is not an issue. Option B is wrong because ACLs do not prevent business rule execution. Option C is wrong because async would still fire eventually.

Answer

The business rule is set to run asynchronously.

Answer

The user lacks the 'incident_edit' ACL.

Answer

The business rule order is set to 100, making it run too late.

Question 8

A developer writes a script include that uses GlideRecord to query a large table. The script is called multiple times in a single transaction. What is the best practice to optimize performance?

Accepted Answer

Use a single GlideRecord query with multiple conditions and call .getRowCount() at the end.. Option A is correct because adding .getRowCount() at the end forces the query to execute and cache results, but better is to use GlideAggregate for counts. However, none are ideal. Actually, the correct answer is to use GlideDBFunction or aggregate. But among options, using a single GlideRecord with multiple conditions is best. Option B is wrong because multiple queries add overhead. Option C is wrong because encoding does not improve performance. Option D is wrong because createOrGetRecord is for single record.

Answer

Use separate GlideRecord queries for each call.

Answer

Use createOrGetRecord for each call to cache the result.

Answer

Use setEncodeQuery(false) to speed up the query.

Question 9

Which method should be used to delete all records in the 'incident' table where the state is 'Closed' and the sys_updated_on is older than 90 days?

Accepted Answer

GlideRecord.deleteMultiple(). Option C is correct because GlideRecord's deleteMultiple() with appropriate query efficiently deletes multiple records. Option A is wrong because deleteRecord deletes a single record. Option B is wrong because setDelete is not a valid method. Option D is wrong because GlideAggregate is for aggregation.

Answer

GlideAggregate.deleteMultiple()

Answer

GlideRecord.deleteRecord()

Answer

GlideRecord.setDelete(true)

Question 10

A report on the 'incident' table shows duplicate counts due to the 'active' field being true for some records that shouldn't be counted. The report is using a simple count. How can the admin ensure only active incidents are counted?

Accepted Answer

Add a filter condition: 'active = true'.. Option B is correct because applying a filter condition in the report ensures only active incidents are counted. Option A is wrong because removing the field does not filter. Option C is wrong because grouping does not filter. Option D is wrong because a business rule is not appropriate.

Answer

Create a business rule to set active=false for certain records.

Answer

Remove the 'active' field from the report.

Answer

Group the report by the 'active' field.

Question 11

A developer is tasked with creating a reference field on a custom table that shows only 'Windows' servers from the 'cmdb_ci_server' table. What is the proper way to implement this?

Accepted Answer

Define a reference qualifier on the field with the condition 'os_type=Windows'.. Option C is correct because defining a reference qualifier with the condition 'os_type=Windows' restricts the selection. Option A is wrong because a business rule would not restrict the picker. Option B is wrong because a choice list is not a reference. Option D is wrong because a dynamic filter is not a standard mechanism.

Answer

Use a choice list instead of a reference field.

Answer

Create a business rule that filters the reference field.

Answer

Create a dynamic filter on the form.

Question 12

Which TWO statements are true about GlideAggregate?

Accepted Answer

It provides methods like addAggregate and getAggregate.. Options A and D are correct. GlideAggregate extends GlideRecord and provides aggregate functions. Option B is wrong because it does not use getRowCount() but addAggregate(). Option C is wrong because it does not have query with limit. Option E is wrong because it does not support multiple tables in one query.

Answer

It uses getRowCount() to retrieve the count.

Answer

It can only be used with sys_id fields.

Answer

It can aggregate data across multiple tables in a single query.

Question 13

Which THREE of the following are valid ways to reduce the number of database queries when processing multiple records in a script?

Accepted Answer

Use dot-walking to access related table fields.. Options B, D, and E are correct. Using sets, dot-walking, and GlideAggregate all reduce queries. Option A is wrong because separate queries increase queries. Option C is wrong because getValue does not reduce queries.

Answer

Use multiple GlideRecord queries for each record.

Answer

Use getValue() to retrieve field values individually.

Question 14

Which TWO methods are commonly used to prevent performance issues when using GlideRecord in a client script?

Accepted Answer

Use GlideAjax to call a script include for server-side processing.. Options A and C are correct. Using GlideAjax for server-side and limiting results are best practices. Option B is wrong because synchronous calls are blocking. Option D is wrong because business rules should be avoided for client scripts. Option E is wrong because GlideRecord is not available in client scripts directly.

Answer

Use GlideRecord directly in client scripts.

Answer

Use synchronous GlideRecord queries for immediate results.

Answer

Use a business rule instead to perform the query.

Question 15

A large enterprise uses ServiceNow for IT service management. The instance has a custom table 'u_asset_tracker' with over 2 million records. The table is referenced by multiple other tables. Recently, users have reported that when they open a record in the 'u_asset_tracker' table, the form takes 15-20 seconds to load. Additionally, reports that query this table often time out. The instance is running on a mid-range server with 8GB RAM. The admin suspects database performance issues. Upon reviewing the sys_properties, the admin finds that 'glide.ui.auto_clear_filters' is set to false. Also, there are several business rules on the table that run on 'before' query and 'after' query. A script include that transforms data from 'u_asset_tracker' to another table is running frequently. The admin needs to improve performance. Which course of action should the admin take first?

Accepted Answer

Review and disable unnecessary 'before query' and 'after query' business rules on the table.. Option C is correct because disabling 'before query' and 'after query' business rules can significantly improve query performance as they run for every query. Option A is wrong because increasing RAM may not address the root cause. Option B is wrong because GlideAggregate is for aggregation, not for general query performance. Option D is wrong because the script include may be necessary; disabling it could break functionality.

Answer

Replace all GlideRecord queries with GlideAggregate for reports.

Answer

Disable the script include that transforms data to reduce load.

Answer

Increase the server RAM to 16GB to handle the load.

SNOW-CAD Working with Data Practice Test 4 — 15 Questions

Exhibit

SNOW-CAD Working with Data Practice Test 4 — 15 Questions

Exhibit