SNOW-CAD Integrating and managing application data Practice Test 2 — 15 Questions

Question 1

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

Answer

PUT

Answer

PATCH

Answer

GET

Question 2

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

Answer

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

Answer

gr.addAggregate('COUNT')

Answer

gr.addAggregate('count')

Question 3

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

Answer

WSDL caching prevents updated endpoint

Answer

SOAP version mismatch between request and response

Answer

HTTP timeout during response retrieval

Question 4

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

Answer

REST data source

Answer

JDBC data source

Answer

LDAP data source

Question 5

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

Answer

Only maps if both source and target are empty

Answer

Always maps regardless

Answer

Only maps if source field is empty

Question 6

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

Accepted Answer

Load all rows first, then run the transform as a batch process. 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.

Answer

Run the transform after each row is inserted into the staging table

Answer

Use a database view to transform data on the fly

Answer

Write directly to the target table using insert statements

Question 7

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

Accepted Answer

Schedule the import to run during off-peak hours. 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.

Answer

Use REST API instead of import sets for better performance

Answer

Use update sets to manage import set configurations

Answer

Always use a staging table for all data sources

Question 8

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

Accepted Answer

Real-time vs batch processing requirement. 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.

Answer

Need for authentication and authorization

Answer

Support for OAuth 2.0

Question 9

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

Accepted Answer

LDAP filter syntax is invalid. 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.

Answer

OAuth token for LDAP is expired

Answer

LDAP attribute mapping does not match target fields

Answer

LDAP server is unreachable

Question 10

What is the most likely cause of this error?

Accepted Answer

The access token has expired or is invalid. 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.

Answer

The request timed out

Answer

The endpoint URL is incorrect

Answer

The Content-Type header is missing

Question 11

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

Accepted Answer

The Content-Type header is not set to application/json. 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.

Answer

The HTTP method should be PUT instead of POST

Answer

Missing authentication credentials

Answer

The Accept header should be text/plain

Question 12

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

Accepted Answer

Add a null check before setting: if(source.u_summary) target.setValue('short_description', source.u_summary);. 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.

Answer

Use target.short_description = source.u_summary instead

Answer

Add a 'return true;' statement at the end

Answer

Map to a system field like 'sys_created_by'

Question 13

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?

Accepted Answer

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

Answer

JSON

Answer

Text

Answer

CSV

Question 14

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?

Accepted Answer

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

Answer

External Data Source

Answer

SOAP Web Service

Answer

REST API

Question 15

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?

Accepted Answer

The SOAP message is missing a mandatory field.. 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.

Answer

The 'change_request' table is locked for data imports.

Answer

The user's role is not recognized when using SOAP web services.

Answer

The SOAP message uses a different namespace.