Courseiva

CCNA Sn Integration Data Questions

50 questions · Sn Integration Data topic · All types, answers revealed

Practice these questionsExam hubAll questions
1
Multi-Selecthard

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.)

Select 3 answers
A.Enable credential monitoring in the Security Operations Center
B.Configure the external system to authenticate ServiceNow requests
C.Store credentials in the ServiceNow Credential Store instead of scripts
D.Use OAuth2.0 with refresh tokens for long-lived access
E.Ensure the REST endpoint uses HTTPS
AnswersC, D, E

The Credential Store encrypts and manages secrets, reducing exposure.

Why this answer

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.

Exam trap

The trap here is confusing operational monitoring (Option A) with proactive authentication security controls, and reversing the authentication direction in Option B, leading candidates to select measures that are either reactive or misdirected.

Practice this question →
2
MCQmedium

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?

A.Use a single GlideRecord update with setWorkflow(false).
B.Use GlideRecord with setLimit and a loop to process in batches.
C.Use a scheduled job to run the script asynchronously.
D.Use a business rule to trigger the update on save.
AnswerB

Correct: Batching prevents hitting the script timeout.

Why this answer

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

Practice this question →
3
MCQhard

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?

A.The import set table is empty
B.The transform map is set to inactive
C.The field mapping between source and target fields is incomplete
D.The transform map's target table name is misspelled
AnswerB

An inactive transform map does not execute even if data is loaded.

Why this answer

Option C is correct: the transform map must be active to run. Option A is incorrect because the table name in transform map determines the target, not the trigger. Option B is incorrect because field mapping misconfiguration would cause transform errors but not prevent it from running.

Option D is incorrect because the import set table is not empty; rows are loaded.

Practice this question →
4
Multi-Selectmedium

Which THREE factors should be considered when deciding between using a REST API integration and an Import Set for data ingestion?

Select 3 answers
A.Real-time vs batch processing requirement
B.Volume of data to be imported
C.Need for authentication and authorization
D.Complexity of data transformation needed
E.Support for OAuth 2.0
AnswersA, B, D

REST is real-time; import sets are batch.

Why this answer

Options A, B, and C are correct. Volume (A) affects performance; real-time vs batch (B) is a key difference; complexity of transformation (C) determines suitability. D is needed for both.

E is a subset of REST, not a deciding factor.

Practice this question →
5
MCQeasy

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?

A.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.
B.Modify the integration to only create incidents if the ticket status is 'New'.
C.Increase the scheduled job interval to run every 2 hours.
D.Add a post-processing script that deletes duplicate incidents after each run.
AnswerA

This ensures that duplicates are prevented at creation time by checking a unique external ID field.

Why this answer

Option A is correct because 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.

Exam trap

The trap here is that candidates might choose Option D (delete duplicates after creation) because it seems like a quick fix, but the SNOW-CAD exam emphasizes preventing errors at the point of data entry rather than relying on post-processing cleanup, which can lead to data inconsistency and performance issues.

How to eliminate wrong answers

Option B is wrong because filtering by ticket status 'New' does not address the root cause of duplicate incidents from repeated API responses; the same ticket could be returned with a 'New' status multiple times due to caching. Option C is wrong because increasing the interval to 2 hours only reduces the frequency of duplicate creation but does not eliminate it; the third-party system could still return the same ticket in consecutive runs. Option D is wrong because deleting duplicates after creation is inefficient, introduces a race condition where users might see duplicates temporarily, and violates the principle of preventing errors rather than cleaning them up.

Practice this question →
6
MCQhard

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?

A.Review the inbound REST message configuration for rate limiting settings.
B.Reset the password for the integration user in the external system.
C.Check the Access Control List (ACL) rules on the sys_user table for the integration user.
D.Verify the REST API endpoint URL in the integration record.
AnswerC

A 403 error indicates forbidden access; ACLs or user permissions are the most common cause.

Why this answer

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.

Exam trap

