AZ-900 Describe Azure architecture and services Practice Question
Which Azure service provides a platform for analyzing and visualizing large amounts of data stored in Azure Data Lake or Azure Blob Storage?
⚠ Common exam trap
Test-takers frequently confuse Azure Data Factory (a data movement service) with an analytics platform, or assume Azure SQL Database can handle big data analytics, when in fact HDInsight is the correct service for large-scale data analysis and visualization.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Azure HDInsight
Azure HDInsight is a fully managed, open-source analytics service that runs popular frameworks like Apache Spark, Apache Hive, and Apache Hadoop. It is specifically designed for processing and analyzing large-scale data stored in Azure Data Lake Storage or Azure Blob Storage, and integrates with visualization tools like Power BI for insights.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Azure Data Factory
Why it's wrong here
Azure Data Factory is a cloud-based data integration service used to orchestrate and automate data movement and transformation pipelines. While it can call HDInsight to run analytics jobs, Data Factory itself does not compute or analyze data with open-source frameworks. Its role is to ingest and prepare data, whereas HDInsight provides the actual big data processing and analysis engine.
- ✓
Azure HDInsight
Why this is correct
Azure HDInsight is a fully managed cloud analytics service that supports popular open-source frameworks including Apache Spark, Hadoop, Hive, and Kafka. It is explicitly designed to process and analyze massive volumes of data in parallel across clusters, making it the correct choice for big data analytics workloads. HDInsight integrates with Azure Data Lake Storage and Blob Storage, allowing petabyte-scale processing with tools data engineers already use.
- ✗
Azure SQL Database
Why it's wrong here
Azure SQL Database is a managed relational database engine optimized for online transaction processing (OLTP) and structured queries. While it can store and query relational data, it is not built for distributed big data analytics with open-source frameworks such as Spark or Hive. Big data scenarios requiring parallel processing across clusters exceed the intended scope of SQL Database, which is why HDInsight is the appropriate service for such workloads.
- ✗
Azure Cognitive Services
Why it's wrong here
Azure Cognitive Services is a suite of prebuilt machine learning APIs for vision, speech, language, and decision-making. It is not designed to process distributed big data workloads, nor does it support open-source analytics frameworks like Spark or Hadoop. These services are called directly from applications to add intelligent features, whereas HDInsight executes large-scale data processing jobs across clusters.
Quick reference
Azure Blob Storage Tier Comparison
| Tier | Storage Cost | Retrieval Cost | Latency | Use Case |
|---|---|---|---|---|
| Hot | Highest | Lowest | Immediate | Active data, frequent reads |
| Cool | Lower | Higher | Immediate | Data accessed < once / month |
| Cold | Lower still | Higher | Immediate | Data accessed < once / quarter |
| Archive | Lowest | Highest + rehydration delay | Hours | Long-term compliance retention |
Go deeper
Related to this question
Learn chapter
Azure Regions and Geographies
Key term
Blob storage
Blob storage is a cloud service for storing large amounts of unstructured data, such as text or binary data, like documents, images, and videos.
Key term
Power BI
Power BI is a Microsoft business analytics tool that transforms raw data into interactive visual reports and dashboards for informed decision-making.
About these practice questions
Courseiva writes every AZ-900 question from scratch — 981 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This AZ-900 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the AZ-900 exam.