Tag: web technology

Questions Related to web technology

Data in BI architecture flows as follows

  1. Dispersed data -> Collected Data -> Integrated Data -> Information -> Knowledge

  2. Collected Data -> Dispersed data -> Integrated Data -> Information -> Knowledge

  3. Dispersed data -> Collected Data -> Integrated Data -> Knowledge-> Information

  4. Collected Data -> Dispersed data -> Integrated Data -> Knowledge -> Informatio


Correct Option: A
  1. Sourcing data from disparate sources and integrating to be central repository

  2. A process to change data from a detailed level to a summary level

  3. A process to change data from a summary level to a detailed level

  4. Separating data from one source into various sources of data


Correct Option: A

Data warehouse is which of the following?

  1. Can be updated by end users.

  2. Contains numerous naming conventions and formats.

  3. Organized around important subject areas.

  4. Contains only current data.


Correct Option: C
  1. A system that is used to run the business in real time and is based on historical data.

  2. A system that is used to run the business in real time and is based on current data.

  3. A system that is used to support decision making and is based on current data.

  4. A system that is used to support decision making and is based on historical data


Correct Option: C

This is a data management practice that characterizes the content, quality, and structure of your data.

  1. data enrichment

  2. data caving

  3. data refinement

  4. data profiling


Correct Option: D
Explanation:

To solve this question, the user needs to have knowledge about data management and its various practices. The user must be able to identify the practice that best describes the characteristics of data content, quality, and structure.

Now, let's go through each option and explain why it is right or wrong:

A. Data enrichment: This practice involves enhancing data with additional information from external sources. It is not related to characterizing the content, quality, and structure of your data. Therefore, this option is incorrect.

B. Data caving: This practice refers to the process of creating and exploring data caves, which are virtual spaces where data can be analyzed and visualized. It is not related to characterizing the content, quality, and structure of your data. Therefore, this option is incorrect.

C. Data refinement: This practice involves improving the quality of data by removing errors, inconsistencies, and redundancies. Although it is related to data quality, it does not address the characterization of data content and structure. Therefore, this option is incorrect.

D. Data profiling: This practice involves analyzing data to understand its content, quality, and structure. It helps to identify potential issues with the data and to establish rules for data integration, transformation, and cleansing. Therefore, this option is the correct answer.

The Answer is: D

What is the process of removing erroneous, incomplete or old data from a database?

  1. data eradication

  2. data cleansing

  3. data unloading

  4. data purging


Correct Option: B

________________ provides context to data, acts as the semantic layer between a company’s IT systems and its business users

  1. Metadata

  2. Master data

  3. Data Governance

  4. Data Quality


Correct Option: A
  1. Source layer

  2. Report Layer

  3. Data Warehouse

  4. All of the above


Correct Option: D