Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

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

Manage Data Flashcards

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
Q

Tables that exists in the base system are called?

A

Core tables

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

Tables created by admins or developers are called:

A

Custom tables

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

Can custom tables interact with core tables?

A

Yes

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

How is a custom table pre-fixed if built in scoped application?

A

“x_” with a namespace identifier

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

How are custom tables prefixed in the global application?

A

“u_”

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

What does a Schema Map?

A

It provides a graphical representation of another tables related to a specific table

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

The Schema Map is available to users with:

A

personalize_dictionary or admin roles

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

In a Schema Map, relationships can be filtered by:

A
  1. Extensions
  2. Reference classes
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
33
Q

Tables with blue bars are tables that:

A

extend the table in a Schema Map

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

Tables with a red bar are tables that:

A

are referenced by the table in a Schema Map

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

With the Schema Map, you can:

A

Identify which columns (fields) originate from the viewed table and which are inherited from their parent table

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

In a Schema Map, the Tables window provides:

A

A summary of all tables presented, and their relationships

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

There are several levels of security before an user can perform CRUD (Create, Read, Update, Delete) operations on a table:

A
  1. User Authentication/Login: Users, groups and roles
  2. Application and Modules access
  3. Database access
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
38
Q

Three security modules used typically by an Admin:

A
  1. All > System Properties > Security
  2. All > System Security > ACL (Access Control List)
  3. All > System Security > High Security Settings
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
39
Q

What is an access control?

A

An access control is a security rule defined to restrict permissions of a user from viewing and interacting with data

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

It is executed when attempting to access any table and may be set at:

A
  1. row-level (access to record)
  2. column level (access to field)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
41
Q

Access controls restrict:

A

ServiceNow specific and CRUD operations

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

What means CRUD?

A

C - create
R - read
U - update (or write)
D - delete

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

Access Control List (ACL) contains:

A

an instance’s Access Control rules. To modify or create new admins must elevate their role to become security_admins

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

Each Access Control rule specifies:

A
  1. Valid operation (CRUD)
  2. Object being secured (eg. table, table AND field)
  3. Permissions required to access object (Roles, Conditional Expressions, Scripts)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
45
Q

To view Access Controls associated with a table:

A
  1. Using Filter Navigator type: <table name>.CONFIG
  2. Select Access Controls tab
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
46
Q

When a custom table is created, the system:

A

Creates four access control rules by default (create, read, update/write, delete) and a role

47
Q

What are the three Access Control rule types?

A
  1. table.–None–
  2. table.field
  3. table.*
48
Q

What does the ACL rule “table.–None–” mean?

A

This rule applies to the whole table incl. all fields, as no specific fields were selected

49
Q

What does the ACL rule “table.field” mean?

A

This rule applies to only one field on a record

50
Q

What does the ACL rule “table.*” mean?

A

Wildcard - this rule applies to every field in a record without a table.field rule

51
Q

When creating a Wildcard * access control, also create:

A

A None Access control, because only None grants access to records

52
Q

When writing an ACL that mostly grants access, use:

A

only None rule

53
Q

When writing an ACL that mostly denies access, use:

A

None and * Wildcard

54
Q

What does the Wildcard * access control rule?

A

It denies access to all fields except the one that allows

55
Q

Record ACL rules are processed in the following order:

A
  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
Q

What must a user pass to access a record object?

A

Both TABLE and FIELD access control rules

57
Q

What is an Import Set?

A

An Import Set is a tool used to import data from various data sources and map that data into ServiceNow lables

58
Q

What roles can import data sets?

A

admin or import_admin

59
Q

What are data sources?

A

Data sources are records in ServiceNow that contain information regarding an Import Set data source

60
Q

What sources can you import data from?

A
  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
Q

What is the Import Set table?

A

The Import Set table is a staging area for records imported from a data source

62
Q

What does a Transform Map?

A

A Transform Map provide a guide from moving data from Import Set tables to “target” tables in the system

63
Q

What is a Transform Map?

A

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
Q

What is a Target table?

A

It is an existing table where data will be placed post-transformation

65
Q

When importing data, it is important to:

A

Not import data in extremely large chunks

66
Q

Is it possible to schedule Imports?

67
Q

Automatic Mapping Utility (Auto Map Matching Fields) is:

A

The simplest method of mapping, works when field names of Import Set match the name of fields on the Target Table

68
Q

What does Mapping Assist Utility?

A

Provides a visually intuitive environment for specifying mapping between Import Set fields and Target table records.

69
Q

What does it mean to coalesce a field (or multiple fields)?

A

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
Q

What are the most common coalesce practices?

A
  1. Single-field coalesce
  2. Multi-field coalesce
  3. Script coalesce
71
Q

Where can you coalesce fields(s)?

A

