/
DMW: DM and Arch
Save to my account
Sign up
DMW: DM and Arch
View
Lect2_ DWArchitectures..pdf Flashcards
Study
1
Question
What is Data Modelling?
Answer
Data Modelling is the process of creating a visual representation of either a whole information system or parts of it to represent connections between data points and structures.
2
Question
What are the different types of Data Models?
Answer
The different types of Data Models include Conceptual Data Model, Logical Data Model, and Physical Data Model.
3
Question
What is a Conceptual Data Model?
Answer
A Conceptual Data Model defines what the system contains, is referred to as a domain model, and offers a big-picture view of what the system will contain and how it will be organized.
4
Question
Who typically develops the Conceptual Data Model?
Answer
Conceptual Data Models are usually developed or created by Business Stakeholders or Data Architects in the organization.
5
Question
What is a Logical Data Model?
Answer
A Logical Data Model defines how the system should be implemented regardless of the Database Management System, providing greater detail about the concepts and relationships in the domain under consideration.
6
Question
What attributes does the Logical Data Model indicate?
Answer
The Logical Data Model indicates data attributes such as data types and their corresponding lengths and shows the relationships among entities.
7
Question
Who typically develops the Logical Data Model?
Answer
Logical Data Models are typically developed and created by Data Architects and Business Analysts in the organization.
8
Question
What is a Physical Data Model?
Answer
A Physical Data Model defines how the system should be implemented with a specific Database Management System and provides a schema for how the data will be physically stored within a database.
9
Question
What characteristics make the Physical Data Model the least abstract?
Answer
The Physical Data Model includes database management system (DBMS)-specific properties including performance tuning.
10
Question
Who typically creates the Physical Data Model?
Answer
Physical Data Models are typically created by Database Administrators and Developers.
11
Question
What is Data Architecture?
Answer
Data Architecture describes how data is managed from collection through to transformation, distribution, and consumption, setting the blueprint for data and the way it flows through systems.
12
Question
What is the difference between Data Models and Data Architectures?
Answer
Data Models focus on detailed data representation, whereas Data Architectures encompass data management and focus on data collection, storage, and governance.
13
Question
What is the role of Data Models in Data Management?
Answer
Data Models ensure precise data design and integrity.
14
Question
What is the role of Data Architecture in Data Management?
Answer
Data Architecture is responsible for the data infrastructure setup.
15
Question
Who collaborates in the development of Data Models?
Answer
Data Architects and Administrators collaborate in the development of Data Models.
16
Question
Who collaborates in the development of Data Architectures?
Answer
Both data teams and stakeholders collaborate in the development of Data Architectures.
17
Question
What is the level of abstraction in Data Models compared to Data Architectures?
Answer
Data Models have a lower level of abstraction and are more specific, while Data Architectures have a higher level of abstraction.
18
Question
What is the end goal of implementing Data Models?
Answer
The end goal of implementing Data Models is to implement data architecture effectively.
19
Question
What is the end goal of Data Architecture?
Answer
The end goal of Data Architecture is to provide data strategy and framework.