BHIS 410 FINAL EXAM REVIEW QUESTIONS AND
ANSWERS RATED 100% CORRECT!!
With regard to an Entity-Relationship diagram, an Attribute will be physically
exhibited within a database as a: Answer - Field or Column
Metadata is: Answer - Data about data in the data model for a given database
A standard for exchange of clinical and administrative data at the application
layer level of the ISO/OSI network model is: Answer - H7L
The architectural model of a Health Information Exchange (HIE) where the HIE
organization manages data centrally but stored in separate repositories is
called: Answer - Federated - consistent databases
Each of the following is included in an Entity-Relationship Diagram EXCEPT:
Answer - processes
The process of standardizing data collected from diverse sources is called:
Answer - data transformation
A primary key is a field that may have the same value in several different
records within a table.
, True or false Answer - false
A clinical data repository (in contrast to a clinical data warehouse) is optimized
for what purpose? Answer - processing many transactions
Which of the following is typically responsible for physical database design
during database implementation? Answer - database administrator
All of the following are true of the HIPAA Security Standard Except: Answer -
Small organizations will have difficulty meeting the standard due to its specific
technology requirements
Which of the following stores "data about data", or metadata? Answer - data
dictionary
One reason for using a star join schema data model rather than an Entity-
Relationship model for OLAP is: Answer - accuracy is enhanced
Topology refers to: Answer - Arrangement of a network
Which of the following best defines the data model? Answer - graphic
representation of entities and attributes in the database
A network that transmits data through secure "tunnels" within public networks
is a: Answer - VPN
Which database structure is constructed using tables that do not specify how
to retrieve the required data or navigate through predefined paths? Answer -
relational database
ANSWERS RATED 100% CORRECT!!
With regard to an Entity-Relationship diagram, an Attribute will be physically
exhibited within a database as a: Answer - Field or Column
Metadata is: Answer - Data about data in the data model for a given database
A standard for exchange of clinical and administrative data at the application
layer level of the ISO/OSI network model is: Answer - H7L
The architectural model of a Health Information Exchange (HIE) where the HIE
organization manages data centrally but stored in separate repositories is
called: Answer - Federated - consistent databases
Each of the following is included in an Entity-Relationship Diagram EXCEPT:
Answer - processes
The process of standardizing data collected from diverse sources is called:
Answer - data transformation
A primary key is a field that may have the same value in several different
records within a table.
, True or false Answer - false
A clinical data repository (in contrast to a clinical data warehouse) is optimized
for what purpose? Answer - processing many transactions
Which of the following is typically responsible for physical database design
during database implementation? Answer - database administrator
All of the following are true of the HIPAA Security Standard Except: Answer -
Small organizations will have difficulty meeting the standard due to its specific
technology requirements
Which of the following stores "data about data", or metadata? Answer - data
dictionary
One reason for using a star join schema data model rather than an Entity-
Relationship model for OLAP is: Answer - accuracy is enhanced
Topology refers to: Answer - Arrangement of a network
Which of the following best defines the data model? Answer - graphic
representation of entities and attributes in the database
A network that transmits data through secure "tunnels" within public networks
is a: Answer - VPN
Which database structure is constructed using tables that do not specify how
to retrieve the required data or navigate through predefined paths? Answer -
relational database
