U.S. Independence Day Deal! Unlock 25% OFF Today – Limited-Time Offer - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft AI-102 Exam - Topic 1 Question 4 Discussion

You have the following data sources:Finance: On-premises Microsoft SQL Server databaseSales: Azure Cosmos DB using the Core (SQL) APILogs: Azure Table storageHR: Azure SQL databaseYou need to ensure that you can search all the data by using the Azure Cognitive Search REST API. What should you do?
B) Mirror Finance to an Azure SQL database.
A) Configure multiple read replicas for the data in Sales.
C) Migrate the data in Sales to the MongoDB API.
D) Ingest the data in Logs into Azure Sentinel. On-premises Microsoft SQL Server database cannot be used as an index data source. Note: Indexer in Azure Cognitive Search: : Automate aspects of an indexing operation by configuring a data source and an indexer that you can schedule or run on demand. This feature is supported for a limited number of data source types on Azure. Indexers crawl data stores on Azure. Azure Blob Storage Azure Data Lake Storage Gen2 (in preview) Azure Table Storage Azure Cosmos DB Azure SQL Database SQL Managed Instance SQL Server on Azure Virtual Machines

Microsoft AI-102 Exam - Topic 1 Question 4 Discussion

Actual exam question for Microsoft's AI-102 exam
Question #: 4
Topic #: 1
[All AI-102 Questions]

You have the following data sources:

Finance: On-premises Microsoft SQL Server database

Sales: Azure Cosmos DB using the Core (SQL) API

Logs: Azure Table storage

HR: Azure SQL database

You need to ensure that you can search all the data by using the Azure Cognitive Search REST API. What should you do?

Show Suggested Answer Hide Answer
Suggested Answer: B

https://docs.microsoft.com/en-us/azure/search/search-indexer-overview#supported-data-sources

by Buddy at May 03, 2022, 11:10 AM

Limited Time Offer

25%

Off

Get Premium AI-102 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Cyndy
8 months ago
I disagree, migrating to MongoDB API sounds like overkill for this.
upvoted 0 times
...
Shoshana
8 months ago
B seems like a solid option too, but not sure if it's necessary.
upvoted 0 times
...
Verda
8 months ago
Wait, can you really not use on-prem SQL Server for indexing?
upvoted 0 times
...
Svetlana
8 months ago
I think D is the way to go! Logs in Azure Table Storage can be indexed.
upvoted 0 times
...
Elouise
8 months ago
Azure Cognitive Search works with Azure SQL Database and Cosmos DB.
upvoted 0 times
...
Adelina
9 months ago
I recall that Azure Cosmos DB is supported, but I wonder if migrating to the MongoDB API is necessary for this scenario.
upvoted 0 times
...
Rupert
9 months ago
I feel like we discussed how Azure Table Storage is supported, but I'm not clear on how that relates to the other data sources here.
upvoted 0 times
...
Kristofer
9 months ago
I think we practiced a question about Azure SQL databases being compatible with Azure Cognitive Search, so maybe option B is the right choice?
upvoted 0 times
...
Virgie
9 months ago
I remember that Azure Cognitive Search can index data from various sources, but I'm not sure if it can directly index from on-premises SQL Server.
upvoted 0 times
...
Lisandra
9 months ago
This looks like a straightforward multiple-choice question about the inputs for the Answer Question command in IBM RPA. I'll carefully read through the options and think about which ones make the most sense.
upvoted 0 times
...
Gilberto
9 months ago
Wait, what's the difference between cryptocurrencies and fiat currencies again? I'm a bit confused on this one.
upvoted 0 times
...
Ilda
9 months ago
This looks like a straightforward SQL question. I'm pretty confident I know the answer - it's ALTER TABLE to remove a foreign key.
upvoted 0 times
...

Save Cancel