MIS-2749

Questions that data analysts often ask include which 3 of the following?

-Who will receive the information and analysis? -What overall outcomes and results that are needed? -What are the time constraints for the project?

Click and drag on elements in order Put these steps in the proper order to explain communication over the internet.

1. Assemble the data packet. 2. Correct domain name is identified (e.g., www.amazon.com). A domain name is a unique name affiliated with an IP address. 3. Look up IP address. Domain name system (DNS) are used to simplify the process. 4. IP (Internet Protocol) Address is added to the packet. 5. Transmission Control Protocol (TCP). TCP is an Internet protocol that ensures delivery of packets. 6. Message is sent/shipped using a variety of different carriers (ISPs). Often message "hop" or move from one network to another.

In order to make understanding and interpretation of SQL queries easier, users have the ability to add comments. The symbol(s) that will tell SQL that an entry is a comment and should not be used in the query is(are) ___.

2 dashes: "- -"

Curiosity, understanding context, having a technical mindset, data design, and data strategy are the 5 essential aspects of __ thinking and skills

Analytical

Geographically distributed network server groups that work together to deliver more efficient delivery of Internet and Web content are called Delivery Networks (CDN).

Content

Data that has been collected internally by the organization is known as ___party data

First

Select all that apply Which of the following are benefits of Cloud computing? More than one answer may be selected.

It can provide virtual applications software. There is significant storage capacity. Broad network access.

Which program is typically limited to one user at a time?

Spreadsheet

One way to visualize a data ecosystem is to apply it to the data project life cycle. The Data Science Ready project outlines the 5 steps of the data project life cycle. The final stage in this life cycle is ___.

Storage

The process of converting the format of data from one form to another is called data

Transformation

Select all that apply Select what's true about how 5G connectivity will support IoT. More than one answer may be selected.

5G connectivity will allow for greater data capacity. 5G connectivity will allow for lower latency. 5G connectivity will allow for faster connection speeds, greater data capacity, and lower latency.

A computing model where processing, storage, software, applications, and a variety of services are provided over a network, mainly access via the Internet is called computing.

Cloud or cloud computing

Match the type of network to the correct definition.

Connect devices around an individual. PANs typically involve laptops, tablets, and smartphones: PAN Connect a variety of devices at a single site such as an office or retail store: LAN Connect a variety of devices between two or more geographic locations: WAN Connect LANs, WANs, and other internets together: Internets

Measurable and counted data that can have almost any numeric value is called ____data.

Continuous

When working in Tableau, users can assume which 3 roles?

Creators Explorers Viewers

Large and small businesses find they can their reliance on internal IT infrastructure and reduce cost by utilizing Cloud-based technologies.

Decrease, reduce, lessen, or lower

Key skills required of data analysts include which 3 of the following?

Experience with SQL and computer code Technical writing skills Oral communication skills

Match the TCP/IP layers to their correct definition.

Handles the physical parts of sending and receiving data. Data can be sent via wireless networks, Ethernet cable, network interface cards (NIC), etc: Datalink Controls the movement of packets throughout the network: Internet Divides data into packets and acknowledges the packets have been received: Transport The group of applications that require network communication and are used by people to facilitate communication. These include email and messaging applications: Application

Select 3 critical factors to consider when determining the right data to select?

How much data should be collected? How will the data be collected? What types of data do you need to solve a specific problem?

Select all that apply Select what's true about Cloud computing in today's business environment. More than one answer may be selected.

In the United States, 96% of all organizations use the Cloud in one form or another. 70% of global businesses backup some portion of their data using a Cloud service provider. 93% of small businesses backup some portion of their data using a Cloud provider.

In order to connect to the Internet and other computers on a network, each device must have a network card (NIC) installed.

Interface

A type of network that connects devices at a single site within a limited geographic range is called a area networks.

LAN

Select all that apply Which of the following are considered a basic type of computer network? You may select more than one.

Local area network (LAN) Wide area network (WAN) Personal area network (PAN)

Data that offers free access, distribution, and usage is known as ___data

Open

Qualitative data that is not categorized is called nominal data. Qualitative data that is categorized (ranked, for example) is considered ___ data.

Ordinal

Select all that apply Geographic Information Systems (GIS) are focused on the capture, analysis, use, and management of spatial location information. GIS is rooted in the science of geography and seeks to integrate many types of data to create visualizations using maps and 3D scenes. Which of the following are applications of GIS? More than one answer may be selected.

Organizations use GIS combined with data analytics to better determine customer needs and wants. Telecommunications providers use GIS to map out cell tower placement. The retail sector uses GIS information to place certain products based on regional demand preferences.

