Module 4 Data Quality and Master Data Management

Please do not Give image format and Proper solution

Which statement is NOT true? a. Drill-down capability is an OLAP feature of data mining tools available to the user. b. The data warehouse should be separate from operational systems. c. Denormalization of data involves dividing the data into very small tables that support detailed analysis. d. Some decisions supported by a data warehouse are not fundamentally different from those that are supported by traditional databases. e. Data cleansing involves transforming data into standard business terms with standard data values.

Data in a data warehouse are in a stable state. Explain how this can hamper data mining analysis. What can an organization do to alleviate this problem?

Suppose your company has built a database application that runs on a centralized database, but even with a high-end computer and appropriate indices created on the data, the system is not able to handle the transaction load, leading to slow processing of queries. What would be some of your options to allow the application to handle the transaction load?

None

Which of the following is not a typical problem found by auditors when cleansing client data for the purposes of performing an ADA? Multiple Choice Some fields may be empty and thus cause errors during analysis. Some fields may not be sorted in numerical order and require sorting for identification of outliers. Some date fields may contain letters or be in the wrong format. Some fields may have country-specific differences such as currency.

The four fundamental characteristics of blockchain ( decentralization, immutability,security, and transparency)create a system with: Distrust inthe quality of its data Trust, for asystem without the need forcentralized authority The needfor a lot of oversight Two manyusers to make it effective

Why is it a challenge performing data analysis in Excel without Power BI tools?

Which of the following statements is not correct?   a.The database approach uses one common database to promote the concept of single user view. b.Database systems resolve task data dependency. c.The flat-file model encourages data redundancy. d.A primary goal of databasesystems is to minimize data redundancy. e.Database systems provide increased accessibility to data and data integration.

User acceptance testing is more important in an object-oriented development process than in a traditional environment because of the implications of thea. absence of traditional design documents.b. lack of a tracking system for changes.c. potential for continuous monitoring.d. inheritance of properties in hierarchies.

Some firms do not think they need to invest time and resources in data analytics because they believe that AIS reporting is more than sufficient. Explain some of the benefits of using data analytics.