Deck 3: Data Management, Business Intelligence, and Data Analytics

Question 1

An accurate and consistent view of data throughout the enterprise is needed so one can make informed,actionable decisions that support the business strategy.A function performed by a DBMS to integrate,match,or link data from disparate sources is data _____________.

A)filtering
B)profiling
C)synchronization
D)maintenance

Answer 1

C

Question 2

Users typically access data as needed from a database management system by using ________.

A)BI tools
B)SQL
C)Transaction processing
D)Data filtering

Answer 2

B

Question 3

Data warehouses and data marts are optimized for all of the following except:

A)Transaction processing
B)Data mining
C)Business intelligence
D)Decision support

Answer 3

A

Question 4

Ad-hoc requests for specific data from a database or warehouse are called ___________.

A)Unplanned reports
B)Relational reports
C)Volatile
D)Queries

Question 5

The function of a DBMS that controls data integrity over time is ______________.

A)Data filtering and profiling
B)Data integrity and maintenance
C)Data synchronization
D)Data security

Question 6

A DBMS that does not lose service as a result of a single failure is said to be ______________.

A)scalable
B)fault tolerant
C)volatile
D)synchronized

Question 7

The primary benefits of centralized database configuration are better ___________ and ____________.

A)Reports / Statistical Tools
B)Quality / Security
C)Speed / Access
D)Software / Hardware

Question 8

The function of a DBMS that matches,or links data from disparate sources is ______________.

A)Data filtering and profiling
B)Data integrity and maintenance
C)Data synchronization
D)Data security

Question 9

Organizations that cannot afford the cost of a data warehouse,but want the benefits of online analytic processing invest in___________.

A)spreadsheets
B)big data
C)text mining
D)data marts

Question 10

The primary disadvantage of centralized database systems is ________.

A)Data security
B)Data quality
C)Availability of statistical analysis tools
D)Transmission delay when users are geo-dispersed

Question 11

The supply of oranges used by Coca-Cola has a three-month growing season,but orange juice production is year-round.Therefore,producing orange juice with a consistent taste year-round is complex.How does Coca-Cola deal with this complexity and keep their orange juice taste consistent?

A)An orange juice decision model was developed that combines detailed data on the 600+ flavors that make up an orange.
B)A decentralized data model was developed to respond to consumer preferences.
C)Legacy systems were replaced with data silos to manage big data.
D)A data governance program was implemented to ensure that juice preferences are achieved.

Question 12

Data in a ________ are volatile because they record ongoing transactions.

A)Database
B)Data warehouse
C)Data mart
D)Data silo

Question 13

Which of the following data management technologies store data that are generated by business apps and operations?

A)Data marts
B)Data warehouses
C)Databases
D)Transaction-processing systems (TPS).

Question 14

______________ is the elapsed time between when data are created and when they are made available for a query or report.

A)Synchronization
B)Latency
C)Volatility
D)Tolerance

Question 15

Which of the following is not a consequence of poor quality or dirty data?

A)The company loses sales or customers
B)Information workers are constrained in their jobs
C)Decision makers face too much uncertainty to make intelligent decisions
D)The company faces data ownership problems

Question 16

________ tools and techniques process data and do statistical analysis for insight and discovery.

A)Operational intelligence
B)Business intelligence
C)Information accessibility
D)Information fluidity

Question 17

After data are extracted from a database and processed to standardize their format,they are then loaded into a ________ and ready for analysis.

A)Synchronized,low-latency system
B)Decision support system
C)Data warehouse
D)DBMS

Question 18

The function of a DBMS that inspects the data for errors,inconsistencies,redundancies,and incomplete information is ______________.

A)Data filtering and profiling
B)Data integrity and maintenance
C)Data synchronization
D)Data security

Question 19

The function of a DBMS that standardizes and verifies the consistency of the data is ______________.

A)Data filtering and profiling
B)Data integrity and maintenance
C)Data synchronization
D)Data security

Question 20

NoSQL systems have increased in popularity because of the growing need for ________,which means the system can increase in size to handle data growth.

A)scalability
B)fault tolerance
C)handling big data
D)large Web apps

Question 21

Walmart's use of big data analytics focused on updating the Polaris search engine with clickstream data,resulting in an increase in online shoppers completing a purchase by more than ________ percent.

A)5
B)10
C)20
D)25

Question 22

With text analytics,information is extracted out of large quantities of various types of textual information.Which of the following is not one of the steps involved in text analytics described in your text?

A)Exploration of documents for preliminary categorization or identification of common topics
B)Preprocessing of documents to standardize content as much as possible
C)Categorization and modeling of document content using statistical models and business rules
D)Visualization - translating text data to graphic format (e.g.charts,graphs)for effective reporting

