Azure Data Fundamentals (DP-900) Flashcards
7 cards from real Microsoft Certification practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Azure Data Fundamentals (DP-900) flashcards as text
What type of data workload processes data in real-time as it continuously arrives?
Answer: Stream processing
Stream processing handles data in real-time as it arrives, unlike batch processing which accumulates data and processes it in groups.
Which of the following is the best example of structured data?
Answer: Rows in a relational database table
Structured data is organized in a defined format with rows and columns, as found in relational database tables.
What does ACID stand for in the context of database transactions?
Answer: Atomicity, Consistency, Isolation, Durability
ACID stands for Atomicity, Consistency, Isolation, and Durability — four properties that guarantee reliable processing of database transactions.
Which Azure service provides a fully managed relational database based on the SQL Server engine?
Answer: Azure SQL Database
Azure SQL Database is a fully managed, Platform-as-a-Service relational database built on the SQL Server engine.
What is the primary purpose of a data warehouse?
Answer: To store and analyze large volumes of historical data for reporting
A data warehouse is optimized for storing and analyzing large amounts of historical data to support business intelligence, analytics, and reporting.
Which of the following best describes a NoSQL database?
Answer: A non-relational database that stores unstructured or semi-structured data flexibly
NoSQL databases are non-relational and can store unstructured or semi-structured data without requiring a fixed schema, offering flexibility and horizontal scalability.
What is a primary key in a relational database?
Answer: A unique identifier that distinguishes each row in a table
A primary key uniquely identifies each row in a database table, ensuring no two rows have the same key value and enabling efficient lookups.
How this page was made: written with AI tools and published by Nathan Beja, founder of Practice Test Geeks, who is responsible for its content. Exam facts are checked against the official sources listed below. Not reviewed by a subject-matter expert. Editorial policy
Sources & references
Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy
- learn.microsoft.com — Test delivery, eligibility, registration, renewal, score validity, retake fee, passing score, exam format, time limit, fees · verified Oct 2026