Microsoft Azure Data Fundamentals DP-900 Practice Question
A retailer needs a database solution that records every point-of-sale event as it happens and prevents data conflicts when thousands of cashiers save orders at the same time. Which characteristic best shows that this requirement represents a transactional workload?
The workload loads data one time each night through a batch ETL pipeline.
The workload mainly stores semi-structured application log files for later processing.
The workload requires scanning billions of rows to build interactive business intelligence dashboards.
The workload emphasizes enforcing ACID properties during many short insert and update operations.
Transactional (OLTP) workloads focus on reliably capturing individual business events, such as sales or reservations. They process large numbers of short INSERT, UPDATE, and DELETE statements, enforce ACID properties, and support high user concurrency so that simultaneous transactions do not corrupt data. Analytical workloads, batch ETL operations, and systems that store semi-structured logs or run long-running aggregations are optimized for very different patterns and are therefore incorrect in this scenario.
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 properties in a database?
Open an interactive chat with Bash
What is the difference between OLTP and OLAP workloads?
Open an interactive chat with Bash
What is a batch ETL pipeline in databases?
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 .