1. AI-102 Topic 4 Question 11
Question
You have an Azure Cognitive Search solution and an enrichment pipeline that performs Sentiment Analysis on social media posts.
You need to define a knowledge store that will include the social media posts and the Sentiment Analysis results.
Which two fields should you include in the definition? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A. storageContainer
- B. storageConnectionString
- C. files
- D. tables
- E. objects
Suggested Answer
BE
Answer Description Click to expand
Community Answer Votes
- BE: 20 most voted
- AB: 9
- DE: 8
- BD: 8
- AD: 1




















Comment 1
To define a knowledge store in Azure Cognitive Search that includes both the social media posts and the Sentiment Analysis results, you should include the following two fields in the definition:
A. storageContainer: This field specifies the Azure Blob Storage container where the enriched data will be stored. You need to define a storage container to hold the processed data from the enrichment pipeline.
B. storageConnectionString: This field provides the connection string to the Azure Storage account that will be used to store the enriched data. The connection string is necessary for Azure Cognitive Search to connect and store the data in the specified storage account.
Both the storageContainer and storageConnectionString fields are required to set up a knowledge store in Azure Cognitive Search that can store the social media posts and the Sentiment Analysis results.
Comment 1.1
I agree, as the task is to define a knowledge store and not the potential prohjections that define the format in which the enriched data is saved
Comment 2
This is about skillset configuration - not knowledge store config.
"name": "my-skillset",
"skills": [ ... ],
"knowledgeStore": {
"storageConnectionString": "...",
"projections": [
{
"objects": [ ... ]
you must have a connectionstring (to the destination)
you must define the type of projection: in this case object (media posts and sen.analysis are text)
Comment 3
ChatGPT 5.2:
"The confusion here comes from mixing what is mandatory with what is optional.
A knowledge store always requires storageConnectionString. Without it, nothing can be persisted.
For sentiment analysis scenarios, Microsoft’s official labs and documentation project enriched content into tables (structured scores, labels, analytics).
storageContainer, objects, and files are only required for specific projection types and are optional, not mandatory, for defining a knowledge store.
Therefore, the exam-safe answer is B (storageConnectionString) and D (tables)."
Comment 4
The two correct fields are: B. storageConnectionString - Required to connect to Azure Storage account D. tables - Optimal projection type for storing social media posts and sentiment analysis results
These two fields work together to define a knowledge store that can persist the enriched social media data and sentiment analysis results in a structured, queryable format within Azure Table Storage.
Comment 5
B. storageConnectionString: When defining a knowledge store, you must provide a connection string for Azure Storage. This specifies where the data will be stored.
[https://docs.azure.cn/en-us/search/knowledge-store-concept-intro?tabs=portal](https://docs.azure.cn/en-us/search/knowledge-store-concept-intro?tabs=portal)
D. tables: When storing social media posts and Sentiment Analysis results, the "tables" projection is typically used. You can store each document and its analysis results (such as sentiment scores) in a table.
[https://microsoftlearning.github.io/AI-102-AIEngineer/Instructions/24-knowledge-store.html](https://microsoftlearning.github.io/AI-102-AIEngineer/Instructions/24-knowledge-store.html)
Comment 6
1/ To create the KB, you just need the storageConnectionString
See https://learn.microsoft.com/fr-fr/azure/search/knowledge-store-create-rest
2/ You have then to define the right projection. In this case, I'm not totaly sure, but I would say "objects".
extract of https://learn.microsoft.com/fr-fr/azure/search/knowledge-store-projections-examples :
"knowledgeStore" : {
"storageConnectionString": "DefaultEndpointsProtocol=https;AccountName=<Acct Name>;AccountKey=<Acct Key>;",
"projections": [
{
"tables": [ ],
"objects": [ ],
"files": [ ]
}
]
}
Comment 7
tables (for storing the sentiment analysis results)
objects (for storing the posts in JSON format)
In an Azure Cognitive Search knowledge store, enriched data from your pipeline can be projected into three types of storage:
Tables → for structured data (like sentiment analysis results).
Objects → for JSON documents (like the original social media posts).
Files → for images or documents, but not needed here.
Comment 8
Correct answers:
A. storageContainer
Specifies the Azure Blob Storage container where enriched output will be stored.
D. tables
Used to define structured outputs (like sentiment analysis results) in table format for downstream querying.
Why not the others?
B. storageConnectionString
This is part of the cognitive search skillset or pipeline configuration, not the knowledge store definition itself.
C. files
Used for raw file output like images or PDFs, not ideal for structured data like social posts and sentiment analysis.
E. objects
Used when outputting JSON objects, but not specifically required for the typical structure of a sentiment analysis pipeline
Comment 9
There is another question where the user case is to store social media posts in tables.
Comment 10
To define a knowledge store that includes both the social media posts and the Sentiment Analysis results, you should include the following two fields:
B. storageConnectionString D. tables
These fields will allow you to store the analyzed data in a structured format and connect to the storage service.
Comment 11
BE is the answer
Comment 12
To define a knowledge store that includes social media posts and Sentiment Analysis results, you should include the following fields:
-tables: This field is used to store structured data, such as the results of the Sentiment Analysis.
-objects: This field is used to store unstructured data, such as the social media posts themselves.
StorageConnectionString is not a knowledge store. It can't be B.
Comment 12.1
In an Azure Cognitive Search solution with an enrichment pipeline for Sentiment Analysis on social media posts, a knowledge store is used to persist transformed or enriched data. The two correct fields to include in the definition are:
D. tables
In a knowledge store, tables are structured storage formats that allow you to store transformed/enriched data, such as Sentiment Analysis results, in a structured manner (e.g., Azure Table Storage).
This is useful for querying and analyzing enriched data.
E. objects
The objects field is used to store unstructured or semi-structured enriched data in JSON format within an Azure Blob Storage container.
This is ideal for storing social media posts and their analysis results in a flexible format.
Comment 13
Selected Answer: BE
Comment 14
was on exam 20.06.2024.
Comment 15
I say this answer is B and E.
Comment 16
It is obvious that BE is the correct answer.
Comment 17
AB: We need storage to upload data and connection string. https://learn.microsoft.com/en-us/azure/search/knowledge-store-create-rest