S2

Question 1

What are the seven different layers responsible for specific data exchange functions in the Open Systems Interconnection (OSI) model?

Answer 1

Physical (Layer 1)
Data Link (Layer 2)
Network (Layer 3)
Transport (Layer 4)
Session (Layer 5)
Presentation (Layer 6)
Application (Layer 7)

Question 2

Modems

Answer 2

Modems connect a network to an ISP’s network, usually through a cable connection

Question 3

Routers

Answer 3

Routers manage network traffic by connecting devices to form a network. They read the source and destination fields in information packet headers to determine the most efficient path through the network for the packet to travel

Question 4

Switches

Answer 4

Switches are similar to routers in that they connect and divide devices within a computer network

Question 5

Gateways

Answer 5

A gateway is a computer or device that acts as an intermediary between different networks

Question 6

Edge-Enabled Devices

Answer 6

Allow computing, storage and networking functions closer to the devices where the data or system request originates, rather than a distant central location

Question 7

Servers

Answer 7

Servers are physical or virtual machines that coordinate the computers, programs and data that are part of the network

Question 8

Firewalls

Answer 8

Firewalls are software applications or hardware devices that protect a person’s or a company’s network traffic by filtering it through security protocols with predefined rules

Question 9

SELECT *

Answer 9

select all attributes from the set of data

Question 10

Four Benefits of Relational Databases

Answer 10

Completeness (This concept means that relational databases assist with the goal that all data required for a business process are included in the data set), no redundancy, business rules enforcement, and communication and integration of business processes

Question 11

Inner Join

Answer 11

uses only the records that both data sets have in common.

Question 12

Operational Data Store

Answer 12

An ODS is a repository of transitional data from multiple sources and is often an interim area between data sources and data warehouses

Question 13

Data Warehouse

Answer 13

Are very large data repositories that are centralized and used for reporting and analysis rather than for transaction purposes

Question 14

Data Mart

Answer 14

A data mart is much like a data warehouse but is more focused on a specific purpose such as marketing or logistics and is often a subset of a data warehouse

Question 15

Data Lake

Answer 15

A repository similar to a data warehouse, but it contains both structured and unstructured data, with data mostly being in its natural or raw format