When data is anonymized, the PII is eliminated or encrypted. PII includes names, social security numbers, addresses, and more and stands for ___ identifiable information.

Personally

Microsoft's analytics software that allows for the processing, manipulation, and visualization of data is called Microsoft____BI

Power

When working in Microsoft Power BI, which 3 tiers are available?

Power BI desktop Power BI Premium Power BI Pro

The 6-step process analysts use to create data-driven decision making includes which 3 of the following?

Prepare, ask, analysis

There are a number of Cloud service vendors that provide a variety of Cloud services. Generally, Cloud computing services are classified in three ways: Infrastructure as a Service (IaaS), Platform as a Service (PaaS), and as a Service (SaaS).

Software

Characteristics of spreadsheets include which 2 of the following?

- Information is organized into cells - Data is structured in rows and columns

Data analysts are likely to have achieved what education level when beginning their career?

Bachelor's degree

DDDM refers to Data Driven ____Making.

Decision

There are many benefits of Cloud computing. One benefit of cloud computing is _____ that allows for the access of data, files, and programs when you are off-site or at home via web-enabled devices.

Flexibility

This type of information system is focused on the capture, analysis, use, and management of spatial location information. It is rooted in the science of geography and seeks to integrate many types of data to create visualizations using maps and 3D scenes. This definition explains a Information System.

Geographic

Collections of related fields in a database are referred to as ___.

Records

Examples of Internet of Things (IoT) devices include which of the following? More than one answer may be selected.

Smart Speakers Home Security Cameras Smart TVs

Someone who possesses the knowledge of processing software, business strategy, and analytical skill to deliver data and reports that guide management and executives as they create well-informed decision making is known as a data ___.

Analyst

The 3-step data visualization process is comprised of which of the following?

Create your visuals Planning for visuals Explore data sets for patterns

A group of two or more devices/computers connected together to allow for the exchange of information and for the sharing of resources is call a _____.

Network

Select all that apply Web 3.0 is the next evolution in the development of the World Wide Web and is built to support a variety of applications and services including: (More than one answer may be selected.)

Ubiquitous computing Saas IoT

The next generation of mobile connectivity that will provide faster data transfer speeds and enhanced connection reliability. Is called ____G. It is the fifth-generation wireless technology for digital cellular networks that began wide deployment in 2019.

5

Select all that apply Select the potential applications/benefits of 5G networks. More than one answer may be selected.

5G connectivity has the potential to create truly connected cities. 5G networks may eventually allow for autonomous vehicles to safely interact with each other and their environment. 5G connectivity will greatly improve what businesses and individuals can do with connected devices.

In the statement: SELECT * FROM Customers, the asterisk (*) indicates that the user wants to extract all the columns of data FROM the table.

Customers

The information technology (IT) architecture and infrastructure, software applications, programming languages, and storage technologies used for the collection, storage, analysis, and interpretation of meaningful data is referred to as the______ecosystem

Data

Trends in data analytics include which 3 of the following?

Data analytic as a core business function Scalable AI Composable data

Select all that apply Select all of the characteristics of that explain how the Internet works.

Data on the Internet is usually stored on specialized computers called servers. The connections points in the Internet are called nodes. Data is transferred from one network to another network through hardware called routers.

SQL is quite useful when working with large data sets and is widely used in today's business environment. It allows the user to query the data contained in a

Database

The main tools used by data analysts include which 3 of the following?

Databases and query languages Data visualization tools spreadsheets

According to Tableau, data-driven decision making (DDDM) is the uses which of the following to guide strategic business decisions that align with organizational goals, objectives, and initiatives.

Facts, metrics, and data

There are four key features of Web 2.0. One key feature allows users to collectively determine the classification of information. For example, tagging of websites, images, videos, and links. This key feature is called:

Folksonomy

Data transformation is the process of converting the ( __ ) of data.

Format

Common SQL terms include which 3 of the following?

From, where, select

Select what is true about computer networks. More than one answer may be selected.

Networks range in size from small home networks to the Internet, which is the world's largest network. Computer networks support many different software applications. A network is a group of two or more devices/computers connected together.

According to the National Institute of Standards and Technology (NIST) there are four Cloud computing deployment models. Cloud is a Cloud deployment model where Cloud infrastructure is provisioned for exclusive use by a single organization comprising multiple consumers, e.g., business units). It may be owned, managed, and operated by the organization, a third party, or some combination of them, and may exist on or off premises.

Private or private cloud

SQL, usually pronounced "sequel", is quite useful when working with large data sets. The Q in SQL stands for (___ ).

