Brainscape's Knowledge GenomeTM

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


See full index

ServiceNow Fundamentals - all versions > Module 3: Database Administration > Flashcards

Module 3: Database Administration Flashcards

1
Q

What are the three ServiceNow infrastructures?

A

Tables, Records, Fields

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

How can you access the System Dictionary?

A

System definition > Dictionary

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

What does the System Dictionary do?

A

Contains the definition of every table and field

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

Where are Numbers maintained?

A

System Definition > Number Maintenance

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

Sys_id are how long?

A

32 characters

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

How do you add columns to a table?

A

System Definition > Tables and columns

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

What are the three attributes of a field?

A

Field Label, Field Name, Value

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

Name the 4 ways tables can be related

A

One-to-Many, Many-to-many, Database View, and Extensions

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

Where d you set up a Database View?

A

System Definition > Database Views

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

What’s a base Table?

A

An extended table that is itself not extended IE Task

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

How do you set up alternate Labels for a Table?

A

System definition > Language File

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

What’s a table that is from OOB?

A

Core Table

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

What’s a table that was created by an admin or developer?

A

Custom Table

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

What’s a schema map

A

A graphical representation of table relations

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

What two modules allow you to create tables?

A

Tables & Tables and Columns

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

What’s created by default in a new table?

A

Application Menu with the same name as the table AND Module with the plural table names

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

How do you edit the title of an application menu?

A

Click the pencil (edit) icon or Update the Title field on the form

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

What is CRUD

A

Create, Read, Update, Delete

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

Name three Security layers to access data?

A

User Logon, Application/Module access, and Database Access

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

What three modules are used to administer security?

A

System Properties>Security,
System Security>Access Control (ACL), and
System Security>High Security Settings

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

Besides CRUD there are 5 additional security operations

A 
Execute, 
edit_ci_relations, 
save_as_template, 
Report_on, and 
personalize_choices
22
Q

What role allows ACL access?

A

security_admin

23
Q

Each access control rule specified three things:

A 
the Object (table), 
permissions required (role, conditions, scripts), and 
Operation (CRUD)
24
Q

How do you access the Access Controls easily?

A

table_name.CONFIG

25
Q

Table access order? (ACL)

A

Match table, match field

26
Q

If you fail a Table ACL?

A

No access to table

27
Q

If you fail a field ACL?

A

No access to field, still can access table

28
Q

What happens if there is more than 1 rule for an ACL?

A

You must pass all to get access

29
Q

What happens with ACL Rule Type: table.None?

A

No specific field so applies to the entire table

30
Q

What happens with ACL Rule Type: table.field?

A

Rule applies to only one field

31
Q

What happens with ACL Rule Type: table.*?

A

Rule applies to all fields without a specific field rule

32
Q

Why use a wildcard in an ACL?

A

Reduces the number of rules needed

33
Q

What is an Import set used for?

A

Import data and map it to tables

34
Q

Import sets contain …

A

information regarding an import Set data source

35
Q

An Import Set Table is used for …

A

staging records from an imported data source

36
Q

Transform maps …

A

A set of field maps defining the relationship between import set fields and target table

37
Q

Automatic Mapping Utility will do what?

A

It matches exact names from the import set and destination table

38
Q

What does the Mapping Assist Utility do?

A

Visually assists mapping the import set to table fields

39
Q

Coalescing a field does what?

A

It’s a unique key to determine if the record is inserted or updated

40
Q

What happens if no Coalesce field(s) is selected

A

All data is imported

41
Q

What does a Conditional Coalesce do?

A

It uses a script to determine unique records

42
Q

What module is used to import data?

A

Load Data

43
Q

What four steps import data?

A

Load the data, Create a transform map, Transform the data, clean up the import

44
Q

What tool is used to determine a relationship between fields in an import set and an existing table

A

A transform map

45
Q

What are the 3 key CMDB tables?

A

Configuration Item [cmdb],
Configuration Item [cmdb_ci] colds ci data, and
CI relationships [cmdb_rel_ci]

46
Q

What helps you create CI Relationships?

A

The CI Relationship Editor

47
Q

What does Service Mapping do?

A

discovers relationships and dependencies between discovered CI’s and automatically populates this info in the CMDB

48
Q

What does MID stand for?

A

Management, Instrumentation, and Discovery

49
Q

Dependency view icons: Triangle with !, wrench, and lego

A

Triangle = Incident, wrench = Active Problem, Lego = Affected CIs for a Task

50
Q

What is CSDM?

A

Common Service Data Model, a CMDB Based framework

51
Q

What is a series of tables containing assets and services for my company?

A

CMDB (Configuration Management DataBase)

52
Q

What ServiceNow service populates the CMDB?

A

Discovery

ServiceNow Fundamentals - all versions (3 decks)

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