AI-102 Question 308
Select 3You are tasked with building an Azure AI solution that processes customer feedback from various sources. The feedback data is stored in different formats, including CSV files in Azure Blob Storage, JSON files in an Azure Data Lake, and relational data in an Azure SQL Database. Which sources can be directly imported for analysis using Azure Machine Learning’s data import capabilities?
- A
CSV files in Azure Blob Storage
- B
JSON files in an Azure Data Lake
- C
Relational data in an Azure SQL Database
- D
Data from an on-premises PostgreSQL database
Show answer and explanation
Correct answers: A, B, C
Explanation
Azure Machine Learning supports direct import of data from cloud-based sources like Azure Blob Storage, Azure Data Lake, and Azure SQL Database. These sources integrate seamlessly with Azure Machine Learning, offering flexibility for data preprocessing and analysis. However, on-premises databases, such as PostgreSQL, require additional steps like setting up a data gateway or exporting data to a supported cloud service before importing it into Azure Machine Learning.
- A. Correct.
Azure Machine Learning supports direct import of CSV files stored in Azure Blob Storage, making it a valid option.
- B. Correct.
JSON files stored in Azure Data Lake are supported by Azure Machine Learning for direct import, making this a valid option.
- C. Correct.
Relational data in Azure SQL Database is supported for direct import by Azure Machine Learning using its built-in connectors.
- D. Incorrect.
Data from on-premises PostgreSQL databases is not directly supported for import by Azure Machine Learning unless you use a custom pipeline or data migration tool.