Quiz On Chapters 6 & 9

Supplier relationship management focuses on keeping suppliers satisfied by evaluating and categorizing suppliers for different projects, which optimizes supplier selection. This involves managing and nurturing relationships with suppliers to ensure that they meet the organization's needs and expectations. By evaluating and categorizing suppliers, organizations can identify the most suitable suppliers for specific projects, leading to improved efficiency and effectiveness in the procurement process. Supplier relationship management helps organizations build strong and mutually beneficial relationships with suppliers, ultimately resulting in better quality products or services and reduced costs.

Transactional information encompasses all of the information contained within a single business or unit of work and its primary purpose is to support the performing of daily operational tasks. It includes data related to specific transactions, such as sales, purchases, and inventory levels. This information is crucial for the day-to-day operations of the business and enables efficient decision-making and task execution. Analytical information, on the other hand, refers to data that is used for analysis and decision-making at a higher level. Timeliness and quality are important aspects of both transactional and analytical information, but they do not encompass all of the information within a single business or unit of work.

During data cleansing, all of the mentioned tasks occur. Cleaning missing records involves identifying and removing any data entries that are incomplete or have missing values. Cleaning redundant records involves identifying and removing any duplicate data entries. Cleaning inaccurate data involves identifying and correcting any errors or inconsistencies in the data. Therefore, all of these tasks are part of the data cleansing process.

Banking BI decisions involve forecasting levels of bad loans and fraudulent credit card use, credit card spending by new customers, and determining which kinds of customers will best respond to new loan offers. This type of decision-making is specific to the banking industry and focuses on managing risks, optimizing credit card usage, and identifying potential customers for loan offers.

The statement is false because timely information does not necessarily have to be up-to-the-second to be accurate. Timely information refers to information that is provided or received at the right time or within a reasonable timeframe. While up-to-the-second information may be more current and potentially more accurate, timely information can still be accurate even if it is not up-to-the-second.

The different information formats mentioned in the options are document, presentation, spreadsheet, and database. These formats represent different ways of organizing and presenting information. A document is a file that contains text and can include images, tables, and other elements. A presentation is a visual slideshow that is used to present information to an audience. A spreadsheet is a file that organizes data in rows and columns, allowing for calculations and analysis. A database is a collection of related data that is organized and stored for easy access and retrieval. These formats serve different purposes and are used in various contexts to convey information effectively.

Database-stored information provides increased flexibility as it allows for easy retrieval, manipulation, and analysis of data. It also offers increased performance as databases are designed to efficiently handle large amounts of data and perform complex queries. Additionally, it ensures increased information integrity by enforcing data validation and consistency rules. However, increased information redundancy is not an advantage of database-stored information. Redundancy refers to the unnecessary duplication of data, which can lead to storage and maintenance issues.

A database can support many logical views because it allows users to define and access data in different ways. Each user or application can have their own logical view of the data, which means they can see and manipulate the data in a way that makes sense to them. This flexibility is important for accommodating the diverse needs and preferences of different users or applications accessing the database.

Retail and sales BI decisions involve predicting sales, determining correct inventory levels and distribution schedules among outlets, and loss prevention. These decisions are specific to the retail industry and involve analyzing data to make informed decisions regarding sales strategies, inventory management, and preventing losses. This type of BI decision-making is crucial for the success and profitability of retail businesses.

The statement "All of the above" is the correct answer because customer information can indeed exist in several operational systems, meaning that it can be stored and accessed from multiple sources. Additionally, customer information in each operational system could change, as it may be updated or modified over time. Lastly, customer information in each operational system can be different, as there may be variations or inconsistencies in how the information is stored or recorded across different systems.

The answer is that the more complete and accurate an organization wants to get its information, the more it costs. This is because obtaining complete and accurate information often requires investing in advanced technology, hiring skilled professionals, conducting thorough research, and implementing comprehensive data collection and analysis processes. All of these factors contribute to increased costs for the organization.

Real-time systems provide real-time information in response to query requests. These systems are designed to process and deliver information instantly, without any delay. They are capable of continuously monitoring and updating data in real-time, ensuring that the information provided is up-to-date and accurate. Therefore, real-time systems are the correct answer as they specifically cater to the need for real-time information.

Business intelligence refers to the information that people use to support their decision-making efforts. It encompasses a variety of tools, technologies, and processes that help collect, analyze, and present data in a meaningful way. Business intelligence allows individuals to gain insights, identify trends, and make informed decisions based on the available information. It helps organizations improve their performance, optimize processes, and achieve their goals.

Consistency implies that aggregate or summary information is in agreement with detailed information. This means that the overall data and the specific data align and are coherent with each other. Consistency ensures that there are no discrepancies or contradictions between the summarized information and the detailed information, indicating that the aggregate information accurately represents the underlying details.

Information cleansing occurs during the ETL process to ensure that the data being loaded into the data warehouse is accurate, consistent, and reliable. Once the data is in the data warehouse, further cleansing may also occur to maintain data quality and integrity.

A relational integrity constraint is a type of constraint that ensures the consistency and accuracy of data in a relational database. In this case, the constraint would prevent the creation of an order for a nonexistent customer, which helps maintain the integrity of the database by ensuring that all orders are associated with valid and existing customer records.

Partner relationship management focuses on keeping vendors satisfied by managing alliance partner and reseller relationships that provide customers with the optimal sales channel. It involves developing and maintaining strong relationships with partners, ensuring effective communication, and collaborating to achieve mutual goals. This helps to enhance sales and customer satisfaction by leveraging the strengths and resources of the partners in the sales channel.

Most organizations today have access to a large amount of data, but they struggle to extract meaningful information from it. This means that they are data rich, but information poor. They may have the tools and technology to collect and store data, but they lack the ability to analyze and interpret it effectively. This can hinder decision-making processes and prevent organizations from gaining valuable insights from their data.

A real-time system is a system that provides information in real-time, meaning it responds to query requests immediately and provides up-to-date information. This type of system is designed to provide timely and accurate information to users. It is different from a system that encompasses all organization information or supports managerial analysis tasks, as its primary purpose is to support the performing of daily operational tasks by providing real-time information.

Relational integrity constraints are rules that enforce basic and fundamental information-based constraints in a relational database. These constraints ensure that data is accurate, consistent, and valid within the database. They define rules such as primary key constraints, foreign key constraints, and uniqueness constraints, which help maintain the integrity and reliability of the data stored in the database. By enforcing these constraints, relational databases can ensure the accuracy and consistency of the information they store.