ServiceNow CSA - ServiceNow Certified System Administrator

ANatural Language Query (NLQ)allows users to filter list data using plain English instead of using the traditional condition builder. NLQ interprets human-readable search terms and translates them into system queries, making it easier for non-technical users to retrieve information without having to understand the underlying database structure.

User-friendly: Users can type a question in normal language (e.g., " Show me all open incidents assigned to me " ).

Automatic Query Conversion: The system translates the NLQ into a structured query that ServiceNow understands.

Faster Search & Filtering: It helps in quickly filtering and finding records without manually setting conditions.

Works on Lists: NLQ is used primarily in list views where users need to filter or search records.

Key Features of NLQ in ServiceNow:Example Usage:If a user enters " Show me all open incidents for John Doe " , the NLQ engine will convert it into a structured query like:

[State = Open] AND [Assigned To = John Doe]

ServiceNow Product Documentation→ " Natural Language Query Overview "

ServiceNow List Filters and Condition Builder→ " Using Natural Language Queries for Filtering "

References from Certified System Administrator (CSA) Documentation:

In ServiceNow, theDependency Viewprovides aninteractive graphical interfaceto visualizeConfiguration Items (CIs) and their relationships. It helps IT teams understand the dependencies between infrastructure components, applications, and services.

Graphical Representation of CI Relationships:

Displays Configuration Items (CIs) and their dependencies usinga dynamic, interactive visualization.

Useslines/arrowsto represent relationships such asdepends on, runs on, hosted by, etc.

Real-Time Impact Analysis:

Helps identifyhow an outage or change to one CI affects related components.

Useful forchange management, incident resolution, and troubleshooting.

Integration with CMDB (Configuration Management Database):

Dependency Views pull data from theCMDBand display it visually.

SupportsITSM (IT Service Management), ITOM (IT Operations Management), and IT Asset Management.

Supports Multiple Relationship Types:

Application-to-Application relationships

Infrastructure dependencies (e.g., servers, databases, cloud resources)

Business Services mapping to technical services

A. CSDM SchemaIncorrect – TheCommon Service Data Model (CSDM)is a framework for organizingCMDB data models, but it does not provide agraphical interfacefor visualizing dependencies.

B. Business Service MapIncorrect – Business Service Maps arepart of Service Mapping(ITOM feature), showinghigh-level business service dependencies, butDependency Viewprovides a more detailed, real-time interactive visualization ofCIs in CMDB.

D. CI Class MapIncorrect – The CI Class Map showsCMDB class structures, not live dependency relationships between CIs.

ServiceNow Docs – Dependency Views📖 Dependency Views Overview

ServiceNow Community – CMDB Best Practices📖 CMDB and Dependency Views

Key Features of Dependency View:Incorrect Answer Choices Analysis:Official ServiceNow Documentation References:Conclusion:The correct answer isC. Dependency Viewbecause it provides amodern interactive graphical interfaceto visualizeCIs and their relationshipsinCMDB.

InServiceNow Reporting, when modifying a report, users can preview the resultswithout savingby clicking the " Run " button. This executes the report with the current settings and displays the updated resultsbefore committing any changes.

C. Run

The " Run " button allows users toexecute the report immediatelyto see updated results.

It helps users verify if filters, conditions, or visualizations are correctbefore saving the report.

Example: If a user changes thedate rangeon anincident report, clicking " Run " updates the chartwithout saving the report permanently.

A. Execute

There isno " Execute " buttonin ServiceNow Reporting.

" Execute " is used in scripting (e.g., Business Rules, Scheduled Jobs), not for reports.

B. Try it

Not a valid option in ServiceNow Reporting.

Possibly confused with " Try It " in Flow Designeror Catalog Items.

D. Test

" Test " is used inWorkflows, Business Rules, and Flow Designer, not in reports.

E. Preview

There isno " Preview " buttonfor running reports.

" Preview " is typically used inUI Policies and Forms.

In ServiceNow, when building filter conditions using theCondition Builder, there are three key components:

Field (Filter Criteria):The specific database field you are filtering on.

Operator:A choice list that defines the condition (e.g., " is " , " contains " , " starts with " ).

Value:The value you are checking against.

Among these components,the Operator is always a choice list, as it provides predefined options for filtering. The Operator determines how the Field and Value should be compared. For example:

" State is Active " (where " is " is the Operator)

" Priority is greater than 2 " (where " is greater than " is the Operator)

Other components, such as Filter Criteria (fields) and Match Criteria, do not always function as choice lists.

InServiceNow Knowledge Management, articles are typicallyrestrictedto specific users or roles. However,if you want an article to be accessible without requiring login, you must enable thePublic setting.

Navigate toKnowledge Base Settings.

Enable thePubliccheckbox.

Save the changes.

The article is nowviewable by anyone, even without logging into ServiceNow.

A. The View All setting

No such setting exists for public access in ServiceNow.

B. The Allow role

" Allow roles " restricts accessto specific roles, but does not make the article public.

C. The ESS role