The trap here is confusing a 403 Forbidden with a 401 Unauthorized or a connectivity issue, leading candidates to focus on credentials or endpoint URLs instead of the authorization layer within ServiceNow's ACLs.

How to eliminate wrong answers

Option A is wrong because rate limiting typically returns a 429 (Too Many Requests) or 503 (Service Unavailable) status, not a 403 Forbidden. Option B is wrong because the authentication credentials have not changed, and resetting the password in the external system would not resolve a permission issue within ServiceNow's own ACLs. Option D is wrong because the REST API endpoint URL has not changed, and verifying it would not address a 403 error that indicates an authorization failure, not a routing or connectivity problem.

Practice this question →
7
MCQhard

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?

A.REST API
B.Import Set
C.External Data Sources
D.SOAP Web Service
AnswerC

Correct: External Data Sources provide JDBC connectivity to external databases.

Why this answer

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

Practice this question →
8
MCQeasy

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?

A.gr.addAggregate('COUNT', 'sys_id')
B.gr.addAggregate('COUNT', 'number')
C.gr.addAggregate('COUNT')
D.gr.addAggregate('count')
AnswerA

This correctly counts records by system ID.

Why this answer

Option A is correct: addAggregate('COUNT', 'sys_id') counts rows. Option B is wrong because addAggregate requires a field name. Option C is wrong because 'count' is not a valid function.

Option D is wrong because it specifies a field but function name is missing.

Practice this question →
9
MCQhard

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?

A.The firewall is blocking port 1521.
B.The Oracle client is not installed.
C.The MID Server is not running.
D.The database instance name (service name) is incorrect in the configuration.
AnswerD

Correct: The error indicates the listener does not recognize the service requested.

Why this answer

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.

Practice this question →
10
MCQmedium

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?

A.The ACL script is malformed.
B.The ACL requires the 'admin' role, but the user has 'incident_manager'.
C.The ACL operation is 'read' but the REST call is a POST.
D.The user does not have the 'rest_api' role.
AnswerB

Correct: The script checks for 'admin' role, so the user is denied.

Why this answer

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.

Practice this question →
11
MCQeasy

A large enterprise uses a scheduled import to retrieve order data from an external ERP system every night at 2 AM. The import runs a REST API call that returns JSON data, which is processed by an Import Set Row and a Transform Map to populate the custom table 'u_order'. Recently, the import completed with errors: some orders were not imported, and the error log shows 'Record already exists' for those orders. However, when the developer checks the 'u_order' table, the referenced orders do not exist. The developer reviews the Import Set Row and finds that the 'Coalesce' field is set to 'u_order_number', but further investigation reveals that the 'u_order_number' field is not unique in the table; multiple records can have the same order number because they are from different regions. The Transform Map is configured with 'On Success' = 'Update'. What is the best course of action to resolve the issue?

A.Remove the Coalesce field from the Transform Map so that duplicate detection is disabled.
B.Change the 'On Success' action on the Transform Map to 'Insert' to ensure all incoming records are treated as new.
C.Modify the Coalesce field to use a combination of fields (e.g., order number and region) that uniquely identifies each record, or create a dedicated unique identifier.
D.Increase the frequency of the scheduled import to run every hour so that errors are minimized.
AnswerC

A unique coalesce field ensures that the system correctly matches existing records, preventing false 'already exists' errors and allowing proper updates.

Why this answer

Option C is correct because the coalesce field must uniquely identify records to avoid false positive matches. Using a combination of fields (e.g., order number and region) ensures each record is uniquely identified. Option A would cause duplicates if the same logical order is reimported.

Option B would also cause duplicates because coalesce is disabled. Option D does not address the root cause of incorrect matching.

Practice this question →
12
MCQeasy

What is the most likely cause of this error?

A.The request timed out
B.The access token has expired or is invalid
C.The endpoint URL is incorrect
D.The Content-Type header is missing
AnswerB

A 401 status with Bearer token typically means the token is not accepted.

