Brainscape's Knowledge GenomeTM


Top Flashcards (Certified)
All Flashcards

CSA 2023 (Tokyo/Utah) > Manage Data > Flashcards

Manage Data Flashcards

(114 cards)

Start Studying
1
Q

On what database is ServiceNow built?

A

Relational database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What includes the ServiceNow Infrastructure?

A
  1. Tables
  2. Records
  3. Fields
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What provides a friendly interface for managing tables, records and forms?

A

Lists and Forms

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What is a Schema Map?

A

It provides a graphical representation of the relationships between tables

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What provides a list of all tables in the database?

A

Tables module

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What is a table?

A

A collection of records in the database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

To what corresponds a field in a table?

A

A column

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

A row corresponds to what in a table?

A

A record

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Records are identified by:

A

32-characted, globally unique ID called sys_id

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Each field has three key attributes:

A
  1. Label (user-friendly)
  2. Name (system-friendly)
  3. Value (actual data)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Reference fields can be indentyfied with:

A

The reference lookup icon and open a dialog box

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

In what ways can tables be related to each other?

A
  1. One-to-Many
  2. Many-to-Many
  3. Database Views
  4. Extenstions
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

One-to-Many relationship fields are for example:

A
  1. Reference Fields
  2. Glide List
  3. Document ID fields
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Many-to-Many is where:

A

Two or more tables are related in a bi-directional relationship

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Database Views defines:

A

Table joins for reporting purposes. For example the Incident table to the Metric Definition and Metric Instance tables

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Extensions means:

A

that the extended tables include unique fields PLUS all fields and properties inherited from the parent table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

Tables can extent other tables creating:

A

Parent and child tables (class)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

What is a common example of a parent and child table?

A

Task (parent) and incident (child)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

Dictionary overrides feature allows:

A

the ability to define a field on an extended table (child) differently from the field on the parent table. For example default data, field dependencies, read-only status of a field.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

How do you call a parent class (table) that is not an extension of another table?

A

A base table (base class)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

What is an example of a base class (table)?

A

The Task table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

What is a Core Table (class)?

A

A core table exists in the ServiceNow base system. It comes WITH the system, but can be an extension of another table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

What makes a base table different from a core table?

A

The base table is NOT an extension of another table, it has NO parent.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

How can you classify the Task table as?

