ACC200 Ch7 Set 3 REVERSED

Question 1

each spreadshhet in an organisation be assigned a unique identifier

Answer 1

Spreadsheet identifier (SSID)

Question 2

a type of advanced data analytics used to support business decision making.

Answer 2

Busiess Intelligence Technologies

Question 3

Fig7.16 pg276

Answer 3

Global spreadsheet query

Question 4

Fig7.17 pg277

Answer 4

BI Technologies

Question 5

a dimensional database has one fact table as its center. A relational database does not have one central database table. Instead, it resembles an interlocking chain, linked together without a center.

Answer 5

Relational database or dimensional database

Question 6

data warehouse

Answer 6

How is data stored using BI technologies

Question 7

1) fact table
2) dimension table

Answer 7

Two types of database in the dimensional database?

Question 8

Fig7.22 pg280

Answer 8

MS SQL server Relational Database

Question 9

has one fact table & two or more dimension (DIM) tables

Answer 9

Dimensional database

Answer 10

Primary key

Question 11

a referential constraint between two tables. A foreign key is a field in a relational table that matches a candidate key of another table. The foreign key can be used to cross-reference tables.

Answer 11

Foreign key

Question 12

Two types of dimensional database structures. Both have one fact table at the centre in a star structure, the dimension database tables are all related onl to the central fact table, creating a star shape.

In a snowflake structure the dimension tables relate to the fact table like a snowflake. There is one inner circle of dimension tables & additional dimension tables are related to the inner dimension tables. At most, a query traverses only three tables.

Answer 12

Star & Snowflake

Question 13

includes data transferred from the operational database; can also include data from other sources, including shadow data; may contain duplication & inconsistencies.

Answer 13

Data warehouse

Question 14

• extracted from the relational database
• reorganised into dimensions
• transferred & loaded into data warehouse tables

Answer 14

To perform BI analytics, the data must be

Question 15

Fig7.23 pg281

Answer 15

Dimensional Database Star Structure

Question 16

The word fact is added to the database fact table name. Dim is added to the dimension database table names.

Answer 16

Difference between fact and dimension table

Question 17

a step-by-step solution to a problem

Answer 17

Algorithm

Question 18

Fig7.24 pg 282

Answer 18

ETL for Loading DimSalesTerritory Table Using MS SQL Server

Question 19

typically used on relatively unstructured data; can be used to mine text stored in various enterprise documents, including emails, word processing documents & reports.

Answer 19

Text mining

Question 20

searches the Internet for specific paterns on Web sites

Answer 20

Web mining