SNOW-CAD Integrating and managing application data — 15 Questions

Question 1

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?

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

Accepted Answer

Export to XML to export order status.. Export to XML is a native ServiceNow feature that allows administrators to export records from any table, including the custom 'order' table, in XML format. This XML data can then be consumed by an external system via a REST or SOAP endpoint, making it a straightforward method for exporting order status. Option D is correct because using Import Sets (which store imported data in the Import Set Row table) is a standard method for importing data from external sources into ServiceNow tables. By creating an Import Set and defining a transform map, administrators can map incoming fields to the 'inventory_item' table fields, enabling structured import of inventory items.

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 2

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?

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 3

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 4

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 5

A company is integrating ServiceNow with an external ticketing system using a custom REST API. The integration should push updates from ServiceNow to the external system when a change request is approved. Which ServiceNow feature is best suited for this?

Accepted Answer

Business Rule with outbound REST call. A Business Rule with an outbound REST call is the best fit because it triggers automatically on the 'approved' state change of a change request and can execute a synchronous or asynchronous REST API call to the external ticketing system. This allows real-time push of updates without manual intervention or polling, directly meeting the requirement to push updates upon approval.

Answer

REST API Explorer

Answer

Access Control List (ACL)

Answer

Scheduled Job

Question 6

Which TWO actions should a developer take when designing an inbound email integration in ServiceNow to ensure proper data mapping? (Choose two.)

Accepted Answer

Configure the inbound email action to trigger on the appropriate table. Inbound email actions in ServiceNow are configured to trigger on a specific target table, which defines where the incoming email data will be mapped and stored. This ensures that the email processing logic is applied to the correct table, enabling proper data mapping and field extraction.

Answer

Set up an ACL to allow the email user to write to the target table

Answer

Ensure the email includes an attachment with the data

Answer

Create a connection to the external email server

Question 7

A developer is creating a REST API integration that retrieves data from an external system and updates ServiceNow records. Which THREE considerations are critical for handling authentication securely? (Choose three.)

Accepted Answer

Store credentials in the ServiceNow Credential Store instead of scripts. Storing credentials directly in scripts exposes them to unauthorized access and makes rotation difficult. The ServiceNow Credential Store securely encrypts and manages credentials, allowing scripts to reference them by alias without hardcoding sensitive data, which is a fundamental security best practice for REST API integrations.

Answer

Enable credential monitoring in the Security Operations Center

Answer

Configure the external system to authenticate ServiceNow requests

Question 8

A large enterprise uses ServiceNow as its ITSM platform. They have an existing LDAP directory that contains user accounts and group memberships. They want to synchronize user accounts from LDAP into the ServiceNow user table (sys_user) and automatically assign roles based on group membership. The LDAP server supports both user and group synchronization. The administrator has configured an LDAP server record and a user import transform map. After running the LDAP user import, all users are created but none have roles assigned. The LDAP group import transform map is configured to load groups into the sys_user_group table and members into the member list. The administrator verified that the LDAP group import runs successfully and populates groups with members. However, the expected roles are still missing. What is the most likely cause and solution?

Accepted Answer

The administrator did not configure role-to-group mapping in the LDAP server record. Solution: define the mapping in the 'Role' related list on the LDAP server configuration.. In ServiceNow, role assignment via LDAP group synchronization requires explicit role-to-group mapping on the LDAP server record. Even when groups and members are imported correctly, roles are not automatically assigned unless the administrator defines which LDAP group corresponds to which ServiceNow role in the 'Role' related list on the LDAP server configuration. Without this mapping, the system has no instruction to link group membership to role inheritance.

Answer

The LDAP group import is not correctly associating users to groups. Solution: check the member attribute mapping in the group import transform map.

Answer

The LDAP user import is not populating the 'group' field on the user record. Solution: add a field mapping to copy the group DN.

Answer

The LDAP user import transform map does not have a coalesce field set, causing duplicate users. Solution: set coalesce on the user ID field.