Im the Transform Map module > Field Maps tab > Coalesce column (true/false)

72
Q

Can you clean up your Import Sets? Where?

A

Yes, head to All > System Import Sets > Import Set Tabes > Cleanup

73
Q

What is a CMDB?

A

CMDB is a Configuration Management Database

74
Q

What is a Configuration Management Database?

A

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
Q

Access to the CMDB tables and underlying data requires certain permissions, such as following roles:

A
  • asset
  • itil
  • itil_admin
  • cmdb_read
76
Q

What are Configuration Items?

A

Configuration Items (CIs) can be tangible or intangible devices or applications in the CMDB such as firewalls, computers, email services and services.

77
Q

What are CMDB key tables?

A
  1. cmdb [Base configuration]
  2. cmdb_ci [Configuration Item]
  3. cmdb_rel_ci [CI Relationship]
78
Q

What provides core functionalist for the CMDB incl. modules for hardware and other configuration items?

A

The Configuration Application

79
Q

What does CMDB provide?

A

A logical model of your company infrastructure by identifying, controlling, maintaining and verifying configuration items that exist.

80
Q

What is a configuration item?

A

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
Q

The CMDB:

A

Tracks CI within your platform and the relationships between those items.

82
Q

What is a Configuration Management Database?

A

Configuration Management Database is a repository of information related to all of the components of an information system.

83
Q

What is the origin of Configuration Management Database?

A

ITIL (Information Technology Infrastructure Library

84
Q

What is the use of CMDB in ITSM?

A
  1. Incident Management
  2. Problem Management
  3. Change Management
  4. Request Management
85
Q

CMDB Workspace is:

A

A central place for working with the CMDB

86
Q

What entails a Configuration Item form?

A
  1. CI attributes
  2. Related Items tool bar
  3. Relationships to other CIs
  4. A toggle between Health Dashboard view and Form view
87
Q

What may be some attributes of a Configuration Item?

A
  • name
  • version
  • descriptions
  • ownership etc.
88
Q

For Configuration Items, you can:

A

easily create a new relationship rule via All > Configuration > Relationships> Suggested Relationships

89
Q

What is a CI Class Manager used for?

A

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
Q

To read Basic Info in a CI Class Manager the following role is required:

91
Q

To wite Basic Info in a CI Class Manager the following role is required:

A

itil_admin and personalize_dictionary

92
Q

To edit Attributes in a CI Class Manager the following role is required:

A

personalize_dictionary and itil_admin

93
Q

To write Attributes in a CI Class Manager the following role is required:

A

personalize_dictionary and itil

94
Q

The CI Class Manager Attributes Tabs consists of:

A
  1. All > includes all attributes, derived or added
  2. Derived
  3. Added
95
Q

To create configuration item relationships use:

A

CI Class Manager Suggested Relationships (via CI Relationship Editor)

96
Q

Where can you find the Dependency View?

A

In Related Item section, selecting the Dependency View icon when viewing a Configuration Item

97
Q

What is a Common Service Data Model (CSDM)?

A

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
Q

What is CS - Common Service?

A

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
Q

What is a DM - Data Model?

A

A Data Model is a CMDB Framework that will enable and support multiple configuration strategies

100
Q

What is a Common Service Data Model (CSDM)?

A
  • 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
Q

What is NOT a Common Service Data Model (CSDM)?

A
  • 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
Q

ServiceNow Discovery (a horizontal discovery):

A

scans the network to inventory devices and applications and updates the CMDB with results for each unique type of hardware or software

103
Q

Service Mapping (top-down discovery):

A

augments (extends) the CMDB with IT relationships and dependencies between CIs to model the IT components that comprise a Service

104
Q

Dependency View (for a Configuration Item) provides:

A

An interactive graphical interface to visualize relationships between configuration items.

105
Q

What is the starting point of a Dependency View called?

A

Root CI or root node of the map (it pulses and has a darker frame)

106
Q

How many levels displays a Dependency Views map?

A

3 levels (both upstream and downstream relationships) - # can be configured by admins

107
Q

In a Dependency Views map, map indicators:

A

Indicate if a CI has any active, pending issues

108
Q

Dependency View: Map icons include:

A
  1. Active Incident
  2. Active Problems
  3. Affected CIs for a task
109
Q

Which modules can you use to create a new table?

A
  1. Tables
  2. Tables & Columns
110
Q

Which elevated role is required to modify access control rules?

A

security_admin

111
Q

What is a CI?

A
  1. Configuration Item
  2. Can be tangible (hardware, software) or intangible (email, services)
112
Q

A parent class that is not an extension of another table is called?

A

A base table

113
Q

In what order are access control rules evaluated?

A
  1. Table level (most specific to general)
  2. Field-level (most specific to general)
114
Q

What are the three key CMDB tables?

A
  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