Category: azure

Build a lightweight application by using Azure Speech in Foundry Tools (AI-901 Exam Prep)

This post is a part of the AI-901: Microsoft Azure AI Fundamentals Exam Prep Hub. 
This topic falls under these sections:
Implement AI solutions by using Microsoft Foundry (55–60%)
--> Implement AI solutions for text and speech by using Foundry
--> Build a lightweight application by using Azure Speech in Foundry Tools


Note that there are 10 practice questions (with answers and explanations) for each section to help you solidify your knowledge of the material. Also, there are 2 practice tests with 60 questions each available on the hub below the exam topics section.

Speech-enabled AI applications are becoming increasingly common in customer service, accessibility, virtual assistants, and productivity solutions. Microsoft Azure provides speech services that allow developers to add speech recognition and speech synthesis capabilities to lightweight AI applications.

For the AI-901 certification exam, candidates should understand the foundational concepts behind building lightweight speech-enabled applications using Azure Speech and Microsoft Foundry tools.

This topic falls under the “Implement AI solutions for text and speech by using Foundry” section of the AI-901 exam objectives.


What Is Azure AI Speech?

Azure AI Speech is a cloud-based AI service that enables speech-related functionality in applications.

Azure AI Speech supports:

  • Speech recognition
  • Speech synthesis
  • Speech translation
  • Voice generation

What Is a Lightweight Application?

A lightweight application is a simple application designed to perform focused tasks with minimal complexity.

Characteristics include:

  • Simple user interface
  • Fast deployment
  • Lower resource usage
  • Easy maintenance

Examples of Lightweight Speech Applications

Examples include:

  • Voice-enabled chatbots
  • Simple voice assistants
  • Speech-to-text applications
  • Text-to-speech readers
  • Voice-controlled support tools

Azure AI Foundry

Azure AI Foundry provides tools for building, deploying, and testing AI-powered applications.

Developers can:

  • Access AI services
  • Configure models
  • Test applications
  • Manage deployments

Speech Recognition

Speech recognition converts spoken language into text.

This process is commonly called:

  • Speech-to-text (STT)
  • Automatic speech recognition (ASR)

Example

Spoken Input

“Schedule a meeting tomorrow.”

Recognized Text

“Schedule a meeting tomorrow.”


Speech Synthesis

Speech synthesis converts written text into spoken audio.

This process is commonly called:

  • Text-to-speech (TTS)

Example

Text

“Your appointment is confirmed.”

Spoken Output

The application reads the text aloud.


Speech Translation

Speech translation converts spoken language from one language into another.


Example

Spoken English

“Good morning.”

Translated Spanish Audio

“Buenos días.”


Voice Generation

AI systems can generate natural-sounding voices for:

  • Virtual assistants
  • Narration
  • Accessibility
  • Customer service systems

Basic Workflow of a Speech Application

A lightweight speech application commonly follows this workflow:

  1. User speaks into microphone
  2. Application captures audio
  3. Azure Speech processes audio
  4. Speech is converted to text
  5. Application processes text
  6. Optional speech synthesis generates spoken response

Example End-to-End Scenario

User Speaks

“What are today’s weather conditions?”

Speech Service

Converts speech to text

AI Processing

Generates response

Text-to-Speech

Reads response aloud


APIs and Endpoints

Applications communicate with Azure Speech services using:

  • APIs
  • Endpoints

These allow applications to send requests and receive responses programmatically.


Authentication

Applications must securely authenticate before using Azure Speech services.

Common methods include:

  • API keys
  • Azure credentials
  • Managed identities

Common User Interface Components

A lightweight speech application often includes:

  • Microphone input button
  • Text display area
  • Playback controls
  • Response output area

Real-Time Processing

Many speech applications process audio in real time.

This allows conversational experiences with minimal delay.


Streaming Audio

Streaming audio enables continuous processing of speech as users speak.

Benefits include:

  • Faster responses
  • More natural interactions
  • Reduced waiting time

Conversation Context

Some applications preserve context across interactions.

This allows more natural conversations.


Example

User

“Who founded Microsoft?”

User Later

“When was it created?”

The system understands “it” refers to Microsoft.


System Prompts

System prompts guide AI behavior and responses.

They help define:

  • Tone
  • Personality
  • Response style
  • Safety boundaries

Example System Prompt

“You are a friendly virtual assistant.”


Responsible AI Considerations

Speech-enabled applications should follow Responsible AI principles.

Key considerations include:

  • Privacy
  • Security
  • Inclusiveness
  • Transparency
  • Fairness
  • Accountability

Privacy Concerns

Speech systems may process sensitive spoken information.

Organizations should:

  • Secure recordings
  • Protect user conversations
  • Minimize unnecessary data retention

Inclusiveness

Speech applications should support:

  • Different accents
  • Multiple languages
  • Diverse speech patterns
  • Accessibility needs

Transparency

Users should know:

  • AI is processing speech
  • Audio may be analyzed
  • AI-generated responses may contain errors

Hallucinations

Generative AI systems may occasionally generate inaccurate responses.

These inaccuracies are called hallucinations.

Applications should not assume responses are always correct.


Error Handling

Applications should handle:

  • Background noise
  • Recognition errors
  • Authentication failures
  • Network interruptions
  • Rate limits

Background Noise Challenges

Speech recognition accuracy may decrease in:

  • Loud environments
  • Crowded spaces
  • Poor microphone conditions

Rate Limits

Azure AI services may limit request frequency.

Applications should handle throttling gracefully.


Latency

Latency refers to delays between:

  • User speech
  • AI processing
  • Spoken responses

Low latency improves user experience.


Advantages of Speech-Enabled Applications

Benefits include:

  • Natural interaction
  • Hands-free usage
  • Accessibility improvements
  • Faster communication
  • Improved engagement

Limitations of Speech Applications

Challenges include:

  • Accent variability
  • Background noise
  • Recognition inaccuracies
  • Privacy concerns
  • Network dependency

Common Real-World Scenarios


Scenario 1: Voice Assistant

Goal

Allow users to ask spoken questions.

Features

  • Speech recognition
  • Spoken responses
  • Conversational interaction

Scenario 2: Accessibility Tool

Goal

Assist visually impaired users.

Features

  • Text-to-speech
  • Voice commands
  • Audio navigation

Scenario 3: Customer Support Bot

Goal

Provide voice-based support.

Features

  • Real-time speech recognition
  • AI-generated responses
  • Multilingual support

High-Level Application Workflow

A simplified workflow includes:

  1. Capture speech
  2. Convert speech to text
  3. Process request
  4. Generate response
  5. Convert response to speech
  6. Play audio response

Example High-Level Pseudocode

audio = capture_audio()
text = speech_to_text(audio)
response = process_request(text)
speak(response)

For AI-901, understanding the workflow is more important than memorizing exact syntax.


Important AI-901 Exam Tips

For the exam, remember these key points:

  • Azure AI Speech provides speech-related AI services.
  • Speech recognition converts speech to text.
  • Speech synthesis converts text to speech.
  • Azure AI Foundry supports AI application development.
  • APIs and endpoints connect applications to cloud AI services.
  • Authentication secures access to Azure services.
  • Streaming audio supports real-time interaction.
  • Responsible AI principles apply to speech-enabled applications.
  • Inclusiveness is important for diverse speech patterns and accents.
  • Hallucinations are inaccurate AI-generated outputs.

