Module 7: Manage Data Flashcards

1
Q

The ServiceNow Infrastructure includes what 3 things?

A
  1. Tables (contain records)
  2. Records (correspond to rows in table)
  3. Fields (individual piece of data in record and corresponds to column in table)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

The System Dictionary contains the definition for each and every table and field in a database.
Where do you navigate to, to find it?

A

All > System Definition > Dictionary

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

What references and uniquely identifies a record? (32 characters)

A

sys_id

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

Each field has 3 key attributes. What are they?

A
  1. Field label
  2. Field Name
  3. Field Data (Value)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What are the 4 ways that Tables can be related to each other?

A
  1. One-to-Many (a field can hold a reference to a record on another table)
  2. Many-to-Many (related in a bi-directional relationship)
  3. Database Views (tables can be joined using Database Views plugin)
  4. Extensions (extends another table)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

There are 3 One-to-Many relationship fields. What are they?

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

What are the 3 classes of Tables?

A
  1. Parent Class
  2. Child Class
  3. Base
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What does the Child Class inherit?

A

It inherits all fields of its parent, plus anything specific to the child class table.

The INCIDENT table extends the TASK table

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

What are the Child Class Tables extended from the Task Table?

A

Incident

Problem

Change Request

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

A Parent Class that is not an extension of another table is called a _?

A

Base Table (class)

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

What are Core Tables?

A

Tables that exist in the base system (part of the initial SN installation).
Core Tables can be BASE tables and PARENT tables.

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

What are Custom Tables?

A

Tables created by admins or developers

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

What provides a graphical representation of other tables related to a specific table?

A

Schema Map.

It tells you what is a Child table, Parent table…

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

Which users is the Schema Map available to?

A

personalise_dictionary

Admin

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

Where are the 2 places you can go to create a table?

A
  1. Tables Module
  2. Tables & Columns Module
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

A new table created in the Global scope will have what?

A

u_

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

A custom table created in custom app will have what?

A

x_

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

3 levels of security before an end user can perform CRUD on a table?

A
  1. Access to platform/ login
  2. Which applications & modules does the user have access to
  3. Database access
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

3 security modules typically used by System Administrator?

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

What is an Access Control?

A

A security rule defined to restrict the permissions of a user from viewing & interacting with data

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

What are the ACL Rules?

A

CRWD (CRUD)
C - Create
R - Read
W - Write
D - Delete

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

What does the Access Control List contain?

A

An instance’s Access Control rules

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

What role is needed to maintain the ACL’s?

A

security_admin role

24
Q

What does each Access Control rule specify?

A
  • A valid operation
  • The object being secured
  • The permissions required to access the object
25
Q

Related to the ACL rule, What are the permissions required to access the object?

A
  • Roles
  • Conditional Expressions
  • Scripts
26
Q

Access Control Rule Types…

A

table.–None– (applies to whole table)

table.field (applies to only 1 field)

table.* (applies to every field on a record without a table.field rule)

27
Q

Using ‘table.*’

A
  • Used when denying the access (mainly)
  • Don’t use when granting access
28
Q

In what order are access controls evaluated?

A

Access to the table (most specific table rules to most general)

Before evaluating access to the field (most specific to most general)

29
Q

True or False.
A user must pass both table and field ACL rules to access a record object

A

True

30
Q

What is an Import Set?

A

A tool used to import data from various data sources, and map that data into ServiceNow tables

31
Q

What roles are needed to manage all aspects of Import Sets?

A

Admin

Import_admin

32
Q

Data Sources are records in ServiceNow that contain information regarding an Import Set data source.
Where can you import data from?

A

-From a local source (XML, CSV, EXCEL)
-From a network server
-From a file
-A Lightweight access Protocol (LDAP) connection
-Java Database Connectivity (JDBC) connection

33
Q

True or False.
An import Set Table acts as a staging area for records imported from a data source

A

True

34
Q

Steps for importing data using an Import Set?

A
  1. Load the data
  2. Create a Transform Map
  3. Transform the data
  4. Clean up the import data
35
Q

What are 5 different Data Sources?

A
  1. JDBC
  2. HTTP/ FTP
  3. EXCEL
  4. CSV
  5. XML
36
Q

What is a Transform Map?

A

A set of fields that define the relationship between fields in an import set table and fields in a target table.
If a name is not the same… it will NOT map.

37
Q

2 Tools used in Transform Map?

A
  1. Automatic Mapping Utility
  2. Mapping Assist Utility
38
Q

Coalesce Fields

A

Coalescing a field mean the field will be used as a unique key during imports.
It’s always for Import Sets

39
Q

What happens if a match is found using the coalesce field(s)?

A

The existing record will be updated with the information being imported

40
Q

What happens if a match is NOT found using the coalesce field(s)?

A

Then a new record will be inserted into the database

41
Q

Can you have more than 1 coalesce field?

A

Yes

42
Q

What are the configurations you can use to coalesce data in Import Sets?

A
  1. Single-field Coalesce
  2. Multiple-field Coalesce
  3. Conditional Coalesce
43
Q

What is the Configuration Management Database (CMDB)?

A

A series of tables and fields that contain all of the Configuration Items (CIs) controlled by your company, as well as their attributes & relationships

44
Q

What roles do you need to access the CMDB?

A

asset

itil

itil_admin

cmdb_read

45
Q

What are the 3 key CMDB tables?

A
  1. Base Configuration Item [cmdb]
  2. Configuration Item [cmdb_ci]
  3. CI Relationships [cmdb_rel_ci]
46
Q

What is stored in the CMDB?

A

Configuration Items

47
Q

What ITSM processes is the CMDB used in?

A

Incident Management

Problem Management

Change Management

Request Management

48
Q

What is used as the central location to explore the CMDB class hierarchy, CI table definitions and Class CIs

A

CI Class Manager.

All > Configuration > CI Class Manager

49
Q

CSDM stands for what?

A

Common Service Data Model

50
Q

What does the CSDM do?

A
  • Identifies where to place the data
  • A way to make sense of the CMDB
  • CMDB based framework
51
Q

ServiceNow Discovery

A

Is used to maintain and populate the CMDB. It finds the devices

52
Q

ServiceNow Service Mapping

A

Tells us how they are related together

53
Q

Dependency View

A
  1. How to view the relationship between the CIs
  2. Provides an interactive graphical interface to visualise relationships between configuration items
54
Q

Which module is used as the first step for importing Data?

A

Load Data

55
Q

Which option allows you to update existing target table records when importing data from an import set?

A

Coalesce

56
Q

Which tool is used to determine relationships between field in an import set and an existing table?

A

Transform Map

57
Q

Which ServiceNow product can be used to populate the CMDB?

A

Discovery