Query

Data-driven decision making (DDDM) can be facilitated through a 6-step processes of Ask, Prepare, Process, Analysis, Share, and Act. Which of these steps refers to creating visualizations and presentations for key stakeholders?

Share

SQL allows users to isolate specific information contained in a database, as well as to aid in the selection, creation, addition, and extraction of data from a database. SQL stands for ___ query language.

Structured

In computer programming, a set of rules and guidelines that define a specific computer language is referred to as the language's ___.

Syntax

Providing the ability to explore and analyze data in seconds using a drag and drop interface as well as natural language processing which allows for the presentation of questions are major attributes of ___ , which offers licenses for Creators, Explorers, and Viewers.

Tableau

Most databases are composed of multiple _____which are groups of assigned records and fields organized in rows and columns. Fields

Tables

Analytical skills necessary for a data analyst include the characteristics and capabilities that allow for the observation, research, and interpretation of a problem or change in a desired state. According to Google, there are five essential aspects of analytical skills including which 3 of the following?

Understanding context Data strategy Curiosity

A major trend in data analytics is the use of artificial intelligence to focus on small data which is more precise, using small datasets that are capable of impacting decisions in the present. This is known as __ AI

scalable

Match the explanation of the benefits of Cloud computing to the correct benefit of Cloud computing-related term.

Allows for the access of data, files, and programs when you are off-site or at home via web-enabled devices: flexibility Reduces expenditures on IT infrastructure and hard disk space: cost savings Enables organizations to communicate and share data/information more efficiently. Collaboration is facilitated because multiple users can share and work on files at the same time: collaboration Makes data backup and recovery easier because critical data are stored offsite and in multiple locations: disaster recovery

Improving decision making, customer service, production and operations processes are just a few of the trends in data

Analytics

The process of data analytics includes which of the following?

Descriptive analytics Prescriptive analytics Predictive analytics

Select all that apply Select the true statements about sending information on the Internet

Devices connect to the Internet or a network using network cables or wireless technologies. Modems and routers are connected to the Internet via an Internet Service Provider (ISP). Each device connecting to the Internet or a network must have a network interface card (NIC) installed.

Which of the following functions are provided by an Internet Service Provider (ISP)? More than one answer may be selected.

Your ISP pays for access to the Internet Provide an Internet Protocol (IP) address Provide access or a gateway to the resources on the Internet

Click and drag on elements in order Put the steps of cellular communication (placing a call on a cellular network) in the correct order, starting with placing a call.

1. Place the call. 2. Your phone converts your voice into an electrical signal that is transmitted via radio waves to the nearest cell tower. 3. Once the call is received by the nearest tower it is relayed to a system/network of cell towers where it is then converted and received by the phone you were calling. 4. When the person on the other phone accepts the call and begins to speak, the person's voice is converted to an electrical signal that is sent back through the network.

Working on data analytics teams to extract data from large data sets, creating reports that outline key findings, monitoring key performance indicators (KPIs) to identify success or failure, and analyzing data to identify trends are just a few of the responsibilities of a data ( ).

Analyst

Improving decision making, customer service, production and operations processes are just a few of the trends in data_____.

Analytics

Match the explanation of the disadvantages of Cloud computing to the correct disadvantage of Cloud computing-related term.

Cloud services are subject to planned and unplanned downtime. Downtime can occur because of maintenance, system/mechanical failure, natural disasters, and outside intrusions/attacks: downtime Cloud service providers do their best to implement the best security measures they can. These security measures often align with security and governmental standards: security Cloud infrastructure is owned, managed, controlled, and monitored by the Cloud service provider. This means the customer often has little control over cloud service processes and procedures: limited control Also known as vendor lock-in, vendor agreements make switching between cloud services somewhat difficult. A vendor agreement is a signed contract with the Cloud service provider for their services: vendor agreements

A simple formula that can be used to define success is: ____+ organizational knowledge = problem solved.

Data

Select all that apply Common methods to connect a LAN to the Internet include which of the following?

Fiber optic cables Coaxial cables Ethernet cables

In order to be considered open data, databases must provide access rights so that they can be ___.

Redistributed

Devices that connect to the Internet have access to a number of different resources that increase communication and efficiency. Match the support function to the correct term.

Email-file sharing and message exchange EFT-digital bank transactions World Wide Web-displaying, formatting, and retrieval of data

Using the correct syntax allows the user to extract data from multiple fields found in data tables. In order to extract information from multiple tables, the ___ command is used to indicate multiple fields in conjunction with FROM and WHERE to narrow the search and get specific results.

Select

