Microsoft Azure Data Fundamentals DP-900 Practice Question
A retailer uses one Azure SQL Database to insert each sale as soon as a customer pays and another service that scans six months of sales data to discover slow-selling products. How should you classify each workload?
Both workloads are analytical workloads.
The sales inserts are an analytical workload, and the trend-finding queries are a transactional workload.
The sales inserts are a transactional workload, and the trend-finding queries are an analytical workload.
Recording individual sales must support frequent, small updates and many concurrent users, which are features of a transactional (OLTP) workload. Scanning historical data to find trends requires large, read-heavy queries over aggregated data, which is characteristic of an analytical (OLAP) workload. Therefore, the first workload is transactional and the second is analytical. The other options misidentify one or both workloads or assume they are the same type.
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 is the difference between OLTP and OLAP workloads?
Open an interactive chat with Bash
Why does scanning historical sales data classify as OLAP?
Open an interactive chat with Bash
How does Azure SQL Database support OLTP 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 .