Refresh your knowledge in DE
Authored by Abdellah ELAAROUB
Information Technology (IT)
Professional Development
Used 1+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
18 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
When is ELT better than ETL?
With cloud data warehouses
With on-premise databases
When transforming before loading
When no transformation is needed
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is a common issue when handling large-scale distributed data?
High network latency
Lack of storage space
Excessive manual data entry
Too many relational tables
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is a primary goal of data normalization?
Increase storage usage
Reduce redundancy
Speed up queries
Remove all primary keys
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which data processing model is best for handling large-scale batch data?
Event-driven
Lambda
OLAP
OLTP
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which tool is commonly used for building ETL pipelines?
Apache Kafka
Apache Airflow
Elasticsearch
Apache NIFI
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the main drawback of data denormalization?
Increased redundancy
Slower queries
More complex joins
Loss of integrity
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which SQL technique improves query performance on large tables?
Joins
Indexing
Normalization
CTEs
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Microsoft
or continue with
%20(1).png)
Apple
Others
Already have an account?
