Exam 3 Quiz Questions Flashcards
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?
PoE
Uniquely identifies a node from every other one on the planet; however provides no information about its location
MAC Address
Rules that govern networking communications
Protocol
Network covering a limited geographical area, such as a single building
LAN
Collection of devices connected together via communications devices and transmission media
Network
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?
Fiber optic ethernet cable
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?
802.11ac
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?
Site survey
Which of the following terms best describes a network where each computer has the ability to both share and use resources?
Peer-to-peer
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?
UPS
_______ is the single greatest cause of lost data.
User error
intentionally registering a domain name to profit from someone else’s firm name or trademark
Cybersquatting
a specialized computer with multiple network ports and specialized software that is used to interconnect networks
Router
the technology that converts hostnames like www.espn.com into IP addresses like 199.181.132.250
DNS
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?
Last mile
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.
we will be able to securely send data from the main office to the Georgia office
Our world today is “awash in data.” According to Gartner Research, the amount of data that we store doubles every ______
6 months
the term used for raw facts and figures is
Data
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?
Unstructured data
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?
Relational database
The rows in a database are called __________
the columns are called ___________
- records
- fields
we define “transaction” as a business exchange that has two key characteristics: it is _________ and occurs repeatedly
Standardized
Firms that trawl the Internet and other sources for data, then package that data up for resale are known as ________________.
Data aggregators
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?
Implement Automated Data Tiering
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?
Data silos
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.
Hadoop
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?
Data warehouse
Three characteristics are necessary for an application to be classified as Big Data. What are they?
Volume
Variety
Velocity
the process of analyzing data to extract information not offered by the raw data alone
Data mining
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?
Canned report
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?
Information overload
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?
Use Data Interpreter
Tableau formula formatting
[Retail Price]-[Discounted Price]
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?
LEFT([Phone],3)
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?
Custom Split
,
How do you make Tableau display sales as six different colored lines, one per customer name?
Drag “Customer Name” onto Color Marks card
What is the name of the menu item on Tableau that is used to change the scatterplot from a single datapoint to having hundreds?
Aggregate Measures