Pass the Microsoft Microsoft Certified: Azure AI Fundamentals AI-900 Questions and answers with CertsForce

In Azure Machine Learning designer, the Split Data module is specifically designed to divide a dataset into training and validation (or testing) subsets. The AI-900 study guide and the Microsoft Learn module “Split data for training and evaluation” explain that this module allows users to control how data is partitioned, ensuring that models are trained on one portion of the data and tested on unseen data to assess performance.

By default, the Split Data module uses a 70/30 or 80/20 ratio, meaning 70–80% of the data is used for training and the remaining 20–30% for validation or testing. This ensures the model’s generalizability and prevents overfitting.

The other options serve different purposes:

A. Select Columns in Dataset: Used to choose specific columns or features from a dataset.

B. Add Rows: Combines multiple datasets vertically.

D. Join Data: Combines datasets horizontally based on a common key.

Only Split Data performs the function of dividing data into training and validation subsets.

Generative AI focuses on creating new content rather than just analyzing existing data. As per Microsoft’s AI-900 curriculum and Azure OpenAI documentation, typical use cases include generating text, images, code, or other creative outputs based on input prompts.

A. Generating draft responses for customer service agents — ✅ Correct. GPT-based models can automatically generate draft replies to customer queries, enabling agents to refine responses and increase efficiency.

B. Creating original artwork from textual descriptions — ✅ Correct. DALL-E, available through Azure OpenAI, can produce unique images based on natural language prompts.

Options C and D are incorrect because they involve predictive or classification models, not generative ones:

C. Predicting sales revenue → Regression (machine learning).

D. Classifying email messages → Classification (machine learning).

Correct answers: A and B.

According to the Microsoft Azure AI Fundamentals (AI-900) official study guide and Microsoft Learn module “Explore fundamental principles of machine learning”, regression models are used to predict numerical or continuous values based on patterns found in historical data. When the goal is to forecast or estimate a real-valued outcome—such as price, temperature, sales, or age—the appropriate model type is regression.

In this question, the task is to predict the sale price of auctioned items. Since price is a continuous numeric value that can vary within a range (for example, $100.50, $105.75, $120.00, etc.), it fits perfectly into a regression problem. Microsoft Learn defines regression as “a supervised machine learning technique that predicts a numeric value based on relationships found in input features.” Common regression algorithms include linear regression, decision tree regression, and neural network regression.

By contrast:

Classification is used when the output variable represents categories or classes, such as predicting whether an email is spam or not spam, or whether a transaction is fraudulent or legitimate. Classification predicts discrete labels, not continuous values.

Clustering, on the other hand, is an unsupervised learning method used to group similar data points together without predefined labels. Examples include grouping customers by purchasing behavior or grouping images by visual similarity.

In a predictive business scenario, like estimating the price of an auctioned item based on features such as age, condition, and demand, regression models are most appropriate. Azure Machine Learning supports regression experiments using built-in algorithms and AutoML to automatically choose the best-performing model for continuous output prediction.

In Azure Machine Learning designer, a low-code drag-and-drop interface, users can visually build machine learning workflows. According to the AI-900 study guide and Microsoft Learn module “Create and publish models with Azure Machine Learning designer”, two key components that can be dragged onto the designer canvas are datasets and modules.

Datasets (A): These are collections of data that serve as the input for training or evaluating models. They can be registered in the workspace and then dragged onto the canvas for use in transformations or model training.

Modules (D): These are prebuilt processing and modeling components that perform operations such as data cleaning, feature engineering, model training, and evaluation. Examples include “Split Data,” “Train Model,” and “Evaluate Model.”

Compute (B) and Pipeline (C) are not drag-and-drop items within the designer. Compute targets are infrastructure resources used to run the pipeline, while a pipeline represents the overall workflow, not a component that can be added like a dataset or module.

Hence, the correct answers are A. Dataset and D. Module.

These answers align with the Microsoft Azure AI Fundamentals (AI-900) Official Study Guide and the Microsoft Learn module “Explore conversational AI in Microsoft Azure.”

1. A webchat bot can interact with users visiting a website → Yes

This statement is true. The Azure Bot Service allows developers to create intelligent chatbots that can be integrated into a webchat interface. This enables visitors to interact with the bot directly from a website, asking questions and receiving automated responses. This is a typical use case of conversational AI, where natural language processing (NLP) is used to interpret and respond to user input conversationally.

2. Automatically generating captions for pre-recorded videos is an example of conversational AI → No

This statement is false. Automatically generating captions from video content is an example of speech-to-text (speech recognition) technology, not conversational AI. While it uses AI to convert spoken words into text, it lacks the two-way interactive communication characteristic of conversational AI. This task is typically handled by the Azure AI Speech service, which transcribes spoken content.

3. A smart device in the home that responds to questions such as “What will the weather be like today?” is an example of conversational AI → Yes

This statement is true. Smart home assistants that engage in dialogue with users are powered by conversational AI. These devices use speech recognition to understand spoken input, natural language understanding (NLU) to determine intent, and speech synthesis (text-to-speech) to respond audibly. This represents the full conversational AI loop, where machines communicate naturally with humans.

According to the Microsoft Azure AI Fundamentals (AI-900) Official Study Guide and the Microsoft Learn module “Explore conversational AI in Microsoft Azure,” conversational bots are AI applications that can understand and respond to natural language inputs through text or speech. Building such a bot typically involves two key Azure services:

Azure Bot Service (Option B):This service provides the framework and infrastructure needed to create, test, and deploy intelligent chatbots that interact with users across multiple channels (webchat, Teams, email, etc.). It handles conversation flow, integration, and user message management.

Azure Language Service (Option A):This service powers the natural language understanding (NLU) capability of the bot. It enables the bot to interpret user input, extract intent, and query a knowledge base using Question Answering (formerly QnA Maker). This allows the bot to respond intelligently to user questions by finding the most relevant answers.