Why this answer

Option A is correct: HTTP 401 with Bearer token indicates the token is invalid or expired. Option B is wrong because wrong endpoint would give 404, not 401. Option C is wrong because missing Content-Type would not cause 401.

Option D is wrong because timeout would be a different error.

Practice this question →
13
MCQmedium

The script above fails with HTTP 400 Bad Request. What is the most likely missing configuration?

A.The HTTP method should be PUT instead of POST
B.Missing authentication credentials
C.The Content-Type header is not set to application/json
D.The Accept header should be text/plain
AnswerC

Without Content-Type, the server cannot parse the request body, resulting in 400.

Why this answer

Option A is correct: missing Content-Type header set to application/json causes 400. Option B is wrong because method is POST, which is correct. Option C is wrong because Accept header is set.

Option D is wrong because authentication would cause 401, not 400.

Practice this question →
14
MCQhard

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?

A.The index was not created correctly.
B.The job runs during peak hours.
C.The job uses a condition that filters on a different field.
D.The database is replicated to a secondary site.
AnswerC

Correct: The index on 'source' is not utilized if the query filters on another field.

Why this answer

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.

Practice this question →
15
MCQmedium

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?

A.Missing client ID in the request
B.Wrong token endpoint URL
C.Using HTTP instead of HTTPS
D.Refresh token has expired
AnswerB

If the token endpoint URL is incorrect, the authorization server cannot validate credentials, leading to 401.

Why this answer

Option B is correct because 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.

Practice this question →
16
MCQmedium

A company wants to synchronize user data from an external HR system into ServiceNow every night. The HR system pushes a CSV file to an SFTP server. Which ServiceNow feature should be used to automate this process?

A.External Data Source
B.SOAP Web Service
C.REST API
D.Scheduled Import
AnswerD

Correct: Scheduled Import can be configured to pull files from SFTP and import them into import sets.

Why this answer

Scheduled Import from an SFTP server is the proper feature to automate ingestion of files from an external SFTP location at scheduled intervals.

Practice this question →
17
Multi-Selectmedium

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

Select 2 answers
A.Set up an ACL to allow the email user to write to the target table
B.Ensure the email includes an attachment with the data
C.Configure the inbound email action to trigger on the appropriate table
D.Create a connection to the external email server
E.Use the email parsing script to extract fields from the email body
AnswersC, E

The inbound action must be associated with the table where records will be created or updated.

Why this answer

Option C is correct because 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.

Exam trap

The trap here is that candidates often confuse the inbound email action table configuration with ACLs or email server connections, thinking those are required for data mapping, when in fact the table selection and parsing script are the core mechanisms for mapping email data to ServiceNow records.

Practice this question →
18
MCQeasy

A developer is configuring a REST message to retrieve data from an external system. The external system returns XML responses. Which data format should the developer set the REST message to expect?

A.JSON
B.Text
C.CSV
D.XML
AnswerD

Correct: The format should match the response from the external system, which is XML.

Why this answer

The REST message must be configured to expect the same data format that the external system returns. Since the external system returns XML, the developer should set the expected format to XML.

Practice this question →
19
MCQmedium

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?

A.REST API Explorer
B.Flow Designer
C.REST API Message
D.IntegrationHub
AnswerC

REST API Messages allow configuration of outbound REST calls, including OAuth authentication.

Why this answer

Option C is correct because 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.

Exam trap

The trap here is that candidates confuse the tool for testing APIs (REST API Explorer) or the workflow automation layer (Flow Designer/IntegrationHub) with the actual configuration component (REST API Message) that handles OAuth 2.0 client credentials grant for outbound REST integrations.

How to eliminate wrong answers

