Can someone answer these database questions? 1 - Data _____ implies that all bus
ID: 3842958 • Letter: C
Question
Can someone answer these database questions?
1 - Data _____ implies that all business entities, data elements, data characteristics, and business metrics are described in the same way throughout the enterprise.
2 - _____ can serve as a test vehicle for companies exploring the potential benefits of data warehouses.
3 - Bill Inmon and Chuck Kelley created a set of 12 rules to define a(n) _____.
4 - The basic star schema has four components: facts, _____, attributes, and attribute hierarchies.
5 - Computed or derived facts, at run time, are sometimes called _____ to differentiate them from stored facts.
6 - In a star schema, attributes are often used to search, filter, or classify _____.
7 - The attribute hierarchy provides a top-down data organization that is used for two main purposes: _____ and drill-down/roll-up data analysis.
8 - In star schema representation, a fact table is related to each dimension table in a _____ relationship.
9 - Fact and dimension tables are related by _____ keys.
10 - In a typical star schema, each dimension record is related to thousands of _____ records.
11 - A _____ schema is a type of star schema in which dimension tables can have their own dimension tables.
12 - _____ splits a table into subsets of rows or columns and places the subsets close to the client computer to improve data access time.
13 - The reliance on _____ as the design methodology for relational databases is seen as a stumbling block to its use in OLAP systems.
14 - Decision support data tend to be non-normalized, _____, and pre-aggregated.
15 - _____ extends SQL so that it can differentiate between access requirements for data warehouse data and operational data.
16 - A _____ index is based on 0 and 1 bits to represent a given condition.
17 - Conceptually, MDBMS end users visualize the stored data as a three-dimensional cube known as a _____.
18 - An multidimensional database management systems (MDBMS) uses proprietary techniques to store data in _____ n-dimensional arrays.
19 - A _____ is a dynamic table that not only contains the SQL query command to generate the rows, but also stores the actual rows.
Explanation / Answer
1 - Data _____ implies that all business entities, data elements, data characteristics, and business metrics are described in the same way throughout the enterprise.
Ans)Integration
2 - _____ can serve as a test vehicle for companies exploring the potential benefits of data warehouses.
Ans) Data marts
3 - Bill Inmon and Chuck Kelley created a set of 12 rules to define a(n) _____.
Ans)data warehouse
4 - The basic star schema has four components: facts, _____, attributes, and attribute hierarchies.
Ans)dimensions
5 - Computed or derived facts, at run time, are sometimes called _____ to differentiate them from stored facts.
Ans)metrics
6 - In a star schema, attributes are often used to search, filter, or classify _____.
Ans)facts
7 - The attribute hierarchy provides a top-down data organization that is used for two main purposes: _____ and drill-down/roll-up data analysis.
Ans)Aggregation
8 - In star schema representation, a fact table is related to each dimension table in a _____ relationship.
Ans)many to one
9 - Fact and dimension tables are related by _____ keys.
Ans)foreign
10 - In a typical star schema, each dimension record is related to thousands of _____ records.
Ans)fact
11 - A _____ schema is a type of star schema in which dimension tables can have their own dimension tables.
Ans)snowflake
12 - _____ splits a table into subsets of rows or columns and places the
subsets close to the client computer to improve data access time.
Ans)Partitioning
13 - The reliance on _____ as the design methodology for relational databases is seen as a stumbling block to its use in OLAP systems.
Ans)Normalization
14 - Decision support data tend to be non-normalized, _____, and pre-aggregated.
Ans)Duplicated
15 - _____ extends SQL so that it can differentiate between access requirements for data warehouse data and operational data.
Ans)Rolap
16 - A _____ index is based on 0 and 1 bits to represent a given condition.
Ans)Bit mapped
17 - Conceptually, MDBMS end users visualize the stored data as a three-dimensional cube known as a _____.
Ans)Data Cube
18 - An multidimensional database management systems (MDBMS) uses proprietary techniques to store data in _____ n-dimensional arrays.
Ans)matrix
19 - A _____ is a dynamic table that not only contains the SQL query command to generate the rows, but also stores the actual rows.
Ans)Meterialized view
____________Plz Could You rate me Well.Thank You