ServiceNow Certified System Administrator Fundamentals New York Module 3: Database Administration Latest Updated 2022

Document Content and Description Below

ServiceNow Certified System Administrator Fundamentals New York Module 3: Database Administration Latest Updated 2022 What does the ServiceNow infrastructure consist of? ✔✔tables, records, and... fields. Which 3 modules can access tables in the System Definition application? ✔✔Dictionary, Tables & Columns, and Tables What is a dictionary (System Definition)? ✔✔defines every table and field in the system. Table records are identified as a Collection type. What are Tables & Columns (System Definition)? ✔✔lists existing tables in the database. Selecting a table name will display its contents. What are Tables (System Definition)? ✔✔contains a record for each table in the database. Custom tables can be created when the New button is selected. What is a table? ✔✔a collection of records in the database What are the 3 key attributes of a field? ✔✔Label, Name, and Value What are some examples of a label (Field)? ✔✔includes User ID, Full Name, and Location What is a name (Field)? ✔✔a unique term that does not always match a field's label. What are values (Field)? ✔✔are the actual data, such as users' names, or location. In some cases, the value may be empty, or null. What are reference fields identified by? ✔✔reference lookup icon What does the reference lookup icon do? ✔✔opens a dialog box for locating a record to reference, presented as a list of the referenced (target) table What does the reference icon do? ✔✔preview the referenced record (on the target table) What are the 4 types of table relationships? ✔✔One-to-Many, Many-to-Many, Database views, and Extensions What is a "One-to-Many" relationship field (Table Relationships)? ✔✔Within a table, a field can hold a reference to a record on another table. What are the 3 "one-to-many" relationship fields (Table Relationships)? ✔✔Reference fields, Gilde List, and Document ID Fields What are reference fields (One-to-Many)? ✔✔Allows a user to select a record on a table defined by the reference field. Example: Caller field on the Incident table allows a user to select any record on User table. What is a gilde list (One-to-Many)? ✔✔Allows a user to select multiple records on a table defined by the glide list. Example: The Watchlist field on the Incident table allows the user to select any record or records on the User table. What are document ID fields (One-to-Many)? ✔✔Allows a user to select a record on any table in the instance. Example: Document field on the Translated Text table. What are "Many-to-Many" relationship fields (Table Relationships)? ✔✔Two or more tables that can be related in a bi-directional relationship, so that the related records are visible from both tables in a related list. Example: software vendors can sell multiple products and products can be sold by multiple vendors. What are "database views" in relationship fields (Table Relationships)? ✔✔Two tables that can be joined virtually using the Database Views Plugin to allow for reporting on data that might be stored in more than one table. Database Views are read-only. Create Database Views by navigating to System Definition > Database Views. What are "extensions" in relationship fields (Table Relationships)? ✔✔A table that can extend another table. The extended table includes unique fields plus all of the fields and their properties from the parent table What can tables extend? ✔✔other tables, creating parent and child tables What is a parent class (Table extension)? ✔✔The table that is extended from the child class table What is a child class (Table extension)? ✔✔A table that extends another table What does the dictionary override feature do? ✔✔provides the ability to define a field on an extended table differently from the field on the parent table. Examples include overriding the default values, field dependencies, or read-only status of a field. What is a base table? ✔✔an extended table which cant extend another table What is a task table? ✔✔a table which makes it both a parent and a base class What is a core table? ✔✔Tables that exist in the base system What is a custom table? ✔✔Tables created by admins or developers What is the schema map? ✔✔provides a graphical representation of other tables related to a specific table. Who is the schema map available to (Schema Map)? ✔✔users with the personalize_dictionary role as well as those with the admin role. What does the tables window on the far right do (Schema Map)? ✔✔provides a summary of all the tables presented and their relationships. Which modules can you use to create a new table? ✔✔Tables and Tables & Columns What is created by default when you create a new table? ✔✔Application Menu with the same name as the table Label (e.g. Infinity), and Module with the plural of the table Label (e.g. Infinities) Which tools can be used to create or modify a form layout? ✔✔Configure > Form Layout or Configure > Form Design What does CRUD mean? ✔✔Create, Read, Update, and Delete Who has access to User Authentication/Login (User Permissions)? ✔✔Users, Groups, and Roles What is Application and Modules Access (User Permissions)? ✔✔Controlled by roles configured at the Application and Module level What is database access (User Permissions)? ✔✔Access to tables and their records and fields are controlled via globally defined system properties (deny access is the default behavior) as well as table and field level access controls What are the three security modules used by the System Administrator? ✔✔System Properties > Security, System Security > Access Control (ACL), and System Security > High Security Settings What is an access control? ✔✔a security rule defined to restrict the permissions of a user from viewing and interacting with data What are the two levels where access control can be set? ✔✔Row-level, and Column-level What are the 5 servicenow operation examples? ✔✔execute, Edit_ci_relations, Save_as_template, Report_on, and Personalize_choices What is to "execute" (Operation Example)? ✔✔user cannot execute scripts on a record or UI page What does "Edit_ci_relations" do (Operation Example)? ✔✔user cannot define relationships between Configuration Item [cmdb_ci] tables What does "Save_as_template" do (Operation Example)? ✔✔controls the field that should be saved when a template is created What does "Report_on" do (Operation Example)? ✔✔user cannot create reports on the object What does "Personalize_Choices" do (Operation Example)? ✔✔user cannot right-click a choice list field and select Configure Choices [Show More]

Last updated: 1 year ago

Preview 1 out of 11 pages