Brainscape's Knowledge GenomeTM

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


See full index

ServiceNow Quebec Fundamentals > Module 3 - Database Administration > Flashcards

Module 3 - Database Administration Flashcards

1
Q

What are the three ServiceNow data 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 do 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 are tables called that are 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 2 things created by default when a new table is created?

A

Application Menu with the same name as the table

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

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)

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

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)

Operation (CRUD)

24
Q

How do you access the Access Controls easily?

A

table_name.CONFIG

25
Q

What’s the table access order for an 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] holds ci data

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

What do these 3 dependency view icons look like:

Triangle with !

wrench

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 Quebec Fundamentals (6 decks)

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