data science exam 1

In which stage of extraction, transformation, and load (ETL) into a data warehouse are anomalies detected and corrected?

Cleanse

How are enterprise resources planning (ERP) systems related to supply chain management systems?

Complementary systems

Business applications have moved from transaction processing and monitoring to other activities. Which of the following is not one of those activities?

Data Monitoring

Which characteristic of data requires that the variables and data values be defined at the lowest (or as low as required) level of detail for the intended use of the data?

Data granularity

Which characteristic of data means that all the required data elements are included in the data set?

Data richness

What is the fundamental challenge of dashboard design?

Ensuring that the required info is shown clearly on a single screen

Which approach to data warehouse integration focuses more on sharing process functionality than data across systems?

Enterprise application integration

The need for more versatile reporting than what was available in 1980 led to the development of what type of system?

Executive info system

Data source reliability means that data are correct and are a good match for the analytics problem

FALSE

Data warehouses are subsets of data marts.

FALSE

Moving the data into a data warehouse is usually the easiest part of its creation

FALSE

To respond to its market challenges, SiriusXM decided to focus on manufacturing efficiency

FALSE

Visual analytics is aimed at answering, "what is it happening?" and is usually associated with business analytics

FALSE

When telling a story during a presentation, it is best to avoid describing hurdles that your character must overcome, to avoid souring the mood.

FALSE

bill inmon advocates the data mart bus architecture whereas Ralph Kimbell promotes the Hub- and - spoke architecture, a data mart bus architecture with conformed dimensions

FALSE

Business intelligence is a specific term that describes architectures and tools only.

False

Computerized support is only used for organizational decisions that are responses to external pressures, not for taking advantage of opportunities

False

Managing information on operations customers internal procedures and employee integration is the donative science.

False

All of the following are benefits of hosted data warehouses EXCEPT

Greater control of Data

How does the use of cloud computing affect the scalability of a data warehouse?

Hardware resources are dynamically allocated as use increases

in the opening vignette on sports analytics, what type of modeling was used to predict offensive tactics?

Heat Maps

Which data warehouse architecture uses a normalized relation warehouse that feeds multiple data marts?

Hub-and-spoke

Key performance indicators (KPIs) are metrics typically used to measure

Internal results

describe the structure and meaning of the data, contributing to their effective use.

METADATA

Oper marts are created when operational data needs to be analyzed

Multidimensionally

Which type of visualization tool can be very helpful when the intention is to show relative proportions of dollars per department allocated by a university administration?

Pie Charts

What type of analytics seeks to determine what is likely to happen in the future?

Predictive

What type of analytics seeks to recognize what is going on as well as likely to forecast and make decisions to achieve the best performance?

Prescriptive

Most data warehouses are built using _____ database management systems to control and manage the data

RELATIONAL DATABASES

The competitive imperatives for BI include all of the following except?

Right User

Which of the following is not an example of transaction processing?

Sales Report

in the opening vignette on sports analytics, what was adjusted to drive on time ticket sales?

Ticket prices

In what decade did disjointed information systems begin to be integrated?

1980's

Online transaction processing (OLTP) systems handle a company's routine ongoing business. In contrast, a data warehouse is typically?

A distinct system that provides storage for data that will be made use of analysis

What is Six Sigma?

A methodology aimed at reducing the number of defects in a business process

BI applications must be integrated with?

All of these

Which if the following is an umbrella term that combines architecture, tools, databases, analytical tools, applications and methodologies?

BI

Kaplan and Norton developed a report that presents an integrated view of success in the organization called.

Balanced scorecard- type reports

Real- time data warehousing can be used to support the highest level of decision making sophistication and power. The major feature that enables this in relation to handling the data is

Speed of data transfer

When representing data in a data warehouse, using several dimension tables that are each connected only to a fact table means you are using which warehouse structure?

Star schema

Data is the main ingredient for any BI, data science, and business analytics initiative

TRUE

Descriptive statistics is all about describing the sample data on hand

TRUE

One of SiriusXM's challenges was tracking potential customers when cars were sold

TRUE

One way an operational data store differs from a data warehouse is recency of their data

TRUE

Predictive algorithms generally require a flat file with a target variable, so making data analytics ready for prediction means that data sets must be transformed into a flat-file format and made ready for ingestion into those predictive algorithms

TRUE

Structured data is what data mining algorithms use and can be classified as categorical or numeric.

TRUE

Visualization differs from traditional charts and graphs in complexity of data and use of multiple dimensions of measure

TRUE

With key performance indicators, driver KPI's have a significant effect of outcome KPI's but the reverse is not necessarily true.

TRUE

without middleware, different BI programs cannot easily connect to the data warehouse

TRUE

Benefits of the latest visual analytics tools, such as SAS visual analytics, include all of the following EXCEPT

They explore massive amounts of data in hours, not days