ban exam 1
Why is an effective ETL process essential to data warehousing?
"Dirty data" can result in incorrect or misleading statistics used for decision making.
Briefly describe how a Wi-Fi network operates.
A computer's wireless adapter translates data into a radio signal and easily transmits it using an antenna. After that, a wireless router receives the signal and decodes it. The router is there also to send information to the internet using a wired connection.
Which of the following statements is NOT true about a mainframe computer?
A single computer with a single user is typical of a mainframe computer.
In what ways can a BI and analytics system be useful to a grocery store or pharmacy?
BI and analytics system could be useful to a grocery store as it could track what people buy and where to put these items so they will be purchases by customers. For a pharmacy BI and analytics could be used to record and store data about people's medications and the computer can organize when customers are due for a refill and it can store what prescription they have.
All of the following are examples of someone using personal productivity software EXCEPT _________.
Callie entering a customer's order into a restaurant's ordering system
Briefly describe the hierarchy of data.
Data is generally organized in a hierarchy that begins with the smallest piece of data used by computers (a bit) and progresses through the hierarchy to a database. A bit (a binary digit) represents a circuit that is either on or off. Bits can be organized into units called bytes. A byte is typically eight bits. Each byte represents a character, which is the basic building block of most information. Characters are put together to form a field. A field is typically a name, number, or combination of characters that describes an aspect of a business object or activity. A collection of data fields all related to one object, activity, or individual is called a record. A collection of related records is a file. At the highest level of the data hierarchy is a database, a collection of integrated and related files. Together, bits, characters, fields, records, files, and databases form the hierarchy of data.
Explain entity-relationship (ER) diagrams.
Entity-relationship (ER) diagrams use basic graphical symbols to show an organization of and relationships between data. In other words, ER diagrams show data items in tables (entities) and the ways they are related. ER diagrams help ensure that the relationships among the data entities in a database are correctly structured so that any application programs developed are consistent with business operations and user needs. In addition, ER diagrams can serve as reference documents after a database is in use. If changes are made to the database, ER diagrams help design them.
_____ is a markup language designed to transport and store data on the Web.
Extensible Markup Language (XML)
Which of the following is required to create a traditional data warehouse but NOT a data lake?
Extract Transform Load process
Outline the steps in the Extract Transform Load (ETL) process and explain the purpose of each step.
Extract data from its original source, transform data by deduplicating it, combining it, and ensuring quality, to then load data into the target database.
_____ is an approach concerned with the efficient and environmentally responsible design, manufacture, operation, and disposal of IS-related products.
Green computing
Which statement about Hadoop is correct?
Hadoop's HDFS divides data into subsets and distributes them onto different servers.
In the data center for Mack's company, one server is dedicated to each application. In contrast, the data center for Jack's company uses virtualized servers. Which statement would you expect to be true?
Jack's company pays for fewer software licenses
_____ is an open-source operating system whose source code is freely available to everyone.
Linux
_____ is an example of a popular general-purpose software suite for personal computer users.
Microsoft Office
Monte's employer provides SaaS applications for its staff to use for their daily job functions. This means that ____.
Monte can sign in to use these applications from any computer or device
A newly discovered entity or attribute can be added to a NoSQL database dynamically because _____.
NoSQL databases do not require a predefined schema
One difference between NoSQL and relational databases is that _____.
NoSQL databases have a greater horizontal scaling capability
_____ are used to grade standardized tests, including the SAT and GMAT tests, and to record votes in elections.
Optical mark recognition (OMR) systems
_____ is a process for driving traffic to a Web site by using techniques that improve the site's ranking in search results.
Search engine optimization
_____ is a special-purpose programming language for accessing and manipulating data stored in a relational database.
Structured Query Language (SQL)
Distinguish between systems software and applications software.
System software is the interface between the application software and the computer's hardware. System software includes operating systems, utilities, and middleware and itcoordinates the activities and functions of the hardware and other programs throughout the computer system. Applications software consists of programs that help users solve computing problems.
_____ is a communication standard that enables computers to route communications traffic from one network to another as needed.
The Internet Protocol (IP)
Briefly explain the passing of packets over the Internet.
The Internet works by chopping data into chunks called packets. Each packet then moves through the network in a series of hops.
_____ consists of server and client software, the Hypertext Transfer Protocol (HTTP), standards, and markup languages that combine to deliver information and services over the Internet.
The Web
The graphical representation that summarizes the steps a consumer takes in making the decision to buy your product and become a customer is called _____.
a conversion funnel
Hadoop's two major components are _____.
a data processing component and a distributed file system
New cars come with onboard computer systems that control antilock brakes, air bag deployment, fuel injection, etc. They run operating system software known as ____.
an embedded operating system
During the modeling phase of the CRISP-DM method, the team conducting the data mining project ______.
applies selected modeling techniques
Graph NoSQL databases _____.
are well-suited for analyzing interconnections
A tier 1 or 2 data center would be most appropriate for an organization with which characteristic?
capable of conducting critical operations manually
Which of the following is NOT one of the common purposes of utility programs?
creating spreadsheets
Raw facts such as a social security number or catalog item number for a shirt are known as _____.
data
A _____ is a climate- and access-controlled building or a set of buildings that houses the computer hardware that delivers an organization's data and information services.
data center
A ______ is a collection of instructions and commands used to define and describe data and relationships in a specific database.
data definition language
Melanie's company takes a "store everything" approach to big data, saving all of it in a raw, unaltered form. Only when she needs to analyze some of the data is it extracted from this _____.
data lake
A _____ is a subset of a data warehouse that is used by small- and medium-sized businesses and departments within large companies to support decision making.
data mart
_____ is used to explore large amounts of data for hidden patterns to predict future trends.
data mining
Because Airbnb needs to support a rapid growth in its number of users but prefers to hire a service to organize and configure its information systems infrastructure, it relies on a(n) _____.
database as a service
With _____, the database is stored on a service provider's servers and accessed by the client over a network, typically the Internet.
database as a service
A tier 3 or 4 data center would be most necessary for an organization with which characteristic?
dependent on computers to manage manufacturing operations
Each attribute in a relational database model can be constrained to a range of allowable values called a _____.
domain
What criteria are used by the Uptime Institute to classify data centers into four tiers?
expected annual downtime, fault tolerance, and power outage protection
During which step of the ETL process can data that fails to meet expected patterns or values be rejected to help clean up "dirty data"?
extract
Which component of the data hierarchy is ranked just below the database and represents a collection of similar entities?
file
_____ is the use of a collection of computers, often owned by many people or different organizations, to work in a coordinated manner to solve a common problem.
grid computing
A DaaS arrangement can be especially cost effective for businesses that _____.
have fluctuating needs for database storage capacity
When Peter purchases software, _____.
he is acquiring a license to use it on his computer
A database system that stores the entire database in random access memory is known as a(n) _____.
in-memory database
KDDI Corporation chose to consolidate their servers into a single Oracle SuperCluster running the Oracle Times Ten in-memory database in order to _____.
increase data access rates and efficiency
Which type of end user license is considered a volume license because it allows the licensee to install the software on a certain number of computers?
individual/multiuser
When rules and relationships are set up to organize raw facts, creating value beyond that of those individual facts, this produces _____.
information
Compared with commercially licensed software, open-source software _____.
is available for similar purposes such as CPU operation and database management
A SaaS provider such as Oracle or SAP manages service levels and availability. This is advantageous because _____.
it allows SaaS customers to increase the number of users without expanding their communications capacity
One of the disadvantages of proprietary software is that ______________.
it can take a long time and significant resources to develop the required software features
For the ____ operation, it is required that the the two tables have a common data attribute.
join
The _____ is the heart of the operating system and controls its most critical processes.
kernel
The component of a computer that provides the CPU with a working storage area for program instructions and data is called the __________.
main memory
An operating system with _____ capabilities allows a user to run more than one program concurrently.
multitasking
Which type of end user license requires that a single copy of the software reside on a file server?
network/multiuser
Mike chooses a DaaS arrangement for his small business because it reduces costs. Why is DaaS less costly than the traditional alternative?
no in-house database installation, maintenance, or monitoring
A type of memory whose contents are not lost if the power is turned off or interrupted is said to be _____.
nonvolatile
Compared with the traditional licensing model in which users purchase and install software, SaaS _____.
offers less expensive upgrades and new releases
Which of the following is NOT a recognized BI and analytics technique?
online transaction processing
What type of software is distributed, typically for free, with the source code also available so that it can be studied, changed, and improved by its users?
open-source
Julian has chosen to use open-source software to help run his small business. He believes it is often more reliable and secure than commercial software because _____.
open-source software bugs are detected and fixed more quickly
When choosing from various types of flat-panel displays, choose a(n) _______ for the lowest power consumption.
organic light-emitting diode (OLED) display
After entering data into a relational database, users can make all of the following basic data manipulations except:
organizing
Letitia's open-source word processing application is not working properly. How can she get help troubleshooting the problem?
post her question to an Internet discussion area
A(n) _____ is a characteristic or set of characteristics in a record that uniquely identifies the record.
primary key
Some people are alarmed that big data applications allow organizations to develop extensive profiles of individuals without their knowledge or consent. This represents which type of concern related to big data?
privacy
Completing an instruction involves two phases—instruction and execution—which are each broken down into two steps for a total of four steps. Which of the following is NOT one of the four steps?
process data
CPU clock speed is the predetermined rate at which the processor _____.
produces a series of electronic pulses
The set of instructions that signal the CPU to perform circuit-switching operations is known as _____.
program code
Mark creates a new relational database table that includes only five of the seven columns in the existing products table. This action is known as ____.
projecting
All of the following are examples of activities performed by an operating system EXCEPT ________.
providing word processing capabilities to users
Because electronic devices are composed of materials such as beryllium, cadmium, lead, mercury, BFRs, selenium, and polyvinyl chloride, one of the three goals of green computing is to _____.
reduce the use of hazardous material
Which of the goals of green computing, if implemented successfully, would be the BEST practice for reducing the hazards posed by e-waste in the United States?
reduce the use of hazardous material
The key challenges associated with big data include the difficulty of locating and deriving value from _____.
relevant data to make decisions
The class of computer systems used by multiple concurrent users offers businesses the potential to increase their processing capability to handle more users, more data, or more transactions in a given period, which is known as _____.
scalability
Which of the following DBMS elements can be represented in a visual diagram or defined using a DDL?
schema
Much of the popular open-source software available is protected by the GNU General Public License. Which of the following is NOT permitted by this type of license?
selling a modified version of the program
Hardware utilization can be improved by logically dividing the resources of a single physical server to create multiple logical servers. This approach is known as _____.
server virtualization
To identify and make predictions about various alternative scenarios, a manager would use _______.
simulation techniques
Which type of end user license allows the program to be installed and used and one CPU that is not accessed by other users over a network?
single-user
Which class of general-purpose computer systems is the least expensive option that meets a wide range of personal computing needs, from data entry to computer-aided design or engineering, and from accessing Internet applications to software development?
single-user nonportable computers
When a business wishes to move away from hosting its own applications, a solution that offers many advantages is to use ______.
software as a service
_____ application software includes a wide range of built-in functions for statistical, financial, logical, database, graphics, and date and time calculations.
spreadsheet
_____ are the most powerful computers with the fastest processing speed and highest performance.
super computers
Big data veracity is a measure of _____.
the accuracy, completeness, and currency of the data
During the load phase of the ETL process, _____.
the data is checked against the constraints defined in the database schema
One of the advantages of off-the-shelf software is that ________________.
the initial cost is lower because the software firm can spread the development costs over many customers
One advantage of proprietary software versus off-the-shelf software is that _____.
the software provides a company with a competitive advantage by solving problems in a unique manner
Traditional data centers require huge amounts of energy because _____.
they constantly run powerful air-conditioning systems
A _____ is a low-cost, centrally managed computer with limited capabilities and no internal or external attached drives for data storage.
thin client
Which type of of data center offers the highest and most predictable level of performance through redundant hardware, power-related devices, and alternate power sources?
tier 4
3D printing is ________.
used to make solid objects from filaments or powder
One key characteristic of big data is that it is being generated at a rate of 2.5 quintillion bytes per day. This is known as big data's _____.
velocity
_____ are used to support engineering and technical users who perform heavy mathematical computing, computer-assisted design (CAD), video editing, and other applications requiring a high-end processor.
workstations
You would use Query by Example if _____.
you wish to use a visual approach to query building
