Designing and Implementing an Azure AI Solution (legacy) — Question 7

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have an Azure SQL database, an Azure Data Lake Storage Gen 2 account, and an API developed by using Azure Machine Learning Studio.
You need to ingest data once daily from the database, score each row by using the API, and write the data to the storage account.
Solution: You create a scheduled Jupyter Notebook in Azure Databricks.
Does this meet the goal?

Answer options

Correct answer: B

Explanation

The proposed solution does not fully meet the goal because Azure Databricks is primarily designed for big data processing and analytics rather than direct integration with Azure Data Lake Storage Gen 2 for daily scheduled tasks. A more suitable approach would involve using Azure Data Factory or Azure Logic Apps, which are specifically built for orchestrating data workflows between services, including scheduled ingestion and processing.