SNOW-CAD Integrating and managing application data Practice Test 3 — 15 Questions

Question 1

What is the purpose of the 'Coalesce' field in a transform map?

Accepted Answer

To use a field to match existing records and avoid duplicates.. The Coalesce field is used to specify which fields to use for matching existing records to avoid duplicates during import.

Answer

To remove null values from the import.

Answer

To combine multiple fields into one.

Answer

To convert data types.

Question 2

A developer is creating a business rule that updates a field on the incident table whenever the state changes to 'Resolved'. The business rule should only run when the incident is updated via the form, not through web services. Which condition should be used?

Accepted Answer

In the condition script, add '!gs.getUser().isWebService()'.. The condition should check if the update did not originate from a web service. The method 'gs.getUser().isWebService()' returns true if the current user is a web service user.

Answer

Set the business rule to run only on 'Submit'.

Answer

Use the 'Filter Conditions' on the table to exclude web service users.

Answer

Set the 'When to run' to 'Update' and nothing else.

Question 3

A customer reports that a scheduled data synchronization job takes longer than expected. The job queries the 'cmdb_ci' table and updates records based on an external source. The DBA suggests adding an index on the 'source' field. After adding the index, performance does not improve. What is the most likely reason?

Accepted Answer

The job uses a condition that filters on a different field.. Indexes only improve performance when the query condition uses the indexed field. If the job filters on a different field, the index on 'source' will not be used.

Answer

The index was not created correctly.

Answer

The job runs during peak hours.

Answer

The database is replicated to a secondary site.

Question 4

Which of the following is a best practice when creating REST API endpoints?

Accepted Answer

Use versioning in the API path.. Versioning the API path (e.g., /api/now/v1/incident) is a best practice to manage changes without breaking existing consumers.

Answer

Use GET methods for data modification.

Answer

Pass sensitive data in URL parameters.

Answer

Return all data without pagination.

Question 5

A developer is writing a script to update a large number of records. To avoid hitting the execution time limit, what is the recommended approach?

Accepted Answer

Use GlideRecord with setLimit and a loop to process in batches.. Processing records in batches using setLimit and a loop prevents long-running scripts and allows the system to handle the load efficiently.

Answer

Use a single GlideRecord update with setWorkflow(false).

Answer

Use a scheduled job to run the script asynchronously.

Answer

Use a business rule to trigger the update on save.

Question 6

In a multi-instance environment, an organization wants to integrate ServiceNow with an on-premise database using JDBC. Which feature is used to establish this connection?

Accepted Answer

External Data Sources. External Data Sources are specifically designed to connect ServiceNow to external databases via JDBC, enabling data synchronization.

Answer

REST API

Answer

Import Set

Answer

SOAP Web Service

Question 7

A developer is investigating why an outbound REST message is not sending data correctly. Which TWO actions should the developer check first? (Choose two.)

Accepted Answer

Check the authentication profile.. The most immediate checks are the endpoint URL to ensure it is correct, and the authentication profile to ensure credentials are valid. These are common causes of failures.

Answer

Restart the web server.

Answer

Reinstall the ServiceNow instance.

Answer

Review the script include for errors.

Question 8

An organization is planning to import a large dataset into ServiceNow using import sets. According to best practices, which TWO actions should the developer take to optimize performance? (Choose two.)

Accepted Answer

Disable business rules and ACLs during import.. Scheduling imports during off-peak hours reduces load on the system. Disabling business rules and ACLs during import speeds up processing by avoiding unnecessary checks.

Answer

Increase the import set table row limit.

Answer

Enable 'Create multiple' for transform maps.

Answer

Use a single transform map for all records.

Question 9

Which THREE of the following are features available in ServiceNow for integrating data with external systems? (Choose three.)

Accepted Answer

SOAP Web Service. REST API, SOAP Web Service, and LDAP are standard integration features in ServiceNow. Email and Print are not used for data integration.

Answer

Email

Answer

Print

Question 10

Refer to the exhibit. An inbound REST call (GET) to the 'incident' table is returning a 403 error. The ACL shown in the exhibit is the only ACL on the table. The calling user has the 'incident_manager' role. What is the likely cause of the 403 error?

