Online Exam 3
All of the following are technologies used to analyze and manage big data EXCEPT:
A one-to-many relationship between two entities is symbolized in a diagram by a line that ends with:
two short marks.
three short marks.
a crow’s foot.
a crow’s foot topped by a short mark.
The data dictionary serves as an important data management tool by:
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.
In place of application server software to allow a Web server to communicate with a back-end database, you can use:
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?
Text mining tools
Sentiment analysis software
Web usage mining technologies
Data mining software for identifying associations
In a relational database, the three basic operations used to develop useful sets of data are:
select, project, and where.
where, from, and join.
select, project, and join.
where, find, and select.
Microsoft SQL Server is a(n):
DBMS for both desktops and mobile devices.
desktop relational DBMS.
DBMS for midrange computers.
Data mining is a tool for allowing users to:
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.
DBMSs typically include report-generating tools in order to:
retrieve and display data.
display data in an easier-to-read format.
display data in graphs.
perform predictive analysis.
__________ are computers consisting of a circuit board with processors, memory, and network connections that are stored in racks.
The relationship between entities and attributes is best illustrated by the entity __________ with the attribute __________.
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):
Which type of infrastructure service provides voice and video connectivity to employees, customers, and suppliers?
Interpretations of Moore’s law assert that:
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.
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.
5, 2, 3, 4, 1
5, 4, 2, 3, 1
4, 5, 2, 3, 1
4, 5, 3, 2, 1
When the same attribute in related data files has different values, this is called data:
Which of the following factors does NOT help explain why computing resources today are ever more available than in previous decades?
Widespread rejection of technology standards
Declining communications costs and the Internet
__________ tools are used to analyze large unstructured data sets, such as e-mail, memos, survey responses, etc., to discover patterns and relationships.
The ability to be in many different states at once, dramatically increasing processing power, is a hallmark of:
Big data does NOT refer to:
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).