Quick Knowledge Check

Question 1

What does speech recognition do?

Answer

Converts spoken language into text.


Question 2

What does speech synthesis do?

Answer

Converts text into spoken audio.


Question 3

Why is authentication important?

Answer

It secures access to Azure AI services.


Question 4

Why is inclusiveness important in speech applications?

Answer

To support users with different accents, languages, and accessibility needs.


Practice Exam Questions

Question 1

What is the PRIMARY purpose of Azure AI Speech?

A. To manage virtual machines
B. To provide speech-related AI capabilities such as speech recognition and speech synthesis
C. To monitor network hardware
D. To create relational databases


Correct Answer

B. To provide speech-related AI capabilities such as speech recognition and speech synthesis


Explanation

Azure AI Speech provides cloud-based speech services including speech-to-text and text-to-speech capabilities.


Why the Other Answers Are Incorrect

A. To manage virtual machines

Virtual machine management is unrelated to speech AI.

C. To monitor network hardware

Azure AI Speech does not monitor infrastructure devices.

D. To create relational databases

Database creation is unrelated to speech services.


Question 2

What does speech recognition do?

A. Converts speech into text
B. Converts images into speech
C. Detects objects in video
D. Compresses audio files


Correct Answer

A. Converts speech into text


Explanation

Speech recognition, also called speech-to-text, converts spoken language into written text.


Why the Other Answers Are Incorrect

B. Converts images into speech

This is unrelated to speech recognition.

C. Detects objects in video

This is a computer vision task.

D. Compresses audio files

Speech recognition does not perform compression.


Question 3

What does speech synthesis perform?

A. Converts text into spoken audio
B. Detects entities in text
C. Creates spreadsheets automatically
D. Increases internet bandwidth


Correct Answer

A. Converts text into spoken audio


Explanation

Speech synthesis, also called text-to-speech, generates spoken audio from written text.


Why the Other Answers Are Incorrect

B. Detects entities in text

This is a text analysis task.

C. Creates spreadsheets automatically

This is unrelated to speech services.

D. Increases internet bandwidth

Speech synthesis does not affect networking.


Question 4

Which Microsoft platform provides tools for building and managing AI applications?

A. Azure AI Foundry
B. Microsoft Paint
C. Windows Media Player
D. Microsoft Calculator


Correct Answer

A. Azure AI Foundry


Explanation

Azure AI Foundry provides tools for building, testing, deploying, and managing AI solutions.


Why the Other Answers Are Incorrect

B. Microsoft Paint

Paint is a graphics editor.

C. Windows Media Player

This is a media playback application.

D. Microsoft Calculator

This is a utility application.


Question 5

How do lightweight applications typically communicate with Azure AI Speech services?

A. Through APIs and endpoints
B. Through printer drivers only
C. Through USB flash drives
D. Through monitor calibration settings


Correct Answer

A. Through APIs and endpoints


Explanation

Applications use APIs and cloud endpoints to send requests and receive AI-generated responses.


Why the Other Answers Are Incorrect

B. Through printer drivers only

Printer drivers are unrelated to AI services.

C. Through USB flash drives

Cloud AI services use network communication.

D. Through monitor calibration settings

This is unrelated to APIs.


Question 6

Why is authentication important when using Azure AI Speech?

A. To secure access to AI services
B. To improve microphone volume
C. To increase response creativity
D. To remove network latency


Correct Answer

A. To secure access to AI services


Explanation

Authentication helps ensure only authorized users and applications can access Azure AI resources.


Why the Other Answers Are Incorrect

B. To improve microphone volume

Authentication does not affect hardware settings.

C. To increase response creativity

Creativity is controlled through model parameters.

D. To remove network latency

Authentication does not control connection speed.


Question 7

What is a benefit of streaming audio in speech-enabled applications?

A. Faster and more natural interactions
B. Permanent elimination of all speech errors
C. Automatic hardware upgrades
D. Unlimited cloud storage


Correct Answer

A. Faster and more natural interactions


Explanation

Streaming audio enables real-time processing, improving responsiveness and conversational flow.


Why the Other Answers Are Incorrect

B. Permanent elimination of all speech errors

Speech systems can still make mistakes.

C. Automatic hardware upgrades

Streaming does not upgrade hardware.

D. Unlimited cloud storage

Streaming does not affect storage capacity.


Question 8

Which Responsible AI consideration is especially important for speech-enabled applications?

A. Protecting sensitive spoken information
B. Increasing screen brightness
C. Improving printer speed
D. Accelerating video rendering


Correct Answer

A. Protecting sensitive spoken information


Explanation

Speech applications may process personal or confidential audio, making privacy and security important concerns.


Why the Other Answers Are Incorrect

B. Increasing screen brightness

This is unrelated to Responsible AI.

C. Improving printer speed

Printers are unrelated to speech AI.

D. Accelerating video rendering

This is unrelated to speech processing.


Question 9

What challenge can negatively affect speech recognition accuracy?

A. Background noise
B. Spreadsheet formatting
C. Screen resolution
D. Video playback speed


Correct Answer

A. Background noise


Explanation

Loud environments and poor audio quality can reduce speech recognition accuracy.


Why the Other Answers Are Incorrect

B. Spreadsheet formatting

This does not affect speech recognition.

C. Screen resolution

Speech recognition does not depend on display quality.

D. Video playback speed

This is unrelated to speech input processing.


Question 10

What is one advantage of speech-enabled AI applications?

A. Hands-free interaction
B. Guaranteed perfect accuracy
C. Elimination of all privacy concerns
D. Removal of internet requirements


Correct Answer

A. Hands-free interaction


Explanation

Speech-enabled applications allow users to interact naturally without typing.


Why the Other Answers Are Incorrect

B. Guaranteed perfect accuracy

Speech systems can still make errors.

C. Elimination of all privacy concerns

Privacy protections are still necessary.

D. Removal of internet requirements

Cloud-based speech services generally require internet connectivity.


Final Thoughts

Building lightweight applications using Azure Speech in Foundry tools is an important AI-901 exam topic. Microsoft expects candidates to understand how speech-enabled AI applications work, including speech recognition, speech synthesis, APIs, authentication, Responsible AI considerations, and real-time conversational workflows.

Azure AI Speech and Azure AI Foundry provide powerful cloud-based tools that make it easier to create modern voice-enabled AI applications for business, accessibility, and productivity scenarios.


Go to the AI-901 Exam Prep Hub main page

Identify techniques to extract information from text, images, audio, and videos (AI-901 Exam Prep)

This post is a part of the AI-901: Microsoft Azure AI Fundamentals Exam Prep Hub. 
This topic falls under these sections:
Identify AI concepts and capabilities (40–45%)
--> Identify AI workloads
--> Identify techniques to extract information from text, images, audio, and videos


Note that there are 10 practice questions (with answers and explanations) for each section to help you solidify your knowledge of the material. Also, there are 2 practice tests with 60 questions each available on the hub below the exam topics section.

Information extraction is one of the most valuable uses of AI and an important topic for the AI-901 certification exam. Organizations generate enormous amounts of unstructured data every day, including documents, emails, images, audio recordings, and videos. AI systems help convert this unstructured data into structured, usable information.