TheESS (Employee Self-Service) roleallows accessto logged-in users, not public users.

InServiceNow, afilter conditionis used toquery data from tables. It consists of three main components:

1. Column (Field)Represents the database column (or field) that is being filtered.

Example:Priority,State,Assigned To

In ServiceNow UI, this appears as thefirst dropdownin a filter condition.

2. OperatorDefines the comparison condition for the filter.

Examples:is,is not,greater than,contains,starts with

In ServiceNow UI, this appears as themiddle dropdownin a filter condition.

3. ValueSpecifies the criteria being matched against the column.

Example:High,Closed,John Doe

In ServiceNow UI, this is thethird input fieldin a filter condition.

Example of a Filter Condition in ServiceNow UI:Column (Field)

Operator

Value

Priority

is

High

State

is not

Resolved

This filter will returnrecords where:

ThePriorityfield is set toHigh

TheStatefield is NOTResolved

B. Match CriteriaIncorrect–No such term exists in ServiceNow filters.

C. FieldIncorrect– " Field " is another word for " Column " , but " Column " is the correct term in ServiceNow filter conditions.

Incorrect Answer Choices Analysis:

ServiceNow Docs – Filtering Data📖 How to Create Filters in ServiceNow

ServiceNow Docs – Query Builder and Operators📖 Building Filter Queries

Official ServiceNow Documentation References:

Assigning work tasks to aGroupinstead of anindividualoffers flexibility, better workload management, and ensures tasks are handled efficiently.

Group members can choose their tasks from " My Groups Work "

The " My Groups Work " module in ServiceNow allows group members to see all unassigned tasks for their group and take ownership of available tasks.

This is particularly useful when multiple team members share responsibility for completing tasks.

Groups can assign tasks to users based on on-call schedules

ServiceNow’sOn-Call Schedulingfeature allows automatic assignment of tasks to available members based on a predefined schedule.

This ensures that work is distributed fairly among team members who are on shift.

Site support members can pick tasks, based on Location

Tasks can be assigned dynamically based on thelocation of the request.

This is particularly useful for IT support teams, field service teams, and facilities management teams, where physical presence is required to complete a task.

Groups can assign tasks to users based on skills

UsingSkill-Based Routing, ServiceNow can match tasks to users who have the right skills for the job.

For example, if a request requires expertise in " Windows Server Management, " the system will assign it to a group member with that skill.

E. Group members can avoid tasks that are nearing SLA breach

This is incorrect because ServiceNowprioritizes SLA breachesand usually escalates such tasks rather than allowing users to avoid them.

F. Groups can assign tasks to users based on availability

WhileOn-Call Schedulingcan assign tasks based on availability, ServiceNow doesnotautomatically assign tasks dynamically based on real-time availability. Availability tracking isnota standard assignment mechanism in ServiceNow unless customized.

ServiceNow Product Documentation→ " Assigning Tasks to Groups "

ServiceNow Product Documentation→ " On-Call Scheduling "

ServiceNow Product Documentation→ " Skill-Based Routing "

Benefits of Assigning Tasks to a Group:Incorrect Answers Explanation:References from Certified System Administrator (CSA) Documentation:

Access to Knowledge Bases (KB) is controlled via User Criteria. On the Knowledge Base definition record, these criteria are attached via Related Lists (often appearing as tabs at the bottom of the form).

Can Read: This Related List defines which users, groups, roles, or companies are allowed to view articles within this specific Knowledge Base.

Can Contribute: This Related List defines who can create or modify articles.

" Available to " is terminology used in the Service Catalog, not Knowledge Management. " Can Access " and " Accessible to " are not standard Related List names for KB security.

Understanding Table Structure in ServiceNow:

Atablein ServiceNow is a structured collection of data, similar to a database table.

Eachrecord (row)in a table consists of multiplefields (columns), where each field holds a specific piece of information.

Why " Field " is the Correct Answer:

Afieldis a single unit of data storage in a table.

Each field corresponds to a specific data attribute (e.g.,Name, Email, Phone Number).

Arecord(also called a row) consists of multiple fields.

Why Other Answers Are Incorrect:

A. Factor→ Not a recognized ServiceNow term related to tables or data storage.

C. Datapoint→ While a field may contain a data point, ServiceNow does not use this term in table structure definitions.

D. Element→ In ServiceNow, " element " is sometimes used in scripting but does not specifically refer to a field in a table.

E. Item→ " Item " is used in catalog and asset management but does not refer to a component of a table.

Best Practice Solution:

UseTable Dictionaryto explore fields in a table.

Navigate toSystem Definition → Tables & Columnsto review the structure of any table.

When importing spreadsheet data into ServiceNow using theImport Setprocess, data is transferred in multiple stages. The step where data getswritten to the receiving tableis called " Run Transform. "

Load Data:The spreadsheet or data file is uploaded to a temporary table (Import Set table).

Run Transform:The system processes the import set data andwrites it to the target table.

Verify Data:After transformation, the data is checked for accuracy.

Load Data:

