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

Question options:

  

cloud computing.

 

no

SQL.

 

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).