Test on Information Systems: Concepts and Digital Strategy

Question 1: A strong relationship between highly analytical people and business managers leads to efficient communication and fosters a richer analysis and data-driven approach to inform business decisions.

A. Ano

B. Ne

Explanation: The combination of highly analytical people and business managers is relevant, and a strong relationship between them leads to efficient and fluid communication, fostering a richer analysis and a data-driven approach to inform business decisions and issues.

Question 2: According to the study materials, what is the primary objective of performing data profiling and data cleaning work before data analysis?

A. To transform unstructured data into a common format for analytics systems.

B. To ensure information in a dataset is consistent, and that errors and duplicate entries are removed.

C. To select, extract, and check the integrity of data for loading into a datawarehouse.

D. To apply data governance policies to guarantee compliance with corporate standards.

Explanation: The study materials state that 'once the necessary data is in place, the next step is to find and fix data quality issues that could affect the accuracy of analytics applications. That includes performing data profiling and data cleaning work to ensure that information in a dataset is consistent and that errors and duplicate entries are removed.'

Question 3: Developing a Business Intelligence project can lead to increased efficiency in data analysis by eliminating the cost associated with traditional reporting that does not add value to management.

A. Ano

B. Ne

Explanation: The study materials state that one of the business benefits of developing a BI project is "Efficiency in data analysis: Selecting and prioritising indicators will eliminate the cost associated with traditional reporting whose data is available but does not add value to management."

Question 4: According to the study materials, which of the following is a symptom indicating the need for the development of a Business Intelligence (BI) project?

A. The establishment of a consensus on indicators and their calculation methods across different departments.

B. The proliferation of individual data use, resulting in decentralized, non-integrated, and non-congruent Excel spreadsheets.

C. The ability to extract, consolidate, and visualize critical variables in real-time.

D. The existence of centralized reporting that consistently supports management.

Explanation: The study materials state that a symptom indicating the need for a BI project is 'Lack of a comprehensive approach to business monitoring. When there is no comprehensive approach...the individual use of data proliferates, leading to its decentralisation in varied, non-integrated and non-congruent Excel spreadsheets in different areas of the company.' Option 1 directly reflects this symptom. The other options describe benefits or functionalities of BI, or a state that would be achieved after implementing BI, not a symptom of needing it.

Question 5: It is always preferable to avoid creating a new field to serve as a key, even if no existing simple or compound field is suitable for uniquely identifying records.

A. Ano

B. Ne

Explanation: The study materials state that if there is no simple or compound field that can serve as a key, a new field must be created to be the key of that table. This indicates that creating a new field for a key is a necessary and acceptable practice when existing fields are not suitable.