DWH LEC
🇬🇧
In English
In English
Practice Known Questions
Stay up to date with your due questions
Complete 5 questions to enable practice
Exams
Exam: Test your skills
Test your skills in exam mode
Learn New Questions
Manual Mode [BETA]
Select your own question and answer types
Specific modes
Learn with flashcards
Complete the sentence
Listening & SpellingSpelling: Type what you hear
multiple choiceMultiple choice mode
SpeakingAnswer with voice
Speaking & ListeningPractice pronunciation
TypingTyping only mode
DWH LEC - Leaderboard
DWH LEC - Details
Levels:
Questions:
70 questions
🇬🇧 | 🇬🇧 |
True or False: techniques applied on operational databases are not suitable for data warehouses. | TRUE |
Data extraction takes data from the source systems. Data load takes the extracted data and loads it into the data warehouse. | Extract and Load Process |
It will optimize the hardware performance and simplify the management of data warehouse. | Partition the Data |
In order to recover the data in the event of data loss, software failure, or hardware failure, it is necessary to keep regular backups. | Backup and Archive the Data |
The information generated in this process is used by the warehouse management process to determine which aggregations to generate. | Query Management Process |
The architecture should be able to perform new operations and technologies without redesigning the whole system. | Extensibility |
Monitoring accesses are necessary because of the strategic data stored in the data warehouses. | Security |
Data Warehouse management should not be complicated. | Administrability |
Is not periodically used in practice. Its purpose is to minimize the amount of data stored to reach this goal; it removes data redundancies. | Single-tier Architecture |
A method used in data warehousing to refer to a system that is used to process the day-to-day transactions of an organization. | Operational System |
The mechanism of extracting information from source systems and bringing it into the data warehouse | ETL |
ETL | Extraction, Transformation, and Loading |
Primary data cleansing features found in ETL tools | Rectification, Homogenization |
The core of the reconciliation phase. | Transformation |
Two ways to carry load | Refresh, Update |