Option A is wrong because REST API Explorer is a tool for testing and exploring REST APIs interactively, not for configuring and managing persistent integrations with authentication like OAuth 2.0 client credentials. Option B is wrong because Flow Designer is used for creating no-code workflows and automations within ServiceNow, but it relies on pre-configured actions or spokes (like REST API Message) to make outbound REST calls; it does not directly configure OAuth 2.0 client credentials grant for an integration. Option D is wrong because IntegrationHub is a premium add-on that extends Flow Designer with spokes and subscription-based integrations, but the base configuration of OAuth 2.0 client credentials for a REST API is still done via REST API Message, not IntegrationHub itself.

Practice this question →
20
MCQhard

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?

A.Increase the scheduled job interval to every 10 minutes to reduce frequency.
B.Modify the scheduled job to use GlideAggregate to check for existing records before update.
C.Add an index on the 'source' field in the incident table.
D.Change the integration to use batch processing with a database view.
AnswerC

Correct: Adding an index on the 'source' field will optimize the query and reduce contention.

Why this answer

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.

Practice this question →
21
Multi-Selectmedium

Which TWO actions are required to ensure that an Import Set can update existing records while inserting new ones? (Choose two.)

Select 2 answers
A.Enable the 'Run as advanced' checkbox on the Import Set Row.
B.Set the 'On Success' field to 'Update' on the Transform Map.
C.Configure a data source to define the external system connection.
D.Set the Coalesce field on the Transform Map to the unique identifier field.
E.Define a Transform Map that maps source fields to target fields.
AnswersB, D

The 'On Success' field controls whether matched records are updated; 'Update' is required to update instead of ignoring.

Why this answer

Option B is correct because setting the 'On Success' field to 'Update' on the Transform Map instructs the transform engine to update existing records when a matching record is found, rather than skipping or inserting a duplicate. Option D is correct because the Coalesce field defines which source field is used to match against existing target records; without a coalesce field, the system cannot determine whether a record already exists, so it will always insert new records.

Exam trap

The trap here is that candidates often think simply defining a Transform Map (Option E) is sufficient for updates, but they overlook the mandatory coalesce field and the 'On Success' setting that explicitly control the update logic.

Practice this question →
22
MCQmedium

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?

A.The LDAP group import is not correctly associating users to groups. Solution: check the member attribute mapping in the group import transform map.
B.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.
C.The LDAP user import is not populating the 'group' field on the user record. Solution: add a field mapping to copy the group DN.
D.The LDAP user import transform map does not have a coalesce field set, causing duplicate users. Solution: set coalesce on the user ID field.
AnswerB

Roles are assigned by mapping LDAP groups to ServiceNow roles in the LDAP server configuration.

Why this answer

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.

Exam trap

The trap here is that candidates assume successful group and member import automatically assigns roles, overlooking the mandatory role-to-group mapping on the LDAP server record.

How to eliminate wrong answers

Option A is wrong because the administrator verified that the LDAP group import runs successfully and populates groups with members, so the member attribute mapping is correct. Option C is wrong because the 'group' field on the user record is not used for role assignment; roles are derived from the sys_user_group table via the role-to-group mapping on the LDAP server record. Option D is wrong because coalesce settings affect duplicate detection and merging, not role assignment; the issue is about missing roles, not duplicate users.

Practice this question →
23
MCQeasy

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?

A.Use a transform map to skip unnecessary fields.
B.Split the import into multiple smaller batches.
C.Increase the timeout value in the scheduled import configuration.
D.Upgrade the instance to a larger size.
AnswerB

Smaller batches each complete within the timeout, and the total processing remains feasible.

Why this answer

Option B is 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.

Practice this question →
24
Multi-Selecthard

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

Select 2 answers
A.Avoid using the GlideRecordSecure API for REST endpoints.
B.Store credentials in a credential store or use OAuth for authentication.
C.Use basic authentication with username and password for all REST API requests.
D.Use the sysparm_query parameter to limit the number of records returned.
E.Always use HTTPS to encrypt data in transit.
AnswersB, E

Using a credential store or OAuth avoids hardcoding credentials and improves security.

Why this answer

Options B and C are best practices. Using HTTPS secures data in transit, and using OAuth or a credential store enhances security over basic authentication.

