Dbms's typically include report generating tools in order to

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