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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What role is required for a user to create or update access control rules?

A

security_admin

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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
  1. It operates in bulk

2. It helps maintain the CMDB healthy and efficient.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

How do you retain all updates’ history to attribute values of the Configuration Items from all discovery sources?

A

Enable Multisource CMDB

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Which of the following should you do before importing data into ServiceNow? Select 3 Answers from the below options

A
  1. Understand the data you plan to import.
  2. Determine which source data maps to which target fields.
  3. Decide what to do with incomplete or erroneous data.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Which of the following statements are true about import sets? Select 3 Answers from the below options

A
  1. Creating an extremely large import set can cause delays and system outages
  2. You can import data from several different file formats or external data sources.
  3. Import Sets cannot add data to encrypted fields.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What scores are found on the CMDB health dashboard? Select 3 Answers from the below options.

A
  1. Compliance
  2. Correctness
  3. Completeness
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What changes are automatically reflected in dynamic application services?

A

Any change to CI relationships in the CMDB CI Relationship table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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
  1. OIDC
  2. LDAP
  3. REST
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What model/standard across applications helps track life cycle stages and stage statuses for CIs effectively?

A

Common Service Data Model

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What is Configuration Management Database (CMDB)?

A

A database used to store configuration records throughout their lifecycle

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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]

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

What setting on the List Control page can speed up loading large lists?

A

Remove pagination count

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

What do access control list rules specify? Select 2 Answers from the below options.

A
  1. The object and operation being secured

2. The permissions required to access the object

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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]

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

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

A
  1. snc_external

2. snc_internal

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

How do you delete related records from the archive log and archive (ar_) tables?

A

Create archive destroy rules

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

What is a stakeholder’s role in implementing and maintaining the CMDB?

A

Determine specific CI information required to support capabilities and build organisational buy-in.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

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?

A

Many to Many

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
29
Q

What variable type should be used to allow uploading an attachment from a question in a catalogue item?

A

Attachment

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
30
Q

Which incident field is used to predict the Configuration Item and Service fields’ value via Predictive Intelligence solution definitions?

A

Short description

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
31
Q

(Rome) How can you identify and maintain overlapping IP addresses in different network partitions as separate CIs?

A

By using the CMDB Data Manager

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
32
Q

What are the different Schema relationship types that are supported for tables? Select 4 Answers from the below options.

A
  1. Referencing
  2. Referenced by
  3. Extending
  4. Extended by
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
33
Q

Which admin role is required to modify access control rules?

A

security_admin

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
34
Q

Which of the following are Data management plugins? Select 3 Answers from the below options.

A
  1. Data Archiving
  2. Database Rotations
  3. Many to Many task relations
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
35
Q

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.

A
  1. Script
  2. Condition
  3. Requires Role
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
36
Q

What rules can prevent the Identification and Reconciliation Engine (IRE) from downgrading or switching between specific CI classes during payload processing?

A

Reclassification restriction rules

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
37
Q

What CMDB Query Builder setting should you override to optimise the running queries that take a long time to complete or that time out?

A

glide.cmdb.query.batch_size

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
38
Q

(Rome) Which of the following defines an application service in the best way?

A

It is a set of interconnected applications and hosts configured to offer a service to an organisation

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
39
Q

What is created by default when you create a new table? Select 2 Answers from the below options.

A
  1. Module with the plural of the table Label

2. Application Menu with the same name as the table Label

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
40
Q

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.

A
  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.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
41
Q

(Rome) Which feature enables you to add related entries for Identification and Reconciliation Engine Identification (IRE) rules?

A

CI Class Manager

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
42
Q

What is Configuration Management System (CMS)?

A

A set of tools and databases used to manage an organisation’s configuration data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
43
Q

Which of the following is a true statement about importing data into ServiceNow?

A

Every import must have at least one Transform Map

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
44
Q

What are the three category of CI? Select 3 Answers from the below options.

A
  1. Intangible (e.g business services, email) entities
  2. Tangible (e.g hardware, software, servers) entities
  3. Configuration Item
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
45
Q

What coalesce configuration in the import process treats all imported rows as new records and does not update existing records?

A

No Coalesce

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
46
Q

Which of the following can be used to create configuration items (CIs) in the CMDB? Select 3 Answers from the below options.

