Information Modelling — Learn free

Self-check

Questions 1–10 of 10

1. What does Information Modelling represent?
Question 1A. Only the physical tables of one databaseB. Entities, relationships and processes within a system or organisationC. The colour scheme of a reporting dashboardD. The hardware specification of a serverE. The list of users with database access
2. In what order do the models typically appear when a project or solution starts?
Question 2A. Conceptual Model, then Logical Model, then Physical ModelB. Physical Model, then Logical Model, then Conceptual ModelC. Logical Model, then Physical Model, then Conceptual ModelD. Information Model, then Physical Model onlyE. Physical Model only, with no other models
3. Why do nerd data folks hardly get in touch with Information Modelling?
Question 3A. Because it has been made obsolete by NoSQLB. Because it is restricted to finance departmentsC. Because it sits one level above creating any specific solutionD. Because it requires a special licenceE. Because it only applies to universities
4. In the university example of Information Modelling, which entities does the Admissions conceptual model include?
Question 4A. Budget and ExpenditureB. Student Information and GradesC. Lecturer and ClassroomD. Applicant and Admission DecisionE. Library and Book
5. In the university example, which department's logical model details tables for Budget and Expenditure?
Question 5A. AdmissionsB. Student ServicesC. LibraryD. Human ResourcesE. Finance
6. What does the Information Modelling perspective focus on in the university example?
Question 6A. How data flows seamlessly across the departments and how their data relatesB. Which relational database vendor each department should buyC. How to reduce the number of students admittedD. The physical layout of the campus networkE. The salaries of departmental staff
7. Which is an example of a Process considered by Information Modelling?
Question 7A. Choosing a table's primary keyB. How an admitted student's information transitions from Admissions to Student ServicesC. Defining a column's data typeD. Selecting an index for a tableE. Naming a database schema
8. Which kind of overarching rule does Information Modelling identify?
Question 8A. The maximum length of a table nameB. The order of columns in a reportC. Ensuring data consistency across departments or compliance with privacy regulationsD. The font used on invoicesE. The number of servers in a cluster
9. Which of the following is NOT a focus of Information Modelling as described?
Question 9A. Relationships between data in different departmentsB. End-to-end processes involving dataC. Overarching rules such as consistency and complianceD. Choosing the specific relational database technology for one departmentE. How information is organised, flows and is utilised within an organisation
10. In essence, what kind of view does Information Modelling provide?
Question 10A. A detailed view of one table's columnsB. A view limited to a single applicationC. A snapshot of server performanceD. A list of user login attemptsE. A panoramic view of how data traverses a system or entire organisation, linking components, processes and rules