IT EXAM ONE REVIEW QUESTIONS
Why were data warehouses created?
-Numbers and type of operational databases increased as businesses grew -many companies had information scattered across multiple systems with different formats -completing reporting requests from numerous operational systems took days or weeks
_________ are unique in that they can create a three-dimensional object made of various materials.
3D Printer
Which of the following is NOT an office suite?
Adobe Creative
which of the following occurs during data cleansing? -clean missing records -clean redundant records -clean inaccurate data
All of these
Which of the following products would you choose if you wanted to edit videos?
Apple Final Cut Pro
Both fingerprint scanners and facial recognition are examples of
Biometrics
The most fundamental unit of computing is the __________ , which is typically represented as a 1 or a 0.
Bit
Which optical disc typically holds 25 GB or 50 GB of data?
Blu-ray
You are shopping for a new computer online. The description lists the following: "Intel i73630QM." What part of the computer does that refer to?
CPU
the primary purpose of a data warehouse is to ________________.
Combine strategic information
which of the following is an example of an external database in the data warehouse model?
Competitor information
The quality of a printer's output is measured in:
DPI Dots per inch
If you want to know the maximum number of pixels that a monitor can display on the screen, you would look at its:
DPI-Resolution
______ occurs when a company examines its data to determine if it can meet business expectations, while identifying possible data gaps or where missing data might exist.
Data gap analysis
________includes the tests and validations used to determine compliance with data governance policies to ensure correctness of data.
Data governance
what is the ultimate outcome of a data warehouse?
Data marts
Recording the same piece of information in multiple places is called
Data redundancy
________ is the management and oversight of an organization's data assets to help provide business users with high-quality data that is easily accessible in a consistent manner.
Data stewardship
_______ maintains information about various types of objects, events, people, and places
Database
The ability to automatically print to both sides of a piece of paper is known as __________ .
Duplexing
Which type of printer should you purchase if your company needs to print employee ID cards?
Dye-sub
Which type of keyboard is designed to be comfortable and help reduce the chance of hand and wrist strain?
Ergonomic
Which of the following is NOT a popular computer programming language?
Exchange
Application software is made for the computer's proper operation, while system software aims to make users more productive
F
Because of their high speeds and the sharp-looking text they produce, dot matrix printers are preferred by modern businesses.
F
Database has only one logical view but supports multiple physical views
F
Managers in sales, marketing, human resources, and management do not need information to run their departments and make daily decisions
F
One gigabyte is larger than one terabyte.
F
One primary goal of a database is to record each piece of information in multiple places in the database
F
Organizations need to capture and store analytical information to perform operational tasks and repetitive decisions such as analyzing daily sales reports and production schedules.
F
The most popular format for file compression is known as CRM
F
The network is the most prevalent data models for organizing information.
F
Transactional information is useful when making important decisions such as whether the organization should build a new manufacturing plant or hire additional sales personal.
F
Transactional information makes it possible to do many things that previously were difficulty to accomplish, such as spot business trends, prevent diseases, and fight crime.
F
Data warehouses struggle with combining too much standardized information
False
according to Gartner Inc., dirty data is a MIS problem, not a business problem
False
the complete removal of dirty data from a source is practical and possible
False
A data warehouse is a central location in which data is stored and managed
False - a data warehouse is a collection of data from a variety of sources used to support decision making applications and general business intelligence
The primary purpose of a data warehouse is to perform transactional processes
False - analytical
A data miner contains a subset of data warehouse information
False - data mart
ETL, within a data warehouse model, stands for exit, track, and load
False - extraction, transformation, and loading
One of the following is NOT one of the advantages of rational database
Increase information redundancy
Which one of the following is NOT one of the four traits of information?
Information granularity
_____refers to the extent of details within the information (fine and detailed or coarse and abstract)
Information Granularity
Occurs when the same data element has different values.
Information inconsistency
_______is a measure of the quality of information
Information integrity
Which one of the following is one of the four traits of information?
Information quality
what is extraction, transformation, and loading?
It is a process that extracts information from internal and external databases, transforms it using a common set of enterprise definitions, and loads it into a data warehouse
A data warehouse is a _________ collection of information, gathered from many different ___________ databases, that supports business analysis activities and decision-making tasks.
Logical, Operational
The __________ is the largest circuit board in a personal computer.
Motherboard
__________ combine either inkjet or laser printing capabilities with scanning, photocopying, and faxing capabilities.
Multifunction
A technology known as __________ can translate the image of a scanned document into text that can be edited and formatted.
OCR- Optical Character Recognition
what do data warehouses support?
OLAP and analytical processing
Which of the following is incorrect in terms of data warehousing and business intelligence? Information from other operational applications is not included Operational systems are integrated Operational information is mainly current Operational information frequently has quality issues
Operational systems are integrated
Which of the following is a DBMS (Database management system) that you might find a large business using?
Oracle
A(n) __________ is software designed to keep individuals organized.
PIM (Personal Information Manangement)
The USB __________ is the most popular type of plug found on desktop and laptop computers.
Port
__________ is the temporary workspace of a computer. It stores the content you are currently working on.
Ram - Random Access Memory
________stores information in the form of logically related two- dimensional table
Rational database model
Which type of software is used for entering, calculating, and analyzing sets of numbers, as well as creating graphs and charts?
Spreadsheet
Gender can be referred to in many ways (Male, Female, M/F, 1/0) in a data warehouse. Ensuring gender is referenced the same way is an example of ___________.
Standardizing information
The __________ of a desktop computer is the case that houses the computer's critical parts, such as the processing and storage devices.
System Unit
A programmer or software company will often release a beta version in order to test software in real-world conditions.
T
Analytical information is useful when making important decisions such as whether the organization should build a new manufacturing plant or hire additional sales personal.
T
Analytical information makes it possible to do many things that previously were difficulty to accomplish, such as spot business trends, prevent diseases, and fight crime.
T
Data integrity issues can cause managers to consider the system reports invalid and will, make decisions based on other sources.
T
Data stewardship is responsible for ensuring the policies and procedures are implemented across the organization and acts as a liaison between the MIS and the business
T
Erroneous decisions can cost time, money, reputations, and even jobs.
T
In some firms or industries, information that is a few days or weeks old can be relevant, while in others information that is a few minutes old can be almost worthless.
T
In some operating systems, folders may be referred to as directories.
T
Information can tell an organization how its current operations are performing and help it estimate and strategize about how future operations might perform
T
Managers typically interact with QBE tools, and MIS professionals have the skills required to code SQL
T
Modern ROM chips can be electronically reprogrammed.
T
Organizations need to capture and store transactional information to perform operational tasks and repetitive decisions such as analyzing daily sales reports and production schedules.
T
The rational database is the most prevalent data models for organizing information.
T
With a subscription model, users pay a fixed amount of money per month in order to use software.
T
With speech recognition, it is possible to issue commands and search for information by speaking into your mobile device.
T
Without proper cooling, a computer could overheat and malfunction.
T
A(n) __________ is a device that can capture television signals for viewing on a computer.
TV tuner
__________ is the primary storage device of a personal computer.
The hard drive
which of the following statement is true? - the more complete an organization wants its information to be, the less it costs -the more accurate an organization wants its information to be, the less it costs -the less accurate an organization wants its information to be, the more It costs -the more complete and accurate an organization wants its information to be, the more it costs
The more complete and accurate an organization wants its information to be, the more it costs
Which of the following is a pointing device that can be useful if you have very limited space on your desk?
Trackball
One of the following is NOT one of the five characteristics of high-quality information:
Transactional
A Data warehouse is a logical collection of information, gathered from many different operational databases, that supports business analysis activities and decision-making tasks
True
Dirty data is erroneous or flawed data
True
a data mart contains a subset of data warehouse information
True
a repository is a central location in which data is stored and managed
True
data aggregation is a collection of data from various sources for the purpose of data processing
True
one example of data aggregation is to gather info about particular groups based on specific variables such as age, profession, or income
True
the primary purpose of a data warehouse is the perform analytical processes
True
within the data warehouse model, the internal databases could include marketing, sales, inventory, and billing
True
Which type of memory is nothing more than the use of your hard drive when you are running out of RAM?
Virtual Memory
Which of the following describes ETL? -a process that extracts information from internal and external databases -a process that transforms information using a common set of enterprise definitions -a process that loads information into a data ware house
all of these
which of the following statements is true regarding customer information? -customer info can exist in several operational systems -customer info in each operational system could change -customer info in each operational system can be different
all of these
which of the following occurs during data cleansing? -clean data marts -clean redundant customer data -clean accurate data -clean correct data
clean redundant customer data
which of the following are examples of external databases in the data warehouse model?
competitor and industry information, mailing lists, and stock market analysis
Operating systems communicate with most hardware components using:
device drivers
Collectively, all malicious programs are referred to as:
malware
within the beginning stages of data warehouse models process, which of the following are included in the internal databases? -marketing, sales, inventory, and billing -data mart 1, data mart 2, data mart 3 -competitor and industry info, mailing lists, and stock market analysis -marketing information, and stock market analysis numbers
marketing, sales, inventory, and billing
Dividing a hard drive into multiple sections is known as:
partitioning
A(n) _________ is a special environment that allows you to run an operating system on top of another operating system.
virtual machine