Microsoft expects AI-901 candidates to understand common techniques used to extract information from text, images, audio, and video content.

This topic falls under the “Identify AI workloads” section of the AI-901 exam objectives.


What Is Information Extraction?

Information extraction is the process of identifying and retrieving useful structured information from unstructured or semi-structured data.

AI systems analyze content and extract meaningful data automatically.


Examples of Information Extraction

SourceExtracted Information
DocumentsNames, dates, invoice totals
EmailsCustomer requests, keywords
ImagesObjects, faces, text
AudioSpoken words, speaker identity
VideoActivities, objects, movement

Structured vs. Unstructured Data

Understanding structured and unstructured data is important for this topic.

Structured DataUnstructured Data
TablesEmails
DatabasesImages
SpreadsheetsAudio
Defined formatsVideos
Organized fieldsDocuments

AI techniques help transform unstructured data into structured information.


Information Extraction from Text

AI systems commonly use Natural Language Processing (NLP) to extract information from text.


Common Text Extraction Techniques

For the AI-901 exam, important techniques include:

  • Keyword extraction
  • Named Entity Recognition (NER)
  • Sentiment analysis
  • Summarization
  • Language detection
  • Text classification

Keyword Extraction

Keyword extraction identifies important words or phrases within text.

Example

Extracting phrases like:

  • “shipping delay”
  • “billing issue”
  • “customer satisfaction”

from support tickets.


Named Entity Recognition (NER)

NER identifies entities such as:

  • People
  • Organizations
  • Locations
  • Dates
  • Phone numbers
  • Products

Example

Input

“Microsoft will host an event in Seattle on June 15.”

Extracted Entities

  • Microsoft → Organization
  • Seattle → Location
  • June 15 → Date

Sentiment Analysis

Sentiment analysis identifies emotional tone within text.

Possible Results

  • Positive
  • Negative
  • Neutral

Example

Analyzing customer reviews to determine satisfaction levels.


Summarization

Summarization creates shorter versions of long text.

Example

Generating meeting summaries from lengthy transcripts.


Text Classification

Text classification assigns categories to text.

Example

Automatically labeling emails as:

  • Support
  • Sales
  • Billing

Information Extraction from Images

Computer vision techniques extract information from images.


Common Image Extraction Techniques

Important techniques include:

  • OCR
  • Image classification
  • Object detection
  • Facial recognition
  • Image tagging

Optical Character Recognition (OCR)

OCR extracts text from images and scanned documents.


OCR Example

Input

Scanned invoice image.

Extracted Information

  • Invoice number
  • Total amount
  • Vendor name
  • Dates

Common OCR Use Cases

  • Receipt scanning
  • Invoice processing
  • Document digitization
  • Form extraction

Image Classification

Image classification identifies the overall category of an image.

Example

Identifying whether an image contains:

  • A dog
  • A car
  • A building

Object Detection

Object detection identifies and locates multiple objects within images.

Example

Detecting:

  • Cars
  • Pedestrians
  • Traffic lights

in a street image.


Facial Recognition

Facial recognition identifies or verifies people based on facial features.

Example

Smartphone face unlock systems.


Image Tagging

Image tagging automatically generates descriptive labels.

Example Tags

  • Beach
  • Sunset
  • Ocean
  • Person

Information Extraction from Audio

Speech AI technologies extract information from spoken audio.


Common Audio Extraction Techniques

Important techniques include:

  • Speech recognition
  • Speaker recognition
  • Sentiment analysis in speech
  • Speech translation

Speech Recognition

Speech recognition converts spoken language into text.

Also called:

  • Speech-to-text
  • Automatic Speech Recognition (ASR)

Example

Audio Input

A recorded meeting.

Extracted Information

A written transcript.


Speaker Recognition

Speaker recognition identifies or verifies speakers based on voice characteristics.

Example

Voice authentication systems.


Speech Sentiment Analysis

Some AI systems analyze vocal tone and emotion.

Example

Detecting frustration during customer service calls.


Speech Translation

Speech translation converts spoken language into another language.

Example

Real-time multilingual meeting translation.


Information Extraction from Video

Video analysis combines computer vision and audio processing techniques.


Common Video Extraction Techniques

Important techniques include:

  • Motion detection
  • Object tracking
  • Activity recognition
  • Scene analysis
  • Video transcription

Motion Detection

Motion detection identifies movement within video footage.

Example

Security surveillance systems detecting activity.


Object Tracking

Object tracking follows identified objects across video frames.

Example

Tracking vehicles in traffic monitoring systems.


Activity Recognition

Activity recognition identifies actions occurring in video.

Example

Detecting:

  • Running
  • Falling
  • Fighting
  • Driving

Scene Analysis

Scene analysis identifies environments or contexts in video.

Example

Recognizing:

  • Office scenes
  • Outdoor settings
  • Crowded areas

Video Transcription

Video transcription converts spoken content in videos into text.

Example

Generating subtitles for videos automatically.


Multimodal AI

Some AI systems combine multiple data types together.

This is called multimodal AI.


Example of Multimodal AI

A meeting assistant may process:

  • Audio
  • Video
  • Text chat
  • Shared documents

simultaneously.


Real-World Information Extraction Scenarios


Scenario 1: Invoice Processing System

Goal

Extract invoice information automatically.

Techniques Used

  • OCR
  • Entity extraction

Scenario 2: Customer Support Analysis

Goal

Analyze customer complaints.

Techniques Used

  • Sentiment analysis
  • Keyword extraction

Scenario 3: Smart Security Camera

Goal

Detect suspicious activity.

Techniques Used

  • Object detection
  • Motion detection
  • Facial recognition

Scenario 4: Meeting Intelligence Platform

Goal

Generate searchable meeting notes.

Techniques Used

  • Speech recognition
  • Summarization
  • Speaker recognition

Scenario 5: Video Streaming Platform

Goal

Generate subtitles automatically.

Techniques Used

  • Speech recognition
  • Video transcription

Azure AI Services for Information Extraction

Azure AI Services provide tools for extracting information from multiple data types.

Common services include:

  • Azure AI Language
  • Azure AI Speech
  • Azure AI Vision
  • Azure AI Document Intelligence

These services allow organizations to build AI solutions without training models from scratch.


Responsible AI Considerations

Information extraction systems should follow Responsible AI principles.

Important considerations include:

  • Privacy
  • Consent
  • Data security
  • Transparency
  • Bias reduction
  • Compliance

Sensitive personal information may be present in extracted data.


Challenges in Information Extraction

AI systems may face challenges such as:

  • Poor image quality
  • Background noise
  • Ambiguous language
  • Multiple speakers
  • Handwritten text
  • Video quality issues

Performance depends heavily on data quality.


Important AI-901 Exam Tips

For the exam, remember these key points:

  • NLP extracts information from text.
  • OCR extracts text from images.
  • Speech recognition converts speech into text.
  • Object detection identifies and locates objects in images or video.
  • Video analysis can detect activities and movement.
  • Information extraction converts unstructured data into structured information.
  • Multimodal AI combines multiple data types.
  • Azure AI services provide prebuilt information extraction capabilities.

Quick Knowledge Check

Question 1

Which technique extracts text from scanned documents?

Answer

OCR.


Question 2

What does speech recognition do?

Answer

Converts spoken language into text.


Question 3

Which technique identifies objects within images?

Answer

Object detection.


