MIS Exam 2
Which of the following are important questions to ask before signing a service level agreement (SLA) with a cloud services security vendor? More than one answer may be selected.
-Are you in compliance with local, state, and federal security standards and regulations? -Do you go through external security audits? -How is data from different corporations kept separate?
Which of the following describes a popular collaboration software program that is used in business? More than one answer may be correct.
-Smartsheet is online project management software that focuses on the collaborative aspects of project management. -Slack is a collaboration hub that focuses on making communication seamless using communication channels other than email. -Trello is a collaboration tool that organizes projects into boards to create visual representations of project info and status.
What is the difference between a cloud service and a web service?
A cloud service provides users with increased computing power and data management, whereas a web service provides the software tools needed for devices and systems to communicate with each other.
Which of the following is an advantage of integrating AI with database management?
AI can significantly reduce data errors and optimize resources
What is the purpose of an SQL statement?
Answer questions about the database
In analyzing transactions, Walmart discovered that many people who buy Children's Tylenol in their stores also buy orange juice in the same transaction. They used this information to discount Children's Tylenol but raise the price of orange juice during flu season. What is the name of the approach Walmart used to discover this information? Multiple choice question.
Big data
The essential RDBMS functions; create, read, update, and delete data is collectively referred to as which acronym?
CRUD
Which type of database maintains the hardware and operating system offsite and is accessed via Internet-based applications?
Cloud database
Forms are created using ________software.
DBMS
What element of a database field specifies the data in a field such as text, numeric, or date/time?
Data Type
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 statement best summarizes how organizations use data warehouses? Multiple choice question.
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 (DBMS) with a high level of data integrity enable more efficient data maintenance in support of organizational goals.
Which statement best explains why traditional file systems have certain issues?
Each file is independent of another file in a traditional system.
An instant computing infrastructure composed of processing, data storage, and a variety of other computing resources provided by a cloud vendor to assist in running an organization's information systems is referred to as platform as a service.
F
Collaboration software leads to better collaboration by enabling people from across the organization and in the same time zone to share content in real time.
F
Common data administration duties include the development of information policies, data planning, data mining, security, and how internal-users and end-users use that data
F
Created in 2008, bitcoin cash remains the most widely traded and respected cryptocurrency.
F
In a database relationship, you can delete a primary key field if there is an associated foreign key record. Group starts
F
The next generation of mobile connectivity, called 4G, is faster and more reliable.
F
How does the structure of an online analytical processing (OLAP) database shape its core functionality?
Its use of data cubes allows users to conduct complex queries, analyses, and modeling by taking multiple dimensions of data (types or levels) into account and viewing data from multiple viewpoints or "slices" (such as by date and location).
Which of these steps in the data mining process most likely involves the actual "mining" or "Knowledge Discovery in Data"?
Model building and evaluation
Doing a data quality audit helps ensure the highest quality of data being used for business intelligence and other applications. The data analysis method involves quality assessment, design, transformation, and ________Blank.
Monitoring
Why is it important for all organizations, no matter how small, to create and implement organizational information policies?
Organizational data are a critical asset; it is important to ensure its security.
To set a primary key field in a database table, you must click the ________Blank key button.
Primary
In a relational database, such as Microsoft Access, a collection of related fields in a data file is called a _.
Record
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 cloud database platform includes the hardware and operating environment of servers in an internet-based datacenter. Group starts
T
A virtual private network creates a secure connection between two computers, allowing for encrypted communications that uses the Internet for data transmissions and communication.
T
One benefit of cloud computing is flexibility.
T
Platform as a service is a cloud-based computing model where cloud service providers host the hardware and software needed for development on their own infrastructure, removing the need for developers to install this on their own devices.
T
Popular applications used by today's organizations in web mining include Google Analytics, Data Miner, and ________Blank.
Tableau
A mid-sized independent hardware store has recently merged with a large national chain. The local owners have long used a reliable database to manage inventory. Their database has been essential in balancing orders for seasonal merchandise with the problem of limited shelf space. The merger will soon entail managing many more types of data, as the national chain has approved lists of suppliers, precise requirements for recording transactions, specific human resources procedures, and more. Which statement best summarizes what the local managers will be able to do for the first time when they start using the parent company's database management system (DBMS)? Multiple choice question.
The managers will be able to create, edit, and store data in a secure manner across all data types required by the parent company.
What is the primary role of a database administrator (DBA)?
To monitor the database and ensure that it functions when needed
Which of the following is a key focus of maintaining data quality in database management?
Utilizing SMART data quality metrics
A leading manufacturer of fitness trackers partners with a large health insurance network. Insurance network members receive a discounted fitness tracker and financial rewards for setting and achieving tracked personal fitness goals. Which characteristic of the resulting Big Data would be most directly affected by a tracker software error that counted users' arm movements as steps?
Veracity
A corporate sales organization is hosting its annual regional meeting. It needs to book a hotel within the region where attendees will stay for three days and two nights. The hotel must have: 30 standard hotel rooms for its sales reps, 5 suites for the regional managers, and 5 conference rooms to hold training sessions. There also must be two restaurants within walking distance of the hotel that can accommodate a dinner reservation for 40 people. Which web mining technique would the organization use to narrow down the choices of hotels to those that fit these parameters? Multiple choice question.
Web content mining
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
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
Referential integrity states that structural relationships in relational databases must ______. Multiple choice question.
be consistent: a foreign key field that references a primary key field must agree with that primary key
Which cryptocurrency shares features with a previous cryptocurrency but is technologically enhanced?
bitcoin cash
The role of a DBA is to ________Blank and maintain tables in a relational database.
build
The key goals of data governance include rules for data use, requirement compliance, high-quality data, and _________Blank.
cost reduction
Online Analytical Processing (OLAP) is included in many Business Intelligence (BI) software applications. We use this OLAP for a range of ________Blank discovery activities, including report creation and analysis, analytical calculations, forecasting, budgeting, planning, and what-if predicative analysis.
data
We use database forms to control how ________ enters a database.
data
Establishing how an organization manages its data and making sure the organization adheres to these methods is a function called ______.
data administration
Data integrity is increased when ______.
data are centralized
Organizing data so that data are in simple tables without any redundancies is known as __________.
data normalization
A cloud database infrastructure integrates computer hardware and operating system in an internet-based ________Blank.
datacenter
List disadvantages of cloud computing. More than one answer may be correct.
downtimesecurity riskslimited control
Search Engine Optimization (SEO) can be ________Blank through the information gained by web mining.
enhanced
Which cryptocurrency offers a blockchain-based platform that can be used to develop decentralized applications?
ethereum
Organizations use data warehouses mainly to ______. Multiple choice question.
facilitate the analysis of data from multiple sources
The primary purpose of a business intelligence (BI) system is to ______.
help a business make strategic decisions based on its own data
A database management system (DBMS) is a computer program that is used to ______.
help organize the data found in a database.
Businesses use business intelligence (BI) systems to ___.
help them make decisions that are informed by business data and facts.
A company's periodic web mining exercise to determine its best-selling products resulted in the discovery that a product sold in conjunction with a movie released 10 years ago has recently become coveted by nostalgia fans. The company redesigned its website so that interested consumers can purchase the product right on the homepage. This company has used web mining to ______.
improve site usability
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
The main advantage of the IPv6 format for IP addresses is that
it can accommodate many more addresses than the IPv4 format.
In contrast to computerized systems, traditional file management systems can create issues with ______. Multiple choice question.
organization, repetition, and lack of consistency
RAM storage and ________Blank processing are two main in-memory computing components.
parallel
Data administrators are responsible for the ________Blank and procedures used to handle the information of an organization. Large companies use/implement the data management policies and procedures most often.
policies
The Important goals of data governance (DG) are to ______.
protect data from risk, misuse, regulatory noncompliance, and quality and cost issues
While using her phone's GPS to drive to her vacation destination, Siena needs to find a gas station. She enters into her phone's GPS that she is looking for a gas station that is no more than five miles away from the route she is currently on. What is this an example of?
proximity location
A database provides the capability of conducting searches or asking questions. A question or search for information in a database is called a .
query
To search a database for information, create a ___.
query
Analytic platforms are designed to ______.
quickly gather and analyze specific organizational data to provide information that guides decision making
Because we can create relationships in Microsoft Access, this program is considered to be a(n) ________Blank database.
relational
SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the ________language for relational database management systems.
standard
The primary characteristic of a relational database is that it ______.
stores and allows access to data objects that are related to one another
What is the second criteria necessary for adding a block to the blockchain?
transaction verification
