CSA 1 - Database Administration Practice Test Flashcards
In which step of the import process, the relationship between fields in an import set table and fields in an existing ServiceNow table is determined?
Transform map
(Rome) What related list can you use to extend and track the different types of groups assigned to a Configuration Item?
Teams
What role is required for a user to create or update access control rules?
security_admin
(Rome) Which of the following are among the ways for managing CIs provided with the CMDB Data Manager? Select 2 Answers from the below options.
- It operates in bulk
2. It helps maintain the CMDB healthy and efficient.
How do you retain all updates’ history to attribute values of the Configuration Items from all discovery sources?
Enable Multisource CMDB
What type of relationship is recommended between Incident and SLA tables to report on incidents resolved by SLA per incident category?
Database Views
Which of the following should you do before importing data into ServiceNow? Select 3 Answers from the below options
- Understand the data you plan to import.
- Determine which source data maps to which target fields.
- Decide what to do with incomplete or erroneous data.
What needs to be set for a CI class in the CI Class Manager to display in the Configuration item field look-up in the change form?
Principal Class
What do each record and each field correspond to in a table?
Each record corresponds to a row in a table and each field to a column on that table.
Which of the following is a definition for transform maps in ServiceNow?
A map to determine relationships between fields displaying in a Import Set to fields in an existing table
Which of the following statements are true about import sets? Select 3 Answers from the below options
- Creating an extremely large import set can cause delays and system outages
- You can import data from several different file formats or external data sources.
- Import Sets cannot add data to encrypted fields.
What scores are found on the CMDB health dashboard? Select 3 Answers from the below options.
- Compliance
- Correctness
- Completeness
What changes are automatically reflected in dynamic application services?
Any change to CI relationships in the CMDB CI Relationship table
ServiceNow can import data from which of the following external data source types when a valid transform map is available? Select 3 Answers from the below options
- OIDC
- LDAP
- REST
What model/standard across applications helps track life cycle stages and stage statuses for CIs effectively?
Common Service Data Model
What is Configuration Management Database (CMDB)?
A database used to store configuration records throughout their lifecycle
What table in the base system details the appropriate relationship types for a CI type, based on its class?
Suggested Relationship
[cmdb_rel_type_suggest]
What setting on the List Control page can speed up loading large lists?
Remove pagination count
What represents a standard and shared set of service-related definitions across the products and platform that will enable and support true service level reporting while providing prescriptive guidance on service modelling within the CMDB?
Common Services Data Model (CSDM)
What do access control list rules specify? Select 2 Answers from the below options.
- The object and operation being secured
2. The permissions required to access the object
(Rome) How do you verify that CMDB is still operational after upgrades and deployments of new applications or integrations if you have a customised CMDB?
Copy and configure the quick start tests
What type of relationship can you add when configuring relationships between an application service and other CSDM components?
A parent relationship to another application service
What table information can be used when integrating third-party data into the CMDB to create CI relationships in compliance with the Common Service Data Model (CSDM) standards?
Suggested Relationship
[cmdb_rel_type_suggest]
In what order are access controls evaluated?
First at the Table-level (most specific to most general), then at the Field-level (most specific to most general)
To provide added security, no user can have both of the explicit roles. What are the two roles? Select 2 Answers from the below options
- snc_external
2. snc_internal
How do you delete related records from the archive log and archive (ar_) tables?
Create archive destroy rules
What is a stakeholder’s role in implementing and maintaining the CMDB?
Determine specific CI information required to support capabilities and build organisational buy-in.
Which of the following indicates the type of relationship for the tables that are bi-directionally related, and the related records are visible from both tables in a related list?
Many to Many
What variable type should be used to allow uploading an attachment from a question in a catalogue item?
Attachment
Which incident field is used to predict the Configuration Item and Service fields’ value via Predictive Intelligence solution definitions?
Short description
(Rome) How can you identify and maintain overlapping IP addresses in different network partitions as separate CIs?
By using the CMDB Data Manager
What are the different Schema relationship types that are supported for tables? Select 4 Answers from the below options.
- Referencing
- Referenced by
- Extending
- Extended by
Which admin role is required to modify access control rules?
security_admin
Which of the following are Data management plugins? Select 3 Answers from the below options.
- Data Archiving
- Database Rotations
- Many to Many task relations
What are the three sections of an Access Control record that must evaluate to true to grant access to a resource? Select 3 Answers from the below options.
- Script
- Condition
- Requires Role
What rules can prevent the Identification and Reconciliation Engine (IRE) from downgrading or switching between specific CI classes during payload processing?
Reclassification restriction rules
What CMDB Query Builder setting should you override to optimise the running queries that take a long time to complete or that time out?
glide.cmdb.query.batch_size
(Rome) Which of the following defines an application service in the best way?
It is a set of interconnected applications and hosts configured to offer a service to an organisation
What is created by default when you create a new table? Select 2 Answers from the below options.
- Module with the plural of the table Label
2. Application Menu with the same name as the table Label
In your implementation, the following tables extend each other:
- The Configuration Item [cmdb_ci] table extends the Base Configuration Item [cmdb] table.
- The Service [cmdb_ci_service] table extends the Configuration Item [cmdb_ci] table.
- The Business Service [cmdb_ci_service_business] table extends the Service [cmdb_ci_service] table.
Business Service [cmdb_ci_service_business]> Service [cmdb_ci_service]> Configuration Item [cmdb_ci]> Base Configuration Item [cmdb]
Based on the above mapping, which table(s) are child, parent and/or base tables? Select 4 Answers from the below options.
- Base Configuration Item table is a Parent table.
- Base Configuration Item table is a Base table.
- Service table is a Child table.
- Configuration Item table is a Parent table.
(Rome) Which feature enables you to add related entries for Identification and Reconciliation Engine Identification (IRE) rules?
CI Class Manager
What is Configuration Management System (CMS)?
A set of tools and databases used to manage an organisation’s configuration data
Which of the following is a true statement about importing data into ServiceNow?
Every import must have at least one Transform Map
What are the three category of CI? Select 3 Answers from the below options.
- Intangible (e.g business services, email) entities
- Tangible (e.g hardware, software, servers) entities
- Configuration Item
What coalesce configuration in the import process treats all imported rows as new records and does not update existing records?
No Coalesce