A
  1. Creation via service cataloge fulfilment processes
  2. Creation via the change management process
  3. Creation triggered by asset management
47
Q

What IT challenges can be solved with the CMDB? Select 3 Answers from the below options.

A
  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
Q

The CMDB is the authoritative source of what information? Select 3 Answers from the below options.

A
  1. Support group
  2. Owner
  3. Contact
49
Q

Which option allows you to update existing Target Table records when importing data from an import set?

A

Coalesce

50
Q

Which of the following are possible data sources for importing data into ServiceNow? Select 4 Answers from the below options.

A
  1. XML
  2. CSV
  3. HTTP
  4. JDBC
51
Q

What CMDB query run scenarios can you use to apply the batch size value? Select 3 Answers from the below options.

A
  1. A scheduled job
  2. A scriptable API
  3. The Query Builder user interface
52
Q

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?

A

Dynamic application services [cmdb_ci_service_calculated]

53
Q

What type of traffic can you apply an IP access control to your instance? Select 3 Answers from the below options.

A
  1. Inbound
  2. Bidirectional
  3. Outbound
54
Q

Which one of the following is used to control access to features and capabilities in applications and modules?

A

Role

55
Q

What are the reasons organisations fail to complete implementation or realise business value from the CMDB? Select 3 Answers from the below options.

A
  1. Unknown Configuration Items
  2. Inconsistent data quality
  3. III-defined relationships among Configuration Items
56
Q

What is Configuration Item (CI)?

A

Componentes of an infrastructure required to deliver a product or service

57
Q

What does the first-page results column in the Search Event [sys_search_event] table contain? Select 2 Answers from the below options.

A
  1. sys_ids

2. Table names

58
Q

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.

A
  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
Q

Which of the following action is recommended when you want to perform system maintenance?

A

Terminate logged in users’ sessions

60
Q

Which of the following are the steps to Easy Import? Select 3 Answers from the below options.

A
  1. Upload Import Data
  2. Download Excel Template
  3. Finalise Import
61
Q

Which of the following are part of the Common Services Data Model (CSDM)? Select 3 Answers from the below options.

A
  1. Base system CMDB core tables
  2. Best practice for CMDB data modelling and data management
  3. Guidance on service modelling
62
Q

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?

A

Service Offering

63
Q

What table can provide you with the information to decide whether it is safe to delete a non-dependent CI relationship?

A

Relationship Sources [sys_rel_source]

64
Q

Which of the following is NOT a database setting on the Application Access section of a Table?

A

Can write

65
Q

From an Application Portfolio Management (APM) perspective, what do Application Services represent?

A

Installed Instances

66
Q

What can you use to drive priority, assignments, and approvals for all ITSM processes?

A

CI meta data

67
Q

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?

A

OpenID Connect

68
Q

What needs to be activated/installed to use the Configuration Management Database (CMDB) quick start tests?

A

The CMDB - ATF Tests’ plugin

69
Q

What CMDB table stores the basic attributes of all the configuration items?

A

Configuration Item [cmdb_ci]

70
Q

(Rome) Which ServiceNow feature imports data from third-party applications, such as Microsoft SCCM, into your Configuration Management Database?

A

Service Graph connectors

71
Q

All technical configuration items extend from ………………?

A

Configuration Item [cmdb_ci]

72
Q

Which modules can you use to create a new table? Select 2 Answers from the below options.

A
  1. Tables & Columns

2. Tables

73
Q

(Rome) What is the single location for all the import sets and concurrent import sets for a scheduled data import chain?

A

Execution Contexts

74
Q

Which of the following describes the relationship between the Problem and the Task tables?

A

The Problem table extends the Task table

75
Q

What is the minimum role required to subscribe or unsubscribe a CI?

A

cmdb_read

76
Q

Which field on a Configuration Item (CI) record may be used to route Incidents to the appropriate group to resolve CI related incidents quickly?

A

Support Group

77
Q

Which of the following are database view limitations? Select 3 Answers from the below options.

A
  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
Q

Which of the following Transform Maps are required to import a spreadsheet containing services and servers? Select 3 Answers from the below options.

A
  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
Q

Which tool is used to determine relationships between fields in an import set and an existing table?

A

Transform map

80
Q

(Rome) Which of the following group reference fields is not among the Teams related list for a Service and its descendent classes in CMDB?