The spreadsheet or external data is first imported into astaging table (Import Set table)in ServiceNow.

At this stage, the data is not yet written to the actual destination table.

Run Transform (Correct Answer):

TheTransform Mapapplies field mappings and business logic.

The data is processed and written from the import set table to the target table (e.g., Incident, CMDB, or any other receiving table).

Any data transformation (such as field mappings, lookups, or script-based modifications) happens here.

Verify Data:

After transformation, users shouldvalidate the imported recordsto ensure that data was written correctly.

B. Run Import:

This steponly loads the data into a temporary Import Set table.

It does not write data to the receiving table.

C. Import Dataset:

" Import Dataset " isnot an actual stepin the ServiceNow data import process.

D. Execute Transform:

There is no " Execute Transform " step in ServiceNow.

The correct term is " Run Transform. "

E. Schedule Transform:

While youcanschedule transforms, this is not the step where data gets written to the final table.

The actual transformation and writing occur during " Run Transform. "

Import Set Process in ServiceNow:Explanation of Each Step:Why Other Options Are Incorrect?Official ServiceNow Documentation Reference:For more details, refer to the official ServiceNow documentation:

Importing Data into ServiceNow

Transform Maps in Import Sets

In theServiceNow Service Catalog module, tables have aOne-to-Many (1:M) relationship, meaning a single record in one table can relate to multiple records in another table. This is especially important for handling Service Catalog requests, as multiple items, approvals, and tasks may be associated with a single request.

One Request can have many Requested Items (REQ → RITM)

ARequest (REQ)is a container for multipleRequested Items (RITM).

When a user submits a catalog request, multiple items (such as a laptop and a phone) can be ordered in the same request.

Table Relationship:sc_request(Request) →sc_req_item(Requested Item)

One Requested Item can have many Approvals (RITM → Approval)

SomeRequested Items (RITM)require approval before being fulfilled.

For example, a laptop purchase might need approvals from both the IT department and a manager.

Table Relationship:sc_req_item(Requested Item) →sysapproval_approver(Approval)

One Requested Item can have many Catalog Tasks (RITM → SCTASK)

ARequested Item (RITM)can generate multipleCatalog Tasks (SCTASK)for different fulfillment teams.

For example, if an employee requests a new laptop, one task might go to IT to set it up, while another goes to finance for cost approval.

Table Relationship:sc_req_item(Requested Item) →sc_task(Catalog Task)

Breakdown of Correct Answers:Incorrect Answers Explanation:A.One Approval can have many Requests

Approvals do not relate to multiple requests. Instead, a request may contain multiple approvals.

E.One Cart can have many Requests

TheCartis only a temporary storage of items before checkout. Once submitted, it generates asingle Request (REQ), not multiple requests.

ServiceNow Product Documentation→ " Understanding Service Catalog Tables and Relationships "

ServiceNow Data Model→ " Request, Requested Item, and Catalog Task Relationships "

References from Certified System Administrator (CSA) Documentation:

Access Control Rules (ACLs)inServiceNowdeterminewho can access a record, table, or field. They are evaluated in aspecific orderto ensure security.

Table-Level ACLs are evaluated first

ServiceNowfirst checks if the user has permission to access the table itself.

If the user doesnothave access at thetable level, no further checks are performed.

Field-Level ACLs are evaluated next

Once table access is granted, ServiceNow checksif the user has permission to access individual fields.

More specific ACLs override broader ones(e.g.,incident.short_descriptiontakes priority overincident.*).

Order of Specificity (Most Specific to Least Specific)

Field-Specific ACL(incident.short_description.read)

Wildcard Field ACL(incident.*.read)

Table-Level ACL(incident.read)

Wildcard Table ACL(*.read)

ACL Evaluation Order in ServiceNow:This ensures thatspecific rules take precedence over general rulesfor enhanced security.

Example of ACL Evaluation in Incident Table:ACL Rule Type

Example ACL

Evaluation Order

Field-Specific

incident.short_description.read

First (Most Specific)

Wildcard Field

incident.*.read

Second

Table-Level

incident.read

Third

Wildcard Table

*.read

Last (Most General)

A. Field-level - most general to most specific; then Row-level - most specific to most generalIncorrect– Field-level ACLs arenot evaluated first; table-level ACLs are checked before field-level.

B. Table-level - most specific to most general; then Row-level - most specific to most generalIncorrect– " Row-level " is not a correct termin ServiceNow ACL processing.

D. Field-level - most specific to most general; then Table-level - most specific to most generalIncorrect–Table-level ACLs are always evaluated before field-level ACLs.

Incorrect Answer Choices Analysis:

ServiceNow Docs – Access Control Evaluation Order📖 How ACLs Are Processed

ServiceNow Docs – Managing ACLs in ServiceNow📖 Best Practices for ACLs

Official ServiceNow Documentation References:

Conclusion:The correct answer is:

C. Table-level - most specific to most general; then Field-level - most specific to most general

Thisensures that general table permissions are granted before checking field-level access,following a structured and secure approachto access control in ServiceNow.