Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

ServiceNow CSA Exam prep "Data Schema", Exams of Business Economics

ServiceNow CSA Exam prep "Data Schema"

Typology: Exams

2023/2024

Available from 10/24/2023

DrShirleyAurora
DrShirleyAurora 🇺🇸

4.5

(8)

4.3K documents

1 / 6

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
ServiceNow CSA Exam prep "Data
Schema"
What is the ServiceNow infrastructure? -
          Data in ServiceNow is stored and managed according to a database structure that
administrators can view and configure:
Tables -
          are a data structure or database component, which contain records
Records -
          are the data stored on tables, which contain fields.
Lists and forms -
          provide a friendly user interface (UI) for managing the data in records and fields.
Dictionary -
          defines every table and field in the system. Table records are identified as a Collection type.
Tables -
          contains a record for each table in the database. Custom tables can be created when the New
button is created.
Tables & Columns -
          lists existing tables in the database. Selecting a table name displays its contents.
The System Dictionary -
          contains the definition for each and every table and field in the database.
To access the system dictionary to modify table and field attributes. -
          Navigate to System Definition > Dictionary
Each record corresponds to -
          a row in a table.
Each field on a record corresponds to -
          a column on that table.
Applications use -
          tables and records to manage data and processes.
Records -
          Are identified by a 32-character, globally unique ID, called a sys_id.
Record numbers are automatically incremented, and -
pf3
pf4
pf5

Partial preview of the text

Download ServiceNow CSA Exam prep "Data Schema" and more Exams Business Economics in PDF only on Docsity!

ServiceNow CSA Exam prep "Data

Schema"

What is the ServiceNow infrastructure? - Data in ServiceNow is stored and managed according to a database structure that administrators can view and configure: Tables - are a data structure or database component, which contain records Records - are the data stored on tables, which contain fields. Lists and forms - provide a friendly user interface (UI) for managing the data in records and fields. Dictionary - defines every table and field in the system. Table records are identified as a Collection type. Tables - contains a record for each table in the database. Custom tables can be created when the New button is created. Tables & Columns - lists existing tables in the database. Selecting a table name displays its contents. The System Dictionary - contains the definition for each and every table and field in the database. To access the system dictionary to modify table and field attributes. - Navigate to System Definition > Dictionary Each record corresponds to - a row in a table. Each field on a record corresponds to - a column on that table. Applications use - tables and records to manage data and processes. Records - Are identified by a 32-character, globally unique ID, called a sys_id. Record numbers are automatically incremented, and -

the number format per table in the system can be changed by visiting the System Definition

Number Maintenance application. Fields - Store the actual data. They are available in a variety of different field types, such as: Choice, Date/Time, Journal, Reference, and more. Field types - define how a field is interacted with through the interface, as well as the type and format of data it can store. Every field has three key attributes: - Field Label, Field Name, Value Field Label - A user-friendly term for the field.In this example, the Field Labels are: User ID, Name, and Location. Field Name - A unique term for the field. It is very important to note the Field Name does NOT always match the Field Label. Value - The actual data stored in the field, anything that comes after the dot [.] - is the Field Name (a unique identifier). A reference field - stores a unique system identifier (known as the sys_id) of a record on another table which is what establishes the reference relationship. When you define a reference field - he platform creates a relationship between the two tables. Adding a reference field to a form - makes the other fields in the referenced table available to the form. Administrators - can create new reference fields and configure several options for reference fields. Reference fields are identified - with the Reference Lookup icon. Wildcard searches can - be used to locate a record.

Database Views - Two tables can be joined virtually to allow for reporting on data that might be stored in more than one table. Certain views are included in the base system with the Database Views and Database Views for Service Management plugins. Database Views are - read-only. Extensions - A table can extend another table. The extended table includes unique fields plus all of the fields and their properties from the parent table. For tables that stand alone, - only the global default fields are automatically created. Extending a table - incorporates all of the fields of the original table and allows for unique fields to be created on the new table. incorporates all of the fields of the original table and allows for unique fields to be created on the new table. - is used to create subcategories of data. The option to extend a table is only available when - creating a new table. It is important to note however, not all tables are extensible. child class. - A table that extends another table The table it extends is - the parent class. Child tables extended from - Task [task] include Change Request, Incident, and Problem. Child tables extended - from Configuration Item [cmdb_ci] include Database, Hardware, and Software. To add a different label for an extended table, - navigate to System Definition > Language File. Then create a new entry for the extended table. A table's Extensible field is used - to control whether a table can be extended.

  • If it is set to true (selected/checked), the table can be extended.
  • If it is set to false (NOT selected/checked), the table cannot be extended. Dictionary overrides - the ability to define a field on a child table differently from the field on the parent table. base table. - If a table is extended but itself is not extending another table, Every child table is a - specialization of its base table or previous child table. The Task [task] table is - a base class (not extending another table), and a parent class (extended). Core tables - are created by ServiceNow and provided with the base system. Custom tables - are created by you. When creating a new custom table, the table name is - automatically populated based on the table label and a prefix. If the table is created in a scoped application - the name is prefixed with a namespace identifier, indicating it is a part of the application. If the table is created in the global application, - the name is prefixed with "u_". If the table is being created in a scoped application, - the name is prefixed with a namespace identifier: "x_", indicating that it is a part of an application. For tables that stand alone, - only the global default fields are automatically created. The option to extend a table is only available - when creating a new table. It is important to note however, not all tables are extensible. child class. - A table that extends another table Task [task] and Configuration Item [cmdb_ci] tables are - parent classes that are extended to child classes A child table inherits -