MIS 183 Exam 1 Review

A database is an organized collection of ____ related data. A Logical B Physical C Beta D Corrupt

A Logical

Quality data can be defined as being: A unique. B inaccurate. C historical. D precise.

A unique.

____ is/are a new technology which trade(s) off storage space savings for computing time. A Dimensional modeling B Column databases C Fact tables D Snowflake schemas

B Column databases

An organization that decides to adopt the most popular NoSQL database management system would select: A Access. B MongoDB. C Neo4j. D Redis.

B MongoDB.

Which of the following advances in information systems contributed to the emergence of data warehousing? A Increase in viruses and other computer threats. B Improvements in monitor technologies. C Advances in middleware products that enabled enterprise database connectivity across heterogeneous platforms. D The invention of the iPad.

C Advances in middleware products that enabled enterprise database connectivity across heterogeneous platforms.

Which of the following organizational trends does not encourage the need for data warehousing? A Multiple, nonsynchronized systems B Focus on customer relationship management C Downsizing D Focus on supplier relationship management

C Downsizing

Datatype conflicts is an example of a(n) ____ reason for deteriorated data quality. A external data source. B inconsistent metadata C data entry problem D lack of organizational commitment

A external data source.

Informational systems are designed for all of the following EXCEPT: A running a business in real time. B supporting decision making. C complex queries. D data mining.

A running a business in real time.

An expanded version of a star schema in which all of the tables are fully normalized is called a(n): A snowflake schema B operational schema. C DSS schema. D complete schema.

A snowflake schema

The real-time data warehouse is characterized by which of the following? A It accepts batch feeds of transaction data. B Data are immediately transformed and loaded into the warehouse. C It provides periodic access for the transaction processing systems to an enterprise data warehouse. D It is based on Oracle technology.

B Data are immediately transformed and loaded into the warehouse.

____ is a tool even non-programmers can use to access information from a database A ODBC B Structured query language C ASP D Data manipulation query language

B Structured query language

____ generally processes the largest quantities of data. A Operational databases B Transaction processing C Big data D Data marts

B Transaction processing

A technique using pattern recognition to upgrade the quality of raw data is called: A data scrounging. B data scrubbing. C data gouging. D data analysis.

B data scrubbing.

The level of detail in a fact table determined by the intersection of all the components of the primary key, including all foreign keys and any other primary key elements, is called the: A span B grain. C selection. D aggregation.

B grain.

The analysis of summarized data to support decision making is called: A operational processing. B informational processing. C artificial intelligence. D data scrubbing.

B informational processing.

Because applications are often developed independently in file processing systems: A the data is always non-redundant. B unplanned duplicate data files are the rule rather than the exception. C data can always be shared with others. D there is a large volume of file I/O.

B unplanned duplicate data files are the rule rather than the exception

____ analyze the business situation and identify the need for information and information services to meet the problems or opportunities of the business. A Programmers B Users C Systems analysts D Database analysts

C Systems analysts

At a basic level, analytics refers to: A collecting data. B conducting a needs analysis. C analysis and interpretation of data. D normalizing data.

C analysis and interpretation of data.

One way to improve the data capture process is to: A allow all data to be entered manually. B provide little or no training to data entry operators. C check entered data immediately for quality against data in the database. D not use any automatic data entry routines.

C check entered data immediately for quality against data in the database.

A data mart is a(n): A enterprisewide data warehouse. B smaller system built upon file processing technology. C data warehouse that is limited in scope. D generic on-line shopping site.

C data warehouse that is limited in scope.

Data that are never physically altered once they are added to the store are called ____ data. A transient B override C periodic D complete

C periodic

The NoSQL model that incorporates 'column families' is called a: A key-value score. B document store. C wide-column store. D column-SQL database.

C wide-column store.

Organizations that utilize the file processing approach spend as much as ____ of their IS development budget on maintenance. A 40 percent B 25 percent C 60 percent D 80 percent

D 80 percent

____ includes NoSQL accommodation of various data types. A Velocity B Vigilant C Verified D Variety

D Variety

All of the following are some beneficial applications for real-time data warehousing EXCEPT: A just-in-time transportation. B e-commerce. For example, an abandoned shopping cart can trigger an email promotional message. C fraud detection in credit card transactions. D data entry.

D data entry.

A technique using artificial intelligence to upgrade the quality of raw data is called: A dumping. B data reconciliation. C completion backwards updates. D data scrubbing.

D data scrubbing.

Data that describe the properties of other data are: A relationships. B logical. C physical. D metadata.

D metadata.

One characteristic of quality data which pertains to the expectation for the time between when data are expected and when they are available for use is: A currency. B consistency. C referential integrity. D timeliness.

D timeliness.

Factless fact tables may apply when: A we are deleting sales. B we are tracking sales. C we are taking inventory of the set of possible occurrences. D we are deleting correlated data.

D we are deleting correlated data.