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?

Choose an answer to begin — your selection is scored in the full session.

Accepted Answer

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

Answer

PUT

Answer

PATCH

Answer

GET

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

Answer

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

Answer

gr.addAggregate('COUNT')

Answer

gr.addAggregate('count')

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

Answer

WSDL caching prevents updated endpoint

Answer

SOAP version mismatch between request and response

Answer

HTTP timeout during response retrieval

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

Answer

REST data source

Answer

JDBC data source

Answer

LDAP data source

Question 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. The condition 'if target field is empty' means the mapping is applied only when the target field is currently empty. Option A is wrong because it incorrectly says both source and target must be empty. Option B is wrong because it says always maps, but the condition restricts mapping. Option D is wrong because it checks source field, not target.

Answer

Only maps if both source and target are empty

Answer

Always maps regardless

Answer

Only maps if source field is empty

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. Loading all rows into the staging table first and then running the transform as a batch process is the most efficient for 50,000 records because it minimizes overhead and leverages bulk processing. Option B is incorrect because transforming each row individually introduces significant per-record overhead. Option C is incorrect because database views are not designed for import transforms and may not support required mappings. Option D is incorrect because direct insert statements bypass import set logic and transform rules.

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 D are correct. A: Scheduling imports during off-peak hours minimizes impact on system performance and user experience. D: Using coalesce in the transform map on a unique field prevents duplicate records by matching existing records based on that field. B is incorrect because REST API is an alternative integration method, not a performance improvement over import sets. C is incorrect because update sets are used to move configurations between instances, not to manage import set configurations. E is incorrect because while staging tables are commonly used, they are not always required for all data sources.

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 D are correct. Real-time vs batch processing (A) is a key difference between REST API and Import Sets. Volume of data (B) affects performance and feasibility of each method. Complexity of data transformation (D) determines which method is more suitable, as Import Sets handle transformations well while REST APIs may require custom scripting. Authentication and authorization (C) is needed for both, so it's not a deciding factor. Support for OAuth 2.0 (E) is a specific authentication method, not a general consideration.

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 A and D are correct. A: Invalid LDAP filter syntax is a common issue because it can cause no results or errors during import. D: Incorrectly specified Base DN is also a frequent misconfiguration that prevents the import from locating the correct directory entries. B: OAuth token expiry is not relevant to LDAP imports; LDAP typically uses simple bind or certificate. C: Attribute mapping mismatches can occur but are less common than filter or Base DN issues. E: LDAP server unreachable is a connectivity problem, but filter and Base DN are more specific to import failures.

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. A 401 Unauthorized error with Bearer authentication typically means the access token is invalid or expired. Therefore, option B is correct. Option A (timeout) would produce a different error (e.g., 504 Gateway Timeout). Option C (incorrect endpoint URL) would likely result in a 404 Not Found. Option D (missing Content-Type header) might cause a 400 Bad Request, not a 401.

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. The 400 Bad Request error typically indicates malformed request syntax. A common cause is missing or incorrect Content-Type header. For REST API endpoints expecting JSON payload, the Content-Type header must be set to application/json. Option C is correct because without this header, the server cannot parse the request body and returns 400. Option A is wrong because the HTTP method (POST) is often correct for creating data; PUT would be for updates. Option B is wrong because missing authentication would result in 401 Unauthorized, not 400. Option D is wrong because the Accept header controls response format; setting it to text/plain is not required for JSON requests.

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);. It adds a null check before setting the value, preventing the transform map from failing when source.u_summary is null. Option A is incorrect because it does not handle null, which would still cause an error. Option C is incorrect because 'return true;' does not address null values. Option D is incorrect because mapping to a system field like 'sys_created_by' avoids the null issue but is not the best practice; using a null check is the appropriate approach.

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.