Practice this question →
25
Matchingmedium

Match each ServiceNow application scope to its description.

Drag a concept onto its matching description — or click a concept then click the description.

Concepts
Matches

Visible and editable across all scopes

Isolated application with own tables and access controls

Built-in scope for system administration

Default scope for end-user interactions

Scope for plugin-provided applications

Why these pairings

Scopes define visibility and editability of application artifacts.

Practice this question →
26
MCQmedium

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?

A.The transform map's field mapping uses "Direct" type instead of "Reference" type.
B.The transform map's field mapping uses "Reference" type but the "Display value" checkbox is not selected.
C.The transform map is set to "Create and Update" but the "Coalesce" field is not set.
D.The "Assigned to" column header contains a space.
AnswerB

For reference fields, when mapping with a non-sys_id value (like a name), the "Display value" checkbox must be selected to resolve the value to the correct sys_id.

Why this answer

Option D is correct because 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.

Practice this question →
27
MCQeasy

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

A.To remove null values from the import.
B.To combine multiple fields into one.
C.To convert data types.
D.To use a field to match existing records and avoid duplicates.
AnswerD

Correct: Coalesce is used for deduplication.

Why this answer

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

Practice this question →
28
MCQhard

A developer is testing a REST API call to retrieve active users with the ITIL role created since last month. The response returns an error. What is the most likely cause?

A.The Accept header should be application/xml.
B.The query parameter sysparm_query uses a script which is not allowed in REST API calls.
C.The endpoint should be /api/now/table/sys_user_list.
D.The query should use sysparm_fields instead of sysparm_query.
AnswerB

ServiceNow REST API does not evaluate client-side scripts in query parameters; the date must be precomputed.

Why this answer

The error occurs because the sysparm_query parameter in a REST API call to the /api/now/table/sys_user endpoint does not support scripts; it only accepts encoded query strings using operators like '=', '^', 'STARTSWITH', etc. Using a script in sysparm_query violates the REST API specification, which expects a simple query string, not executable code, leading to a bad request error.

Exam trap

ServiceNow often tests the misconception that sysparm_query can accept any JavaScript expression, when in fact it only supports a predefined set of operators and encoded query strings, not arbitrary scripts.

How to eliminate wrong answers

Option A is wrong because the Accept header should be application/json, not application/xml, as the default and most common response format for ServiceNow REST APIs is JSON; using XML would not cause an error but would be non-standard. Option C is wrong because the correct endpoint for querying the sys_user table is /api/now/table/sys_user, not /api/now/table/sys_user_list; the 'sys_user_list' suffix is not a valid table endpoint. Option D is wrong because sysparm_fields is used to specify which fields to return, not to filter records; filtering requires sysparm_query, so replacing sysparm_query with sysparm_fields would not retrieve active users with the ITIL role.

Practice this question →
29
MCQmedium

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?

A.REST data source
B.JDBC data source
C.File data source
D.LDAP data source
AnswerC

File data source can be configured to fetch from a URL.

Why this answer

Option D is correct: File data source can import from a URL. Option A is wrong because LDAP is for directory services. Option B is wrong because JDBC is for SQL databases.

Option C is wrong because REST is for web services.

Practice this question →
30
MCQmedium

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?

A.Set the business rule to run only on 'Submit'.
B.Use the 'Filter Conditions' on the table to exclude web service users.
C.In the condition script, add '!gs.getUser().isWebService()'.
D.Set the 'When to run' to 'Update' and nothing else.
AnswerC

Correct: This prevents execution when the update comes from a web service.

Why this answer

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.

Practice this question →
31
MCQhard

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?

A.The SOAP message is missing a mandatory field.
B.The 'change_request' table is locked for data imports.
C.The user's role is not recognized when using SOAP web services.
D.The SOAP message uses a different namespace.
AnswerA

Correct: Missing mandatory fields cause the insert to fail.

Why this answer

