FUNDAMENTALS OF COMPUTER

Previous
Next

DATABASE FUNDAMENTALS

DATA WAREHOUSING AND DATA MINING

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
____ defines the structure of the data held in operational databases and used byoperational applications.
A
User-level metadata.
B
Data warehouse metadata.
C
Operational metadata.
D
Data mining metadata.
Explanation: 

Detailed explanation-1: -Data Definition Language (DDL) is used to create and modify the structure of objects in a database using predefined commands and a specific syntax.

Detailed explanation-2: - Operational Metadata − It includes currency of data and data lineage. Currency of data means whether the data is active, archived, or purged. Lineage of data means the history of data migrated and transformation applied on it. Role of Metadata. Metadata has a very important role in a data warehouse.

Detailed explanation-3: -An operational database is a database that stores data inside of an enterprise. They can contain things like payroll records, customer information and employee data. They are critical to data warehousing and business analytics operations.

Detailed explanation-4: -Which of the following maps the core warehouse metadata to business concepts, familiar and useful to end-users. Answer-B) Application-level metadata maps the core warehouse metadata to business concepts.

There is 1 question to complete.
Previous
Next