Accounting Chapter 7 2 Which of the following is considered a disadvantage of shadow data

3) Software called ________ translates data analysis query commands into commands that are

compatible with RDBMS commands.

4) Businesses are turning to complex mathematical formulas, called ________, to analyze data to

make better decisions.

5) Quantitative data answers which question?

A) What?

B) How much?

C) Where?

D) Why?

6) Shadow data may be stored in

A) MS Access

B) Lotus Notes

C) Emails

D) All the above

7) Shadow data is vulnerable to

A) Data analysis

B) Unauthorized access

C) Data collection

D) Manipulation

8) Open Database Connectivity

A) Performs analysis on shadow data

B) Performs analysis on data in a relational database

C) Provides a visual image of the data

D) Translates query commands into commands compatible to RDBMS commands

9) An analysis tool NOT designed for software spreadsheets is

A) AutoFilter

B) PivotTables

C) Subtotal

D) Neural networks

10) A shadow data dashboard in an Excel spreadsheet can be created using

A) AutoFilter and PivotCharts

B) Conditional Formatting and Subtotal

C) PivotTables and PivotCharts

D) PivotTables and Conditional Formatting

11) Which of the following is considered a disadvantage of shadow data?

A) Spreadsheets are outside the formal data systems under IT control.

B) An accounting professional can develop the spreadsheet solution when needed.

C) Spreadsheets have extensive analytic features.

D) Spreadsheets offer reporting features that do not require custom programming.

12) A spreadsheet identifier is

A) The name of the spreadsheet file and is not unique

B) An identification assigned to a spreadsheet that is unique throughout the enterprise

C) A password that allows viewing and editing permissions to a spreadsheet

D) A password that allows viewing permissions to a spreadsheet

13) Why are shadow data spreadsheets created?

14) Why are spreadsheets popular for performing data analysis?

15) What is the purpose of Open DataBase Connectivity (ODBC) software?

16) What are some of the data analysis tools available for software spreadsheets, such as MS

Excel?

17) What are the advantages of shadow data?

18) What are the disadvantages of shadow data?

19) What are three ways of standardizing and securing shadow data spreadsheets within an

organization?

1) Business Intelligence Technologies are a type of advanced data analytics used to support

business decision making.

2) Large data warehouses usually store data using a dimensional database structure.

3) The dimension tables in a star database are dimensions of the database, such as time

dimension, product information, sales territory, and currency.

4) In a dimensional database with a star structure, a query traverses only three tables.

5) Foreign keys in a dimensional table are primary keys in a fact table.

6) A data warehouse may contain data duplication and inconsistencies.

7) A dimensional database has one ________ table and two or more dimension (Dim) tables.

8) The primary keys of the dimension tables are foreign keys in the ________ at the center of the

star.

9) ________ tools convert data into the dimensional structure required for a data warehouse.

10) ________ techniques rely on pattern recognition, clustering, and neural networks.

11) ________ searches the internet for specific patterns on web sites.

12) A ________ graphically represents BI, allowing the user to manipulate data and view the

resulting changes.

13) No matter how complex the BI technologies, the role of the accounting professional typically

involves only the ________ tool.

14) Business intelligence technologies are

A) Just another form of unsecured shadow data

B) Are usually controlled by accounting professionals

C) A type of advanced data analytics used to support business decision making

D) Consist of database queries that take a long time to run

15) A data warehouse can be thought of as

A) A location to store shadow data

B) A staging area for data analysis

C) A cluster of operational databases

D) Unused data archived for historical purposes

16) In a dimension table, the primary keys are

A) Optional

B) Foreign keys in the fact table

C) Required to add the word Dim to the field name

D) Foreign keys in the dimension tables

17) In a dimensional database with a star structure

A) The dimension database tables are all related only to the central fact table

B) There is one inner circle of dimension tables and additional dimension tables are related to the

inner dimension tables

C) Queries traverse at least three tables

D) A and C

18) A dimensional database structure

A) Is almost identical to the relational database structure

B) Is overly complex and seldom used

C) Allows for faster retrieval of massive amounts of data

D) Only contains data from operational databases

19) What is a dimensional database? When/where is this type of database usually used?

20) What is the difference between the star and snowflake structures of dimensional databases?

21) Why can data in a dimensional database with a star or snowflake structure be retrieved more

quickly than from a relational database?

22) What the difference between a relational database and a dimensional database?

23) What are the intelligent components used in BI technologies?

24) What is web mining? Provide an example.

25) What are the advantages of business intelligence technologies?

26) What are the disadvantages of business intelligence technologies?

1) How data is extracted and transferred depends on the database structure.

2) The electronic tags used by XBRL permit the user to slice and dice data for multidimensional

data analysis.

3) Electronic tags used by ________ permit data analysis of multidimensional data.

4) Which language is usually used to query a relational database?

A) SQL

B) XBRL

C) HTML

D) SHTML

5) Which type of database architecture is more suited for business intelligent technologies?

A) Dimensional database architecture

B) Relational database architecture

C) Network database architecture

D) Hierarchical database architecture

6) Shadow data

A) Is supported by the IT department

B) Takes three to six months to implement

C) Usually is not SOX compliant

D) Provides interactive reporting

7) Business intelligence technology

A) Typically has one user

B) Integrates data from operational database and data warehouse

C) Usually is not documented

D) Is quick to implement

8) Compare business intelligence technologies to shadow data.