The most likely cause is that the SOAP message is missing a mandatory field, causing the insert to fail validation. The SOAP web service processes the request and if a required field is omitted, the insert is rejected.

Practice this question →
32
MCQhard

An organization uses an LDAP integration to import user accounts into ServiceNow. The integration creates a large number of users, but some users are missing their manager field. The manager field in LDAP is a distinguished name (DN). The transform map uses a reference field mapping with "Display value" unchecked. The target field "manager" on sys_user is a reference to sys_user. The import set log shows no errors for those records. What is the most likely cause?

A.The transform map's "Coalesce" field is set on manager.
B.The import set's "On Conflict" setting is set to "Ignore".
C.The LDAP DN values do not match the sys_id of the manager users.
D.The manager field in LDAP is empty for some users.
AnswerC

The mapping expects a sys_id, but the DN is not a sys_id, so the reference cannot be resolved.

Why this answer

Option A is correct because the manager field is a reference, and with "Display value" unchecked, the mapping expects a sys_id. Since the LDAP provides a DN, the mapping fails silently, leaving the field empty.

Practice this question →
33
MCQeasy

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?

A.The scheduled import job was interrupted by another job
B.The transform map has a filter that excludes certain records
C.The field mapping is incorrect and some fields are not being populated
D.The JDBC driver has a default row limit that caps the number of records imported
AnswerD

ServiceNow JDBC imports have a default limit of 50,000 rows, which can be adjusted in the datasource configuration.

Why this answer

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.

Exam trap

The trap here is that candidates often assume partial data is due to a transform map filter or field mapping error, but the key clue is that the import 'runs successfully' — meaning no errors — which points to a silent cap on row retrieval rather than a configuration or interruption issue.

How to eliminate wrong answers

Option A is wrong because a scheduled import job being interrupted by another job would typically cause the import to fail or produce an error, not complete successfully with partial data. Option B is wrong because a transform map filter that excludes certain records would consistently exclude the same records on every run, not load a partial set of all records; it would also be visible in the transform map configuration. Option C is wrong because incorrect field mapping would result in some fields being empty or null, not in a reduced number of records being imported; the import would still load all rows, but with missing field values.

Practice this question →
34
Multi-Selecthard

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.)

Select 2 answers
A.Disable business rules and ACLs during import.
B.Increase the import set table row limit.
C.Enable 'Create multiple' for transform maps.
D.Use a single transform map for all records.
E.Use scheduled imports instead of manual imports.
AnswersA, E

This reduces overhead and speeds up import significantly.

Why this answer

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.

Practice this question →
35
MCQeasy

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

A.Use GET methods for data modification.
B.Use versioning in the API path.
C.Pass sensitive data in URL parameters.
D.Return all data without pagination.
AnswerB

Correct: Versioning allows backward compatibility.

Why this answer

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

Practice this question →
36
Drag & Dropmedium

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

Drag steps to the numbered slots on the right, or tap a step then tap a slot.

Steps
Order

Why this order

The standard workflow: navigate to Business Rules, create new, specify table and name, set conditions, then script and submit.

Practice this question →
37
MCQmedium

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?

A.PUT
B.PATCH
C.GET
D.POST
AnswerD

POST is the standard method for creating new resources.

Why this answer

Option B is correct: POST is used to create new resources. Option A is wrong because GET retrieves data. Option C is wrong because PUT updates/replaces.

Option D is wrong because PATCH updates partially.

Practice this question →
38
Multi-Selecteasy

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

Select 2 answers
A.Schedule the import to run during off-peak hours
B.Use REST API instead of import sets for better performance
C.Use update sets to manage import set configurations
D.Use coalesque in the transform map to avoid duplicates
E.Always use a staging table for all data sources
AnswersA, D

Scheduling minimizes impact on system performance.

Why this answer

Options A and C are correct. A: Coalescing on a unique field prevents duplicate records. C: Scheduling imports ensures regular updates.