Question 9

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 10

A company has a ServiceNow instance integrated with a third-party ticket management system. The integration runs every hour via a scheduled job that calls a REST API to fetch new tickets and create incidents in ServiceNow. The administrator notices that some incidents are being created as duplicates. Investigation reveals that the third-party system sometimes returns the same ticket in multiple API calls due to caching. The scheduled job does not check for existing incidents before creating new ones. The administrator needs to modify the integration to prevent duplicate incidents without relying on the third-party system to change its behavior. Which action should the administrator take?

Accepted Answer

Add a check in the integration script to query the incident table for an existing incident with the same external ticket ID before creating a new one.. The most reliable way to prevent duplicates is to check the incident table for an existing record with the same external ticket ID before creating a new incident. This leverages the unique identifier from the third-party system and avoids relying on the third-party's caching behavior. By querying the incident table using a GlideRecord lookup on a field that stores the external ID, the script can conditionally skip creation if a match is found.

Answer

Modify the integration to only create incidents if the ticket status is 'New'.

Answer

Increase the scheduled job interval to run every 2 hours.

Answer

Add a post-processing script that deletes duplicate incidents after each run.

Question 11

Drag and drop the steps to configure a Business Rule in ServiceNow into the correct order.

Accepted Answer

Step 1: Navigate to the Business Rules module. Step 2: Click the New button. Step 3: Select the table and enter a name. Step 4: Set the conditions for when the rule runs. Step 5: Write the script. Step 6: Click Submit.. The standard workflow: navigate to Business Rules, create new, specify table and name, set conditions, then script and submit.

Answer

Step 1: Navigate to the Business Rules module. Step 2: Click the New button. Step 3: Write the script. Step 4: Set the conditions. Step 5: Select the table and enter a name. Step 6: Click Submit.

Answer

Step 1: Navigate to the Business Rules module. Step 2: Click the New button. Step 3: Set the conditions. Step 4: Select the table and enter a name. Step 5: Write the script. Step 6: Click Submit.

Answer

Step 1: Navigate to the Business Rules module. Step 2: Click the New button. Step 3: Select the table and enter a name. Step 4: Write the script. Step 5: Set the conditions. Step 6: Click Submit.

Question 12

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 13

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. In client credentials grant, the token endpoint must be correct. Option A is wrong because missing client ID would cause a different error. Option C is wrong because HTTPS is required but not the most likely cause of 401. Option D is wrong because client credentials grant does not use refresh tokens.

Answer

Missing client ID in the request

Answer

Using HTTP instead of HTTPS

Answer

Refresh token has expired

Question 14

An import set loads data from a CSV file into the staging table successfully, but the transform map does not run. The import set rows show status 'loaded'. What is the most likely cause?

Accepted Answer

The transform map is set to inactive. The transform map is set to inactive, which prevents it from running. Option A is incorrect because the import set table is not empty; rows have been loaded. Option C is incorrect because incomplete field mapping would cause transform errors but not prevent the map from running. Option D is incorrect because a misspelled target table name would likely cause a different issue, such as rows not being created, but the map would still attempt to run.

Answer

The import set table is empty

Answer

The field mapping between source and target fields is incomplete

Answer

The transform map's target table name is misspelled

Question 15

As a best practice, which method should be used to schedule recurring data imports from external sources?

Accepted Answer

Configure a scheduled job to use the Import Set API or transform. A scheduled job can be configured to run at recurring intervals and use the Import Set API or transform to import data from external sources. Option A is incorrect because update sets are used for version control and deployment, not for scheduling data imports. Option B is incorrect because a Flow Designer flow with an HTTP trigger is designed for real-time HTTP requests, not for recurring scheduled imports. Option D is incorrect because business rules trigger on database operations (like insert, update, delete) and are not suited for scheduling recurring imports.

Answer

Deploy an update set for each import

Answer

Use a Flow Designer flow with an HTTP trigger

Answer

Create a business rule that triggers on a condition