SNOW-CAD Integrating and managing application data — 25 Questions

Question 1

A company needs to integrate ServiceNow with an external HR system using REST API. The HR system requires OAuth 2.0 client credentials grant. Which ServiceNow application should be used to configure this integration?

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

Accepted Answer

REST API Message. REST API Message is the dedicated ServiceNow application for defining and managing outbound REST integrations, including OAuth 2.0 client credentials grant. It allows you to configure the authentication profile, endpoint URL, HTTP method, and request/response handling in a structured, reusable way, making it the appropriate choice for integrating with an external HR system via REST API.

Answer

REST API Explorer

Answer

Flow Designer

Answer

IntegrationHub

Question 2

A ServiceNow admin is troubleshooting a data import from an external database via JDBC. The import runs successfully but only loads partial data. Which is the most likely cause?

Accepted Answer

The JDBC driver has a default row limit that caps the number of records imported. JDBC drivers often impose a default row limit (e.g., 10,000 rows) to prevent memory overload during data retrieval. When importing from an external database via JDBC, this limit caps the number of records returned, causing only partial data to load even though the import job completes successfully. The admin must explicitly set the fetch size or disable the row limit in the JDBC URL or driver configuration to import all records.

Answer

The scheduled import job was interrupted by another job

Answer

The transform map has a filter that excludes certain records

Answer

The field mapping is incorrect and some fields are not being populated

Question 3

An organization uses ServiceNow Discovery to populate the CMDB. They notice that some CI relationships are missing after a discovery run. The discovery logs show no errors. What is the most likely cause?

Accepted Answer

The CI Class Manager does not have the correct relationship types defined for the discovered CIs. The CI Class Manager defines which relationship types are valid for each CI class. If the relationship types are not defined or incorrectly configured, Discovery will not create those relationships even if the probes run successfully and no errors are logged. The absence of errors indicates the discovery process completed normally, but the missing relationships are due to missing or incorrect relationship definitions in the CI Class Manager.

Answer

The MID server credentials do not have permission to query relationship data

Answer

The discovery probes are not configured to capture relationships

Answer

The CMDB is set to read-only mode

Question 4

A ServiceNow instance integrates with an external HR system via REST. The integration retrieves employee records and updates the 'sys_user' table. Recently, the integration started failing with '403 Forbidden' errors. The REST API endpoint and authentication credentials have not changed. Which action should the administrator take first to resolve the issue?

Accepted Answer

Check the Access Control List (ACL) rules on the sys_user table for the integration user.. A 403 Forbidden error indicates that the server understood the request but is refusing to authorize it. Since the REST endpoint and credentials haven't changed, the most likely cause is that the integration user's access rights within ServiceNow have been altered, specifically the Access Control List (ACL) rules on the 'sys_user' table. The administrator should first check these ACLs to ensure the integration user still has the necessary read/write permissions.

Answer

Review the inbound REST message configuration for rate limiting settings.

Answer

Reset the password for the integration user in the external system.

Answer

Verify the REST API endpoint URL in the integration record.

Question 5

A ServiceNow administrator needs to integrate with an external inventory system. The integration must import inventory items into a custom table 'inventory_item' and export order status from a custom table 'order' to the external system. Which TWO methods should the administrator use to achieve this?

Accepted Answer

Export to XML to export order status.. Option D (Import Set Row) is correct because importing external data into a custom table like 'inventory_item' is done by staging the records in an Import Set table and then processing them through a transform map, and the Import Set Row API is the standard programmatic/web-service mechanism for loading rows into that staging table. Option B (Export to XML) is correct because exporting data such as order status from the custom 'order' table to an external system can be accomplished by generating an XML document, which ServiceNow supports natively via export targets and the XML exporter for outbound integrations. Option A is not correct because 'Web Services Import Set' is not a valid ServiceNow method name; the correct approach is the Import Set API/Import Set Row, making A a distractor. Option C is not correct because Flow Designer is an orchestration/automation tool, not the designated import/export mechanism for staging and transforming external inventory data. Option E is not correct because a Transform Map is used to map and transform imported staging data into target tables on import, not to export order status outbound.