Question 4

What is multimodal AI?

Answer

AI systems that process multiple types of data together, such as text, audio, and images.


Practice Exam Questions

Question 1

Which AI technique is used to extract text from scanned documents or images?

A. Sentiment analysis
B. Optical Character Recognition (OCR)
C. Object detection
D. Speech synthesis


Correct Answer

B. Optical Character Recognition (OCR)


Explanation

OCR extracts machine-readable text from images, scanned documents, and photographs.


Why the Other Answers Are Incorrect

A. Sentiment analysis

Sentiment analysis identifies emotional tone in text.

C. Object detection

Object detection identifies objects within images.

D. Speech synthesis

Speech synthesis converts text into spoken audio.


Question 2

A company wants to convert recorded customer support calls into written transcripts.

Which AI capability should be used?

A. Speech recognition
B. Facial recognition
C. Image classification
D. Regression


Correct Answer

A. Speech recognition


Explanation

Speech recognition converts spoken language into written text.


Why the Other Answers Are Incorrect

B. Facial recognition

Facial recognition analyzes faces in images.

C. Image classification

Image classification categorizes images.

D. Regression

Regression predicts numeric values.


Question 3

Which AI technique identifies and locates multiple objects within an image?

A. OCR
B. Object detection
C. Summarization
D. Clustering


Correct Answer

B. Object detection


Explanation

Object detection identifies objects and their positions within images or video frames.


Why the Other Answers Are Incorrect

A. OCR

OCR extracts text from images.

C. Summarization

Summarization condenses text.

D. Clustering

Clustering groups similar data points.


Question 4

A business wants to automatically determine whether customer reviews are positive or negative.

Which AI technique is MOST appropriate?

A. Sentiment analysis
B. OCR
C. Facial recognition
D. Image tagging


Correct Answer

A. Sentiment analysis


Explanation

Sentiment analysis evaluates emotional tone and opinions in text.


Why the Other Answers Are Incorrect

B. OCR

OCR extracts text from images.

C. Facial recognition

Facial recognition identifies people from images.

D. Image tagging

Image tagging labels image content.


Question 5

Which AI capability is commonly used to identify names, locations, and organizations within text?

A. Named Entity Recognition (NER)
B. Speech synthesis
C. Object tracking
D. Regression analysis


Correct Answer

A. Named Entity Recognition (NER)


Explanation

NER extracts entities such as people, organizations, dates, and locations from text.


Why the Other Answers Are Incorrect

B. Speech synthesis

Speech synthesis generates spoken audio.

C. Object tracking

Object tracking follows objects in video.

D. Regression analysis

Regression predicts numeric values.


Question 6

A smart security camera tracks moving vehicles across multiple video frames.

Which AI technique is being used?

A. Text classification
B. Object tracking
C. Summarization
D. Speech translation


Correct Answer

B. Object tracking


Explanation

Object tracking follows identified objects as they move through video footage.


Why the Other Answers Are Incorrect

A. Text classification

Text classification categorizes written text.

C. Summarization

Summarization condenses text.

D. Speech translation

Speech translation converts spoken language between languages.


Question 7

Which term describes AI systems that process multiple data types such as text, images, and audio together?

A. Regression AI
B. Multimodal AI
C. Clustering AI
D. Rule-based AI


Correct Answer

B. Multimodal AI


Explanation

Multimodal AI combines and processes multiple forms of data simultaneously.


Why the Other Answers Are Incorrect

A. Regression AI

Regression predicts numeric values.

C. Clustering AI

Clustering groups similar items.

D. Rule-based AI

Rule-based systems follow predefined logic rules.


Question 8

Which AI capability would MOST likely be used to generate automatic subtitles for videos?

A. Speech recognition
B. Image classification
C. Facial recognition
D. Recommendation systems


Correct Answer

A. Speech recognition


Explanation

Speech recognition converts spoken words in videos into text subtitles.


Why the Other Answers Are Incorrect

B. Image classification

Image classification categorizes images.

C. Facial recognition

Facial recognition identifies people in images.

D. Recommendation systems

Recommendation systems suggest content or products.


Question 9

A retailer wants AI to automatically identify products such as shoes, shirts, and electronics in uploaded images.

Which AI capability should be used?

A. Object detection
B. Sentiment analysis
C. Speech synthesis
D. Language translation


Correct Answer

A. Object detection


Explanation

Object detection identifies multiple objects within images and can locate them visually.


Why the Other Answers Are Incorrect

B. Sentiment analysis

Sentiment analysis evaluates text emotion.

C. Speech synthesis

Speech synthesis converts text into speech.

D. Language translation

Language translation converts text or speech between languages.


Question 10

What is the PRIMARY goal of information extraction AI systems?

A. Creating video games
B. Converting unstructured data into useful structured information
C. Compressing database files
D. Replacing all human decision-making


Correct Answer

B. Converting unstructured data into useful structured information


Explanation

Information extraction systems analyze unstructured content such as text, images, audio, and video to retrieve meaningful structured data.


Why the Other Answers Are Incorrect

A. Creating video games

This is unrelated to information extraction.

C. Compressing database files

This is a storage task, not AI extraction.

D. Replacing all human decision-making

AI systems are designed to assist and augment human processes, not completely replace all decision-making.


Final Thoughts

Information extraction is one of the most practical and widely used AI workloads covered in the AI-901 certification exam. Microsoft expects candidates to understand how AI systems extract useful insights from text, images, audio, and videos using NLP, speech AI, computer vision, and multimodal AI technologies.

These capabilities help organizations automate workflows, analyze large volumes of data, and build intelligent applications using Azure AI services.


Go to the AI-901 Exam Prep Hub main page

Describe the difference between Batch and Streaming data (DP-900 Exam Prep)

This post is a part of the DP-900: Microsoft Azure Data Fundamentals Exam Prep Hub. 
This topic falls under these sections:
Describe an analytics workload (25–30%)
--> Describe considerations for real-time data analytics
--> Describe the difference between Batch and Streaming data


Note that there are 10 practice questions (with answers and explanations) for each section to help you solidify your knowledge of the material. Also, there are 2 practice tests with 60 questions each available on the hub below the exam topics section.

Understanding the difference between batch data and streaming data is fundamental for designing modern analytics solutions. These two approaches define how data is ingested, processed, and analyzed.


What Is Batch Data?

Batch data refers to data that is:

  • Collected over a period of time
  • Processed in large chunks (batches)
  • Handled at scheduled intervals

Key Characteristics of Batch Data

  • High latency (minutes, hours, or days)
  • Processes large volumes at once
  • Typically scheduled (e.g., nightly jobs)
  • Efficient and cost-effective

Common Use Cases

  • Daily sales reports
  • Monthly financial summaries
  • Historical data analysis
  • Data warehousing workloads

Azure Services for Batch Processing

  • Azure Data Factory → batch ingestion and orchestration
  • Azure Synapse Analytics → batch processing and analytics

What Is Streaming Data?

Streaming data refers to data that is:

  • Generated continuously
  • Processed in real time (or near real time)
  • Handled as individual events or small micro-batches

Key Characteristics of Streaming Data

  • Low latency (seconds or milliseconds)
  • Continuous data flow
  • Enables real-time insights
  • Often requires more complex processing

Common Use Cases

  • IoT sensor monitoring
  • Fraud detection
  • Live dashboards
  • Website activity tracking

