DWH LEC
🇬🇧
In Inglés
In Inglés
Practique preguntas conocidas
Manténgase al día con sus preguntas pendientes
Completa 5 preguntas para habilitar la práctica
Exámenes
Examen: pon a prueba tus habilidades
Pon a prueba tus habilidades en el modo de examen
Aprenda nuevas preguntas
Modos dinámicos
InteligenteMezcla inteligente de todos los modos
PersonalizadoUtilice la configuración para ponderar los modos dinámicos
Modo manual [beta]
Seleccione sus propios tipos de preguntas y respuestas
Modos específicos
Aprende con fichas
Completa la oración
Escuchar y deletrearOrtografía: escribe lo que escuchas
elección múltipleModo de elección múltiple
Expresión oralResponde con voz
Expresión oral y comprensión auditivaPractica la pronunciación
EscrituraModo de solo escritura
DWH LEC - Marcador
DWH LEC - Detalles
Niveles:
Preguntas:
70 preguntas
🇬🇧 | 🇬🇧 |
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 |