Answer

Web Services Import set to import inventory items.

Answer

Flow Designer to both import and export.

Answer

Transform Map to export order status.

Question 6

Match each ServiceNow application scope to its description.

Accepted Answer

System: Artifacts are part of the core platform and can be accessed by all applications.. Scopes in ServiceNow determine where application artifacts can be seen and modified. Global scope allows access and editing from any application, while scoped applications restrict visibility to within the application. System scope contains core platform artifacts that are available to all applications. Common confusions include mixing global and scoped definitions.

Answer

Global: Artifacts are visible only within the application that created them.

Answer

Scoped Application: Artifacts have global visibility across all applications.

Question 7

A company uses REST API to push data from ServiceNow to an external system. The authentication keeps failing with HTTP 401. They have set up OAuth 2.0 client credentials grant. What is the most likely cause?

Accepted Answer

Wrong token endpoint URL. Wrong token endpoint URL is correct because OAuth 2.0 client credentials grant requires the client to request a token from the correct token endpoint. If the URL is incorrect, the request will fail with HTTP 401 Unauthorized, as the server cannot authenticate the client.

Answer

Missing client ID in the request

Answer

Using HTTP instead of HTTPS

Answer

Refresh token has expired

Question 8

A developer needs to count the number of records in the 'task' table that have been updated since the last import. Which GlideAggregate method is correct?

Accepted Answer

gr.addAggregate('COUNT', 'sys_id'). The GlideAggregate.addAggregate() method requires two arguments: the aggregate function name (uppercase, e.g., 'COUNT', 'SUM', 'AVG') and the field to aggregate on. Passing 'sys_id' as the field is the correct pattern for counting records, since sys_id is the unique primary key present on every table and guarantees a non-null count. The method is case-sensitive on the function name, so 'COUNT' must be uppercase.

Answer

gr.addAggregate('COUNT', 'number')

Answer

gr.addAggregate('COUNT')

Answer

gr.addAggregate('count')

Question 9

A scheduled import brings in 50,000 records daily. Which approach is the MOST efficient for transforming these records?

Accepted Answer

Load all rows first, then run the transform as a batch process. For a daily batch of 50,000 records, loading all rows into a staging table first and then running a single set-based transform is far more efficient than row-by-row processing. Set-based operations in ServiceNow (Transform Maps, background scripts, or scheduled jobs) minimize database round-trips and leverage bulk SQL. This is the standard 'batch over row' best practice.

Answer

Run the transform after each row is inserted into the staging table

Answer

Use a database view to transform data on the fly

Answer

Write directly to the target table using insert statements

Question 10

Which TWO are best practices when implementing data integrations using ServiceNow import sets?

Accepted Answer

Schedule the import to run during off-peak hours. Option A is correct because scheduling import set runs during off-peak hours reduces contention on the ServiceNow instance, avoiding performance degradation for interactive users and other scheduled jobs while large data loads and transform maps execute. Option D is correct because configuring a coalesce field in the transform map lets the system match incoming rows to existing target records, so re-runs update rather than insert, preventing duplicate records. Option B is not a best practice for import sets; REST is a transport mechanism and does not by itself improve performance or replace the staging/transform model. Option C is not a best practice because import set configurations (data sources, transform maps) should be promoted via update sets only in the sense of any configuration, but the question asks about implementing integrations, and update sets are not the recommended mechanism for managing import set runtime data or scheduling. Option E is not a best practice because not every data source requires a staging table; direct or scripted imports and web service imports can bypass staging when appropriate.

Answer

Use REST API instead of import sets for better performance

Answer

Use update sets to manage import set configurations

Answer

Always use a staging table for all data sources

Question 11

What is the most likely cause of this error?

Accepted Answer

The access token has expired or is invalid. An 'access token has expired or is invalid' error is the classic symptom of an OAuth 2.0 bearer token that has passed its expiry or was revoked. The API rejects the request with 401 Unauthorized before any business logic runs, which is why the fix is to refresh or re-acquire the token rather than change the URL or headers.