Azure Services for Streaming

  • Azure Event Hubs → event ingestion
  • Azure Stream Analytics → real-time processing

Batch vs Streaming — Key Differences

FeatureBatch ProcessingStreaming Processing
Data FlowPeriodicContinuous
LatencyHighLow
Data SizeLarge chunksSmall events
ComplexitySimplerMore complex
CostLowerHigher
Use CaseHistorical analysisReal-time insights

When to Use Batch Processing

Choose batch when:

  • Real-time data is not required
  • You are working with large historical datasets
  • Cost efficiency is important
  • Processing can occur on a schedule

When to Use Streaming Processing

Choose streaming when:

  • You need real-time or near real-time insights
  • Data is generated continuously
  • Immediate action is required

Hybrid Approaches (Lambda / Modern Architectures)

Many modern systems use both:

  • Batch layer → historical analysis
  • Streaming layer → real-time insights

✔ Example:

  • Real-time dashboard + nightly aggregated reports

Why This Matters for DP-900

On the exam, you may be asked to:

  • Distinguish between batch and streaming scenarios
  • Choose the appropriate processing method
  • Identify Azure services for each approach
  • Understand trade-offs (latency, cost, complexity)

Summary — Exam-Relevant Takeaways

✔ Batch processing

  • Processes data in chunks
  • Higher latency
  • Lower cost
  • Best for historical analysis

✔ Streaming processing

  • Processes data continuously
  • Low latency
  • Enables real-time insights
  • More complex

✔ Azure services:

  • Batch → Azure Data Factory, Azure Synapse Analytics
  • Streaming → Azure Event Hubs, Azure Stream Analytics

✔ Exam tip:
👉 Real-time requirement → Streaming
👉 Scheduled / historical → Batch


Go to the Practice Exam Questions for this topic.

Go to the DP-900 Exam Prep Hub main page.

Practice Questions: Describe the difference between Batch and Streaming data (DP-900 Exam Prep)

Practice Questions


Question 1

What is the primary characteristic of batch data processing?

A. Continuous data flow
B. Real-time processing
C. Processing data in scheduled chunks
D. Immediate event handling

✅ Answer: C

Explanation:
Batch processing handles data in groups at scheduled intervals, not continuously.


Question 2

Which type of processing is BEST suited for real-time analytics?

A. Batch processing
B. Stream processing
C. Periodic processing
D. Manual processing

✅ Answer: B

Explanation:
Stream processing enables real-time or near real-time insights.


Question 3

Which Azure service is commonly used for streaming data ingestion?

A. Azure Data Factory
B. Azure Event Hubs
C. Azure Synapse Analytics
D. Azure SQL Database

✅ Answer: B

Explanation:
Azure Event Hubs is designed for high-throughput, real-time data ingestion.


Question 4

Which scenario is BEST suited for batch processing?

A. Monitoring live stock prices
B. Detecting fraud in real time
C. Generating a monthly financial report
D. Tracking website clicks instantly

✅ Answer: C

Explanation:
Batch processing is ideal for scheduled, periodic workloads like reports.


Question 5

What is the typical latency for streaming data processing?

A. Hours
B. Days
C. Seconds or milliseconds
D. Weeks

✅ Answer: C

Explanation:
Streaming processing provides low-latency, near real-time results.


Question 6

Which Azure service is used to process streaming data in real time?

A. Azure Blob Storage
B. Azure Stream Analytics
C. Azure Files
D. Azure Virtual Machines

✅ Answer: B

Explanation:
Azure Stream Analytics processes streaming data in real time.


Question 7

Which statement about batch processing is TRUE?

A. It processes data continuously
B. It always requires real-time data sources
C. It is typically more cost-effective than streaming
D. It has lower latency than streaming

✅ Answer: C

Explanation:
Batch processing is generally more cost-efficient than continuous streaming.


Question 8

Which scenario requires streaming processing?

A. Archiving old data
B. Processing annual tax records
C. Monitoring IoT sensor data in real time
D. Generating quarterly reports

✅ Answer: C

Explanation:
Streaming is needed for continuous, real-time data flows like IoT.


Question 9

What is a key difference between batch and streaming processing?

A. Batch uses structured data, streaming does not
B. Streaming has higher latency than batch
C. Batch processes data in chunks, streaming processes data continuously
D. Streaming is always cheaper than batch

✅ Answer: C

Explanation:
Batch = periodic chunks, Streaming = continuous flow.


Question 10

Which approach would you choose if immediate action is required based on incoming data?

A. Batch processing
B. Stream processing
C. Scheduled processing
D. Offline processing

✅ Answer: B

Explanation:
Streaming is required when real-time decisions are needed.


✅ Quick Exam Takeaways

✔ Batch processing

  • Scheduled
  • High latency
  • Cost-effective
  • Best for historical analysis

✔ Streaming processing

  • Continuous
  • Low latency
  • Real-time insights
  • More complex

✔ Azure services:

  • Batch → Azure Data Factory, Azure Synapse Analytics
  • Streaming → Azure Event Hubs, Azure Stream Analytics

✔ Exam tip:
👉 Real-time = Streaming
👉 Scheduled/historical = Batch


Go to the DP-900 Exam Prep Hub main page.

Describe options for analytical data stores (DP-900 Exam Prep)

This post is a part of the DP-900: Microsoft Azure Data Fundamentals Exam Prep Hub. 
This topic falls under these sections:
Describe an analytics workload (25–30%)
--> Describe common elements of large-scale analytics
--> Describe options for analytical data stores


Note that there are 10 practice questions (with answers and explanations) for each section to help you solidify your knowledge of the material. Also, there are 2 practice tests with 60 questions each available on the hub below the exam topics section.

Analytical data stores are designed to support reporting, business intelligence, and large-scale data analysis. For the DP-900 exam, you should understand the different types of analytical stores, their characteristics, and when to use each.


What Is an Analytical Data Store?

An analytical data store is optimized for:

  • Querying large volumes of data
  • Aggregations and reporting
  • Historical analysis

✔ Unlike transactional systems, analytical stores focus on read-heavy workloads rather than frequent updates.


Key Characteristics

  • Optimized for complex queries and aggregations
  • Stores historical data
  • Handles large datasets (TBs to PBs)
  • Typically uses denormalized schemas
  • Designed for high-performance reads

Main Types of Analytical Data Stores


1. Data Warehouse

Definition

A structured repository designed for relational analytical queries.

Key Features

  • Uses structured data
  • Schema-based (often star or snowflake schema)
  • Supports SQL queries

Azure Example

Azure Synapse Analytics

Use Cases

  • Business intelligence reporting
  • Financial analysis
  • Enterprise dashboards

✔ Best for: Structured data and SQL-based analytics


2. Data Lake

Definition

A storage repository for raw data in its native format.

Key Features

  • Supports structured, semi-structured, and unstructured data
  • Schema-on-read (schema applied when querying)
  • Highly scalable and cost-effective

Azure Example

Azure Data Lake Storage

Use Cases

  • Big data analytics
  • Machine learning
  • Storing raw ingestion data

✔ Best for: Flexible, large-scale data storage


3. Data Lakehouse (Conceptual)

Definition

A hybrid approach combining features of data lakes and data warehouses.

