20+ practice questions focused on Describe core data concepts — one of the most tested topics on the Microsoft Azure Data Fundamentals DP-900 exam. Each question includes a detailed explanation so you learn why the right answer is correct.
Start Describe core data concepts PracticeA hospital system stores patient medical records. Each record includes structured data like patient ID, name, date of birth, and also includes unstructured data like doctor's notes and X-ray images. Which type of data is the doctor's notes?
Explanation: Doctor's notes are unstructured data because they consist of free-form text that does not follow a predefined data model or schema. Unlike structured data (e.g., patient ID, name) which fits neatly into rows and columns, doctor's notes lack a fixed format and cannot be easily queried using traditional relational database tools without additional processing.
A manufacturing company uses IoT sensors to monitor machine temperature. The data is analyzed immediately to trigger alerts if temperature exceeds a threshold. The same data is also stored and later analyzed to identify long-term trends. Which two terms best describe these data processing approaches?
Explanation: Only Option A is correct. In this scenario, alerts require immediate analysis, which is achieved by real-time processing (or stream processing). For long-term trend analysis, data is stored and processed in bulk using batch processing. Option B incorrectly pairs stream processing with transactional processing: transactional processing (OLTP) is designed for transaction-oriented workloads, not analytical trend analysis. The correct approach for trend analysis is batch processing, not transactional processing. Options C and D reverse the pairings or use inappropriate terms (OLAP/OLTP) for the described workloads.
A car manufacturing company has two data processing systems: one system processes real-time sensor data from assembly lines to immediately detect equipment failures, and another system processes historical production records to generate monthly efficiency reports. Which two types of data processing workloads best describe these systems?
Explanation: Stream processing (option A) handles real-time sensor data from the assembly line to detect equipment failures immediately, while batch processing (option A) is ideal for processing historical production records on a scheduled basis to generate monthly efficiency reports. Transactional processing (option D) refers to OLTP workloads that process business transactions, not real-time sensor streams, so it is not a correct description for the first system. The correct answer is A only.
A global e-commerce platform uses a distributed database for its shopping cart service. The platform must be highly available and continue to accept writes even if network partitions occur between data centers. The business accepts that during a partition, users might see slightly outdated inventory counts, but the service must remain operational. According to the CAP theorem, which two properties is this system prioritizing?
Explanation: According to the CAP theorem, during a network partition, a distributed system must choose between consistency and availability. This system is designed to remain available and accept writes even during partitions, accepting that users may see slightly outdated inventory (inconsistent data). Therefore, it prioritizes Availability and Partition Tolerance (AP). Option C (Consistency and Availability) is not possible during a partition. The correct answer is B only.
A globally distributed online auction platform uses a replicated database system across multiple Azure regions. The system must continue accepting bids (writes) even if a network partition occurs between regions, because auctions cannot be interrupted. The business decides that during a partition, some users might see slightly outdated item prices (read inconsistency) but all bids must be recorded. According to the CAP theorem, which two properties is this system prioritizing?
Explanation: The CAP theorem defines three properties: Consistency (C), Availability (A), and Partition Tolerance (P). The system continues accepting bids during network partitions, prioritizing Availability (every request receives a response) and Partition Tolerance (system operates despite network splits). Option A (Availability and Partition Tolerance) directly describes this AP trade-off. Option D (Durability and Availability) is incorrect because Durability is not a CAP property; it belongs to ACID. The question specifically asks for CAP properties, so only A is correct.
+15 more Describe core data concepts questions available
Practice all Describe core data concepts questions1. Baseline your knowledge
Start with 10 questions to gauge your current understanding of Describe core data concepts. This tells you whether you need a concept refresher or just practice.
2. Review every explanation
For each question — right or wrong — read the full explanation. Understanding why an answer is correct is more valuable than knowing the answer itself.
3. Focus on exam traps
Describe core data concepts questions on the DP-900 frequently use trap wording. Look for subtle differences in answers that test your precision, not just general knowledge.
4. Reach 80% consistently
Do repeated sessions until you score 80%+ three times in a row. Then move to mixed-mode practice to test cross-topic recall under realistic conditions.
The exact number varies per candidate. Describe core data concepts is tested as part of the Microsoft Azure Data Fundamentals DP-900 blueprint. Practicing with targeted Describe core data concepts questions ensures you can handle any format or difficulty that appears.
Yes. Courseiva provides free DP-900 practice questions across all exam topics and domains. The platform includes topic-based practice, mock exams, missed-question review, bookmarked questions, and readiness tracking — no account required.
Difficulty is subjective, but Describe core data concepts is a high-priority exam concept tested in multiple ways — direct recall, scenario analysis, and command-output interpretation. Consistent practice is the best way to build confidence.
Launch a full Describe core data concepts practice session with instant scoring and detailed explanations.
Start Describe core data concepts Practice →