Question 23

Machine-generated sensor data from________ are becoming a much larger proportion of big data and analytics.

A)physical objects
B)satellites
C)smartphones
D)vehicles

Question 24

When customer X calls an organization's customer service center,the service representative has access to a complete history of X's previous calls,as a list of the services X has purchased,and customer profitability score.All of this information is up-to-date and is accessed from the company's _________.

A)Management information system
B)Transactional database system
C)Active data warehouse
D)Online transaction processing system

Question 25

What is the key advantage of an active data warehouse compared to a traditional data warehouse?

A)The ADW is less expensive to install and operate
B)Data from an ADW can be used for DSS,report generation and Business Intelligence
C)Data in an ADW is constantly updated,providing more current data than a traditional data warehouse
D)The ADW is more widely available from a larger number of vendors

Question 26

___________ is a set of processes that aid organizations in integrating data from various sources or enterprise applications to create and maintain a more unified view of a customer,product,or other core data entity that is shared across systems.

A)Client/server architecture
B)OLAP
C)Master data management
D)Data synchronization

Question 27

________ processes move data from databases into data warehouses or data marts,where the data are available for access,reports,and analysis.

A)Big data analytics
B)Data mining
C)Extract,transformation,load (ETL)
D)Data de-duplication

Question 28

Big data volumes that exceed the processing capacity of conventional infrastructures are processed using the ________ platform.

A)Oracle
B)Hadoop
C)ADW
D)MySQL

Question 29

In terms of the major functions performed by a DBMS,"data filtering and profiling" refers to which of the following?

A)Inspecting the data for errors,inconsistencies,redundancies,and incomplete information.
B)Correcting,standardizing,and verifying the integrity of the data.
C)Integrating,matching,or linking data from disparate sources.
D)Checking and controlling data integrity over time.

Question 30

Distributed databases use ___________ architecture to process information requests.

A)Client/server
B)NoSQL
C)Private clouds
D)Public clouds

Question 31

____________ software enables users to analyze data from various dimensions or angles,categorize them,and find correlations or patterns among fields in the data warehouse.

A)NoSQL
B)Data mining
C)Hadoop
D)Nexus

Question 32

According to the ________,a majority of data is seldom accessed after a 3-month period.

A)Principle of data in context
B)Principle of 90/90 data use
C)Principle of diminishing data value
D)Principle of data quality

Question 33

________ enable managers to predict how customers would behave and use that knowledge to be prepared to respond quickly.

A)Big data analytics
B)Data discovery
C)Master data management
D)Information optimization

Question 34

Sometimes organizations place too much emphasis on the costs associated with acquiring high levels of data quality and ignore the costs of "dirty" or poor quality data.Which of the following sets of factors make up the total costs associated with poor quality data?

A)Technology costs + Training costs + Marketing costs
B)Value of lost business + Cost to prevent errors + Cost to correct errors
C)Cost of repeating analyses + Lost opportunity costs + Cost of unrealized threats
D)Value of lost business + Cost to correct errors + Cost of repeating analyses (on corrected data)

Question 35

The principle of ________ explains why most organizations cannot operate at peak performance with blind spots (lack of data availability)of 30 days or longer.Global financial services institutions rely on near-real-time data for peak performance.

A)data in context
B)90/90 data use
C)diminishing data value
D)data quality

Question 36

_____________ helps companies tap into the massive volume of customer opinions expressed online.

A)Media metrics
B)Unstructured analytics
C)Text mining
D)Media mining

Question 37

In the past,data was transferred from OTLP databases to data warehouses periodically,say once a month or even once a week.Now,the trend is toward ___________,or real-time,data warehousing so that analysis and decision support apps use current data.

A)Active
B)Always-on
C)Dynamic
D)Operational

Question 38

Which of the following is not a risk associated with cloud-based BI?

A)Slower response time
B)Security risk
C)Backup risk
D)Increased costs

Question 39

MDM consolidates data from various data sources into a __________,which then feeds data back to the applications,thereby creating accurate and consistent.This helps eliminate redundancies,inaccuracies and omissions that might otherwise hinder business processes.

A)Data silo
B)Master reference file
C)Backup file
D)Central directory

Question 40

Despite the need for high-quality data,____________ and technical issues often make it a difficult goal to achieve.

A)High costs
B)Untrained or undertrained IT personnel
C)User errors
D)Organizational politics

Question 41

________ are documentation of business events,actions,decisions,or transactions.

A)data
B)reports
C)information
D)records

Question 42

Which of the following would not be a benefit of using ERM?

A)Enabling the company to access and use the content contained in documents.
B)Cutting labor costs by automating business processes.
C)Increasing costs associated with printing,storing,and searching for content
D)Reducing the time and effort required to locate information the business needs to support decision making.