Answer

The request timed out

Answer

The endpoint URL is incorrect

Answer

The Content-Type header is missing

Question 12

The transform map fails when the source field 'u_summary' is null. What is the best way to prevent this error?

Accepted Answer

Add a null check before setting: if(source.u_summary) target.setValue('short_description', source.u_summary);. It adds a null check before setting the value, preventing the transform map from failing when source.u_summary is null. Option A is incorrect because it does not handle null, which would still cause an error. Option C is incorrect because 'return true;' does not address null values. Option D is incorrect because mapping to a system field like 'sys_created_by' avoids the null issue but is not the best practice; using a null check is the appropriate approach.

Answer

Use target.short_description = source.u_summary instead

Answer

Add a 'return true;' statement at the end

Answer

Map to a system field like 'sys_created_by'

Question 13

A developer is troubleshooting an integration where an inbound SOAP message fails to insert a record into the 'change_request' table. The SOAP message is well-formed and the user has the 'change_manager' role. The ACL for the 'change_request' table allows write to 'admin' and 'change_manager'. What is the most likely cause?

Accepted Answer

The SOAP message is missing a mandatory field.. When a SOAP message is well-formed, the user has the required role, and the ACL grants write access, the most common remaining cause of an insert failure is a missing mandatory field on the target table. ServiceNow enforces mandatory fields at the database layer regardless of the API used, so the insert is rejected with a validation error.

Answer

The 'change_request' table is locked for data imports.

Answer

The user's role is not recognized when using SOAP web services.

Answer

The SOAP message uses a different namespace.

Question 14

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()'.. ServiceNow business rules can check whether the current user is a web service user via 'gs.getUser().isWebService()'. Adding '!gs.getUser().isWebService()' to the condition script ensures the rule only runs for interactive form updates, not web service calls.

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 15

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.. Using GlideRecord with setLimit and a loop to process records in batches is the recommended approach because ServiceNow enforces a transaction execution time limit (typically 30 seconds for synchronous scripts, longer for scheduled jobs). Batching keeps each transaction under the limit and allows the script to resume or continue across multiple runs without timing out.

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 16

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.. Option A is correct because disabling business rules and ACLs during a large import removes the overhead of executing rule logic and access-control checks on every row, which significantly speeds up the insert of records into the import set or target table. Option E is correct because scheduled imports run asynchronously in the background, avoiding the interactive session timeouts and UI overhead associated with manual imports, and they can be tuned to run during off-peak hours for better throughput. The remaining options do not belong: increasing the import set table row limit (B) does not improve performance and can even strain the instance, using a single transform map for all records (D) is not a performance best practice since it ignores per-table mapping needs, and 'Create multiple' (C) is a transform-map setting for creating multiple target records from one source row, not a general import-performance optimization.

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 17

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 18

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 integration queries the incident table using a condition on the 'source' field, which is not indexed. Without an index, the database must perform a full table scan on millions of records each run, causing high I/O and contention. Adding an index on 'source' allows the database to quickly locate matching records, drastically reducing query time and database load.

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 19

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 20

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.. Option B is correct because storing credentials in a credential store (e.g., a Connection & Credential alias or the Credentials table) or using OAuth 2.0 keeps secrets out of scripts and provides token-based, revocable authentication, which is the recommended secure pattern for outbound REST integrations. Option E is correct because all REST traffic to and from external systems should be sent over HTTPS (TLS) so that credentials, tokens, and payload data are encrypted in transit and protected from interception. Option A is not a best practice—GlideRecordSecure enforces ACLs and is often appropriate for REST endpoints, so avoiding it is not a general rule. Option C is wrong because hardcoding basic authentication with username and password for all requests exposes static credentials and should be replaced by credential stores or OAuth. Option D is wrong because sysparm_query filters which records match a condition; it does not limit the number of records returned—that is done with sysparm_limit.

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.