Exam 3 Quiz Questions

Question 1

You’re going to install a couple of networked security cameras in your office building. It’s expensive to put 110 volt electrical outlets by each camera, so you want to use the Ethernet cable to provide both electricity and data to the cameras.
What technology will solve that problem?

Answer 1

PoE

Question 2

Uniquely identifies a node from every other one on the planet; however provides no information about its location

Answer 2

MAC Address

Question 3

Rules that govern networking communications

Answer 3

Protocol

Question 4

Network covering a limited geographical area, such as a single building

Answer 4

LAN

Question 5

Collection of devices connected together via communications devices and transmission media

Answer 5

Network

Question 6

Your company has just bought a new facility near Sarasota, Florida. There are two buildings, which are about 500’ apart. The buildings have very thick steel and concrete walls to protect against hurricanes. You’ve been told that lightning storms are common in the area.
You want to setup a LAN that includes both buildings. Given the facts above, what would be the best way to connect the two buildings?

Answer 6

Fiber optic ethernet cable

Question 7

There are a lot of 2.4GHz cordless phones in the your office suite, plus a microwave oven. You seem to remember that these devices can interfere with some WiFi networks. You head down to the local electronics superstore to buy wireless networking hardware. Given your concerns about interference, which of the following should you buy?

Answer 7

802.11ac

Question 8

Your friend Jill is the network manager for a large company. She’s heard reports that some users are unhappy about poor WiFi performance in their part of the building.
Which of the following is Jill’s best first step to help those users?

Answer 8

Site survey

Question 9

Which of the following terms best describes a network where each computer has the ability to both share and use resources?

Answer 9

Peer-to-peer

Question 10

Your small business is in a building that experiences a lot of unexpected power outages. Whenever this happens, the servers crash and you lose money.
Which of the following could help solve that problem?

Answer 10

UPS

Question 11

_______ is the single greatest cause of lost data.

Answer 11

User error

Question 12

intentionally registering a domain name to profit from someone else’s firm name or trademark

Answer 12

Cybersquatting

Question 13

a specialized computer with multiple network ports and specialized software that is used to interconnect networks

Answer 13

Router

Question 14

the technology that converts hostnames like www.espn.com into IP addresses like 199.181.132.250

Answer 14

DNS

Question 15

The core of the Internet is incredibly fast. By contrast, many users have unacceptably slow links to the Internet. What term is used for this problem?

Answer 15

Last mile

Question 16

Your company has a main office in Florida, plus satellite offices in Georgia and Alabama.
You also have a highly mobile group of salespeople that are constantly traveling to visit clients across the US.
The IT group is building a traditional WAN using dedicated data circuits.

Answer 16

we will be able to securely send data from the main office to the Georgia office

Question 17

Our world today is “awash in data.” According to Gartner Research, the amount of data that we store doubles every ______

Answer 17

6 months

Question 18

the term used for raw facts and figures is

Answer 18

Data

Question 19

you have the following corporate servers
1. two million emails
2. 300,000 microsoft word docx files
3. 900,000 PDF files
what term applies to that collection?

Answer 19

Unstructured data

Question 20

Your friend Bob asked you to look at his sales database. Each record records everything about that sale: customer name, street, city, state, zip, phone, item purchased, price paid, etc.
You note that you’re in there 20 times – once for each item you’ve purchased at his store. Listing your name and personal info 20 times seems rather inefficient (and error-prone).
What type of database system should Bob implement to solve that problem?

Answer 20

Relational database

Question 21

The rows in a database are called __________
the columns are called ___________

Answer 21

1. records
2. fields

Question 22

we define “transaction” as a business exchange that has two key characteristics: it is _________ and occurs repeatedly

Answer 22

Standardized

Question 23

Firms that trawl the Internet and other sources for data, then package that data up for resale are known as ________________.

Answer 23

Data aggregators

Question 24

the CEO has given you the job of solving the company’s problems with data storage.
Background: The amount of data your company stores is constantly going up. Storage costs are wreacking havoc with the budget and the CEO wants to save money.
Some of the files are ancient. Nobody ever touches them but you cannot just destroy them in case they are useful one day. Then there are some files people use every day; some of those users are complaining that the storage system is not fair enough.
Which of the solutions below offers the best hope of satisfying all of those requirements?

Answer 24

Implement Automated Data Tiering

Question 25

your company has multiple data systems that are incompatible with one another. it is impossible to share data among these systems. Which of the following terms best matches this (sad) situation?

Answer 25

Data silos

Question 26

this is a powerful open source system that is specially designed for the analysis of big data. two of it’s core components are MapReduce and the Pig programming language.

Answer 26

Hadoop

Question 27

Suppose you are the IT manager for an electronics retailer that has a very busy online store. Your online store has heavy user traffic and generates a lot of sales revenue. You don’t want managers running reports against the live operational data for fear of reducing the performance of the online store, frustrating users and reducing revenue.
Which of the following technologies would be the best way to let your managers do analytics without harming the performance of your operational system?

Answer 27

Data warehouse

Question 28

Three characteristics are necessary for an application to be classified as Big Data. What are they?

Answer 28

Volume
Variety
Velocity

Question 29

the process of analyzing data to extract information not offered by the raw data alone

Answer 29

Data mining

Question 30

your company’s human relations department needs to have a report created that will allow any employee to get some very basic inf about their employment history. there are thousands of employees with widley varying levels of computer skills, so this report needs to be easy to use with almost zero training required. each employee needs to see the same output; there is no need for each user to be able to customize his report. which types of report do you think will be most appropriate?

Answer 30

Canned report

Question 31

there is more disruption this week. many people claim that there is just too much data! they say there is so much data that it is like we are “drinking from a fire hose.” moreover, they say that this imposes a $900 billion cost on our economy.
which term below is typically usually used to describe this situation?

Answer 31

Information overload

Question 32

When field names on Tableau aren’t helpful and there’s extra rows of data, what can you click on the Tableau Data Source screen to fix that?

Answer 32

Use Data Interpreter

Question 33

Tableau formula formatting

Answer 33

[Retail Price]-[Discounted Price]

Question 34

Suppose you want to create a calculated field to show the area code for each customer (the first 3 characters of the phone number field)
What format is a valid Tableau formula?

Answer 34

LEFT([Phone],3)

Question 35

Suppose you want to create one new Tableau field that contains the customer’s first name only
What feature do you use, and what separator?

Answer 35

Custom Split
,

Question 36

How do you make Tableau display sales as six different colored lines, one per customer name?

Answer 36

Drag “Customer Name” onto Color Marks card

Question 37

What is the name of the menu item on Tableau that is used to change the scatterplot from a single datapoint to having hundreds?

Answer 37

Aggregate Measures