CIS 355Final exam study guide Questions with
verified answers
"ETL" stands for: Ans✓✓✓-Extract, Transform, Load
A "cube" is typically used for VERY large volumes of data in a data warehouse.
Ans✓✓✓-False
A "cube" is typically used for VERY large volumes of data in a data warehouse.
Ans✓✓✓-False
A best practice for non-additive facts is to: Ans✓✓✓-None of the answer
selections are correct
A federated data warehouse architecture: Ans✓✓✓-Is made up of a collection of
independent data marts
A federated EDW environment is typically comprised of a collection of Ans✓✓✓-
Independent data marts
A federated EDW environment is typically comprised of a collection of: Ans✓✓✓-
Independent data marts
A persistent staging layer: Ans✓✓✓-Retains data in the staging layer, even after
the data has been successfully loaded into the data warehouse's "performance
layer
,A ratio is typically an example of: Ans✓✓✓-A non-additive fact
A star schema: Ans✓✓✓-None of the answer selections are true
If you have two identical applications running in different parts of your company -
for example, one payroll system for your western region, and the same payroll
system software for your eastern region - which of the following ETL
transformation models would you most likely use to bring the payroll data
together in the data warehouse? Ans✓✓✓-Source data merging
In a snowflake schema, each "terminal" dimension table will contain: Ans✓✓✓-
Never more than one surrogate key column
In a snowflake schema, each "terminal" dimension table will contain: Ans✓✓✓-
Never more than one surrogate key column
In an environment that makes use of front-end data marts, the enterprise data
warehouse (EDW) component in such an environment provides which type of
business intelligence/reporting/analytics? Ans✓✓✓-Enterprise-wide strategic
reporting and BI
In an environment that makes use of front-end data marts, the enterprise data
warehouse (EDW) component in such an environment provides which type of
business intelligence/reporting/analytics? Ans✓✓✓-Enterprise-wide strategic
reporting and BI
In early-generation data warehouses, architects and planners would typically
need to make design compromises because of technology limitations. Which of
the following was not a common design compromise found in early data
, warehouses Ans✓✓✓-Incorporating front-end data marts into the overall
architecture
In early-generation data warehouses, architects and planners would typically
need to make design compromises because of technology limitations. Which of
the following was not a common design compromise found in early data
warehouses: Ans✓✓✓-Incorporating front-end data marts into the overall
architecture
In Microsoft SQL Server, you use the "REFERENCES" clause with: Ans✓✓✓-A
foreign key constraint
In the data warehousing "wholesaler-retailer" paradigm, which of the following
components can be thought of as a "retailer" of data? Ans✓✓✓-Data mart
In the data warehousing "wholesaler-retailer" paradigm, which of the following
components can be thought of as a "retailer" of data? Ans✓✓✓-Data mart
Suppose that you are bringing in customer data from one application that has the
customer's last name stored as "CHAR (30)" and the customer's first name stored
as CHAR (20)" - and then you are also bringing in customer data from another
application that has the customer's last name stored as "CHAR (35)" and the
customer's first name stored as CHAR (25)."
Which of the following statements is most true? Ans✓✓✓-You will use the "data
type/size unification" transformation pattern to store all customer with the same
data types/sizes for the last name and first name in each database row
The "E" in "EDW" stands for Ans✓✓✓-Entrprise
verified answers
"ETL" stands for: Ans✓✓✓-Extract, Transform, Load
A "cube" is typically used for VERY large volumes of data in a data warehouse.
Ans✓✓✓-False
A "cube" is typically used for VERY large volumes of data in a data warehouse.
Ans✓✓✓-False
A best practice for non-additive facts is to: Ans✓✓✓-None of the answer
selections are correct
A federated data warehouse architecture: Ans✓✓✓-Is made up of a collection of
independent data marts
A federated EDW environment is typically comprised of a collection of Ans✓✓✓-
Independent data marts
A federated EDW environment is typically comprised of a collection of: Ans✓✓✓-
Independent data marts
A persistent staging layer: Ans✓✓✓-Retains data in the staging layer, even after
the data has been successfully loaded into the data warehouse's "performance
layer
,A ratio is typically an example of: Ans✓✓✓-A non-additive fact
A star schema: Ans✓✓✓-None of the answer selections are true
If you have two identical applications running in different parts of your company -
for example, one payroll system for your western region, and the same payroll
system software for your eastern region - which of the following ETL
transformation models would you most likely use to bring the payroll data
together in the data warehouse? Ans✓✓✓-Source data merging
In a snowflake schema, each "terminal" dimension table will contain: Ans✓✓✓-
Never more than one surrogate key column
In a snowflake schema, each "terminal" dimension table will contain: Ans✓✓✓-
Never more than one surrogate key column
In an environment that makes use of front-end data marts, the enterprise data
warehouse (EDW) component in such an environment provides which type of
business intelligence/reporting/analytics? Ans✓✓✓-Enterprise-wide strategic
reporting and BI
In an environment that makes use of front-end data marts, the enterprise data
warehouse (EDW) component in such an environment provides which type of
business intelligence/reporting/analytics? Ans✓✓✓-Enterprise-wide strategic
reporting and BI
In early-generation data warehouses, architects and planners would typically
need to make design compromises because of technology limitations. Which of
the following was not a common design compromise found in early data
, warehouses Ans✓✓✓-Incorporating front-end data marts into the overall
architecture
In early-generation data warehouses, architects and planners would typically
need to make design compromises because of technology limitations. Which of
the following was not a common design compromise found in early data
warehouses: Ans✓✓✓-Incorporating front-end data marts into the overall
architecture
In Microsoft SQL Server, you use the "REFERENCES" clause with: Ans✓✓✓-A
foreign key constraint
In the data warehousing "wholesaler-retailer" paradigm, which of the following
components can be thought of as a "retailer" of data? Ans✓✓✓-Data mart
In the data warehousing "wholesaler-retailer" paradigm, which of the following
components can be thought of as a "retailer" of data? Ans✓✓✓-Data mart
Suppose that you are bringing in customer data from one application that has the
customer's last name stored as "CHAR (30)" and the customer's first name stored
as CHAR (20)" - and then you are also bringing in customer data from another
application that has the customer's last name stored as "CHAR (35)" and the
customer's first name stored as CHAR (25)."
Which of the following statements is most true? Ans✓✓✓-You will use the "data
type/size unification" transformation pattern to store all customer with the same
data types/sizes for the last name and first name in each database row
The "E" in "EDW" stands for Ans✓✓✓-Entrprise