B is not a best practice because staging tables are used but not always required. D is incorrect because REST API is an alternative, not a best practice for import sets. E is not relevant to import sets.

Practice this question →
39
MCQeasy

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?

A.REST API Explorer
B.Business Rule with outbound REST call
C.Access Control List (ACL)
D.Scheduled Job
AnswerB

Business Rules can trigger on record updates and make outbound REST calls using the RESTMessageV2 API.

Why this answer

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.

Exam trap

The trap here is that candidates may confuse REST API Explorer (a manual testing tool) with the ability to automate outbound calls, or think that a Scheduled Job is appropriate for event-driven integrations, missing the need for real-time, state-change-triggered execution.

How to eliminate wrong answers

Option A is wrong because REST API Explorer is a diagnostic and testing tool for manually constructing and testing REST API calls, not a mechanism to automatically trigger outbound integrations based on record state changes. Option C is wrong because Access Control Lists (ACLs) govern data security and permissions within ServiceNow, not outbound data transmission to external systems. Option D is wrong because Scheduled Jobs run on a time-based interval (e.g., every hour) and cannot react instantly to a record state change like approval; they would introduce latency and require polling logic.

Practice this question →
40
MCQeasy

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

A.Only maps if both source and target are empty
B.Always maps regardless
C.Only maps if target field is empty
D.Only maps if source field is empty
AnswerC

That is the 'if target field is empty' condition.

Why this answer

Option B is correct: it maps only when the target field is empty. Option A is wrong because it checks target, not source. Option C is wrong because it is conditional.

Option D is wrong because it checks only target.

Practice this question →
41
MCQhard

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?

A.WSDL caching prevents updated endpoint
B.SOAP version mismatch between request and response
C.HTTP timeout during response retrieval
D.Missing or incorrect namespace prefix handling in the script
AnswerD

Namespaces must be resolved correctly to access elements.

Why this answer

Option B is correct: namespace prefix handling is critical in SOAP XML parsing. Option A is wrong because SOAP version is not the issue. Option C is wrong because WSDL caching might affect updating but not parsing.

Option D is wrong because timeout would cause a different error.

Practice this question →
42
MCQhard

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

A.Use target.short_description = source.u_summary instead
B.Add a null check before setting: if(source.u_summary) target.setValue('short_description', source.u_summary);
C.Add a 'return true;' statement at the end
D.Map to a system field like 'sys_created_by'
AnswerB

Null check prevents the script from erroring when the source field is empty.

Why this answer

Option D is correct: check for null before setting. Option A is wrong because the script does not need a return. Option B is wrong because setValue is correct method.

Option C is wrong because system fields are not the issue.

Practice this question →
43
MCQmedium

A company is integrating with an external HR system using a REST API to create and update user records in the sys_user table. The API endpoint requires a token that expires every 24 hours. The integration is scheduled to run hourly. The token is stored in a credential record. After a few days, the integration fails with a 401 Unauthorized error. The error log shows "Invalid token". What is the most likely cause?

A.The token was refreshed but the credential record was not updated.
B.The REST API endpoint URL changed.
C.The credential record was deleted.
D.The IP address of the external system changed.
AnswerA

The token expires; the integration uses the stored token. If the token is refreshed externally but not stored, the old token remains and becomes invalid after 24 hours.

Why this answer

Option B is correct because the token expires every 24 hours, so after the first day, the token used by the integration is stale. The credential record must be updated with a fresh token, but if the integration does not handle token refresh, it will fail.

Practice this question →
44
Multi-Selecthard

Which TWO are common issues when troubleshooting a failed LDAP import?

Select 2 answers
A.LDAP filter syntax is invalid
B.OAuth token for LDAP is expired
C.LDAP attribute mapping does not match target fields
D.Base DN is incorrectly specified
E.LDAP server is unreachable
AnswersA, D

Invalid filters cause the import to retrieve no data or error.

Why this answer