Key Features

  • Stores raw data like a data lake
  • Supports structured queries like a warehouse
  • Often uses open formats (e.g., Parquet, Delta)

Azure Context

  • Often implemented using:
    • Azure Data Lake Storage
    • Azure Synapse Analytics

✔ Best for: Unified analytics platform


4. Analytical Databases / Big Data Processing Systems

Definition

Systems designed for distributed processing of large datasets.

Azure Example

Azure Synapse Analytics

Key Features

  • Parallel processing
  • Handles massive datasets
  • Supports batch and interactive queries

✔ Best for: Large-scale analytics workloads


Comparison of Analytical Data Stores

FeatureData WarehouseData LakeLakehouse
Data TypeStructuredAll typesAll types
SchemaSchema-on-writeSchema-on-readHybrid
CostHigherLowerModerate
FlexibilityLowHighHigh
Query PerformanceHighVariableHigh

Key Design Considerations


1. Data Structure

  • Structured → Data warehouse
  • Mixed or raw → Data lake

2. Query Requirements

  • Complex SQL queries → Data warehouse
  • Exploratory analytics → Data lake

3. Cost

  • Data lakes are generally more cost-effective
  • Warehouses provide optimized performance at higher cost

4. Scalability

  • All Azure analytical stores scale
  • Data lakes excel in massive data storage

5. Performance Needs

  • Warehouses → optimized for speed
  • Lakes → optimized for storage and flexibility

Typical Analytics Architecture

  1. Data Ingestion
    • Batch or streaming
  2. Storage
    • Data lake or data warehouse
  3. Processing
    • Transformations and aggregations
  4. Visualization
    • BI tools (e.g., Power BI)

Why This Matters for DP-900

On the exam, you may be asked to:

  • Identify the correct analytical store for a scenario
  • Compare data lakes vs data warehouses
  • Understand schema-on-read vs schema-on-write
  • Recognize Azure services used for analytics

Summary — Exam-Relevant Takeaways

✔ Analytical data stores are used for:

  • Reporting
  • Analytics
  • Historical data analysis

✔ Main types:

  • Data Warehouse → structured, high-performance queries
  • Data Lake → raw, flexible storage
  • Lakehouse → hybrid approach

✔ Key concepts:

  • Schema-on-write (warehouse)
  • Schema-on-read (lake)

✔ Azure services to know:

  • Azure Synapse Analytics → data warehouse & analytics
  • Azure Data Lake Storage → scalable data lake

✔ Exam tip:
👉 Structured + SQL analytics → Data Warehouse
👉 Raw + flexible + big data → Data Lake


Go to the Practice Exam Questions for this topic.

Go to the DP-900 Exam Prep Hub main page.

Practice Questions: Describe options for analytical data stores (DP-900 Exam Prep)

Practice Questions


Question 1

What is the primary purpose of an analytical data store?

A. To process high-volume transactions
B. To store temporary application data
C. To support reporting and data analysis
D. To manage user authentication

✅ Answer: C

Explanation:
Analytical data stores are optimized for reporting, querying, and analysis, not transactions.


Question 2

Which type of data store is BEST suited for structured data and complex SQL queries?

A. Data lake
B. Data warehouse
C. File storage
D. Key-value store

✅ Answer: B

Explanation:
Data warehouses are designed for structured data and high-performance SQL queries.


Question 3

Which Azure service is commonly used as a data warehouse?

A. Azure Data Lake Storage
B. Azure Synapse Analytics
C. Azure Files
D. Azure Table Storage

✅ Answer: B

Explanation:
Azure Synapse Analytics provides data warehousing and large-scale analytics capabilities.


Question 4

What is a key characteristic of a data lake?

A. Requires predefined schema before loading data
B. Stores only structured data
C. Stores data in its raw format
D. Optimized for transactional workloads

✅ Answer: C

Explanation:
Data lakes store raw data in native formats, supporting schema-on-read.


Question 5

Which concept describes applying schema when data is read rather than when it is written?

A. Schema-on-write
B. Schema-on-read
C. Data normalization
D. Data partitioning

✅ Answer: B

Explanation:
Schema-on-read is used in data lakes, allowing flexible analysis.


Question 6

Which scenario is BEST suited for a data lake?

A. Financial reporting with strict schema
B. Running complex SQL joins on structured data
C. Storing raw IoT and log data for later analysis
D. Processing online transactions

✅ Answer: C

Explanation:
Data lakes are ideal for large volumes of raw, diverse data.


Question 7

Which analytical data store typically uses schema-on-write?

A. Data lake
B. Data warehouse
C. Object storage
D. Key-value store

✅ Answer: B

Explanation:
Data warehouses require a defined schema before data is loaded.


Question 8

Which of the following best describes a data lakehouse?

A. A transactional database system
B. A file storage system only
C. A hybrid of data lake and data warehouse
D. A key-value storage solution

✅ Answer: C

Explanation:
A lakehouse combines flexibility of data lakes with performance of warehouses.


Question 9

Which factor is MOST important when choosing between a data lake and a data warehouse?

A. Screen resolution
B. Data structure and query requirements
C. Programming language
D. User interface design

✅ Answer: B

Explanation:
The choice depends on data type (structured vs raw) and query needs.


Question 10

Which Azure service is BEST suited for storing large volumes of raw, unstructured data?

A. Azure SQL Database
B. Azure Data Lake Storage
C. Azure Synapse Analytics
D. Azure Table Storage

✅ Answer: B

Explanation:
Azure Data Lake Storage is optimized for large-scale raw data storage.


✅ Quick Exam Takeaways

✔ Analytical data stores support:

  • Reporting
  • Business intelligence
  • Large-scale analytics

✔ Main types:

  • Data Warehouse → structured, SQL, high performance
  • Data Lake → raw, flexible, scalable
  • Lakehouse → hybrid approach

✔ Key concepts:

  • Schema-on-write → warehouse
  • Schema-on-read → lake

✔ Azure services:

  • Azure Synapse Analytics → data warehouse / analytics
  • Azure Data Lake Storage → data lake

✔ Exam tip:
👉 Structured + SQL → Data Warehouse
👉 Raw + flexible → Data Lake


Go to the DP-900 Exam Prep Hub main page.

Describe considerations for data ingestion and processing (DP-900 Exam Prep)

This post is a part of the DP-900: Microsoft Azure Data Fundamentals Exam Prep Hub. 
This topic falls under these sections:
Describe an analytics workload (25–30%)
--> Describe common elements of large-scale analytics
--> Describe considerations for data ingestion and processing


Note that there are 10 practice questions (with answers and explanations) for each section to help you solidify your knowledge of the material. Also, there are 2 practice tests with 60 questions each available on the hub below the exam topics section.

In modern data platforms, data ingestion and processing are critical steps that determine how raw data becomes meaningful insights. For the DP-900 exam, you should understand how data enters a system, how it is transformed, and the key design considerations involved.


What Is Data Ingestion?

Data ingestion is the process of collecting and importing data from various sources into a storage or analytics system.

Common Data Sources

  • Databases (relational and NoSQL)
  • Files (CSV, JSON, logs)
  • Streaming data (IoT devices, sensors)
  • Applications and APIs

Types of Data Ingestion


1. Batch Ingestion

  • Data is collected and processed at scheduled intervals
  • Suitable for large volumes of data
  • Higher latency (not real-time)

