All of the following are technologies used to analyze and manage big data EXCEPT:
Question options:
  

cloud computing.
 

noSQL.
 

in-memory computing.
 

Hadoop.
 
Question 2
A one-to-many relationship between two entities is symbolized in a diagram by a line that ends with:
Question options:
  

two short marks.
 

three short marks.
 

a crow’s foot.
 

a crow’s foot topped by a short   mark.
 
Question 3
The data dictionary serves as an important data management tool by:
Question options:
  

assigning attributes to the data.
 

creating an inventory of the data   elements contained in the database.
 

presenting data as end users or   business specialists would perceive them.
 

maintaining data in updated form.
 
Question 4
In place of application server software to allow a Web server to communicate with a back-end database, you can use:
Question options:
  

CGI.
 

HTML.
 

Java.
 

SQL.
 
Question 5
A household appliances manufacturer has hired you to help analyze their social media datasets to determine which of their refrigerators are seen as the most reliable. Which of the following tools would you use to analyze this data?
Question options:
  

Text mining tools
 

Sentiment analysis software
 

Web usage mining technologies
 

Data mining software for   identifying associations
 
Question 6
In a relational database, the three basic operations used to develop useful sets of data are:
Question options:
  

select, project, and where.
 

where, from, and join.
 

select, project, and join.
 

where, find, and select.
 
Question 7
Microsoft SQL Server is a(n):
Question options:
  

DBMS for both desktops and mobile   devices.
 

Internet DBMS.
 

desktop relational DBMS.
 

DBMS for midrange computers.
 
Question 8
Data mining is a tool for allowing users to:
Question options:
  

quickly compare transaction data   gathered over many years.
 

find hidden relationships in data.
 

obtain online answers to ad-hoc   questions in a rapid amount of time.
 

summarize massive amounts of data   into much smaller, traditional reports.
 
Question 9
DBMSs typically include report-generating tools in order to:
Question options:
  

retrieve and display data.
 

display data in an easier-to-read   format.
 

display data in graphs.
 

perform predictive analysis.
 
Question 10
__________ are computers consisting of a circuit board with processors, memory, and network connections that are stored in racks.
Question options:
  

Mainframes
 

Rack servers
 

Blade servers
 

Hybrid servers
 
Question 11
The relationship between entities and attributes is best illustrated by the entity __________ with the attribute __________.
Question options:
  

CUSTOMER; PRODUCT
 

CUSTOMER; PURCHASE
 

PRODUCT; PURCHASE
 

PRODUCT; CUSTOMER
 
Question 12
A formal contract between customers and their service providers that outlines the specific responsibilities of the service provider and to the customer is called a(n):
Question options:
  

SOA.
 

SLA.
 

TCO.
 

RFQ.
 
Question 13
Which type of infrastructure service provides voice and video connectivity to employees, customers, and suppliers?
Question options:
  

Networking
 

Telephone
 

VOIP
 

Telecommunications
 
Question 14
Interpretations of Moore’s law assert that:
Question options:
  

computing power doubles every 18   months.
 

transistors decrease in size 50%   every two years.
 

data storage costs decrease by 50%   every 18 months.
 

PCs decrease in market share by 9%   every 5 years.
 
Question 15
Place the following eras of IT infrastructure evolution in order, from earliest to most recent: 1. Cloud Computing Era; 2. Client/Server; 3. Enterprise Era; 4. Personal Computer; and 5. Mainframe and Minicomputer.
Question options:
  

5, 2, 3, 4, 1
 

5, 4, 2, 3, 1
 

4, 5, 2, 3, 1
 

4, 5, 3, 2, 1
 
Question 16
When the same attribute in related data files has different values, this is called data:
Question options:
  

redundancy.
 

inconsistency.
 

dependence.
 

discrepancy.
 
Question 17
Which of the following factors does NOT help explain why computing resources today are ever more available than in previous decades?
Question options:
  

Network economics
 

Widespread rejection of technology   standards
 

Moore’s law
 

Declining communications costs and   the Internet
 
Question 18
__________ tools are used to analyze large unstructured data sets, such as e-mail, memos, survey responses, etc., to discover patterns and relationships.
Question options:
  

OLAP
 

Text mining
 

In-memory
 

Clustering
 
Question 19
The ability to be in many different states at once, dramatically increasing processing power, is a hallmark of:
Question options:
  

co-location.
 

edge computing.
 

grid computing.
 

quantum computing.
 
Question 20
Big data does NOT refer to:
Question options:
  

datasets with fewer than a billion   records.
 

datasets with unstructured data.
 

machine-generated data (i.e. from   sensors).
 

data created by social media (i.e.   tweets, Facebook Likes).