Integrating and managing application data

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

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?

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?

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

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 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?

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 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?

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?

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 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?

What is the most likely cause of this error?

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

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 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 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?

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

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 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 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?

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

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 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?

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

Match each ServiceNow application scope to its description.

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?

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

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?

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 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 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?

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 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?

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

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

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

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?

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

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?

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

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?

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

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?

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

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 developer is investigating why an outbound REST message is not sending data correctly. Which TWO actions should the developer check first? (Choose two.)

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

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

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