Protecting private or sensitive information by eliminating or encrypting information is the goal of data

anonymization

The process of investigating raw data of various types to uncover trends and correlations, and to answer specifically crafted questions is the role of data _____.

Analytics

Match the the following terms associated with Internet Protocol (IP) addresses to the correct definition

IP address that are permanently assigned: Static IP address Four-decimal notation such as 182.124.7.9. This allows for approximately 4 billion IPv4 addresses: IPv4 Uses a format such as 2001:0db8:85a3:0000:0000:8a2e:0370:7334 and can accommodate at least 340 undecillion addresses: IPv6 Allows IP addresses to be translated in to recognizable words which are much easier to remember than a set of numbers: Domain Name System (DNS)

The number that is assigned to all information technology devices (routers, modems, etc.) which identifies the device and allows the device the ability to communicate with each other on a computer network, including the Internet is called an Internet ______ address.

IP, protocol

Match each key term that is commonly used in the discussion about cellular communication to the correct definition.

Transmits cell phone signals to the cellular system's mobile switching station: Base Transceiver Station (BTS) Controls all the transmissions between cellular phone towers and their base transceiver stations: Mobile Switching Station Allow smartphones to receive an analog sound wave, such as a person's voice, and convert it to a digital signal that can be processed and stored by a computer: Analog-Digital Converter (ADC) A small computer within your smartphone that analyzes the sounds entering your phone through the analog/digital converter: Digital Signal Processor (DSP)

Uses of data analytics include which 3 of the following?

Improved decision making Improved customer service Improved patient experiences and internal procedures in healthcare

In the broadest sense, the of Things refers to everything connected to the Internet. It allows billions of devices to be connected to the Internet and is increasingly being used to define objects connected to the Internet that talk to each other including sensors, wearable technology, and smartphones.

Internet

Select all that apply Select all of the correct statements about Transmission Control Protocol/Internet Protocol.

Used as a private network communications protocol for private networks including intranets and extranets A suite of communication protocols (standards/rules/guidelines) used to connect devices to the Internet Covers how software applications communicate across networks and how data packets are assembled and reassembled once they reach their destination

Match these 5G concepts with their descriptions.

Networks will support 500 mbps to 10 Gbps of download speed. Speeds vary by location and carrier. At the top end, that's over 100 times the speed of 4G: faster connection/data transfer speeds Allows for more high-demand devices to connect over single network. This means more people can transmit data at the same time: greater capacity On 4G networks, the time that passes when a device is asked to perform a task to when it is completed is between 40-50 milliseconds. It is estimated 5G can reduce this by 75%: lower latency

Match each use of a Geographic Information System (GIS) to the correct definition.

With a location specified, the GIS finds targets within the defined area. This can include gas stations, hospitals, and retail stores: Proximity Location When a user has determined their destination, GIS can assist in providing directions: Route Information GIS can map population densities based on a standardized unit of measure (kilometers). This can assist decision making related to increased police presence or mapping of delivery routes: Density Maps GIS can provide information related to how many businesses are present in a certain geographic area. This can help businesses to make more informed decisions about where to open their next store: Quantity Maps

According to the National Institute of Standards and Technology (NIST) there are four Cloud computing deployment models. Match the Cloud computing deployment model description to the correct Cloud deployment model term.

Cloud infrastructure is provisioned for exclusive use by a single organization comprising multiple consumers, e.g., business units): private cloud The Cloud infrastructure is provisioned for open use by the general public. It may be owned, managed, and operated by a business, academic, or government organization, or some combination of them: public cloud The Cloud infrastructure is a composition of two or more distinct Cloud infrastructures that remain unique entities but are bound together by standardized or proprietary technology: hybrid cloud Cloud infrastructure for exclusive use by a specific community of consumers from organizations that have shared concerns (mission, security requirements, policy and compliance): community cloud

Select all that apply Select what's true about Geographic Information Systems (GIS). More than one answer may be selected

GIS permits organizations and users the ability to store, view, and analyze geographic and geographic data in the form of multidimensional charts and maps. GIS allows for the analysis of spatial data (including geospatial data and geographic information) that is used for more informed decision making. GIS are built on a foundation provided by the Global Positioning System (GPS).

While there are many benefits of Cloud computing, there are also some disadvantages. One of the disadvantages is __. Cloud infrastructure is owned, managed, controlled, and monitored by the Cloud service provider. This means the customer often has little control over Cloud service processes and procedures.

Limited control

Web services are a set of software technologies that are able to exchange information with each other using standardized web communication protocols and languages. One of the technologies on which web services are based is XML. XML stands for Extensible Language.

Markup