Microsoft DP-800 Developing AI-Enabled Database Solutions Free Practice Test - 20 Questions

Question 1

A company wants to enable users to query an Azure SQL database using natural language questions. Which service should be integrated to achieve this with minimal custom development?

Accepted Answer

Azure Machine Learning with a text-to-SQL model

Question 2

You are designing a solution to perform real-time anomaly detection on streaming data in Azure SQL Database. Which approach is the most appropriate?

Accepted Answer

Use Azure Stream Analytics with a built-in anomaly detection function

Question 3

What is the primary benefit of using vector embeddings in a database like Azure Cosmos DB for AI applications?

Accepted Answer

Efficient similarity search for unstructured data

Question 4

A retail company wants to automatically extract product attributes (e.g., color, size) from images stored in Azure Blob Storage and store them in a database. Which service combination is most suitable?

Accepted Answer

Azure Cognitive Services Computer Vision with Azure SQL Database

Question 5

You are using Azure Cognitive Search with an AI enrichment pipeline to extract entities from documents. Which data source type is directly supported for built-in entity recognition?

Accepted Answer

Azure Blob Storage

Question 6

A bank wants to synthesize customer data for testing without exposing personally identifiable information (PII). Which AI approach is best for generating realistic but synthetic data?

Accepted Answer

Deploy a Generative Adversarial Network (GAN) using Azure Machine Learning

Question 7

You need to enable natural language querying of an Azure Cosmos DB database. Which integration is best suited for this?

Accepted Answer

Azure OpenAI Service with a prompt that generates SQL

Question 8

A manufacturing company wants to predict equipment failure based on sensor data stored in Azure SQL Database. Which approach allows the prediction to be made directly in T-SQL queries?

Accepted Answer

Create an Azure Machine Learning model and deploy it as a web service, then call it via T-SQL

Question 9

You are building a chat application that uses a database to answer customer questions. To return relevant product information, you need to perform a semantic search without custom ML training. Which Azure service should you use?

Accepted Answer

Azure OpenAI Service with a vector embedding model

Question 10

A healthcare organization wants to automatically redact PII from clinical notes before storing them in Azure SQL Database. Which AI service can be integrated directly during data ingestion?

Accepted Answer

Azure Cognitive Services Text Analytics API

Question 11

You need to implement a recommendation engine for an e-commerce site. The product data is stored in Azure SQL Database, and user behavior is stored in a separate database. Which approach uses AI most effectively?

Accepted Answer

Use Azure Machine Learning to train a collaborative filtering model on user-product interactions

Question 12

A global company wants to automatically translate customer reviews stored in Azure SQL Database into multiple languages. Which service should be integrated?

Accepted Answer

Azure Cognitive Services Translator

Question 13

You are designing a solution to classify incoming support tickets into categories using an Azure SQL Database. The categories are predefined, and you need minimal latency. Which is the most efficient approach?

Accepted Answer

Use Azure Machine Learning to deploy a classification model as a web service and call it from T-SQL

Question 14

You need to build a vector database for a similarity search application. Which Azure database option natively supports vector indexing and search?

Accepted Answer

Azure Database for PostgreSQL (with pgvector extension)

Question 15

A data scientist wants to use automated machine learning to find the best model for predicting customer churn. The data is in Azure Synapse Analytics. Which service should be used?

Accepted Answer

Azure Machine Learning with automated ML

Question 16

You need to monitor and alert on unusual query patterns in an Azure SQL Database. Which AI service is best for this task?

Accepted Answer

Azure SQL Database built-in Intelligent Insights

Question 17

A company wants to allow users to ask questions about a knowledge base stored in Azure SQL Database and receive AI-generated answers. Which combination is most appropriate?

Accepted Answer

Azure OpenAI Service with Retrieval Augmented Generation (RAG) using Cognitive Search

Question 18

You are integrating Azure AI services with a database. Which authentication method is recommended for securely connecting an Azure SQL Database to an Azure Cognitive Services endpoint?

Accepted Answer

Managed Identity

Question 19

A financial analyst needs to generate a natural language summary of quarterly sales data stored in Azure Synapse. Which AI service can be used to generate this summary?

Accepted Answer

Azure OpenAI Service with summarization model

Question 20

You need to process a large dataset in Azure Blob Storage and load it into Azure SQL Database after applying some AI-based transformations. Which service is best for orchestrating this workflow?

Accepted Answer

Azure Data Factory with mapping data flows and AI activities

Microsoft DP-800 Developing AI-Enabled Database Solutions Free Practice Test - 20 Questions

The free lane is only the front row