The other options are incorrect:

C. Form Recognizer is used for extracting structured data from documents like invoices or forms.

D. Anomaly Detector is used for identifying unusual patterns in time-series data.

Hence, to build a bot that understands and answers user questions in natural language, the solution must combine Azure Bot Service for conversation management and Azure Language Service for knowledge-based question answering and natural language understanding.

According to the Microsoft Azure AI Fundamentals (AI-900) official study guide and the Microsoft Learn module “Identify features of Natural Language Processing (NLP) workloads on Azure”, Azure Cognitive Services provides several text analytics and language understanding workloads that perform different types of language processing tasks. Each workload extracts specific information or performs distinct analysis operations on text data.

Entity Recognition → Extracts persons, locations, and organizations from the textEntity recognition is a feature of Azure Cognitive Service for Language (formerly Text Analytics). It identifies and categorizes named entities in unstructured text, such as people, organizations, locations, dates, and more. The study guide defines this workload as: “Entity recognition locates and classifies named entities in text into predefined categories.” This allows applications to extract structured information from raw text data—for example, identifying “Microsoft” as an organization and “Seattle” as a location.

Sentiment Analysis → Evaluates text along a positive–negative scaleSentiment analysis determines the emotional tone or opinion expressed in a piece of text. It classifies text as positive, negative, neutral, or mixed, which is widely used for social media monitoring, customer feedback, and product reviews. Microsoft’s official documentation describes it as: “Sentiment analysis evaluates text and returns a sentiment score indicating whether the sentiment is positive, negative, neutral, or mixed.”

Translation → Returns text translated to the specified target languageThe Translator service, part of Azure Cognitive Services, automatically translates text from one language to another. It supports multiple languages and provides near real-time translation. The AI-900 content specifies that “translation workloads are used to automatically translate text between languages using machine translation models.”

In summary:

Entity Recognition → Extracts entities like names and locations.

Sentiment Analysis → Determines emotional tone.

Translation → Converts text between languages.

✅ Final Answers:

Extracts persons, locations, and organizations → Entity recognition

Evaluates text along a positive–negative scale → Sentiment analysis

Returns text translated to the specified target language → Translation

In Azure Machine Learning Designer, the Dataset output visualization feature is specifically used to explore and understand the distribution of values in potential feature columns before model training begins. This capability is critical for data exploration and preprocessing, two essential stages of the machine learning pipeline described in the Microsoft Azure AI Fundamentals (AI-900) and Azure Machine Learning learning paths.

When a dataset is imported into Azure Machine Learning Designer, users can right-click on the dataset output port and select “Visualize”. This launches the dataset visualization pane, which provides detailed statistical summaries for each column, including:

Data type (numeric, categorical, string, Boolean)

Minimum, maximum, mean, and standard deviation values for numeric columns

Frequency counts and distinct values for categorical columns

Missing value counts

This visual inspection helps determine which columns should be used as features, which might need normalization or encoding, and which contain missing or irrelevant data. It is a vital step in ensuring the dataset is clean and ready for model training.

Let’s examine why other options are incorrect:

Normalize Data module is used to scale numeric data, not to visualize distributions.

Select Columns in Dataset module is used to include or exclude columns, not to analyze them.

Evaluation results visualization feature is used after model training to interpret performance metrics like accuracy or recall, not data distributions.

Therefore, based on official Microsoft documentation and AI-900 study materials, to explore the distribution of values in potential feature columns, you use the Dataset output visualization feature in Azure Machine Learning Designer.

According to the Microsoft Azure AI Fundamentals (AI-900) official study guide and Microsoft Learn module “Identify features of Natural Language Processing (NLP) workloads and services,” the Azure Cognitive Service for Language – Question Answering capability is designed to allow applications to respond to user questions using information from a prebuilt or custom knowledge base. It relies on Natural Language Processing (NLP) to match user queries to the most relevant answers but does not directly execute queries against databases or infer user intent.

“You can use Language Service’s question answering to query an Azure SQL database.” → NOThe Question Answering feature does not connect directly to or query structured databases such as Azure SQL. Instead, it retrieves answers from unstructured or semi-structured content (FAQs, manuals, documents). Querying SQL databases would require traditional database access, not a cognitive service.

“You should use Language Service’s question answering when you want a knowledge base to provide the same answer to different users who submit similar questions.” → YESThis statement is correct and aligns exactly with Microsoft’s official documentation. Question Answering enables organizations to create a knowledge base that can automatically answer repeated or similar customer queries using natural language understanding. For instance, two users asking “How do I reset my password?” and “Can you help me change my password?” would receive the same predefined response.

“Language Service’s question answering can determine the intent of a user utterance.” → NODetermining user intent is handled by Language Understanding (LUIS) or Conversational Language Understanding, not by Question Answering. While both belong to the Language Service, Question Answering focuses on retrieving relevant answers, whereas LUIS focuses on intent detection and entity extraction.

As described in the AI-900 study guide under “Identify features of machine learning,” regression is a supervised learning technique used to predict continuous numerical values. In this scenario, the goal is to predict energy output (a continuous variable) based on density (a numeric input).

Regression models find relationships between variables by fitting a line or curve that best represents the trend of the data. In Azure Machine Learning, regression algorithms such as linear regression, decision tree regression, and boosted decision trees are commonly used for such predictions.

Classification (A) predicts discrete labels (e.g., “High” or “Low”), not numeric values.

Clustering (B) groups similar data points but does not perform prediction.

Knowledge mining (C) extracts insights from unstructured data using tools like Azure AI Search and Cognitive Skills.

Hence, based on AI-900 fundamentals, predicting energy based on density requires a regression workload.