SNOW-CAD Integrating and managing application data — Timed 20 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?

20 minute time limit — choose an answer to begin.

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

Question 16

A developer is designing a REST message to send data from ServiceNow to an external system. The external system expects a new resource to be created at a specific endpoint. Which HTTP method should be used?

Accepted Answer

POST. The correct HTTP method is POST (option D). POST is used to create new resources on the server. Option A (PUT) is typically used to update or replace an existing resource, not create a new one at a specific endpoint. Option B (PATCH) is used for partial updates to an existing resource. Option C (GET) is used to retrieve data, not create new resources.

Answer

PUT

Answer

PATCH

Answer

GET

Question 17

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'). `addAggregate('COUNT', 'sys_id')` counts all records in the table, as `sys_id` is always present and unique. Option B is wrong because using `'number'` as the field would only count records where the `number` field is not null, potentially undercounting if any records have a null number. Option C is wrong because `addAggregate('COUNT')` omits the required field name, causing an error. Option D is wrong because `'count'` (lowercase) is not a valid aggregate function; the function name must be uppercase, e.g., `'COUNT'`.

Answer

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

Answer

gr.addAggregate('COUNT')

Answer

gr.addAggregate('count')

Question 18

A team is using a SOAP web service integration. The response contains namespaced XML, and the script that parses it is not extracting values correctly. What is the most likely issue?

Accepted Answer

Missing or incorrect namespace prefix handling in the script. Namespaced XML requires proper namespace prefix handling to extract values; if the script lacks or mismatches prefixes, parsing fails. Option A is incorrect because WSDL caching affects endpoint updates, not parsing. Option B is incorrect because SOAP version mismatch typically causes communication errors, not parsing issues. Option C is incorrect because HTTP timeout would result in no response, not incorrect value extraction.

Answer

WSDL caching prevents updated endpoint

Answer

SOAP version mismatch between request and response

Answer

HTTP timeout during response retrieval

Question 19

An organization needs to import data from a SaaS application that provides a CSV file accessible via a direct URL. Which data source type should be configured?

Accepted Answer

File data source. A File data source can import data from a CSV file accessible via a direct URL. Option A is wrong because a REST data source is used for web services, not direct file URLs. Option B is wrong because a JDBC data source connects to SQL databases. Option D is wrong because an LDAP data source is used for directory services.

Answer

REST data source

Answer

JDBC data source

Answer

LDAP data source

Question 20

In a transform map, a field mapping uses the condition 'if target field is empty'. What does this mean?

Accepted Answer

Only maps if target field is empty. The condition 'if target field is empty' means the mapping is applied only when the target field is currently empty. Option A is wrong because it incorrectly says both source and target must be empty. Option B is wrong because it says always maps, but the condition restricts mapping. Option D is wrong because it checks source field, not target.

Answer

Only maps if both source and target are empty

Answer

Always maps regardless

Answer

Only maps if source field is empty