✔ Example:

  • Daily sales data uploads

✔ Common Azure service:
Azure Data Factory


2. Stream (Real-Time) Ingestion

  • Data is ingested continuously as it is generated
  • Low latency (near real-time processing)

✔ Example:

  • IoT sensor data
  • Live website activity

✔ Common Azure services:

  • Azure Event Hubs
  • Azure Stream Analytics

What Is Data Processing?

Data processing involves transforming raw data into a usable format for analysis.

Typical Processing Tasks

  • Cleaning data (removing errors, duplicates)
  • Transforming formats (e.g., JSON → tabular)
  • Aggregating data (summaries, totals)
  • Enriching data (adding additional context)

Types of Data Processing


1. Batch Processing

  • Processes large datasets at scheduled intervals
  • Efficient for historical analysis

✔ Example:

  • Monthly financial reporting

✔ Common Azure service:

  • Azure Synapse Analytics

2. Stream Processing

  • Processes data in real time as it arrives
  • Enables immediate insights and actions

✔ Example:

  • Fraud detection
  • Real-time dashboards

✔ Common Azure service:

  • Azure Stream Analytics

Key Considerations for Data Ingestion and Processing


1. Latency Requirements

  • Batch → Higher latency (minutes/hours)
  • Streaming → Low latency (seconds)

✔ Choose based on how quickly insights are needed.


2. Data Volume and Velocity

  • Large datasets require scalable solutions
  • High-velocity data requires streaming platforms

✔ Azure services are designed to scale automatically.


3. Data Variety

  • Structured, semi-structured, and unstructured data
  • Requires flexible processing tools

4. Data Quality

  • Ensure accuracy and consistency
  • Clean and validate data during processing

5. Scalability

  • Systems must handle increasing data sizes
  • Cloud platforms provide elastic scaling

6. Cost Optimization

  • Batch processing is generally more cost-efficient
  • Streaming may cost more due to continuous processing

7. Reliability and Fault Tolerance

  • Ensure data is not lost during ingestion
  • Use checkpointing and retry mechanisms

Common Architecture Pattern

A typical analytics pipeline:

  1. Ingestion
    • Batch: Azure Data Factory
    • Stream: Azure Event Hubs
  2. Storage
    • Data lake or storage account
  3. Processing
    • Batch: Azure Synapse Analytics
    • Stream: Azure Stream Analytics
  4. Visualization
    • Reporting tools (e.g., Power BI)

Batch vs Stream — Quick Comparison

FeatureBatch ProcessingStream Processing
Data FlowPeriodicContinuous
LatencyHighLow
Use CaseHistorical analysisReal-time insights
CostLowerHigher

Why This Matters for DP-900

On the exam, you may be asked to:

  • Distinguish between batch and stream processing
  • Identify appropriate ingestion methods
  • Choose Azure services based on scenarios
  • Understand trade-offs (latency, cost, scalability)

Summary — Exam-Relevant Takeaways

✔ Data ingestion = bringing data into the system
✔ Data processing = transforming data for analysis

✔ Two main patterns:

  • Batch → periodic, high latency
  • Streaming → real-time, low latency

✔ Key considerations:

  • Latency
  • Volume and velocity
  • Data quality
  • Scalability
  • Cost

✔ Azure services to know:

  • Azure Data Factory (batch ingestion)
  • Azure Event Hubs (stream ingestion)
  • Azure Stream Analytics (real-time processing)
  • Azure Synapse Analytics (batch processing)

Go to the Practice Exam Questions for this topic.

Go to the DP-900 Exam Prep Hub main page.

Practice Questions: Describe considerations for data ingestion and processing (DP-900 Exam Prep)

Practice Questions


Question 1

What is the primary purpose of data ingestion?

A. To visualize data
B. To store data permanently
C. To collect and import data into a system
D. To delete outdated data

✅ Answer: C

Explanation:
Data ingestion is the process of bringing data into a storage or analytics system.


Question 2

Which type of ingestion processes data at scheduled intervals?

A. Stream ingestion
B. Batch ingestion
C. Real-time ingestion
D. Event-driven ingestion

✅ Answer: B

Explanation:
Batch ingestion processes data periodically, not continuously.


Question 3

Which Azure service is commonly used for batch data ingestion?

A. Azure Event Hubs
B. Azure Data Factory
C. Azure Stream Analytics
D. Azure Virtual Machines

✅ Answer: B

Explanation:
Azure Data Factory is designed for batch ETL/ELT workflows.


Question 4

Which scenario requires stream (real-time) ingestion?

A. Monthly sales reporting
B. Archiving old data
C. Monitoring live sensor data from IoT devices
D. Migrating historical records

✅ Answer: C

Explanation:
Streaming ingestion is used for continuous, real-time data like IoT.


Question 5

What is the primary benefit of stream processing?

A. Lower cost
B. Simpler architecture
C. Real-time insights
D. Reduced storage requirements

✅ Answer: C

Explanation:
Stream processing enables low-latency, real-time analysis.


Question 6

Which Azure service is used for real-time data ingestion at scale?

A. Azure Synapse Analytics
B. Azure Blob Storage
C. Azure Event Hubs
D. Azure Files

✅ Answer: C

Explanation:
Azure Event Hubs is designed for high-throughput streaming ingestion.


Question 7

Which type of processing is BEST suited for historical data analysis?

A. Stream processing
B. Batch processing
C. Real-time processing
D. Event-driven processing

✅ Answer: B

Explanation:
Batch processing is ideal for large, historical datasets.


Question 8

Which factor is MOST important when choosing between batch and stream processing?

A. File format
B. Latency requirements
C. Storage account type
D. Programming language

✅ Answer: B

Explanation:
The key decision is how quickly the data needs to be processed.


Question 9

Which Azure service is used to process streaming data in real time?

A. Azure Data Factory
B. Azure Stream Analytics
C. Azure SQL Database
D. Azure Files

✅ Answer: B

Explanation:
Azure Stream Analytics processes real-time streaming data.


Question 10

Which of the following is a key consideration when designing a data ingestion pipeline?

A. Screen resolution
B. Latency, scalability, and data volume
C. Programming language syntax
D. User interface design

✅ Answer: B

Explanation:
Important considerations include latency, scalability, volume, and data quality.


✅ Quick Exam Takeaways

✔ Data ingestion = bringing data into the system
✔ Data processing = transforming data for analysis

✔ Two main approaches:

  • Batch → scheduled, high latency
  • Streaming → continuous, low latency

✔ Key Azure services:

  • Azure Data Factory → batch ingestion
  • Azure Event Hubs → streaming ingestion
  • Azure Stream Analytics → real-time processing
  • Azure Synapse Analytics → batch processing

✔ Key decision factor:
👉 Do you need real-time insights or not?


Go to the DP-900 Exam Prep Hub main page.

Practice Questions: Describe Azure Cosmos DB APIs (DP-900 Exam Prep)

Practice Questions


Question 1

Which API in Azure Cosmos DB uses a SQL-like query language?

A. Gremlin API
B. Cassandra API
C. Core (SQL) API
D. Table API

✅ Answer: C

Explanation:
The Core (SQL) API uses a SQL-like syntax to query JSON documents.


Question 2

Which Azure Cosmos DB API is BEST suited for applications currently using MongoDB?

