Barb Valle CSA 1 - Database Administration Practice Test Flashcards
1
Q
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?
A
Transform map
2
Q
(Rome) What related list can you use to extend and track the different types of groups assigned to a Configuration Item?
A
Teams
3
Q
What role is required for a user to create or update access control rules?
A
security_admin
4
Q
(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.
A
- It operates in bulk
2. It helps maintain the CMDB healthy and efficient.
5
Q
How do you retain all updates’ history to attribute values of the Configuration Items from all discovery sources?
A
Enable Multisource CMDB
6
Q
What type of relationship is recommended between Incident and SLA tables to report on incidents resolved by SLA per incident category?
A
Database Views
7
Q
Which of the following should you do before importing data into ServiceNow? Select 3 Answers from the below options
A
- 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.
8
Q
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?
A
Principal Class
9
Q
What do each record and each field correspond to in a table?
A
Each record corresponds to a row in a table and each field to a column on that table.
10
Q
Which of the following is a definition for transform maps in ServiceNow?
A
A map to determine relationships between fields displaying in a Import Set to fields in an existing table
11
Q
Which of the following statements are true about import sets? Select 3 Answers from the below options
A
- 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.
12
Q
What scores are found on the CMDB health dashboard? Select 3 Answers from the below options.
A
- Compliance
- Correctness
- Completeness
13
Q
What changes are automatically reflected in dynamic application services?
A
Any change to CI relationships in the CMDB CI Relationship table
14
Q
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
A
- OIDC
- LDAP
- REST
15
Q
What model/standard across applications helps track life cycle stages and stage statuses for CIs effectively?
A
Common Service Data Model
16
Q
What is Configuration Management Database (CMDB)?
A
A database used to store configuration records throughout their lifecycle
17
Q
What table in the base system details the appropriate relationship types for a CI type, based on its class?
A
Suggested Relationship
[cmdb_rel_type_suggest]
18
Q
What setting on the List Control page can speed up loading large lists?
A
Remove pagination count
19
Q
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?
A
Common Services Data Model (CSDM)
20
Q
What do access control list rules specify? Select 2 Answers from the below options.
A
- The object and operation being secured
2. The permissions required to access the object
21
Q
(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?
A
Copy and configure the quick start tests
22
Q
What type of relationship can you add when configuring relationships between an application service and other CSDM components?
A
A parent relationship to another application service
23
Q
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?
A
Suggested Relationship
[cmdb_rel_type_suggest]
24
Q
In what order are access controls evaluated?
A
First at the Table-level (most specific to most general), then at the Field-level (most specific to most general)
25
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
1. snc_external
| 2. snc_internal
26
How do you delete related records from the archive log and archive (ar_) tables?
Create archive destroy rules
27
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.
28
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
29
What variable type should be used to allow uploading an attachment from a question in a catalogue item?
Attachment
30
Which incident field is used to predict the Configuration Item and Service fields' value via Predictive Intelligence solution definitions?
Short description
31
(Rome) How can you identify and maintain overlapping IP addresses in different network partitions as separate CIs?
By using the CMDB Data Manager
32
What are the different Schema relationship types that are supported for tables? Select 4 Answers from the below options.
1. Referencing
2. Referenced by
3. Extending
4. Extended by
33
Which admin role is required to modify access control rules?
security_admin
34
Which of the following are Data management plugins? Select 3 Answers from the below options.
1. Data Archiving
2. Database Rotations
3. Many to Many task relations
35
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.
1. Script
2. Condition
3. Requires Role
36
What rules can prevent the Identification and Reconciliation Engine (IRE) from downgrading or switching between specific CI classes during payload processing?
Reclassification restriction rules
37
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
38
(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
39
What is created by default when you create a new table? Select 2 Answers from the below options.
1. Module with the plural of the table Label
| 2. Application Menu with the same name as the table Label
40
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.
1. Base Configuration Item table is a Parent table.
2. Base Configuration Item table is a Base table.
3. Service table is a Child table.
4. Configuration Item table is a Parent table.
41
(Rome) Which feature enables you to add related entries for Identification and Reconciliation Engine Identification (IRE) rules?
CI Class Manager
42
What is Configuration Management System (CMS)?
A set of tools and databases used to manage an organisation's configuration data
43
Which of the following is a true statement about importing data into ServiceNow?
Every import must have at least one Transform Map
44
What are the three category of CI? Select 3 Answers from the below options.
1. Intangible (e.g business services, email) entities
2. Tangible (e.g hardware, software, servers) entities
3. Configuration Item
45
What coalesce configuration in the import process treats all imported rows as new records and does not update existing records?
No Coalesce
46
Which of the following can be used to create configuration items (CIs) in the CMDB? Select 3 Answers from the below options.
1. Creation via service cataloge fulfilment processes
2. Creation via the change management process
3. Creation triggered by asset management
47
What IT challenges can be solved with the CMDB? Select 3 Answers from the below options.
1. Regularly maintain complex data for accuracy
2. Make sense of data to drive decisions and services
3. Consolidate disparate Configuration Item (CI) data into a single Configuration Management
48
The CMDB is the authoritative source of what information? Select 3 Answers from the below options.
1. Support group
2. Owner
3. Contact
49
Which option allows you to update existing Target Table records when importing data from an import set?
Coalesce
50
Which of the following are possible data sources for importing data into ServiceNow? Select 4 Answers from the below options.
1. XML
2. CSV
3. HTTP
4. JDBC
51
What CMDB query run scenarios can you use to apply the batch size value? Select 3 Answers from the below options.
1. A scheduled job
2. A scriptable API
3. The Query Builder user interface
52
What do you convert your legacy manual services into to align with the CSDM, leverage ITOM capabilities, and use them with service monitoring and change management?
Dynamic application services [cmdb_ci_service_calculated]
53
What type of traffic can you apply an IP access control to your instance? Select 3 Answers from the below options.
1. Inbound
2. Bidirectional
3. Outbound
54
Which one of the following is used to control access to features and capabilities in applications and modules?
Role
55
What are the reasons organisations fail to complete implementation or realise business value from the CMDB? Select 3 Answers from the below options.
1. Unknown Configuration Items
2. Inconsistent data quality
3. III-defined relationships among Configuration Items
56
What is Configuration Item (CI)?
Componentes of an infrastructure required to deliver a product or service
57
What does the first-page results column in the Search Event [sys_search_event] table contain? Select 2 Answers from the below options.
1. sys_ids
| 2. Table names
58
An Access Control List (ACL) rule only grants a user access to an object if the user meets all of the following permissions required by the matching ACL rule. Select 3 Answers from the below options.
1. The user must have one of the roles in the required role list. If the list is empty, this condition evaluates to true
2. The script must evaluate to true or return an answer variable with the value of true.
3. The condition must evaluate to true.
59
Which of the following action is recommended when you want to perform system maintenance?
Terminate logged in users' sessions
60
Which of the following are the steps to Easy Import? Select 3 Answers from the below options.
1. Upload Import Data
2. Download Excel Template
3. Finalise Import
61
Which of the following are part of the Common Services Data Model (CSDM)? Select 3 Answers from the below options.
1. Base system CMDB core tables
2. Best practice for CMDB data modelling and data management
3. Guidance on service modelling
62
Which of the following CI class is not included in the search results for configuration items, affected CIs, or impacted services within an Incident record?
Service Offering
63
What table can provide you with the information to decide whether it is safe to delete a non-dependent CI relationship?
Relationship Sources [sys_rel_source]
64
Which of the following is NOT a database setting on the Application Access section of a Table?
Can write
65
From an Application Portfolio Management (APM) perspective, what do Application Services represent?
Installed Instances
66
What can you use to drive priority, assignments, and approvals for all ITSM processes?
CI meta data
67
What authentication method is used as a Single Sign-On (SSO) identity provider (IdP) to allow users to log in to ServiceNow using their social identity provider, like Google and Okta?
OpenID Connect
68
What needs to be activated/installed to use the Configuration Management Database (CMDB) quick start tests?
The CMDB - ATF Tests' plugin
69
What CMDB table stores the basic attributes of all the configuration items?
Configuration Item [cmdb_ci]
70
(Rome) Which ServiceNow feature imports data from third-party applications, such as Microsoft SCCM, into your Configuration Management Database?
Service Graph connectors
71
All technical configuration items extend from ..................?
Configuration Item [cmdb_ci]
72
Which modules can you use to create a new table? Select 2 Answers from the below options.
1. Tables & Columns
| 2. Tables
73
(Rome) What is the single location for all the import sets and concurrent import sets for a scheduled data import chain?
Execution Contexts
74
Which of the following describes the relationship between the Problem and the Task tables?
The Problem table extends the Task table
75
What is the minimum role required to subscribe or unsubscribe a CI?
cmdb_read
76
Which field on a Configuration Item (CI) record may be used to route Incidents to the appropriate group to resolve CI related incidents quickly?
Support Group
77
Which of the following are database view limitations? Select 3 Answers from the below options.
1. Its is not possible to edit data within a database view.
2. Database views cannot be created on tables that participate in table rotation.
3. In a clone request, database view tables cannot be added as a data preserver.
78
Which of the following Transform Maps are required to import a spreadsheet containing services and servers? Select 3 Answers from the below options.
1. Transform Map to populate services in the Service [cmdb_ci_service] table.
2. Transform Map to populate servers in the Server [cmdb_ci_server] table
3. Transform Map to populate the relationship between each service and server.
79
Which tool is used to determine relationships between fields in an import set and an existing table?
Transform map
80
(Rome) Which of the following group reference fields is not among the Teams related list for a Service and its descendent classes in CMDB?
Monitor group
81
What authentication enables you to create policies based on a criteria-like role, IP address, or group?
Adaptive authentication
82
Rome) What framework helps you consistently use standard values across applications and effectively track assets through their life-cycle transitions?
CSDM (Common Service Data Management)
83
What is the system behaviour when applying a data policy to the list view to make a field read-only?
The field will appear to be editable, but the update will fail
84
What are the different ways for ServiceNow tables to be related to each other? Select 4 Answers from the below options
1. Database Views
2. Extensions
3. One-to-Many
4. Many-to-Many
85
What are the Incident Database views for the Service Management plugin in the base system? Select 3 Answers from the below options.
1. incident_metric
2. incident_time_worked
3. incident_sla
86
Which of the following are a true statement about the admin role? Select 3 Answers from the below options.
1. Non-admin users cannot add a user to a group that contains the admin role.
2. To grant the admin role to a user, the granting user must also have the admin role.
3. A user with only the admin role cannot grant the security_admin role to other users.
87
Which user authentication method is used when it authenticates the user name and password configured in identity providers with a matching user account in the ServiceNow instance?
External Single Sign-On (SSO)
88
What can you identify in ITSM processes by using the configuration management database (CMDB)? Select 3 Answers from the below options.
1. The business criticality of affected CIs to aid in prioritisation and escalation.
2. Potential upstream or downstream impacts
3. The respective support and approval groups
89
(Rome) Which of the following are the standard fields and values in the CSDM framework that can be used consistently across applications to track an asset's life cycle? Select 2 Answers from the below options.
1. Life-cycle stage
| 2. Life-cycle Stage Status
90
What is the auto-populated table name prefix when creating a new custom table in the global application?
u_
91
Which of the following is an example of a base table that is extended but is not extending another table?
Task [task]
92
(Rome) What does the ServiceNow Import and Export application enable you to do? Select 3 Answers from the below options.
1. You can see the execution record for scheduled data import.
2. You can access import logs from a related list in a import set.
3. You can see all the import sets for a scheduled data import set chain in the Execution Contexts.
93
What are the benefits of using Multisource CMDB? Select 3 Answers from the below options.
1. Revert CMDB data integration from a specific discovery source
2. Visualise the source of attribute values for each discovery source and at the attribute level.
3. Control CI updates at the discovery source and CI attribute level
94
Which of the following is an example of a CI Class switch?
A CI is reclassified from the Linux Server [cmdb_ci_linux_server] class to the Window Server [cmdb_ci_win_server] class
95
(Rome) Which of the following is true about the CMDB Data Manager? Select 3 Answers from the below options.
1. It can create policies that govern CI life cycle stages such as retirement and deletion.
2. It is a wizard-like tool that provides a comprehensive solution managing CIs.
3. It is a policy-driven framework for managing CI life cycle operations.
96
Which of the following options are supported by the Identification and Reconciliation Engine (IRE) for CI updates without reclassification? Select 3 Answers from the below options.
1. Switch
2. Upgrade
3. Downgrade
97
What NOW Platform feature, in conjunction with field normalisation, does CMDB leverage to check a CI's uniqueness automatically?
Identification and Reconciliation Engine (IRE)
98
How can you integrate third-party data into the Configuration Management Database without compromising its integrity?
By using the IntegrationHub ETL
99
What data type in a survey metric has the field validation option to validate email, IP address, phone number or URL?
String
100
Which of the following are possible outcomes when coalescing detects a match between a record in the staging table and a record in the target table? Select 2 Answers from the below options.
1. Keep the record already in the target table.
| 2. Overwrite the record in the target table with the source data.
101
What are the four access control rules that the system creates by default when a custom table is created? Select 4 Answers from the below options.
1. Read
2. Delete.
3. Create
4. Write
102
What are the three key tables in the CMDB? Select 3 Answers from the below options.
1. Base Configuration Item [cmdb]
2. Configuration Item [ cmdb_ci]
3. CI Relationship [cmdb_rel_ci]
103
What types of permissions can be configured in an access control rule? Select 3 Answers from the below options.
1. Role
2. Conditions
3. A script that sets the 'answer' variable to true or false
104
What are the three key attributes of every field? Select 3 Answers from the below options.
1. Field Label
2. Value
3. Field Name
105
What are the different levels of ServiceNow security before an end-user has the capability to perform CRUD (Create, Read, Update, Delete) operations on a table? Select 3 Answers from the below options.
1. User Authentication
2. Application and Modules Access
3. Database Access
106
Which of the following field types do have a one-to-many relationship? Select 3 Answers from the below options.
1. Document ID fields
2. Glide List
3. Reference fields
107
What role is required to create and edit Access Controls?
security_admin
108
What is automatically deleted when a non-dependent relationship is deleted from the CI Relationship [cmdb_rel_ci] table?
1. All corresponding records in the Relationship Sources table
109
Which of the following are true statements about Data Policies? Select 3 Answers from the below options.
1. Data Polices are script-free, server-side application files.
2. Data Polices have a condition as part of the trigger.
3. Data Polices can take different actions when the Conditions field evaluates to true or false.
110
(Rome) What import sets can you find in the Execution Contexts?
You can see all the import sets and concurrent import sets for a scheduled data import chain in a single location
111
What do you call a single row in a table or list?
Record
112
Which of the following record operations can be secured by ACL rules? Select 3 Answers from the below options.
1. save_as_template
2. edit_task_relations
3. personalize_choices
113
Which Common Service Data Model (CSDM) domain does Business Capability reside in?
Design