Question 43

______________ systems consist of hardware and software that manage and archive electronic documents and image paper documents;then index and store them according to company policy.

A)Electronic records management
B)Business management
C)Compliance
D)Digital Document

Question 44

Data generated by business apps,sensors,and transaction processing systems (TPS)are typically stored first in a database.

Question 45

Volatile refers to data that change frequently.

Question 46

The Four V's of Data Analytics are Variety,Volume,Velocity,and ______________.

A)Volatility
B)Visibility
C)Vicinity
D)Veracity

Question 47

Companies have always faced the challenge of managing physical documents.Which of the following is the most significant challenge associated with managing physical documents?

A)The volume of documents that must be reviewed to determine if they should be retained or destroyed
B)Loading documents onto company websites
C)Sharing documents across geographic locations
D)Translating documents into other languages

Question 48

Which of the following would not be a benefit of using ERM?

A)Limiting the access and usage of the content contained in documents
B)Reducing the time and effort required to locate information the business needs to support decision making.
C)Improving the security of content,thereby reducing the risk of intellectual property theft.
D)Minimizing the costs associated with printing,storing,and searching for content.

Question 49

________ must ensure that their companies comply with legal and regulatory duties by managing electronic records.

A)Senior management
B)CIOs
C)Corporate lawyers
D)Workers

Question 50

Many database management systems use the Syntax Query Language (SQL)for programming queries.

Question 51

Adaptive means the system can increase in size to handle data growth or the processing load of an increasing number of concurrent users.

Question 52

SQL is an ad-hoc request for specific data or information from a database or warehouse.

Question 53

Operational intelligence refers to the credentials,technological skills,decision making abilities,and industry experience of key leaders in an organization.

Question 54

Traditional databases are not well suited for managing unstructured data such as customer comments and tweets.

Question 55

Online transaction processing (OLTP)systems are designed to manage transaction data,which are volatile.

Question 56

All of the following are factors contributing to the increased use of BI,except:

A)Smart devices and demand for 24/7 access to insights
B)Proprietary information systems
C)Cloud-enabled BI and analytics
D)Increased amounts of data

Question 57

Data warehouses and data marts are optimized for extremely fast transactions processing.

Question 58

Relational databases store data in tables consisting of columns and rows,similar to the format of a spreadsheet.

Question 59

Improperly managed or destroyed business records become ________.

A)archives
B)liabilities
C)breach of contracts
D)lawsuits

Question 60

Data latency is the elapsed time or delay between when data are created and when they are available for a query or report.

Question 61

Data analytics will produce results,but those results might be meaningless or misleading.

Question 62

Data mining is important because any customer can become a brand advocate or adversary by freely expressing opinions and attitudes that reach millions of other customers on social media.

Question 63

Databases are stored on servers that reside in the company's data centers,a private cloud,or a public cloud.

Question 64

Up to 25 percent of an organization's data are nonstructured word-processing documents,social media,text messages,audio,video,images and diagrams,fax and memos,call center or claims notes,and so on.

Question 65

Data are worthless if you cannot analyze,interpret,understand,and apply the results in context.

Question 66

Distributed databases use a Select Query (SQ)architecture to process information requests.

Question 67

Distributed databases use a client/server architecture to process information requests.

Question 68

Low-cost sensors make it possible to monitor and control the behavior of all types of physical things.

Question 69

Data ownership,data quality,and formally managed data are high on the agenda of database managers because they are held personally accountable if their company is found to be in violation of regulations.

Question 70

Databases need one or more backups and should be archived either onsite or offsite in case of a crash or security incident.

Question 71

To improve quality,McDonald's bakery operation replaced manual equipment with high-speed photo analyses to inspect thousands of buns per minute for color,size,and sesame seed distribution.

Question 72

Social commentary and social media are mined for sentiment analysis or to understand consumer intent.

Question 73

Big data can have a significant positive impact on the success of any enterprise,or be a low-contributing major expense.

Question 74

According to the 90/90 data-use principle,a majority of stored data,as high as 90 percent,is often accessed after 90 days.

Question 75

The primary disadvantage of distributed database configurations is transmission delay when users are geo-dispersed.

Question 76

MapReduce breaks up the huge dataset into smaller subsets;then distributes the subsets among multiple servers where they are partially processed.

Question 77

A distributed database allows apps on computers and mobiles to access data from local and remote databases.

Question 78

A limitation of Apache Hadoop is that it imposes conditions on the structure of the data it can process.

Question 79

Profit margin is a measure of the percent of a company's revenue left over after paying for its variable costs,such as wages and raw materials.

Question 80

Master data entities are the main entities of a company,such as customers,products,suppliers,employees,and assets.