PDF CSA Study Guide

Importingspreadsheet datainto a ServiceNow table follows a structured process that ensures data is accurately mapped and transformed before being added to the target table. The correct process consists of three main steps:

Navigate toSystem Import Sets > Load Data.

Upload thespreadsheet (CSV, Excel, etc.)or connect to anexternal data source.

The system creates anImport Set Tableto temporarily store the imported data.

ATransform Mapis created to definehow fields from the Import Setmap to fields in thetarget table(e.g.,incident,cmdb_ci).

Field mappingscan be manually configured orauto-mappedif field names match.

Coalesce fieldsare defined toprevent duplicate recordsby identifying unique keys.

TheTransform Mapis executed, transferring data from the Import Set to thefinal target table.

Anytransformation scripts(such as data conversions) are applied during this process.

The imported data is now available in the production table.

1. Load Data (Import Set Creation)2. Create Transform Map (Mapping Fields to Target Table)3. Run Transform (Apply Data to the Target Table)

B. Select Import Set, Select Transform Map, Run Transform

You must first load data before selecting an Import Set.Import Sets are createdafter data is loadedinto the system.

C. Select Data Source, Schedule Transform

WhileData Sourcesdefine where data comes from, theydo not load data directly.Scheduling transformationsis optional, but it ' s not the primary step-by-step method for importing data.

D. Define Data Source, Select Transform Map, Run Transform

Defining a Data Source is part of setting up external integrations, but it isnot required for a basic spreadsheet import.

Why Other Answers Are Incorrect:

ServiceNow Data Import and Transform Maps

ServiceNow CSA Training Module: " Importing Data and Managing Import Sets "

References from Certified System Administrator (CSA) Official Documentation:

In ServiceNow Knowledge Management, the ability to create, edit, or import articles into a specific Knowledge Base is governed by User Criteria , specifically the Can Contribute criteria.

1. User Criteria vs. Roles:

While ServiceNow heavily utilizes Roles (like itil or admin) for general platform security, Knowledge Bases use a more granular, criteria-based approach. On a Knowledge Base definition record, administrators define who can interact with it using two primary related lists:

Can Read: Who is allowed to see the articles.

Can Contribute: Who is allowed to author, edit, and import articles.

2. The Import Process:

ServiceNow allows users to import Word documents directly into a Knowledge Base to automatically generate HTML articles. To utilize this feature for a given KB, the user must meet the conditions defined in that KB ' s " Can Contribute " User Criteria (which could be based on their department, group, role, or individual user record).

3. Why the other options are incorrect:

A & B: sn_knowledge_contribute and sn_knowledge_import are not standard out-of-the-box base platform roles dedicated specifically to the single action of importing.

C: There is no distinct " Can import " User Criteria related list. The right to import is bundled into the general right to author/contribute.

In ServiceNow, when a user wants topersonalize the layout of the columnsin arelated list, they need to click theGear icon (⚙️).

Navigate to a record that contains arelated list.

Look at the top-right corner of the related list for theGear icon.

Click theGear iconto open the " Personalize List Columns " interface.

From there, the user canadd, remove, or rearrange columnsin the related list.

A. Magnifier– A magnifying glass is typically used forsearch functionsbut not for column customization.

B. Context Menu– The context menu (right-click) providesother actionsbut does not allow column layout changes.

C. Pencil– A pencil icon typically representseditingbut not column layout customization.

ServiceNow Personalizing List Views

ServiceNow CSA Training Module: " Personalizing Lists and Forms "

How It Works:Why Other Answers Are Incorrect:References from Certified System Administrator (CSA) Official Documentation: