BHIS 410 FINAL EXAM REVIEW UPDATED ACTUAL
QUESTIONS AND CORRECT ANSWERS
Question:
1. With regard to an Entity-Relationship diagram, an Attribute will be physically exhibited within a
database as a:
Answer:
Field or Column
Question:
2. Metadata is:
Answer:
Data about data in the data model for a given database
Question:
3. A standard for exchange of clinical and administrative data at the application layer level of the ISO/OSI
network model is:
Answer:
H7L
Question:
4. 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
Question:
5. Each of the following is included in an Entity-Relationship Diagram EXCEPT:
Answer:
processes
Question:
6. The process of standardizing data collected from diverse sources is called:
Answer:
data transformation
Question:
7. A primary key is a field that may have the same value in several different records within a table.
True or false
Answer:
false
Question:
8. A clinical data repository (in contrast to a clinical data warehouse) is optimized for what purpose?
, Answer:
processing many transactions
Question:
9. Which of the following is typically responsible for physical database design during database
implementation?
Answer:
database administrator
Question:
10. 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
Question:
11. Which of the following stores "data about data", or metadata?
Answer:
data dictionary
Question:
12. One reason for using a star join schema data model rather than an Entity-Relationship model for OLAP
is:
Answer:
accuracy is enhanced
Question:
13. Topology refers to:
Answer:
Arrangement of a network
Question:
14. Which of the following best defines the data model?
Answer:
graphic representation of entities and attributes in the database
Question:
15. A network that transmits data through secure "tunnels" within public networks is a:
Answer:
VPN
Question:
16. 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
QUESTIONS AND CORRECT ANSWERS
Question:
1. With regard to an Entity-Relationship diagram, an Attribute will be physically exhibited within a
database as a:
Answer:
Field or Column
Question:
2. Metadata is:
Answer:
Data about data in the data model for a given database
Question:
3. A standard for exchange of clinical and administrative data at the application layer level of the ISO/OSI
network model is:
Answer:
H7L
Question:
4. 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
Question:
5. Each of the following is included in an Entity-Relationship Diagram EXCEPT:
Answer:
processes
Question:
6. The process of standardizing data collected from diverse sources is called:
Answer:
data transformation
Question:
7. A primary key is a field that may have the same value in several different records within a table.
True or false
Answer:
false
Question:
8. A clinical data repository (in contrast to a clinical data warehouse) is optimized for what purpose?
, Answer:
processing many transactions
Question:
9. Which of the following is typically responsible for physical database design during database
implementation?
Answer:
database administrator
Question:
10. 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
Question:
11. Which of the following stores "data about data", or metadata?
Answer:
data dictionary
Question:
12. One reason for using a star join schema data model rather than an Entity-Relationship model for OLAP
is:
Answer:
accuracy is enhanced
Question:
13. Topology refers to:
Answer:
Arrangement of a network
Question:
14. Which of the following best defines the data model?
Answer:
graphic representation of entities and attributes in the database
Question:
15. A network that transmits data through secure "tunnels" within public networks is a:
Answer:
VPN
Question:
16. 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