Microsoft Azure Fundamentals (AZ-900)Describe Azure architecture and servicesHard
A company needs to analyze large datasets from various sources, including relational databases and unstructured files, to gain business insights. They require a unified analytics platform that can handle petabytes of data, support data warehousing, and enable big data analytics and machine learning workloads. Which Azure service provides these comprehensive capabilities?
- AAzure Cosmos DB
- BAzure Data Lake Storage
- CAzure Synapse Analytics
- DAzure SQL Database
Show answer & explanationAnswer & explanation
Correct answer: C. Azure Synapse Analytics
Azure Synapse Analytics is a unified analytics platform that brings together enterprise data warehousing and Big Data analytics. It provides a single service for data integration, enterprise data warehousing, big data processing, and machine learning, making it ideal for the described comprehensive analytics needs.
Why the other options are wrong
- A. Azure Cosmos DB is a globally distributed NoSQL database, primarily for transactional applications, not large-scale analytical processing across diverse data types.
- B. Azure Data Lake Storage is a highly scalable storage solution for big data, but it does not provide the processing and analytics capabilities.
- D. Azure SQL Database is a relational database for transactional workloads, not a comprehensive analytics platform for petabytes of diverse data.
Azure Synapse Analytics
A unified analytics platform that brings together enterprise data warehousing and Big Data analytics. It provides a single service for data integration, enterprise data warehousing, big data processing, and machine learning.
- Combines data warehousing, big data, and ETL capabilities.
- Supports SQL, Spark, and Data Explorer engines.
- Handles petabytes of data.
- Integrates with other Azure services for end-to-end analytics.
Memory trick: Synapse connects all your big data insights.