stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
DE fundamentals Flashcards | StudBud
Explore
/
DE fundamentals
DE fundamentals
12 terms
·
StudBud Administration
·
19 plays
Imported from external platform
Flashcards
12 cards
F
Practice quiz
P
Host live
L
Questions
12
Answers
1
Which term describes the
real-time
movement of data from sources to consumers ?
Streaming
Offline Analysis
Batch Processing
Data Archiving
2
What is an
advantage
of organizing data into a
data lake
before doing analytics ?
They eliminate the need for data governance and security
They store data in its raw format for future transformations and analyses
Data lakes are always faster than data warehouses for all queries
Data lakes automatically guarantee data quality without any work
3
What is the
correct order
in a typical data pipeline for an online retailer ?
Transform → Extract → Load
Extract → Transform → Load
Load → Extract → Transform
Transform → Load → Extract
4
Which of the following
is NOT
a typical responsibility of a data engineer ?
Transforming raw data into usable formats
Designing machine learning algorithms
Ensuring data quality and reliability
Monitoring data pipelines in production
5
Which scenario is most
suitable for batch
processing
?
Nightly aggregation of sales records for a weekly performance report
Real-time fraud detection in a banking system
Monitoring live social media feeds for trending topics
Alert systems that notify users of suspicious logins instantly
6
What is the primary focus of data engineering ?
Designing and maintaining data pipelines to move and transform data
Creating business intelligence dashboards
Building data visualizations for end-users
Writing front-end web applications
7
Which
part
of the lifecycle deals with
scheduling, monitoring, and managing
dependencies between data pipeline tasks ?
Data visualization
Data modeling in a relational database
Orchestration and workflow management
Data lake creation
8
Which
phase
of the data engineering lifecycle is responsible for
cleaning
,
aggregating
, or
enriching
raw data ?
Data transformation
Data storage
Data ingestion
Data consumption
9
Which statement best describes data in its raw form ?
Collection of raw facts, numbers, or observations with no inherent meaning
Detailed interpretation of events that provides immediate insights
Refined collection of knowledge that answers critical business questions
Fully analyzed information ready for business decisions
10
What is the final step in data engineering where data is used for analytics or reporting?
Data extraction
Data consumption
Data archiving
Data validation
11
Which
best describes
data ingestion ?
The final step of providing data to end-users
The creation of machine learning models
The process of storing processed data in a data warehouse
The initial acquisition of data from external or internal sources
12
Which of the following best explains the relationship between data engineering and data analytics ?
They are the same role with different job titles
Analytics is all about infrastructure, while DE focuses on visualizations
Neither data engineers nor analysts need to collaborate with each other
DE provides the organized data foundation that analytics use for reporting
