Microsoft Certified: Azure Fundamentals (AZ-900) Practice Exam

Which Azure service would be most suitable for analyzing structured data?

1. Azure SQL Database

2. Cosmos DB

3. Azure Data Factory

4. Azure Storage

The correct answer is: Azure SQL Database

The most suitable Azure service for analyzing structured data is Azure SQL Database. This service is specifically designed to handle relational databases, which store structured data in tables with defined schemas. SQL Database provides powerful querying capabilities using the SQL language, which makes it ideal for performing analytical operations on structured data. The service is fully managed, allowing users to leverage built-in features such as high availability, automated backups, and security without the need for extensive configuration or management. Its compatibility with existing SQL databases and tools further enhances its usability in structured data analysis scenarios. In comparison, while Cosmos DB is a flexible NoSQL database that accommodates various data models, it is not solely focused on structured data analysis. Azure Data Factory is primarily an integration service for data movement and transformation, and Azure Storage is designed for general data storage, lacking specific analytical capabilities for structured data.