A

Monitor group

81
Q

What authentication enables you to create policies based on a criteria-like role, IP address, or group?

A

Adaptive authentication

82
Q

Rome) What framework helps you consistently use standard values across applications and effectively track assets through their life-cycle transitions?

A

CSDM (Common Service Data Management)

83
Q

What is the system behaviour when applying a data policy to the list view to make a field read-only?

A

The field will appear to be editable, but the update will fail

84
Q

What are the different ways for ServiceNow tables to be related to each other? Select 4 Answers from the below options

A
  1. Database Views
  2. Extensions
  3. One-to-Many
  4. Many-to-Many
85
Q

What are the Incident Database views for the Service Management plugin in the base system? Select 3 Answers from the below options.

A
  1. incident_metric
  2. incident_time_worked
  3. incident_sla
86
Q

Which of the following are a true statement about the admin role? Select 3 Answers from the below options.

A
  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
Q

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?

A

External Single Sign-On (SSO)

88
Q

What can you identify in ITSM processes by using the configuration management database (CMDB)? Select 3 Answers from the below options.

A
  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
Q

(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.

A
  1. Life-cycle stage

2. Life-cycle Stage Status

90
Q

What is the auto-populated table name prefix when creating a new custom table in the global application?

A

u_

91
Q

Which of the following is an example of a base table that is extended but is not extending another table?

A

Task [task]

92
Q

(Rome) What does the ServiceNow Import and Export application enable you to do? Select 3 Answers from the below options.

A
  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
Q

What are the benefits of using Multisource CMDB? Select 3 Answers from the below options.

A
  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
Q

Which of the following is an example of a CI Class switch?

A

A CI is reclassified from the Linux Server [cmdb_ci_linux_server] class to the Window Server [cmdb_ci_win_server] class

95
Q

(Rome) Which of the following is true about the CMDB Data Manager? Select 3 Answers from the below options.

A
  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
Q

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.

A
  1. Switch
  2. Upgrade
  3. Downgrade
97
Q

What NOW Platform feature, in conjunction with field normalisation, does CMDB leverage to check a CI’s uniqueness automatically?

A

Identification and Reconciliation Engine (IRE)

98
Q

How can you integrate third-party data into the Configuration Management Database without compromising its integrity?

A

By using the IntegrationHub ETL

99
Q

What data type in a survey metric has the field validation option to validate email, IP address, phone number or URL?

A

String

100
Q

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.

A
  1. Keep the record already in the target table.

2. Overwrite the record in the target table with the source data.

101
Q

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.

A
  1. Read
  2. Delete.
  3. Create
  4. Write
102
Q

What are the three key tables in the CMDB? Select 3 Answers from the below options.

A
  1. Base Configuration Item [cmdb]
  2. Configuration Item [ cmdb_ci]
  3. CI Relationship [cmdb_rel_ci]
103
Q

What types of permissions can be configured in an access control rule? Select 3 Answers from the below options.

A
  1. Role
  2. Conditions
  3. A script that sets the ‘answer’ variable to true or false
104
Q

What are the three key attributes of every field? Select 3 Answers from the below options.

A
  1. Field Label
  2. Value
  3. Field Name
105
Q

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.

A
  1. User Authentication
  2. Application and Modules Access
  3. Database Access
106
Q

Which of the following field types do have a one-to-many relationship? Select 3 Answers from the below options.

A
  1. Document ID fields
  2. Glide List
  3. Reference fields
107
Q

What role is required to create and edit Access Controls?

A

security_admin

108
Q

What is automatically deleted when a non-dependent relationship is deleted from the CI Relationship [cmdb_rel_ci] table?

A
  1. All corresponding records in the Relationship Sources table
109
Q

Which of the following are true statements about Data Policies? Select 3 Answers from the below options.

A
  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
Q

(Rome) What import sets can you find in the Execution Contexts?

A

You can see all the import sets and concurrent import sets for a scheduled data import chain in a single location

111
Q

What do you call a single row in a table or list?

A

Record

112
Q

Which of the following record operations can be secured by ACL rules? Select 3 Answers from the below options.

A
  1. save_as_template
  2. edit_task_relations
  3. personalize_choices
113
Q

Which Common Service Data Model (CSDM) domain does Business Capability reside in?

A

Design