A. Core (SQL) API
B. MongoDB API
C. Cassandra API
D. Table API

✅ Answer: B

Explanation:
The MongoDB API provides compatibility with MongoDB drivers and queries.


Question 3

Which API should you choose for graph-based data and relationships?

A. Table API
B. Cassandra API
C. Gremlin API
D. MongoDB API

✅ Answer: C

Explanation:
The Gremlin API is designed for graph data models and relationship analysis.


Question 4

Which API in Cosmos DB is most similar to Azure Table Storage?

A. MongoDB API
B. Cassandra API
C. Table API
D. Core (SQL) API

✅ Answer: C

Explanation:
The Table API uses a key-value model similar to Azure Table Storage.


Question 5

Which statement about Azure Cosmos DB APIs is TRUE?

A. You can switch APIs after creating the account
B. Each API uses a different query language and data model
C. All APIs use T-SQL
D. APIs determine storage redundancy

✅ Answer: B

Explanation:
Each API has its own data model and query language.


Question 6

Which API would you choose for a distributed system currently using Apache Cassandra?

A. Core (SQL) API
B. MongoDB API
C. Cassandra API
D. Gremlin API

✅ Answer: C

Explanation:
The Cassandra API supports Cassandra Query Language (CQL) and workloads.


Question 7

Which API is the default and most commonly used in Azure Cosmos DB?

A. Table API
B. Gremlin API
C. Core (SQL) API
D. Cassandra API

✅ Answer: C

Explanation:
The Core (SQL) API is the most commonly used and general-purpose API.


Question 8

Which scenario is BEST suited for the Table API?

A. Complex graph traversal
B. Large-scale relational queries
C. Simple key-value data storage
D. Document-based analytics

✅ Answer: C

Explanation:
The Table API is ideal for simple, scalable key-value storage.


Question 9

What is a key consideration when choosing a Cosmos DB API?

A. The size of the storage account
B. The number of virtual machines
C. The application’s existing data model and query language
D. The type of Azure subscription

✅ Answer: C

Explanation:
API selection depends on existing technologies and data models.


Question 10

Which statement best describes Azure Cosmos DB APIs?

A. Each API uses a different underlying database engine
B. APIs provide different ways to interact with the same service
C. APIs are only used for relational data
D. APIs determine the pricing tier only

✅ Answer: B

Explanation:
All APIs use the same Cosmos DB service but offer different interfaces and models.


✅ Quick Exam Takeaways

✔ Cosmos DB APIs allow different ways to interact with the same service

✔ APIs:

  • Core (SQL) → SQL-like queries (most common)
  • MongoDB → MongoDB compatibility
  • Cassandra → Distributed systems (CQL)
  • Table → Key-value storage
  • Gremlin → Graph data

✔ Key concepts:

  • API choice depends on data model and existing system
  • API selection is permanent after creation

✔ Exam tip:
👉 Match data model → API type


Go to the DP-900 Exam Prep Hub main page.

Describe Azure Cosmos DB APIs (DP-900 Exam Prep)

This post is a part of the DP-900: Microsoft Azure Data Fundamentals Exam Prep Hub. 
This topic falls under these sections:
Describe considerations for working with non-relational data on Azure (15–20%)
--> Describe Capabilities and Features of Azure Cosmos DB
--> Describe Azure Cosmos DB APIs


Note that there are 10 practice questions (with answers and explanations) for each section to help you solidify your knowledge of the material. Also, there are 2 practice tests with 60 questions each available on the hub below the exam topics section.

Azure Cosmos DB supports multiple APIs that allow developers to interact with the database using different data models and familiar query languages.

For the DP-900 exam, you should understand what these APIs are, how they differ, and when to use each one.


What Are Azure Cosmos DB APIs?

APIs in Azure Cosmos DB define:

  • How data is structured
  • How it is queried
  • Which tools and SDKs are used

✔ Each API provides a different way to interact with the same underlying Cosmos DB service.


Why Multiple APIs?

Azure Cosmos DB supports multiple APIs to:

  • Allow developers to use familiar tools
  • Enable easy migration from existing systems
  • Support different types of applications and data models

💡 Key idea:
👉 Choose the API based on your application’s existing technology or data model


Core Azure Cosmos DB APIs


1. Core (SQL) API

Also known as the SQL API.

Key Features

  • Uses a SQL-like query language
  • Stores data as JSON documents
  • Most commonly used API

Use Cases

  • New application development
  • General-purpose NoSQL workloads

✔ Best for: Developers familiar with SQL who want flexibility


2. MongoDB API

Key Features

  • Compatible with MongoDB drivers and tools
  • Uses MongoDB query syntax

Use Cases

  • Migrating existing MongoDB applications
  • Applications already using MongoDB

✔ Best for: MongoDB workloads moving to Azure


3. Cassandra API

Key Features

  • Compatible with Apache Cassandra
  • Supports Cassandra Query Language (CQL)

Use Cases

  • Large-scale distributed workloads
  • Applications using Cassandra

✔ Best for: Cassandra-based systems needing cloud scalability


4. Table API

Key Features

  • Similar to Azure Table Storage
  • Key-value data model
  • Uses OData-based queries

Use Cases

  • Simple key-value workloads
  • Applications already using Table Storage

✔ Best for: Lightweight, scalable key-value scenarios


5. Gremlin API

Key Features

  • Supports graph data models
  • Uses Gremlin query language

Use Cases

  • Graph-based applications
  • Relationship-heavy data

✔ Best for: Social networks, recommendation engines, network analysis


Key Differences Between APIs

APIData ModelQuery LanguageBest For
Core (SQL)Document (JSON)SQL-likeGeneral-purpose apps
MongoDBDocumentMongoDB queryMongoDB migration
CassandraWide-columnCQLDistributed systems
TableKey-valueODataSimple scalable storage
GremlinGraphGremlinRelationship-based data

Important Concepts for DP-900


1. Same Service, Different Interfaces

All APIs run on Azure Cosmos DB, but:

  • Each API has its own endpoint
  • Each uses different query syntax
  • Each supports different SDKs

2. API Choice Is Permanent

  • You choose the API when creating a Cosmos DB account
  • You cannot switch APIs later

3. Performance and Features Are Shared

  • Global distribution
  • Low latency
  • High availability
  • Scalability

✔ These benefits apply regardless of API choice.


When to Choose Each API

  • Core (SQL) API → Default choice for most applications
  • MongoDB API → Existing MongoDB apps
  • Cassandra API → Distributed, large-scale systems
  • Table API → Simple key-value workloads
  • Gremlin API → Graph relationships

Why This Matters for DP-900

On the exam, you may be asked to:

  • Identify the correct API for a scenario
  • Match APIs to data models
  • Understand why multiple APIs exist
  • Recognize migration scenarios

Summary — Exam-Relevant Takeaways

✔ Azure Cosmos DB supports multiple APIs:

  • Core (SQL) API
  • MongoDB API
  • Cassandra API
  • Table API
  • Gremlin API

✔ Each API:

  • Uses a different data model
  • Has its own query language

✔ Key concept:
👉 Choose the API based on your application’s needs or existing system

✔ Important:

  • API choice is fixed at creation
  • All APIs benefit from Cosmos DB features (scalability, global distribution)

Go to the Practice Exam Questions for this topic.

Go to the DP-900 Exam Prep Hub main page.