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.