Data Architecture & Modelling Flashcards
(24 cards)
In a recursive relationship
The foreign key must have a role name to avoid attribute duplication
Which of these is NOT a type of key found in a data model
Local key
Identify who has primary responsibility for data capture and usage design within programs
Software Architects, Developers
In Dimensional data models, which of these is NOT true regarding Measures
Measures can always be added across all dimensions
In the conceptual data model an instantiation of a particular business entity is described as:
Entity occurrence
Dimension tables
Have many columns but few rows
You need to discover possible relationships or to show data patterns in an exploratory fashion when you do not necessarily have a specific question to ask. What kind of data tool would you use to identify patterns of data using various algorithms?
Data Mining
Which of the following statements about business rules is FALSE?
Data rules cannot be shown on a data model.
What is the difference between cardinality rules and data integrity rules?
Cardinality rules define the quantity of each entity instance that can participate in a relationship between two entities and referential integrity rules ensure valid values.
The highest level of these data model types is the
Conceptual model
Complete the following statement: A business rule . . .
. . .defines constraints on what can and cannot be done.
When performing an evaluation of analytic applications, which of the following questions is least relevant to identify the level of effort needed?
Annual costs such as license, maintenance, etc.
Critical to the incremental development of the data warehouse is
a strong release management process.
One of the difficulties when integrating multiple source systems is:
determining valid links or equivalences between data elements.
Components of logical data models include
Entities, Keys, Attributes & Relationships
In a non-identifying relationship
The primary key of the parent entity becomes a foreign key in the child entity
Which of the following options is NOT an accurate characterization of Data Architecture?
The steps involved in designing a system
Which of the following is true of a recursive relationship?
It is unary
It is also referred to as self-referencing
It involves only one entity
What area do you not consider when developing a ‘data governance operating model’?
The availability of industry data models
Which of these statements has the most meaningful relationship label?
An order is composed of order lines.
The role of the Physical data model in the Metadata repository is
To describe how and where our data is stored in our systems applications or packages.
What is a Data Architecture Governance activity:
Overseeing projects
Managing architectural designs, lifecycle, and tools
Defining standards
What is considered a metric in Data Architecture governance activities?
Architecture standard compliance rate
What is a common business driver for implementing Data Architecture, as highlighted in the Data Management Body of Knowledge (DMBOK)?
Bridge between the data strategy and technology execution
