DATABASES: IS 3100 (chapter four)
which of the following is an example of organization analyzing predictive behavior with the goal of creating new offerings?
A in-home healthcare provider tracks the hospital readmission rates of elderly people who live alone after they received care for failing in their homes, Netflix tracks what used who viewed all three seasons of Stranger Things also had in their queues
How are data marts different from data warehouses?
Data marts focus on an individual department or business function and manage less data than a data warehouse.
which of the following statements describe the capabilities database management system?
RDBMS have features that support the quality and security of data
the four steps in a data quality audit are___
assessment, design, transformation, and monitoring
organizations often use data scrubbing software because it____
automatically analyzes data, then fixes any errors, and consistently formats the data according to an organization's guidelines
To control how information is entered into a database, programmers and database administrators create ___ to help ensure data integrity.
forms
primary purpose of a business intelligence system is to___
help a business make a strategic decisions based on it own data
businesses use business intelligence system to___
help them make decisions that are formed by business data and facts
which of these steps in data mining process most likely involves the actual "mining" or "knowledge discovery in data"?
model building and evaluation
to search a database for information, create a___
query
Forms allow data to go into a database, ___ display information coming out of a database.
reports
To display or distribute information from a database, programmers or database administrators create ___ .
reports
business can use in-memory computing to conduct or support almost any task that____
requires the full RAM storage and processing capability of the users operating system
which statement best summarizes the primary advantages of performing a data quality audit?
the audit recommends ways the organizations can improve its data quality and reduce costs through increasing data consistency
which of the following describes the defining characteristics of big data?
the data are measured in terabytes or even larger units, that data are from structured and unstructured sources and exist in multiple forms
examples of a relationship that are entity relationship diagram could be used to describe
the employees who report to a specific manager in a organizational chart, products a customer has ordered, the courses a student is taking
which of the following is an example of the type of information data mining can yield?
the likihood of a Gen X female who makes $50,000 and is divorced with no children will take a trip within a year or her divorce being finalized, middle aged males who are members of their local church bible study group are more inclined to vote than younger males who are also members of a local bible study group
two statements the explain the roles of data marts and data warehouses in a decision support system
- data warehouses are used to analyze long term, historical data for an organizatioms strategic purposes, because they store data from different time periods and subject areas, data marts are used to analyze recent data that a department needs for operational troubleshooting and management, because they collect and measure data specific to that area
which is an example of why a database should be accessible through the web?
-a small distributor with limited staffing wants customers to be able to track the status of their orders without having to contact a customer service presentative - a large portion of a company's workforce are contract workers who work offsite, using their own devices to complete their work - a company has recently scaled it operations so that it compares internationally and needs business partners all over the world to have access to its database
which statement explains the difference between a database management system (DBMS)
a DBMS is a software program design to organize and administer databases
which of the following is an example of what an informative policy could specify?
a large corp grants access to salary infromation to the direct supervisors of employees and to members of the Human Resources department who administer payroll a user agreement on a website indicates that it will store the browsing history linked to IP address for an indefinite amount of time and reserves the rights to sell that information to interested parties health insurance company stores data that patients self reports as inputs on its websites, but does not link that data with information about the patients search history
which statement best explains why traditional file systems have certain issues?
each file is independent of another file in a traditional system
the practice of data scrubbing is a vital part of data quality management because it___
ensures ongoing data validity by identifying adn then fixing data errors
the practice of data scrubbing is vital part of data quality management because it
ensures ongoing data validity by identifying and then fixing data errors
organizations use data warehouses mainly to___
facilitate the analysis of data from multiple sources
in a relational database, a common field that links two labels in a relationship but is not a primary key is called a_____
foreign key
for which task is a data mart more useful or appropriate than a data warehouse?
resolving a current problem with a specific type of inventory, purchase transaction or supply chain
which of the following is a task that an SQL statement would be expected to perform?
retrieve data
a relational database management system (RDBMS) is a type of DBMS whose primary function is to____
show how data are connected through relationships
Your college has a database with a Students table. Which of the following could be a primary key in the table?
social security number and student number
the primary characteristic of relational database is that it___
stores and allows access to data objects that are related to one another ( a rational database structures data and create relationships between objects. the data may be stored and accessed in different ways)
organizations use____ to determine what contributions the departments or work units can make toward the organizations strategic priorities and policies during the next 6- 24 months
tactical
which statement best summarizes how a data governance plan is created?
the plan is tailored to the organization's specific goals, objectives, and actions
why do large, data-driven companies use analytic platforms?
they generate vast amounts of organizational data and need to be able to rapidly analyze and interpret this information to make informed business decisions
what is a reason why an organization would use web mining?
a new social media platform wants to increase engagment and is looking to know what content its most frequent users spend the most time engaging with him, an e-commerce business looking to improve the customer experience and its website to boost sales want to know what types of sites users go to after visiting their website and putting items in their card but not completing a purchase
data mining is best described as__
a research and analysis technique in which data analysts employ mathematical tools and artificial intelligence to search large volumes of data and discover less-obvious patterns and trends
a query is a request for information stored in a database. one of the benefits of using a database to store information is the ability to run a query. in relational database management systems, there are a variety of query tools that are used to execute and run queries. which of the following are tools used to run queries in a RDBMS?
action queries, crosstab queries, SQL specific queries
database management (DBMS) make it easier to secure data and information because they___
allow for the creation of access constraints
what is the purpose of an SQL statement?
answer questions about the database (SQL uses statements generated by the user to answer questions about the database)
referential integrity states that structural relationships in relational databases must____
be consistent: a foreign key field that references a primary key field must agree with that primary key
which of the following are advantages of cloud databases over a traditional database?
can support both SQL and NoSQL databases, are maintained by an external provider such as Amazon or Oracie, can be accessed through an application programming interface
which type of database maintains the hardware and operating system offsite and is accessed via internet-based applications?
cloud database
establishing how an organization manages its data and making sure the organization adheres to these methods it a function called__
data administration
data integrity is increase when___
data are centralized (storing data in one place is vital to increasing data integrity)
which term best describes the process organizations use to discover meaningful relationships and patterns among the data sets it has collected?
data mining
organizing data so that data are in simple tables without any redudances is known as
data normalization
organizing data so that data are in simple tables without any redundancies is known as___
data normalization
Brooks Accounting is no stranger to audits- for their customers. managers discovered come issues in services and billing they suspected were linked to their databases practices rather than to employee competence. brooks hired an outside firm to perform a data quality audit. which statement best describes how the audit process identifies problems?
data profiling analyzed the accounting firm's data sources
which of the following sets of characteristics specifically apply to relational databases?
data tables in a relational database are linked by the fields they have in common, a relational database organizes data in tables composed of records or objects (the rows), and fields (the columns)
which statement best summarizes how organizations use data warehouses?
data warehouses are used to store data from multiple sources for collective analysis
which statement most accurately describes the value of data integrity to an organization?
databases and database management system with a high level of data integrity enable more efficient data maintenance in support of organizational goals
which of the following task that data adminstration would be responsible for?
defining polices stating that employees may not share data with people who are not employees of the organization, deciding that the organization will begin collecting and storing users' locations upon the release of the next generation software for its mobile app, determining that two factor identification must be used to access data that the company has determined be confidential
which of the following correctly describes a type of data mart?
dependent data marts extract data from a data warehouse when it is needed, independent data marts are separate from data warehouses and are created in order to collect data relating only to particular business, hybrid data marts combine data warehouse and other collection systems
which of the following statements correctly describes referential integrity?
for referential integrity to exist, data on both sides of the table relationship must be present, referential integrity applies to data quality within the structure of a relational database
a database management system (DBMS) is a computer program that is used to_____
help organize the data found in a database
Forms structure data input to help ensure data ________, meaning the information entered is accurate, timely, and useful.
integrity
businesses can use in-memory computing to conduct or support almost any task that
involves the near instantaneous processing and analysis of huge volumes of data
why is online analytical processing software included in many business intelligence software applications?
it allows for sophisticating data and trend analysis, data modeling, and forecasting, it allows user to view data from different perspectives of angles and gain new insights, it allows reports and analytics to be exported to more user-friendly, front-end tools
how does the structure of an online analytical processing database shape its core functionality?
its use of data cubes allow users to conduct complex quieries, analyses, and modeling by taking multiple dimensions of data (types of levels) into account and viewing data from multiple viewpoints or "slices" (such as data or location)
in the datasheet view of a relational database (like Microsoft access), a row of information is called___
list
which of the following tasks are NoSQL databases designed to do?
manage large databases across different platforms, analyze nonstructured data, create queries from the data created from web apps
which of the following tasks can businesses perform with the help of in-memory computing?
mapping alternative driving routes to help truckers avoid bad weather and traffic jams, predicting the impact of news on stock prices and conducting immediate transactions, altering online customers that the desired items is out of stock before the order is placed
which of the following are examples of data objects that a relational database management system (RDBMS) may include?
names of customers and records of when merchandise was returned, addresses of the company's wholesalers and the number of items in a company's inventory
In contrast to computerized systems, traditional file management systems can create issues with ______.
organization, repetition, and lack of consistency
why is it important for all organizations, no matter how small, to create and implement organizations information policies?
organizational data are a critical asset; it is important to ensure its security
why is it important for all organizations no matter how small, to create and implement organizational policies?
organizational data are critical assets; it is important to ensure its security
the important goals of data governance are to___
protect data from risk, misuse, regulatory noncompliance, and quality and cost issues
a database provides the capability of conducting searches or asking questions. a question or search for information in a database is called a
query
analytical platforms are designed to__
quickly gather and analyze specific organizational data to provide information that guides decision making
analytic platforms are designed to___
quickly gather and analyze specific organizations data to provide information that guides decision making
which of the following improvements might be the direct outcome of a data quality audit?
recommendations for a new data management design and prescriptions for preserving data quality, corrections in source data issues and ways to examine data over time, elimination of redundant metadata and strengthened referential integrity
in a relational database, such as microsoft access, a collection of related fields in a data file is called a______
record
A link between tables in a relational database that defines how the data is related is called a _____.
relationship
why must database administrations be trained or experienced in using an organizations specific database platform?
they must troubleshoot or solve problems with the data base when necessary
the primary purpose of business intelligence system is to___
to help a business make a strategic decisions based on its own data
what is the primary role of a database administer?
to monitor the database and ensure that it functions when needed
relational database management systems have a variety of tools that can be used to execute/ run queries. one of these query tools is the ability to execute/ run action queries. which of the following are common types of action queries?
update query, delete query, append query
