IT Operations Management (ITOM) Practice Exam

These questions are part of the practice quiz. Start practicing

• Which of the following is a disadvantage of indexes?
• Which of the following is a security practice for databases?
• In QBE, how do you rename a computed field?
• Which of the following is listed as a project variable?
• In a relational schema, what is the purpose of a foreign key?
• What constitutes effective incident communication during a major incident?
• What are ephemeral instances in cloud-native environments?
• Which activity is a core component of Scope Management?
• Which input method involves loading data from a flat file into a database?
• Which statement about quality management is accurate?
• What is a key concern of Integration Management?
• Which of the following statements about data warehouses is accurate?
• Which statement about views is true?
• Which operator is shorthand for a long list of OR conditions?
• What is the purpose of automation governance in ITOM?
• Project cost includes which components?
• What does GROUP BY do in a query?
• Which design principle is described for emphasizing data in reports?
• Referential integrity is defined by which of the following?
• What are common data sources for reports in relational databases?
• In ITOM, asset discovery is defined as?
• In Access, which component contains fields?
• Entity integrity ensures which of the following?
• How should ITOM address multi-cloud or hybrid cloud environments?
• What are the two common monitoring deployment models?
• Project scope is defined as the definition of tasks to be included and excluded in a project. This makes it a key determinant of other factors. Which statement best reflects this definition?
• What is a common goal of Access forms?
• What is Project Management?
• Which tools are commonly used to correlate events and alerts across IT environments?
• Which operation efficiently removes a large number of records from a table when conditions are met?
• What is the correct sequence for a basic SQL retrieval statement using select-from-where?
• What is a Change Advisory Board (CAB) and its roles?
• What are the main change types in ITIL-based Change Management?
• Under Methods of Input, which method is listed?
• What is the primary purpose of a primary key in a relational database?
• Which of the following is a component of Quality Management as described?
• Which statement about the primary purpose of tables is true?
• How do risk, vulnerability, and threat relate in ITOM?
• Outer join is used in scenarios where you want what?
• How do logs differ from monitoring data in ITOM?
• What is an RFC in ITSM?
• How should incident closure documentation be used?
• Which of the following is listed as a requirement for a good project leader?
• Which statement appropriately contrasts primary keys and secondary keys?
• What is the purpose of Change Management in ITOM?
• What is a typical characteristic of aggregate functions in a query?
• In relational databases, which statement best describes a primary key?
• Why is data quality in the CMDB critical?
• AutoNumber field type does what?
• When using ORDER BY, what must be included in the SELECT list?
• What is the purpose of post-incident reviews in ITOM and DevOps practices?
• Which join returns only matching rows from both tables?
• Long Text field type stores how many characters?
• What is a primary purpose of a CMDB?
• Short Text field type stores up to how many characters?
• Query By Example (QBE) is best described as
• Which relationship types exist in relational databases?
• Which statement correctly distinguishes agent-based versus agentless monitoring?
• What do you see in Table design view?
• What is a Configuration Item (CI)?
• What do MTBF and MTTR measure, and how are they used?
• Which clause specifies the new values in an UPDATE statement?
• What distinguishes a major incident from a standard incident?
• What is the function of a Make Table Query?
• What is an Emergency Change?
• Which keywords are used to update data in a table?
• What do the term 'Fields' in a table refer to?
• What does a RACI model in Change Management stand for?
• What does the Create Table Statement define?
• What is Microsoft Access?
• Which SQL command is used to display data from tables?
• Which data sources are essential to observability?
• The CMDB is used to understand service dependencies and support which activities?
• Ethical Issues with Computers includes which listed question?
• Views provide data independence when the database changes. True or False?
• Lookup tables are used to...
• After triage and classification, if escalation is required, what is the next step?
• What best describes the difference between GDPR/HIPAA considerations and ITOM practice?
• Which practice is most directly responsible for maintaining a documented workaround and permanent solution for known issues?
• What is the purpose of Security Operations in ITOM?
• Yes/No field type stores true/false values?
• Data Warehouse benefits include which of the following?
• What is a primary purpose of indexes in relational databases?
• What is the purpose of verification in incident management?
• Which guideline helps in determining fields for a table?
• How does GDPR/HIPAA influence ITOM practice?
• Which of the following are typical ITOM KPIs to track?
• Which items are considered report objects?
• What is an error budget in SRE and how does it influence ITOM decisions?
• What is the purpose of an IT Service Continuity and Disaster Recovery plan?
• What is a primary purpose of a data warehouse?
• Which statement about Access Tables is true?
• Which statement best describes a relational database?
• In a Disaster Recovery plan, what do Recovery Objectives and Actions refer to?
• Which item is listed as a risk area to watch for in Risk Management?
• What is Project Time primarily concerned with?
• Which SQL clause is used to sort the result set?
• What methods are used in Capacity Planning to validate future demand?
• Cascade rules: which statement is true?
• Which statement best differentiates the problem lifecycle from incident management?
• Which query type deletes records?
• Which two types of reports are described in the material?
• Integrity in SQL: Which statement about constraints is true?
• Which item is not listed as a component of Corporate Systems?
• What is a Standard Change?
• Which statistic reflects the rate at which projects fail or face major challenges?
• In relational database nomenclature, what do Rows represent?
• Which statement best describes a major incident's typical requirements?
• What is required for an inner join?
• Which clause is used to join tables in a query?
• Which statement about projects is accurate?
• Which KPI measures the average time to restore service after a disruption?
• The Number field type can store which numeric types?
• Which comparison operator represents equality in criteria?
• Which statement describes Access forms?
• Which statement about Scope Management is true?
• Reports built with Wizards have which feature?
• How is a project defined in the material?
• What is SIEM and how is it used in ITOM?
• Partitions are described as a version of a hierarchy. Which statement is correct about partitions?
• What is the term used to ask the database a question?
• Which of the following is listed as a requirement for a good project leader?
• What is the primary goal of IT operations management (ITOM) within an organization?
• Which aggregate function returns the total number of records?
• What is the CMDB and why is it important?
• Which term refers to surveillance and tracking of individuals by computers/technology?
• Which best describes data integrity?
• In the notation Table Name (Field1, Field2, Field3...), what do the listed items correspond to?
• Which concept describes querying data from two or more tables usually linked by a key field and a foreign key?
• What does capacity management primarily forecast?
• What types of ITOM tools are commonly used?
• Which ITIL practice is primarily responsible for preventing recurring issues by identifying and eliminating root causes?
• Which of the following is commonly considered a risk area in project risk management?
• Which type of query creates a brand new table from query results?
• When data is split into multiple tables, what is true?
• Which term refers to a detected change or condition in a component that may or may not affect service?
• What is the primary goal of Capacity Management?
• Which of the following is a common DR recovery strategy?
• Which sequence best describes the typical incident lifecycle from detection to closure?
• Why is knowledge management important for ITOM?
• Catalog contains what information?
• Which operator is used for tests like Balance > 750?
• What does NOT do in compound criteria?
• Maintaining indexes during updates may require what?
• Which statement best describes a Known Error?
• Which item is an Access object specifically used to store macros and VBA code?
• Can forms include VBA code?
• Left join returns records from the left table even if there are no matching records in the right table?
• Data marts can be built with what type of data stores?
• What are the differences between Problem Management and Known Error Management?
• How do capacity, demand, and resource supply relate in Capacity Management?
• In joining tables, what is typically used to link the data across tables?
• In Query By Example, what does the asterisk in Fields Requested signify?
• What is the purpose of a CMDB in ITOM?
• In Tuckman's model, which phase follows Forming?
• What does an Append Query do?
• What are the core components described for a table in a relational database?
• Which metric measures the proportion of time a service is usable?
• What is a characteristic of Access Forms — Auto Form?
• Which of the following is NOT considered a form object component?
• Name common performance metrics used in ITOM monitoring.
• Which statement best reflects Project Quality as described?
• Which description matches the primary use of personal computers?
• What are the three pillars of observability?
• One benefit of using views is that they can send less data across the network. True or False?
• Which statement describes a function of a database view?
• Which term best describes confidential information not to be disclosed to others?
• Which statement about flat-file databases is true?
• What is the expected outcome of post-incident reviews?
• Which Access object stores code for macros and VBA?
• Which of the following is an example of field types in the Create Table Statement?
• Which statement about primary keys is true?
• Web Site computers are described as interfacing with the outside world. Which option reflects this use?
• What is the purpose of detecting drift from or relative to the configuration baseline?
• Which item is not listed as an Access object in the material?
• Which statement is used to delete records from a table?
• In ITOM monitoring, how does an event differ from an incident?
• Which property helps ensure a column has unique values within a table?
• When using GROUP BY with aggregate functions, what result is typically produced?
• In ITOM, asset inventory is defined as?
• What does MTBF stand for?
• Privacy is defined as which of the following?
• Which statement best describes a data mart?
• What is IT Financial Management and why is it important in ITOM?
• What is the objective of Incident Management?
• Which term best describes the language used to query data?
• How does observability differ from monitoring?
• Which data type is used for real-time assessment and thresholds?
• In ITOM, what is the primary difference between automation and orchestration?
• What is the purpose of Group By in aggregation?
• Which DevOps/SRE practices align with ITOM?
• Auto reports in Access have which characteristics?
• Which describes BETWEEN in criteria?
• Which statement differentiates availability and reliability in ITOM?
• Which statement about secondary keys is true?
• Which considerations are important when monitoring cloud-native environments?
• Which of the following are key fields in a relational database?
• Which concern is addressed by Integration Management?
• Which feature provides calculations such as Count and Sum over records?
• What is the role of a Service Continuity plan in ITOM?
• How does CMDB differ from asset repository?
• Which aggregate function yields the total across records?
• Which technique describes a legal values constraint?
• What is the primary purpose of Manufacturing Control Systems?
• Which statement best explains why relational databases are used?
• In Tuckman's Forming-Storming-Norming-Performing model, which phase is characterized by the team first meeting, unclear roles, and leadership providing direction?
• What is a configuration baseline?
• What role does the Service Desk play in ITOM?
• Which query type updates or replaces existing data?
• How are relationships between tables implemented?