(Solved): CIS 355 Midterm Exam | Points 100 | Attempt 1 - Score for this quiz: 100 out of 100...

CIS 355 Midterm Exam 

Points 100 |  Questions 25 

 Attempt 1
Score for this quiz: 100 out of 100

Time Limit 75 Minutes

 
Question 1
4 / 4 pts
Which of the following is not a common incremental ETL pattern?

• In-palce updates
• Virtual append
• Complete replacement
• All of the above are common incremental ETL patterns

  
Question 2
4 / 4 pts
True or False: “Data Virtualization” is a related but different approach to building a “Data Warehouse” – the two terms do not mean exactly the same.

• True
• False

  
Question 3
4 / 4 pts
Which of the following is not one of the four original “Bill Inmon Rules” for data warehousing:

• Integrated
• Time-variant
• Dimensional data
• All of the answer selections are among the four original “Bill Inmon Rules”

 
 
Question 4
4 / 4 pts
True or False: all enterprise data warehouses are built using relational databases, while all data marts are built using cubes.

• True
• False

  
Question 5
4 / 4 pts
In early-generation data warehouses, architects and planners would typically need to make design compromises because of technology limitations. Which of the following was a common design compromise found in early data warehouses:

• Building centralized rather than component-based data warehouses
• Aggregation rather than individual transaction data
• Incorporating front-end data marts into the overall architecture
• All of the answer selections were early-generation DW design compromises

  
Question 6
4 / 4 pts
Today’s enterprise-scale data warehouses commonly receive data from _____ (number) of source applications:

• No more than ten
• Thousands
• Hundreds of thousands
• None of the answer selections are correct

  
Question 7
4 / 4 pts
True or False: Today’s data warehouses can easily support many terabytes of data.

• True
• False

 
Question 8
4 / 4 pts
Which of the following is one of the common “flavors” or types of business intelligence (BI)?

• Tell me what happened, and why
• Tell me what is likely to happen (predictive analytics)
• Tell me something interesting and important
• All of the answer selections are common “flavors” or types of BI

 
 
Question 9
4 / 4 pts
The unlabeled “disk symbol” on the right side of the diagram could represent which one or more of the following:

• A. An independent data mart
• B. A dependent data mart
• C. A centralized data warehouse
• Answers (A) and (C) both are correct
• Answers (B) and (C) both are correct
• Answers (A), (B), and (C) are all correct

 
 
Question 10
4 / 4 pts
True or False: A multidimensional database “cube” is commonly used rather than a relational database when an organization has exceptionally large volumes of data to include in the data warehouse.

• True
• False

Question 11
4 / 4 pts
In the data warehousing “wholesaler-retailer” paradigm, which of the following components can be thought of as a “supplier” of data?

• Source application
• Data warehouse
• Data mart
• Business Intelligence (BI) users

 
Question 12
4 / 4 pts
True or False: An independent data mart is architecturally identical to a data warehouse.

• True
• False

Question 13
0 / 4 pts
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?

• Organization-specific operational reporting
• Enterprise-wide strategic reporting and BI
• Organization-specific predictive analytics
• None of the answer selections are correct

 
 
Question 14
4 / 4 pts
True or False: When you have an enterprise data warehouse that feeds data to dependent data marts, every dependent data mart must have its data organized dimensionally to support “classic” business intelligence and online analytical processing (OLAP). You would never feed data from an EDW into a data mart that is structured to support data mining.

• True
• False

 
Question 15
4 / 4 pts
We’ve discussed how one particular relational database capability created difficulties for early-generation relational databases, and how significant work needed to occur in RDBMS products to give RDBMSs satisfactory performance for data warehousing. What relational database capability is this?

• CREATE TABLE
• WHERE clauses
• JOIN operations
• None of the answer selections

 
 
Question 16
4 / 4 pts
True or False: We typically do not delete all information about a customer in a data warehouse or data mart even if that customer has been deleted from a source application.

• True
• False

 
Question 17
4 / 4 pts
Two common ETL transformation models are:

• Data hubs and source merging
• Non-persistent staging layers and de-duplication
• Address matching/standardization and data virtualization
• Dropping columns and value based row/record filtering

 
 
Question 18
4 / 4 pts
When we refer to a relational database management system (RDBMS) as sort of a “Swiss Army Knife” for data management, we mean:

• An RDBMS can only support analytical processing
• An RDBMS can only support transactional processing
• An RDBMS can be built using either physical pointers among database tables or logical relationships among database tables
• None of the answer selections are correct

  
Question 19
4 / 4 pts
True or False: “ETL” is an important aspect of data warehousing, and is an acronym for several combinations of words; one of those combinations is “Extraction, Transaction, and Loading.”

• True
• False

Question 20
4 / 4 pts
True or False: “Front end data marts” and “Dependent data marts” are the same thing.

• True
• False

Question 21
4 / 4 pts
True or False: a “Foreign Key” in a relational database table is the formal name for the unique identifier of any given row in that table.

• True
• False

 
Question 22
4 / 4 pts
True or False: a “star join” is a technical means for a relational database management system to efficiently join data from potentially a large number of database tables , typically when a database is being used for data warehousing purposes.

• True
• False

Question 23
4 / 4 pts
True or False: In a Corporate Information Factory (CIF) approach to component-oriented data warehousing, users access data from either the EDW component or the data marts, whichever suits their needs best.

• True
• False

 
 
Question 24
4 / 4 pts
You will find which of the following in the Federated EDW architectural approach:

• A. An architected, component-oriented data warehousing environment
• B. Independent data marts
• C. An integrated, centralized EDW
• A and B above
• A and C above
• B and C above
• A, B, and C above
• None of the answer selections are correct

 
Question 25
4 / 4 pts
True or False: a “cube” used for data warehousing could have more than 3 dimensions, despite the usage of the “cube” term.

• True
• False