(Solved): CIS355 Quiz #1 (2022)...

Quiz #1 

Points 40 

Score for this quiz: 40 out of 40

Question 1

2 / 2 pts

True or False: An “independent data mart” requires the existence of a data warehouse to provide data content.

•   TrueCorrect!
•   False

Question 2

2 / 2 pts

True or False: If you were to build a data warehouse today, you would use almost the exact same technology as if you had built a first-generation data warehouse back in the early 1990s.

•   TrueCorrect!
•   False

Question 3

2 / 2 pts

The “E” in “EDW” stands for:

•   Error-free orrect!
•   Enterprise
•   Extended
•   None of the answer selections

Question 4

2/ 2 pts

The primary difference between a CIF architecture and a Data Warehouse Dimensional Bus architecture is:

•   The CIF has no data marts, only an EDW, while the DW Bus architecture has data martsYou Answered
•   The DW Bus architecture has an “EDW” component that contains integrated data from all sources, while the CIF has only data marts
•   The CIF architecture has an “EDW” component that contains integrated data from all sources, while the DW bus has only data marts
•   The CIF and the DW Bus architectures are identical; there are no differences between the two

Question 5

2 / 2 pts

The “front-end data mart” architecture:u Answered

•   Sends data from source applications and systems into an enterprise data warehouse, and then a subset of that enterprise data is extracted and sent to one or more data marts 
•   Sends data from source applications into data marts, and then all data from all data marts is further sent downstream to an enterprise data warehouse
•   Sends data from source applications directly into data marts, which are then “declared” to be an enterprise data warehouse even though the data marts are totally independent from one another
•   None of the answer selections are correct

Question 6

2 / 2 pts

A persistent staging layer:

•   Purges all of the staging layer data after the data has been successfully loaded into the data warehouse’s “performance layer”orrect!
•   Retains data in the staging layer, even after the data has been successfully loaded into the data warehouse’s “performance layer”
•   Is only used in data marts – never in an enterprise data warehouse
•   None of the answer selections are correct

Question 7

2 / 2 pts

True or False: “Initial ETL” is the term used when you are first loading a brand new empty data warehouse with dataect!

•   True 
•   False

Question 8

2 / 2 pts

Which ETL pattern adds recently created data but also removes or deletes the oldest data from the data warehouse?

•   Complete replacement
•   AppendCorrect!
•   Rolling append
•   In-place update

Question 9

2 / 2 pts

True or False: You are required to use the same ETL pattern (e.g., in-place update, append, etc.) on all database tables within your data warehouse; you are not permitted to “mix and match” on the same incremental ETL job.orrect!

•   False 
•   True

Question 10

2 / 2 pts

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?

•   You will store the customer data in the performance layer of the data warehouse with the same data types and sizes as in the respective sources, which means that some customer data will have the last name stored as CHAR (30) and other customer data will have the last name stored as CHAR (35). You Answered
•   You will use the “data value substitution” transformation pattern to store all customer with the same data types/sizes for the last name and first name in each database row 
•   You aren’t permitted to bring customer data with different types and sizes into the data warehouse; you instead would contact the application maintenance team for one of the two systems and have them make changes to how they store their customer data
•   None of the answer selections are true

Question 11

2 / 2 pts

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?

•   Dropping columns
•   Value-based row filteringCorrect!
•   Source data merging 
•   None of the answer selections are true

Question 12

2 / 2 pts

True or False: Address matching and standardization is a valuable ETL transformation model to ensure that you don’t have unwanted duplicate customer data in your data warehouse.

•   TrueCorrect!
•   False

Question 13

2 / 2 pts

A federated data warehouse architecture:You Answered

•   Is highly centralized and monolithic in nature 
•   Is made up of a collection of dependent data marts
•   Is made up of a collection of independent data marts
•   None of the answer selections are true

Question 14

2 / 2 pts

True or False: “Data warehouse” and “data virtualization” mean the same thing, and can be used interchangeably.

•   TrueCorrect!
•   False

Question 15

2 / 2 pts

True or False: You will never find a relational database management system (e.g., Microsoft SQL Server) being used for a data warehouse’s platform.

•   TrueCorrect!
•   False

Question 16

2 / 2 pts

True or False: An advantage of a non-persistent staging layer is that if a data warehouse performance layer “blows up” you can try to reconstruct the data warehouse’s contents from within the data warehouse, rather than having to reacquire all data from its original source applications.

•   Trueorrect!
•   False

Question 17

2 / 2 pts

“ETL” stands for:

•   Extraction, Targeting, and Loading 
•   Engineering, Transformation, and Loading
•   Engineering, Targeting, and LayoutCorrect!
•   None of the answer selections are correct

Question 18

2 / 2 pts

Which of the following “tell me…” types of business intelligence is not considered to fall under the “data mining” grouping?

•   Tell me what is likely to happenorrect!
•   Tell me what happened
•   Tell me what might have happened if we had done something differently
•   Tell me something interesting and important
•   All of the above fall under “data mining”

Question 19

2 / 2 pts

True or False: The modern era of business intelligence began a decade before the modern era of data warehousing.ou Answered

•   True
•   False

Question 20

2 / 2 pts

Which of the following is not one of the original 4 “Inmon rules” for data warehousing?

•   Subject-oriented 
•   Non-volatile 
•   Time-variant 
•   Integrated
•   All of the above are “Inmon rules”