Options B and D are correct. B: Incorrect base DN is a frequent misconfiguration. D: Invalid LDAP filter syntax can cause no results.

A is also common but connectivity is more foundational; C is important but not as common as filter issues; E is irrelevant to LDAP.

Practice this question →
45
MCQhard

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?

A.The MID server credentials do not have permission to query relationship data
B.The CI Class Manager does not have the correct relationship types defined for the discovered CIs
C.The discovery probes are not configured to capture relationships
D.The CMDB is set to read-only mode
AnswerB

The CI Class Manager defines which relationships are possible between CI classes. If a relationship type is missing, it won't be created.

Why this answer

Option B is correct because 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.

Exam trap

The trap here is that candidates assume missing relationships must be caused by a probe or permission issue, overlooking that the CI Class Manager's relationship definitions are a prerequisite for relationship creation, even when discovery runs without errors.

How to eliminate wrong answers

Option A is wrong because MID server credentials are used for authentication to target systems; if they lacked permission to query relationship data, the discovery logs would typically show authentication or permission errors, not a clean run with no errors. Option C is wrong because discovery probes are configured to capture CIs and their attributes, but relationships are not captured by probes directly; they are inferred by the Discovery engine based on relationship types defined in the CI Class Manager. Option D is wrong because a read-only CMDB would prevent any updates to the CMDB, including CI creation and relationship creation, and would generate errors or warnings in the logs, not a clean run with missing relationships.

Practice this question →
46
Multi-Selectmedium

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

Select 2 answers
A.Restart the web server.
B.Reinstall the ServiceNow instance.
C.Review the script include for errors.
D.Check the authentication profile.
E.Verify the endpoint URL.
AnswersD, E

Invalid credentials or configuration can prevent sending.

Why this answer

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.

Practice this question →
47
MCQeasy

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

A.Deploy an update set for each import
B.Use a Flow Designer flow with an HTTP trigger
C.Configure a scheduled job to use the Import Set API or transform
D.Create a business rule that triggers on a condition
AnswerC

Scheduled jobs are designed for recurring tasks like data imports.

Why this answer

Option B is correct: scheduled jobs with import set API provide reliable automation. Option A is wrong because business rules are not for scheduling. Option C is wrong because flow designer is for real-time integrations, not scheduled imports.

Option D is wrong because update sets are for version control, not scheduling.

Practice this question →
48
Multi-Selectmedium

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?

Select 2 answers
A.Web Services Import set to import inventory items.
B.Export to XML to export order status.
C.Flow Designer to both import and export.
D.Import Set Row to import inventory items.
E.Transform Map to export order status.
AnswersB, D

Export to XML can be used to export data from ServiceNow.

Why this answer

Option B is correct because 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 Import Set Row is a specific import set table that stores each row of imported data before it is transformed into the target table, such as 'inventory_item', providing a structured way to import inventory items.

Exam trap

The trap here is that candidates confuse 'Import Set Row' with 'Web Services Import set' (a non-existent term) or assume Flow Designer can directly handle bulk data import/export, when in reality it is a workflow tool that triggers other processes, not a data transfer method itself.

Practice this question →
49
MCQhard

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

A.Load all rows first, then run the transform as a batch process
B.Run the transform after each row is inserted into the staging table
C.Use a database view to transform data on the fly
D.Write directly to the target table using insert statements
AnswerA

Batch transform is the recommended pattern for large volumes.

Why this answer

Option C is correct: running transform after all rows are loaded in batch is efficient. Option A is wrong because transforming each row individually is slower. Option B is wrong because database views are not for import transformation.

Option D is wrong because directly using import set row table bypasses transform logic.

Practice this question →
50
Multi-Selecteasy

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

Select 3 answers
A.SOAP Web Service
B.LDAP
C.Email
D.REST API
E.Print
AnswersA, B, D

SOAP is another web service integration.

Why this answer

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

Practice this question →

Ready to test yourself?

Try a timed practice session using only Sn Integration Data questions.

Start 20-question session