Online Exam 3
Question 1
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).
