Question 1

Many database management systems use the ______________________ for programming queries.

Accepted Answer

The commonly used abbreviation for the language used to program queries in most database management systems is SQL, which stands for Structured Query Language. Therefore, the correct choice is B.

Question 2

___________________ technology is used to archive the growing amount of physical data

Accepted Answer

Document management technology is designed to help organizations store, track, and manage their physical and digital documents, making it an ideal choice for archiving the growing amounts of data generated by businesses. This technology can help organizations ensure that they comply with legal and regulatory requirements, as well as improve operational efficiency, reduce costs, and enhance data security. USB drives and file management systems, on the other hand, are more focused on storing and organizing digital files rather than physical ones, while mashup technology is typically used to combine and display data from multiple sources in a single dashboard.

Question 3

In terms of IS dependability, _________________data management technologies means zero-downtime, zero data loss, and continuous access to data, analytics, and reporting.

Accepted Answer

Fault tolerant technologies ensure that if one component fails, another takes over without any interruption to the system. This leads to zero downtime, zero data loss, and continuous access to data, analytics, and reporting. Redundant process and high-performance technologies may improve dependability, but they do not guarantee zero downtime or zero data loss. Priority process does not relate directly to dependability.

Question 4

_______________________ integrate data from multiple databases and data silos and organize them for complex analysis, knowledge discovery, and to support decision making.

Accepted Answer

Data warehouses are specifically designed to integrate data from multiple databases and data silos and organize them for complex analysis, knowledge discovery, and to support decision making. Databases, data collectors, and data silos may store data, but they do not have the same level of integration capabilities as a data warehouse.

Question 5

Systems designed to manage volatile transaction data are called _________________________.

Accepted Answer

Online transaction processing (OLTP) systems are specifically designed to manage volatile transaction data in real-time, making them the best choice for this question. VDM systems and TA systems are not commonly used industry terms, and OLAP systems are designed for analytical processing rather than real-time transaction management.

Question 6

What are the two basic types of databases?

Accepted Answer

The two basic types of databases are centralized and distributed. Centralized databases store all data in one location, whereas distributed databases store data across multiple locations. Option A is incorrect as it doesn't specify the difference between the types of databases. Option B is incorrect as it refers to how data is presented, not how it is stored. Option D is incorrect as it divides databases based on their functionality rather than their structure.

Question 7

__________________ refers to an organization's ability to get information to the people who need it to make decisions or react appropriately to business events.

Accepted Answer

Operational intelligence is focused on the real-time or near real-time delivery of information to support operational processes and decisions. This involves getting the right information to the right people at the right time, allowing them to react quickly and effectively to business events. Business intelligence, on the other hand, is more focused on strategic decision-making and tends to involve more complex data analysis and modeling. Information accessibility and information fluidity are not commonly used terms in this context.

Question 8

In a distributed database configuration, the computers and mobile devices that access data from remote servers are called ________________.

Accepted Answer

In a distributed database configuration, the computers and mobile devices that access data from remote servers are called clients. Servers are the remote machines that store and manage the data. Query tools are software programs used to access and manipulate data. Computing accessories are hardware devices such as keyboards, mice, and printers.

Question 9

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

Accepted Answer

Data generated by business apps, sensors, and transaction processing systems (TPS) are typically stored first in a database. This is the most common and efficient way of storing and organizing large amounts of data. Data warehouses and data marts are specialized types of databases designed for analytical purposes, while data silos refer to isolated storage systems that do not integrate with the rest of the organization's data.

Question 10

_________________ are small-scale data warehouses that support a single function or department.

Accepted Answer

Data marts are designed for a specific business function or department and contain a subset of data from a larger data warehouse. They are optimized for quick access and analysis of data related to that particular area, making them a more efficient and cost-effective solution for smaller-scale data needs. Databases are collections of data organized for easy retrieval and manipulation, while data warehouses are large repositories of integrated data from various sources. Data silos, on the other hand, refer to isolated pockets of data within an organization that cannot be easily accessed or shared.

Question 11

_____________________ tools and techniques process data and do statistical analysis for insight and discovery-that is, to discover meaningful relationships in the data, keep informed of real time, gain insight, detect trends, and identify opportunities and risks.

Accepted Answer

Business intelligence tools and techniques provide data processing and statistical analysis for gaining insights, identifying trends, and identifying opportunities and risks. It helps in making informed decisions based on real-time data. Metric analysis is a part of this process, but it does not encompass the full range of BI tools and techniques. Market research is also related, but it is not focused solely on data analysis and statistical methods. Pattern recognition is a specific technique within BI, but it is not the only aspect of this field.

Question 12

An ad-hoc request for specific data or information from a database or warehouse is called an) ___________.

Accepted Answer

An ad-hoc request for specific data or information from a database or warehouse is called a query. A report is a formatted presentation of data, an analysis is a deeper examination of data with the goal of discovering patterns or insights, and a digest is a summary of information.

Question 13

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

Accepted Answer

A distributed database system allows apps to access data from local and remote databases, making it a suitable choice for accessing data across different devices and locations. Portable and flexible database systems do not necessarily have the capability to access data from remote databases, and a centralized database system may not be able to accommodate different devices and locations.

Question 14

An) ________________ stores all related files in one physical location.

Accepted Answer

A centralized database is designed to store all related files in one physical location. It allows for easier management, maintenance, and security of data. The other options (B, C, and D) are not related to this concept.

Question 15

The primary benefits of centralized database configuration are better _____________ and ________________.

Accepted Answer

Centralized database configuration allows for better quality control and increased security measures due to the centralization of data and standardization of configurations. This leads to more reliable and secure data management.

Question 16

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

Accepted Answer

Data warehouses and data marts are not optimized for OLTP - Online Transaction Processing, which focuses on transactional processing of day-to-day operations. Instead, they are optimized for data mining, business intelligence (BI), and decision support to provide insights and strategic decision-making capabilities.

Question 17

________________________ are computer programs used to manage additions, updates, and deletions of data in a database as transactions occur; and support data queries and reporting.

Accepted Answer

Database management systems (DBMS) are specifically designed to manage data in a database efficiently. They handle transactions as they occur, ensuring that updates, additions, and deletions are managed effectively, while also providing support for queries and reporting. Data warehouse management systems (DWMS), data silo management systems (DSMS), and data mart management systems (DMMS) are all types of database management systems with specific focuses and functionalities, but they are not as comprehensive as DBMS.

Question 18

The primary disadvantage of centralized database configurations is

Accepted Answer

The primary disadvantage of a centralized database configuration is transmission delays that can occur when users are geo-dispersed. This delay is caused by the physical distance between the users and the centralized server, which can lead to slow response times and decreased user productivity. Data security, data quality, and availability of statistical analysis tools may also be concerns with centralized databases, but they are not the primary disadvantage.

Question 19

Distributed databases use an) _____________ architecture to process information requests.

Accepted Answer

Distributed databases use a client/server architecture to process information requests. This means that clients send requests for data to servers, which process the requests and return the relevant data to the clients. This architecture allows for scalability, as multiple clients can connect to multiple servers simultaneously, and also for fault tolerance, as if one server goes down, clients can connect to other servers instead.

Question 20

Databases are optimized for extremely fast processing of ____________-or ad hoc user requests for specific data.

Accepted Answer

Databases are optimized for processing queries, which are ad hoc user requests for specific data. It may also be used for reports, decision support, or statistical analysis, but its primary function is to quickly and efficiently retrieve data in response to a query.

Quiz 3: Database, Data Warehouse, and Data Mining