Skip to Content

AI-900: Automate Customer Service FAQs with Azure QnA Maker from Excel

Efficiently create a knowledge base for customer service by leveraging Azure QnA Maker, extracting FAQs from Excel documents for streamlined automated responses.

Table of Contents


The customer service of your company spends a lot of time answering the same questions. They asked you to help them to automate this process. They provided you with a Microsoft Excel (*.xlsx) document with frequently asked questions and typical answers. What service will you use to create a knowledge base from this document?

A. Azure Bot Service
B. Custom vision
C. Text Analytics
D. QnA Maker


QnA Maker


To create a knowledge base from the provided Excel document with FAQs and answers, you can use Azure QnA Maker. This service helps automate the process by extracting information from such documents and building a conversational knowledge base that powers chatbots and other AI-based customer service tools.

You need to use the QnA Maker service. First, you need to provision the QnA Maker resource in your Azure subscription. After that, you can populate the newly created knowledge base using a frequently asked questions (FAQ) document.

Azure Bot Service facilitates access to the knowledge base, but this service doesn’t create a knowledge base.

Custom vision service helps create your computer vision model, but this service doesn’t create a knowledge base.

Text Analytics helps analyze text documents, detect documents’ language, extract key phrases, determine entities, and provide sentiment analysis. This service doesn’t create a knowledge base.

Language Understanding Intelligent Service (LUIS) helps understand voice or text commands. This service doesn’t create a knowledge base.

Microsoft Azure AI Fundamentals AI-900 certification exam practice question and answer (Q&A) dump with detail explanation and reference available free, helpful to pass the Microsoft Azure AI Fundamentals AI-900 exam and earn Microsoft Azure AI Fundamentals AI-900 certification.

Microsoft Azure AI Fundamentals AI-900 certification exam practice question and answer (Q&A) dump

Alex Lim is a certified IT Technical Support Architect with over 15 years of experience in designing, implementing, and troubleshooting complex IT systems and networks. He has worked for leading IT companies, such as Microsoft, IBM, and Cisco, providing technical support and solutions to clients across various industries and sectors. Alex has a bachelor’s degree in computer science from the National University of Singapore and a master’s degree in information security from the Massachusetts Institute of Technology. He is also the author of several best-selling books on IT technical support, such as The IT Technical Support Handbook and Troubleshooting IT Systems and Networks. Alex lives in Bandar, Johore, Malaysia with his wife and two chilrdren. You can reach him at [email protected] or follow him on Website | Twitter | Facebook

    Ads Blocker Image Powered by Code Help Pro

    Your Support Matters...

    We run an independent site that is committed to delivering valuable content, but it comes with its challenges. Many of our readers use ad blockers, causing our advertising revenue to decline. Unlike some websites, we have not implemented paywalls to restrict access. Your support can make a significant difference. If you find this website useful and choose to support us, it would greatly secure our future. We appreciate your help. If you are currently using an ad blocker, please consider disabling it for our site. Thank you for your understanding and support.