SNHU DAD 220 ACTUAL EXAM PAPER 2026
QUESTIONS WITH ANSWERS GRADED A+
• Change Management.
Answer: The process, tools and techniques that help people implement
changes to achieve a desired outcome. (Supports the adoption of a
medication Administration System)
• Informatics innovator:.
Answer: expected to be educationally prepared to conduct informatics
research and generate informatics theory, have advanced understanding,
skills in information management and computer technology. (e.g.,
developing innovative and analytic techniques for scientific inquiry,
applying advanced analysis and design concepts to the system life cycle
process), and fiscal management
• healthcare terminology standards.
Answer: designed to enable and support widespread interoperability among
healthcare software applications for the purpose of sharing information
• American Recovery and Reinvestment Act (ARRA).
Answer: **Authorized INCENTIVE PAYMENTS to specific types of
hospitals & healthcare professionals for adopting & using interoperable
Health Information Technology and EHR's. The purposes of this act include
the following: (1) To preserve/create jobs and promote economic recovery.
(2) To assist those most impacted by the recession. (3) To provide
investments needed to increase economic efficiency by spurring
technological advances in science and health. (4) To invest in transportation,
environmental protection, and other infrastructure that will provide
long-term economic benefits. (5) To stabilize state and local government
budgets, in order to minimize and avoid reductions in essential services and
counterproductive state and local tax increases.
• True or False: A logical operator always evaluates to null when one or
, bother operands are null.
Answer: false
• In Jeopardy-style online quiz you are playing the "answers" to the bonus
question: 1. All non-key columns must depend on the whole primary key 2.
A table with a simple primary key is automatically in this form 3 This form
does not eliminate all redundancies.
Answer: Second normal form
• knowledge workers.
Answer: Generate knowledge as product
• 1. The wildcard character % 2. The wildcard character _ 3. LIKE by default
4. LIKE followed by BINARY.
Answer: 1. To match any number of characters 2. To match exactly one
character 3. To conduct a case-insensitive pattern match 4. To conduct a
case-sensitive pattern match
• Which of these are true about null values? Select all that apply..
Answer: A null value is different from a zero value or an empty string. One
NULL is never equal to another.
• Disclosure to Covered entities.
Answer: Covered entities may disclose protected health information to: (1)
public health authorities authorized by law to collect or receive such
information for preventing or controlling disease, injury, or disability and to
public health or other government authorities authorized to receive reports
of child abuse and neglect; (2) entities subject to FDA regulation regarding
FDA regulated products or activities for purposes such as adverse event
reporting, tracking of products, product recalls, and post-marketing
surveillance; (3) individuals who may have contracted or been exposed to a
communicable disease when notification is authorized by law; and (4)
employers, regarding employees, when requested by employers, for
information concerning a work-related illness or injury or workplace related
medical surveillance, because such information is needed by the employer to
comply with the Occupational Safety and Health Administration (OHSA),
, the Mine Safety and Health Administration (MHSA), or similar state law
• Current functionality of EHR includes:.
Answer: • Point of care (POC) access by practitioners. • Support for multiple
users to view data on same patient at the same time. • Results review
(laboratory, pathology, imaging, notes, etc.) . • Quality metrics. •
Dashboards. • Documentation. • Electronic communication. • Order
management. • Patient monitoring in real time. • Patient summary displays. •
Patient support. • Medication administration record. • Population health. •
Bar code medication administration. • External reference resources. • Billing
• Clinical Nurse Specialist.
Answer: Expert clinician in a specialized area of practice who engages in
research and helps direct practice change.
• When a table is in third normal form, which of these is true? Select one..
Answer: All non-key columns depend on the whole primary key and on no
other columns.
• 1. SELECT MIN(Year) FROM Opioid Addiction 2. SELECT
MAX(Percentage) FROM Opioid Addiction 3.SELECT COUNT(*) FROM
Opioid Addiction WHERE Percentage <0.04 4. SELECT AVG(Percentage)
FROM Opioid Addiction.
Answer: 1.2016 2. 0.066 3. 4 4. 0.039
• Information management CDSS includes.
Answer: patient education material, info buttons, or guidelines for practice
• You are analyzing data for a new sports stats website and have access to
their databases related to the Major League Baseball games. A coworker has
created the table Attendance, which estimates the average attendance at
home games next season for franchises in each division of the National
League and the American League..
Answer: SELECT League, Division, MAX(Average) FROM Attendance
GROUP by League, Division ORDER by League, Division
• knowledge translation.
, Answer: applying research to practice
• 1. SELECT CONCAT(CITY,FRANCHISNAME) FROM ATTENDANCE
WHERE GAMEPLAYERS < 35000 2. SELECT REPLACE('ST.
LOUIS','ST.','SAINT') 3. SELECT SUBSTRING('ST. LOUIS',1,3) 4.
SELECT CONCAT (FRANCHISENAME, CITY) FROM
SUPERBOWLSTATS WHERE GAMEPLAYER > 45000.
Answer: 1. CHICAGOMARAUDERS 2. SAINT LOUIS 3. ST 4.
PACERSCLEVELAND
• Denormalization intentionally introduces redundancy by merging tables, and
therefore improves query performance. Which types of normal form tables
does it result in? Select all that apply.
Answer: First or Second form tables.
• Meaningful Use (MU).
Answer: Part of the requirements of the Health Information Technology for
Economic and Clinical Health (HITECH) Act, which is meant to increase
the use of an electronic health record through monetary incentives provided
the HER is used in a meaningful way to improve patient care. At the time of
publication, the Meaningful Use regulations are undergoing revision.
• PHR (personal health record).
Answer: Lifelong tool for managing health info, controlled by pt - data can
be provided by MD or pharmacy. (conditions, allergies, meds, surgeries)
Barriers: Poor or no internet, poorly designed apps, limited clinical
integration Predictors: Awareness of PHR's, ease of access, personal
motivation, increased levels of education and health literacy.
• HIE forms.
Answer: Direct - send/recieve secure info electronically between providers
ex: immunization data, quality measures sent to Medicaide/Medicare Query
- find & request info, often used for unplanned care (ER, pregnancy)
Consumer mediated - pts to aggregate and control the use of health info
among providers (correcting info, tracking their health, providing providers
w/ info)
QUESTIONS WITH ANSWERS GRADED A+
• Change Management.
Answer: The process, tools and techniques that help people implement
changes to achieve a desired outcome. (Supports the adoption of a
medication Administration System)
• Informatics innovator:.
Answer: expected to be educationally prepared to conduct informatics
research and generate informatics theory, have advanced understanding,
skills in information management and computer technology. (e.g.,
developing innovative and analytic techniques for scientific inquiry,
applying advanced analysis and design concepts to the system life cycle
process), and fiscal management
• healthcare terminology standards.
Answer: designed to enable and support widespread interoperability among
healthcare software applications for the purpose of sharing information
• American Recovery and Reinvestment Act (ARRA).
Answer: **Authorized INCENTIVE PAYMENTS to specific types of
hospitals & healthcare professionals for adopting & using interoperable
Health Information Technology and EHR's. The purposes of this act include
the following: (1) To preserve/create jobs and promote economic recovery.
(2) To assist those most impacted by the recession. (3) To provide
investments needed to increase economic efficiency by spurring
technological advances in science and health. (4) To invest in transportation,
environmental protection, and other infrastructure that will provide
long-term economic benefits. (5) To stabilize state and local government
budgets, in order to minimize and avoid reductions in essential services and
counterproductive state and local tax increases.
• True or False: A logical operator always evaluates to null when one or
, bother operands are null.
Answer: false
• In Jeopardy-style online quiz you are playing the "answers" to the bonus
question: 1. All non-key columns must depend on the whole primary key 2.
A table with a simple primary key is automatically in this form 3 This form
does not eliminate all redundancies.
Answer: Second normal form
• knowledge workers.
Answer: Generate knowledge as product
• 1. The wildcard character % 2. The wildcard character _ 3. LIKE by default
4. LIKE followed by BINARY.
Answer: 1. To match any number of characters 2. To match exactly one
character 3. To conduct a case-insensitive pattern match 4. To conduct a
case-sensitive pattern match
• Which of these are true about null values? Select all that apply..
Answer: A null value is different from a zero value or an empty string. One
NULL is never equal to another.
• Disclosure to Covered entities.
Answer: Covered entities may disclose protected health information to: (1)
public health authorities authorized by law to collect or receive such
information for preventing or controlling disease, injury, or disability and to
public health or other government authorities authorized to receive reports
of child abuse and neglect; (2) entities subject to FDA regulation regarding
FDA regulated products or activities for purposes such as adverse event
reporting, tracking of products, product recalls, and post-marketing
surveillance; (3) individuals who may have contracted or been exposed to a
communicable disease when notification is authorized by law; and (4)
employers, regarding employees, when requested by employers, for
information concerning a work-related illness or injury or workplace related
medical surveillance, because such information is needed by the employer to
comply with the Occupational Safety and Health Administration (OHSA),
, the Mine Safety and Health Administration (MHSA), or similar state law
• Current functionality of EHR includes:.
Answer: • Point of care (POC) access by practitioners. • Support for multiple
users to view data on same patient at the same time. • Results review
(laboratory, pathology, imaging, notes, etc.) . • Quality metrics. •
Dashboards. • Documentation. • Electronic communication. • Order
management. • Patient monitoring in real time. • Patient summary displays. •
Patient support. • Medication administration record. • Population health. •
Bar code medication administration. • External reference resources. • Billing
• Clinical Nurse Specialist.
Answer: Expert clinician in a specialized area of practice who engages in
research and helps direct practice change.
• When a table is in third normal form, which of these is true? Select one..
Answer: All non-key columns depend on the whole primary key and on no
other columns.
• 1. SELECT MIN(Year) FROM Opioid Addiction 2. SELECT
MAX(Percentage) FROM Opioid Addiction 3.SELECT COUNT(*) FROM
Opioid Addiction WHERE Percentage <0.04 4. SELECT AVG(Percentage)
FROM Opioid Addiction.
Answer: 1.2016 2. 0.066 3. 4 4. 0.039
• Information management CDSS includes.
Answer: patient education material, info buttons, or guidelines for practice
• You are analyzing data for a new sports stats website and have access to
their databases related to the Major League Baseball games. A coworker has
created the table Attendance, which estimates the average attendance at
home games next season for franchises in each division of the National
League and the American League..
Answer: SELECT League, Division, MAX(Average) FROM Attendance
GROUP by League, Division ORDER by League, Division
• knowledge translation.
, Answer: applying research to practice
• 1. SELECT CONCAT(CITY,FRANCHISNAME) FROM ATTENDANCE
WHERE GAMEPLAYERS < 35000 2. SELECT REPLACE('ST.
LOUIS','ST.','SAINT') 3. SELECT SUBSTRING('ST. LOUIS',1,3) 4.
SELECT CONCAT (FRANCHISENAME, CITY) FROM
SUPERBOWLSTATS WHERE GAMEPLAYER > 45000.
Answer: 1. CHICAGOMARAUDERS 2. SAINT LOUIS 3. ST 4.
PACERSCLEVELAND
• Denormalization intentionally introduces redundancy by merging tables, and
therefore improves query performance. Which types of normal form tables
does it result in? Select all that apply.
Answer: First or Second form tables.
• Meaningful Use (MU).
Answer: Part of the requirements of the Health Information Technology for
Economic and Clinical Health (HITECH) Act, which is meant to increase
the use of an electronic health record through monetary incentives provided
the HER is used in a meaningful way to improve patient care. At the time of
publication, the Meaningful Use regulations are undergoing revision.
• PHR (personal health record).
Answer: Lifelong tool for managing health info, controlled by pt - data can
be provided by MD or pharmacy. (conditions, allergies, meds, surgeries)
Barriers: Poor or no internet, poorly designed apps, limited clinical
integration Predictors: Awareness of PHR's, ease of access, personal
motivation, increased levels of education and health literacy.
• HIE forms.
Answer: Direct - send/recieve secure info electronically between providers
ex: immunization data, quality measures sent to Medicaide/Medicare Query
- find & request info, often used for unplanned care (ER, pregnancy)
Consumer mediated - pts to aggregate and control the use of health info
among providers (correcting info, tracking their health, providing providers
w/ info)
