SNOW-CAD Integrating and managing application data — All Questions With Answers

Question 1mediummultiple choice

Read the full Integrating and managing application data explanation →

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?

Question 2easymultiple choice

Read the full Integrating and managing application data explanation →

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?

Question 3hardmultiple choice

Read the full Integrating and managing application data explanation →

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?

Question 4easymultiple choice

Read the full Integrating and managing application data explanation →

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?

Question 5mediummulti select

Read the full Integrating and managing application data explanation →

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

Question 6hardmulti select

Read the full Integrating and managing application data explanation →

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

Question 7mediummultiple choice

Read the full Integrating and managing application data explanation →

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?

Question 8hardmultiple choice

Read the full Integrating and managing application data explanation →

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?

Question 9mediummulti select

Read the full Integrating and managing application data explanation →

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?

Question 10easymultiple choice

Read the full Integrating and managing application data explanation →

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?

Question 11mediumdrag order

Read the full Integrating and managing application data explanation →

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

1Step 1

2Step 2

3Step 3

4Step 4

5Step 5

Question 12mediummatching

Read the full Integrating and managing application data explanation →

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

Question 13mediummultiple choice

Read the full Integrating and managing application data explanation →

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?

Question 14hardmultiple choice

Read the full Integrating and managing application data explanation →

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?

Question 15easymultiple choice

Read the full Integrating and managing application data explanation →

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

Question 16mediummultiple choice

Read the full Integrating and managing application data explanation →

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?

Question 17easymultiple choice

Read the full Integrating and managing application data explanation →

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?

Question 18hardmultiple choice

Read the full Integrating and managing application data explanation →

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?

Question 19mediummultiple choice

Read the full Integrating and managing application data explanation →

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?

Question 20easymultiple choice

Read the full Integrating and managing application data explanation →

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

Question 21hardmultiple choice

Read the full Integrating and managing application data explanation →

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

Question 22easymulti select

Read the full Integrating and managing application data explanation →

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

Question 23mediummulti select

Read the full Integrating and managing application data explanation →

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

Question 24hardmulti select

Read the full Integrating and managing application data explanation →

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

Question 25easymultiple choice

Read the full Integrating and managing application data explanation →

What is the most likely cause of this error?

Exhibit

Refer to the exhibit.

Log snippet:
```
[2025-04-09 10:00:00] ERROR: REST API request failed: HTTP 401 Unauthorized
Request URL: https://external.example.com/api/v1/data
Headers: Authorization: Bearer abc123xyz
```

Question 26mediummultiple choice

Read the full Integrating and managing application data explanation →

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

Exhibit

Refer to the exhibit.

Script snippet:
```
var request = new sn_ws.RESTMessageV2();
request.setEndpoint('https://api.example.com/data');
request.setHttpMethod('POST');
request.setRequestHeader('Accept', 'application/json');
request.setRequestBody('{"key":"value"}');
var response = request.execute();
if(response.getStatusCode() != 201){
    gs.error('Error: ' + response.getBody());
}
```

Question 27hardmultiple choice

Read the full Integrating and managing application data explanation →

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

Exhibit

Refer to the exhibit.

Transform map script:
```
(function runTransform0(source, target, map, log) {
    target.setValue('short_description', source.u_summary);
    target.setValue('description', source.u_description);
    target.setValue('category', source.u_category);
})(source, target, map, log);
```

Question 28easymultiple choice

Read the full Integrating and managing application data explanation →

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?

Question 29mediummultiple choice

Read the full Integrating and managing application data explanation →

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?

Question 30hardmultiple choice

Study the full ACL explanation →

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?

Question 31easymultiple choice

Read the full Integrating and managing application data explanation →

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

Question 32mediummultiple choice

Read the full Integrating and managing application data explanation →

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?

Question 33hardmultiple choice

Read the full Integrating and managing application data explanation →

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?

Question 34easymultiple choice

Read the full Integrating and managing application data explanation →

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

Question 35mediummultiple choice

Read the full Integrating and managing application data explanation →

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?

Question 36hardmultiple choice

Read the full Integrating and managing application data explanation →

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?

Question 37mediummulti select

Read the full Integrating and managing application data explanation →

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

Question 38hardmulti select

Read the full Integrating and managing application data explanation →

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

Question 39easymulti select

Read the full Integrating and managing application data explanation →

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

Question 40mediummultiple choice

Study the full ACL explanation →

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?

Exhibit

{
  "name": "incident",
  "operation": "read",
  "script": "gs.hasRole('admin')",
  "type": "record"
}

Question 41hardmultiple choice

Read the full Integrating and managing application data explanation →

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?

Exhibit

2023-01-15 10:23:45 ERROR com.glide.mid.MIDServerException: Connection to database failed: ORA-12514: TNS listener not currently aware of service requested in connect descriptor
at com.glide.mid.oracle.OracleConnection.checkConnection(OracleConnection.java:56)

Question 42hardmultiple choice

Read the full Integrating and managing application data explanation →

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?

Question 43mediummultiple choice

Read the full Integrating and managing application data explanation →

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?

Question 44hardmulti select

Read the full Integrating and managing application data explanation →

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

Question 45easymultiple choice

Read the full Integrating and managing application data explanation →

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?

Question 46mediummultiple choice

Read the full Integrating and managing application data explanation →

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?

Question 47hardmultiple choice

Read the full Integrating and managing application data explanation →

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?

Question 48mediummulti select

Read the full Integrating and managing application data explanation →

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

Question 49hardmultiple choice

Read the full Integrating and managing application data explanation →

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?

Exhibit

Refer to the exhibit.
{
  "method": "GET",
  "endpoint": "/api/now/table/sys_user",
  "headers": {
    "Accept": "application/json"
  },
  "queryParameters": {
    "sysparm_query": "active=true^role=ITIL^sys_created_on>=javascript:gs.beginningOfLastMonth()"
  }
}

Question 50easymultiple choice

Read the full Integrating and managing application data explanation →

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?

Refer to the exhibit. Log snippet: ``` [2025-04-09 10:00:00] ERROR: REST API request failed: HTTP 401 Unauthorized Request URL: https://external.example.com/api/v1/data Headers: Authorization: Bearer abc123xyz ```

Refer to the exhibit. Script snippet: ``` var request = new sn_ws.RESTMessageV2(); request.setEndpoint('https://api.example.com/data'); request.setHttpMethod('POST'); request.setRequestHeader('Accept', 'application/json'); request.setRequestBody('{"key":"value"}'); var response = request.execute(); if(response.getStatusCode() != 201){ gs.error('Error: ' + response.getBody()); } ```

Refer to the exhibit. Transform map script: ``` (function runTransform0(source, target, map, log) { target.setValue('short_description', source.u_summary); target.setValue('description', source.u_description); target.setValue('category', source.u_category); })(source, target, map, log); ```

2023-01-15 10:23:45 ERROR com.glide.mid.MIDServerException: Connection to database failed: ORA-12514: TNS listener not currently aware of service requested in connect descriptor at com.glide.mid.oracle.OracleConnection.checkConnection(OracleConnection.java:56)

Refer to the exhibit. { "method": "GET", "endpoint": "/api/now/table/sys_user", "headers": { "Accept": "application/json" }, "queryParameters": { "sysparm_query": "active=true^role=ITIL^sys_created_on>=javascript:gs.beginningOfLastMonth()" } }