A
  1. Base table
  2. Core table
  3. Parent Table
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Tables that exists in the base system are called?
Core tables
26
Tables created by admins or developers are called:
Custom tables
27
Can custom tables interact with core tables?
Yes
28
How is a custom table pre-fixed if built in scoped application?
"x_" with a namespace identifier
29
How are custom tables prefixed in the global application?
"u_"
30
What does a Schema Map?
It provides a graphical representation of another tables related to a specific table
31
The Schema Map is available to users with:
personalize_dictionary or admin roles
32
In a Schema Map, relationships can be filtered by:
1. Extensions 2. Reference classes
33
Tables with blue bars are tables that:
extend the table in a Schema Map
34
Tables with a red bar are tables that:
are referenced by the table in a Schema Map
35
With the Schema Map, you can:
Identify which columns (fields) originate from the viewed table and which are inherited from their parent table
36
In a Schema Map, the Tables window provides:
A summary of all tables presented, and their relationships
37
There are several levels of security before an user can perform CRUD (Create, Read, Update, Delete) operations on a table:
1. User Authentication/Login: Users, groups and roles 2. Application and Modules access 3. Database access
38
Three security modules used typically by an Admin:
1. All > System Properties > Security 2. All > System Security > ACL (Access Control List) 3. All > System Security > High Security Settings
39
What is an access control?
An access control is a security rule defined to restrict permissions of a user from viewing and interacting with data
40
It is executed when attempting to access any table and may be set at:
1. row-level (access to record) 2. column level (access to field)
41
Access controls restrict:
ServiceNow specific and CRUD operations
42
What means CRUD?
C - create R - read U - update (or write) D - delete
43
Access Control List (ACL) contains:
an instance's Access Control rules. To modify or create new admins must elevate their role to become security_admins
44
Each Access Control rule specifies:
1. Valid operation (CRUD) 2. Object being secured (eg. table, table AND field) 3. Permissions required to access object (Roles, Conditional Expressions, Scripts)
45
To view Access Controls associated with a table:
1. Using Filter Navigator type: .CONFIG 2. Select Access Controls tab
46
When a custom table is created, the system:
Creates four access control rules by default (create, read, update/write, delete) and a role
47
What are the three Access Control rule types?
1. table.--None-- 2. table.field 3. table.*
48
What does the ACL rule "table.--None--" mean?
This rule applies to the whole table incl. all fields, as no specific fields were selected
49
What does the ACL rule "table.field" mean?
This rule applies to only one field on a record
50
What does the ACL rule "table.*" mean?
Wildcard - this rule applies to every field in a record without a table.field rule
51
When creating a Wildcard * access control, also create:
A None Access control, because only None grants access to records
52
When writing an ACL that mostly grants access, use:
only None rule
53
When writing an ACL that mostly denies access, use:
None and * Wildcard
54
What does the Wildcard * access control rule?
It denies access to all fields except the one that allows
55
Record ACL rules are processed in the following order:
1. Match the object against TABLE acl rules (most specific to general), 2. Match the object against FIELD acl rules (most specific to general)
56
What must a user pass to access a record object?
Both TABLE and FIELD access control rules
57
What is an Import Set?
An Import Set is a tool used to import data from various data sources and map that data into ServiceNow lables
58
What roles can import data sets?
admin or import_admin
59
What are data sources?
Data sources are records in ServiceNow that contain information regarding an Import Set data source
60
What sources can you import data from?
1. Local (xml, csv, excel) 2. Network server by providing path and authentication information 3. LDPA connection (Lightweight Directory Access Protocol) 4. Java Database Connectivity (JDBC) connection
61
What is the Import Set table?
The Import Set table is a staging area for records imported from a data source
62
What does a Transform Map?
A Transform Map provide a guide from moving data from Import Set tables to "target" tables in the system
63
What is a Transform Map?
A Transform Map is a set of field mas that determine the relationships between fields in an Import Set and fields in an existing ServiceNow table
64
What is a Target table?
It is an existing table where data will be placed post-transformation
65
When importing data, it is important to:
Not import data in extremely large chunks
66
Is it possible to schedule Imports?
Yes
67
Automatic Mapping Utility (Auto Map Matching Fields) is:
The simplest method of mapping, works when field names of Import Set match the name of fields on the Target Table
68
What does Mapping Assist Utility?
Provides a visually intuitive environment for specifying mapping between Import Set fields and Target table records.
69
What does it mean to coalesce a field (or multiple fields)?
It means that the field(s) will be used as a unique key during imports. Once a match is found using coalesce field, the existing record will be updated and not inserted as new into the database
70
What are the most common coalesce practices?
1. Single-field coalesce 2. Multi-field coalesce 3. Script coalesce
71
Where can you coalesce fields(s)?
Im the Transform Map module > Field Maps tab > Coalesce column (true/false)
72
Can you clean up your Import Sets? Where?
Yes, head to All > System Import Sets > Import Set Tabes > Cleanup
73
What is a CMDB?
CMDB is a Configuration Management Database
74
What is a Configuration Management Database?
A CMDB is a series of tables and fields that contain all of the Configuration Items (CIs) controlled by your company, as well as their attributes and relationships.
75
Access to the CMDB tables and underlying data requires certain permissions, such as following roles:
- asset - itil - itil_admin - cmdb_read
76
What are Configuration Items?
Configuration Items (CIs) can be tangible or intangible devices or applications in the CMDB such as firewalls, computers, email services and services.
77
What are CMDB key tables?
1. cmdb [Base configuration] 2. cmdb_ci [Configuration Item] 3. cmdb_rel_ci [CI Relationship]
78
What provides core functionalist for the CMDB incl. modules for hardware and other configuration items?
The Configuration Application
79
What does CMDB provide?
A logical model of your company infrastructure by identifying, controlling, maintaining and verifying configuration items that exist.
80
What is a configuration item?
A configuration item is any component that needs to be managed in order to deliver services. CIs typically include services and their underlying components (business applications and hardware)
81
The CMDB:
Tracks CI within your platform and the relationships between those items.
82
What is a Configuration Management Database?
Configuration Management Database is a repository of information related to all of the components of an information system.
83
What is the origin of Configuration Management Database?
ITIL (Information Technology Infrastructure Library
84
What is the use of CMDB in ITSM?
1. Incident Management 2. Problem Management 3. Change Management 4. Request Management
85
CMDB Workspace is:
A central place for working with the CMDB
86
What entails a Configuration Item form?
1. CI attributes 2. Related Items tool bar 3. Relationships to other CIs 4. A toggle between Health Dashboard view and Form view
87
What may be some attributes of a Configuration Item?
- name - version - descriptions - ownership etc.
88
For Configuration Items, you can:
easily create a new relationship rule via All > Configuration > Relationships> Suggested Relationships
89
What is a CI Class Manager used for?
CI Class Manager is a central location to explore CMDB class hierarchy in tree-view format, CI table definitions and class CIs (All > Configuration > Cl Class Manager)
90
To read Basic Info in a CI Class Manager the following role is required:
itil
91
To wite Basic Info in a CI Class Manager the following role is required:
itil_admin and personalize_dictionary
92
To edit Attributes in a CI Class Manager the following role is required:
personalize_dictionary and itil_admin
93
To write Attributes in a CI Class Manager the following role is required:
personalize_dictionary and itil
94
The CI Class Manager Attributes Tabs consists of:
1. All > includes all attributes, derived or added 2. Derived 3. Added
95
To create configuration item relationships use:
CI Class Manager Suggested Relationships (via CI Relationship Editor)
96
Where can you find the Dependency View?
In Related Item section, selecting the Dependency View icon when viewing a Configuration Item
97
What is a Common Service Data Model (CSDM)?
Is a set of terms and definitions that can be used with all ServiceNow products. It can be used as a blueprint to map IT services.
98
What is CS - Common Service?
It is a standard and shared set of service-related definitions across SN products and platform that will enable and support true service level reporting
99
What is a DM - Data Model?
A Data Model is a CMDB Framework that will enable and support multiple configuration strategies
100
What is a Common Service Data Model (CSDM)?
- standard terms and definitions - best practices for CMDB data modeling and data management - out of box CMDB core tables - guidance on service modeling - recommended mappings
101
What is NOT a Common Service Data Model (CSDM)?
- not a process implementation guide - not a set of reports - not code to install - not a product to buy - not an automatic fix for past implementations
102
ServiceNow Discovery (a horizontal discovery):
scans the network to inventory devices and applications and updates the CMDB with results for each unique type of hardware or software
103
Service Mapping (top-down discovery):
augments (extends) the CMDB with IT relationships and dependencies between CIs to model the IT components that comprise a Service
104
Dependency View (for a Configuration Item) provides:
An interactive graphical interface to visualize relationships between configuration items.
105
What is the starting point of a Dependency View called?
Root CI or root node of the map (it pulses and has a darker frame)
106
How many levels displays a Dependency Views map?
3 levels (both upstream and downstream relationships) - # can be configured by admins
107
In a Dependency Views map, map indicators:
Indicate if a CI has any active, pending issues
108
Dependency View: Map icons include:
1. Active Incident 2. Active Problems 3. Affected CIs for a task
109
Which modules can you use to create a new table?
1. Tables 2. Tables & Columns
110
Which elevated role is required to modify access control rules?
security_admin
111
What is a CI?
1. Configuration Item 2. Can be tangible (hardware, software) or intangible (email, services)
112
A parent class that is not an extension of another table is called?
A base table
113
In what order are access control rules evaluated?
1. Table level (most specific to general) 2. Field-level (most specific to general)
114
What are the three key CMDB tables?
1. cmdb 2. cmdb_ci 3. cmdb_rel_ci

CSA 2023 (Tokyo/Utah) (10 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2025 Bold Learning Solutions. Terms and Conditions