WGU D514 EXAMS TEST PAPER QUESTIONS AND
ANSWERS SET A+
✔✔Network Database Model - ✔✔Data is connected through pointers, and unlike the
hierarchical model that has one "parent" to one "child," a "child" can have multiple
"parents." Multiple records can be linked to the same owner. This model is more difficult
to implement and maintain but more flexible than the hierarchical model. It allows many-
to-many relationships.
✔✔Multidimensional Database - ✔✔This is a hybrid between hierarchical and relational,
capturing the benefits of both so that large amounts of data can be processed quickly.
You have the ability to process various data attributes at a time, including within various
hierarchies and levels. If you need large amounts of data in a short time, this database
would be useful to you.
✔✔Transactional Database - ✔✔This is a database management system that has the
capability to roll back or undo a database transaction or operation if it is not completed
appropriately. Although this was a unique capability several decades ago, today, the
majority of relational database systems support transactional database operations.
✔✔Data Warehouses - ✔✔But, they want to be able to share their data among all of
their facilities. They would have a data warehouse into which all of these different
technologies could be loaded, and a common language standard would be used in
order for all of these different systems to "talk" to each other, to "translate" the data into
a common language.
By doing this, data could be pulled from all sources for reports and stats. Data
warehouses are critical to the success of analytics, because they hold huge amounts of
data to be used, and having the common language allows that. It is all very techy on
that end, but makes analytics possible for managers and others running reports at the
operational level.
✔✔Rollup Query - ✔✔It is not a type of database; a rollup query is a process that drills
down into data at many levels, giving the researcher a higher-level view of the data.
, This would be very beneficial when performing data analytics and looking at huge
amounts of data.
✔✔Data Warehouse - ✔✔A business intelligence analyst at a multistate healthcare
system is developing reports for clinical quality-improvement projects and best practice
guideline development. The best practice guidelines will be used across the entire
multistate system.
Which type of database should be used to gather and analyze data for the reports
needed?
✔✔Trauma registry - ✔✔The chief medical officer of emergency services is
investigating the number of gunshot victims seen in their emergency department in the
past two years, for their hospital.
Which type of database should be used to locate this data?
✔✔Object oriented - ✔✔A group of speech pathologists from several facilities within the
same large healthcare system is doing a research study on children who stutter. They
want to share their audio files across their interoperable databases as they work on this
study together.
Which database should they use?
✔✔True - ✔✔If you were constructing a database for a research project, de-identifying
patient information would be an important consideration in protecting patient privacy.
True or False
✔✔Research identified - ✔✔A clinical research associate is comparing data on study
patients and their response to a clinical-trial drug for patients with fibromyalgia. The
patients were enrolled six months ago. The associate is comparing data from when the
patients were first enrolled in the study to today.
Which type of database is the associate using?
✔✔Current lengths of stay for patients after CABG; this data will provide a baseline
trend of current practice.
Number of providers providing direct care for patients post CABG per day; knowledge of
the extent of human resources used for this patient population will be used to analyze
current provider service patterns - ✔✔The vice president of operations of a medical
facility in Jackson, Mississippi, seeks to improve the efficiency, effectiveness, equity,
and timeliness of patient care at the facility. Over the past month, 150 patients have
undergone coronary artery bypass graft (CABG) surgery. These patients require
significant resources and are occupying the majority of beds in the facility, on average,
with an eight-day post-procedure length of stay. Currently, the facility has no
established standardized protocol guiding physicians on postoperative care.
The chief medical officer (CMO) is concerned about the situation and sees this as an
opportunity to perform data analysis and make recommendations based on the results.
ANSWERS SET A+
✔✔Network Database Model - ✔✔Data is connected through pointers, and unlike the
hierarchical model that has one "parent" to one "child," a "child" can have multiple
"parents." Multiple records can be linked to the same owner. This model is more difficult
to implement and maintain but more flexible than the hierarchical model. It allows many-
to-many relationships.
✔✔Multidimensional Database - ✔✔This is a hybrid between hierarchical and relational,
capturing the benefits of both so that large amounts of data can be processed quickly.
You have the ability to process various data attributes at a time, including within various
hierarchies and levels. If you need large amounts of data in a short time, this database
would be useful to you.
✔✔Transactional Database - ✔✔This is a database management system that has the
capability to roll back or undo a database transaction or operation if it is not completed
appropriately. Although this was a unique capability several decades ago, today, the
majority of relational database systems support transactional database operations.
✔✔Data Warehouses - ✔✔But, they want to be able to share their data among all of
their facilities. They would have a data warehouse into which all of these different
technologies could be loaded, and a common language standard would be used in
order for all of these different systems to "talk" to each other, to "translate" the data into
a common language.
By doing this, data could be pulled from all sources for reports and stats. Data
warehouses are critical to the success of analytics, because they hold huge amounts of
data to be used, and having the common language allows that. It is all very techy on
that end, but makes analytics possible for managers and others running reports at the
operational level.
✔✔Rollup Query - ✔✔It is not a type of database; a rollup query is a process that drills
down into data at many levels, giving the researcher a higher-level view of the data.
, This would be very beneficial when performing data analytics and looking at huge
amounts of data.
✔✔Data Warehouse - ✔✔A business intelligence analyst at a multistate healthcare
system is developing reports for clinical quality-improvement projects and best practice
guideline development. The best practice guidelines will be used across the entire
multistate system.
Which type of database should be used to gather and analyze data for the reports
needed?
✔✔Trauma registry - ✔✔The chief medical officer of emergency services is
investigating the number of gunshot victims seen in their emergency department in the
past two years, for their hospital.
Which type of database should be used to locate this data?
✔✔Object oriented - ✔✔A group of speech pathologists from several facilities within the
same large healthcare system is doing a research study on children who stutter. They
want to share their audio files across their interoperable databases as they work on this
study together.
Which database should they use?
✔✔True - ✔✔If you were constructing a database for a research project, de-identifying
patient information would be an important consideration in protecting patient privacy.
True or False
✔✔Research identified - ✔✔A clinical research associate is comparing data on study
patients and their response to a clinical-trial drug for patients with fibromyalgia. The
patients were enrolled six months ago. The associate is comparing data from when the
patients were first enrolled in the study to today.
Which type of database is the associate using?
✔✔Current lengths of stay for patients after CABG; this data will provide a baseline
trend of current practice.
Number of providers providing direct care for patients post CABG per day; knowledge of
the extent of human resources used for this patient population will be used to analyze
current provider service patterns - ✔✔The vice president of operations of a medical
facility in Jackson, Mississippi, seeks to improve the efficiency, effectiveness, equity,
and timeliness of patient care at the facility. Over the past month, 150 patients have
undergone coronary artery bypass graft (CABG) surgery. These patients require
significant resources and are occupying the majority of beds in the facility, on average,
with an eight-day post-procedure length of stay. Currently, the facility has no
established standardized protocol guiding physicians on postoperative care.
The chief medical officer (CMO) is concerned about the situation and sees this as an
opportunity to perform data analysis and make recommendations based on the results.