Accepted Answer

The ACL requires the 'admin' role, but the user has 'incident_manager'.. The ACL script explicitly requires the 'admin' role. Since the user has 'incident_manager' but not 'admin', the ACL denies access, resulting in a 403 Forbidden error.

Answer

The ACL script is malformed.

Answer

The ACL operation is 'read' but the REST call is a POST.

Answer

The user does not have the 'rest_api' role.

Question 11

Refer to the exhibit. A MID Server is failing to connect to an external Oracle database. The error log shows the above message. Which is the most likely cause?

Accepted Answer

The database instance name (service name) is incorrect in the configuration.. Error ORA-12514 indicates that the listener received a connection request but the service name (in the connect descriptor) is not known to the listener. This usually means the database service name is incorrect or the listener is not configured for that service.

Answer

The firewall is blocking port 1521.

Answer

The Oracle client is not installed.

Answer

The MID Server is not running.

Question 12

A large enterprise uses ServiceNow for IT service management. The company has recently implemented a custom integration that pulls incident data from an external monitoring system via REST every 5 minutes. The integration runs as a scheduled job that creates new incidents and updates existing ones. Over the past week, users have reported that the system becomes sluggish during peak hours (9-11 AM). The performance team identifies that the integration job is causing high database contention. The job currently queries the incident table for existing records using a condition on the 'source' field and then updates or inserts records in a loop. Each job run processes around 500 records. The incident table has several million records. The developer is asked to optimize the integration. What should the developer do first?

Accepted Answer

Add an index on the 'source' field in the incident table.. The query on the 'source' field without an index is causing full table scans, leading to high database contention. Adding an index on the 'source' field will drastically reduce the cost of looking up existing records, improving performance significantly. The other options are either less effective or address secondary concerns.

Answer

Increase the scheduled job interval to every 10 minutes to reduce frequency.

Answer

Modify the scheduled job to use GlideAggregate to check for existing records before update.

Answer

Change the integration to use batch processing with a database view.

Question 13

A company is using an Import Set to load data from a CSV file into the Incident table. The CSV contains a column "Assigned to" with user names (e.g., "John Doe"). The transform map maps the "Assigned to" column to the "assigned_to" field on the Incident table. The import set runs successfully but the "assigned_to" field remains empty. What is the most likely cause?

Accepted Answer

The transform map's field mapping uses "Reference" type but the "Display value" checkbox is not selected.. When mapping to a reference field using display value, the "Display value" checkbox must be selected in the field mapping. Without it, ServiceNow attempts to map the value as a sys_id, which fails silently, leaving the field empty.

Answer

The transform map's field mapping uses "Direct" type instead of "Reference" type.

Answer

The transform map is set to "Create and Update" but the "Coalesce" field is not set.

Answer

The "Assigned to" column header contains a space.

Question 14

Which TWO are best practices for integrating with external systems via REST API in ServiceNow?

Accepted Answer

Store credentials in a credential store or use OAuth for authentication.. Options B and E are best practices. Storing credentials in a credential store or using OAuth (option B) enhances security over basic authentication (option C is incorrect). Using HTTPS (option E) encrypts data in transit, protecting it from interception. Option A is wrong because GlideRecordSecure API is actually recommended for secure REST endpoint operations. Option D is incorrect because the sysparm_query parameter filters records but does not limit the number of records returned; use sysparm_limit for that purpose.

Answer

Avoid using the GlideRecordSecure API for REST endpoints.

Answer

Use basic authentication with username and password for all REST API requests.

Answer

Use the sysparm_query parameter to limit the number of records returned.

Question 15

A company uses a scheduled import from an external database to update the user table nightly. Recently, the import has been failing with a timeout error after 30 minutes. The import set contains 50,000 records. What should the administrator do to resolve this issue?

Accepted Answer

Split the import into multiple smaller batches.. The best course of action because splitting the import into smaller batches reduces the processing time per batch and avoids timeout, addressing the root cause.

Answer

Use a transform map to skip unnecessary fields.

Answer

Increase the timeout value in the scheduled import configuration.

Answer

Upgrade the instance to a larger size.