There is not routes.txt file in the azure storage account for an exercise, from where we should consume the data. Please confirm this doubt.

Question

Link to the course

^
|
heres the link for the course.

This question is related to the following Learning Module

Answer 1

Hi Amit Kumar ,

Thank you for reaching out to Microsoft Q&A forum.

Based on the detailed exercise you provided earlier, there is no requirement for a routes.txt file in an Azure storage account as part of the exercise steps. 

The exercise focuses on deploying and configuring an Azure SQL Database, connecting to it via Azure Data Studio, setting up the database schema with T-SQL scripts, and leveraging JSON and geospatial capabilities of Azure SQL Database for bus-related data.

If exercise instructions do not include a routes.txt file in an Azure storage account, it is not necessary for this exercise. Occasionally, guides may describe hypothetical scenarios involving data files, but if not mentioned in your current exercise, you can proceed with the tasks as outlined.

1.Start by deploying an Azure SQL Database instance using PowerShell. Once deployed, ensure everything is set up correctly.

2.Use Azure Data Studio to connect to the newly deployed Azure SQL Database. Verify the connection to ensure seamless access.

3.Within Azure Data Studio, employ T-SQL scripts to establish the required database schema. Create tables and define schema elements as per the application's needs.

4.Leverage the capabilities of Azure SQL Database, such as JSON handling and geospatial functionalities, to effectively manage and analyze data related to bus operations.

 
Please don't hesitate to reach out to us if you have any further queries. I hope the information provided has been helpful to you! If so, please accept the answer by clicking the Accept Answer / Upvote on the post. We value your feedback, and it will help to assist others who might have a similar query. Thank you for your contribution in enhancing Microsoft Q&A!