Microsoft Azure Data Fundamentals DP-900 Practice Question
A project team must decide whether an upcoming workload should be classified as transactional or analytical. Which characteristic would most strongly indicate that the workload is transactional rather than analytical?
It loads data from several sources during a nightly batch process for reporting.
It runs long-running queries that aggregate several months of historical data.
It performs many small insert and update operations that must commit atomically in real time.
It stores data in a columnar format optimized for large scans.
Transactional workloads are designed to support frequent, small data modifications that must be completed reliably with full ACID guarantees. The need for many short insert, update, or delete operations that commit atomically is therefore a hallmark of a transactional system. Long-running aggregations, nightly batch loading, and column-oriented storage are all typical of analytical (OLAP) workloads that focus on large-scale reading and reporting rather than real-time data modification.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What are ACID guarantees in a transactional system?
Open an interactive chat with Bash
How is transactional data different from analytical data?
Open an interactive chat with Bash
Why is columnar storage associated with analytical workloads?
Open an interactive chat with Bash
Microsoft Azure Data Fundamentals DP-900
Describe core data concepts
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .