Microsoft Azure Fundamentals (AZ-900)Describe Azure architecture and servicesHard
A cybersecurity firm needs to analyze massive volumes of security logs and telemetry data generated from various sources, including Azure resources, on-premises systems, and other cloud providers. They require a service that can ingest, store, and perform complex queries and analytics on this data in real-time, enabling rapid threat detection and response. Which Azure service is best suited for this task?
- AAzure Data Lake Storage
- BAzure SQL Database
- CAzure Event Hubs
- DAzure Synapse Analytics
Show answer & explanationAnswer & explanation
Correct answer: D. Azure Synapse Analytics
Azure Synapse Analytics is an enterprise analytics service that accelerates time to insight across data warehouses and big data systems. It integrates big data and data warehousing capabilities, allowing for ingestion, preparation, management, and serving data for immediate BI and machine learning needs, making it perfect for complex, real-time analytics on massive security logs.
Why the other options are wrong
- A. Azure Data Lake Storage is a highly scalable data lake, primarily for storage, but it doesn't inherently provide the real-time complex query and analytics engine required.
- B. Azure SQL Database is a relational database, not designed for ingesting and performing complex, real-time analytics on 'massive volumes of security logs and telemetry data'.
- C. Azure Event Hubs is a highly scalable data streaming platform for ingesting millions of events per second, but it's an ingestion service, not an analytics engine for complex queries.
Azure Synapse Analytics
An enterprise analytics service that unifies data warehousing and big data analytics. It provides a single service for ingesting, preparing, managing, and serving data for immediate BI and machine learning needs.
- Unifies data warehousing and big data
- Ingest, prepare, manage, and serve data
- Supports T-SQL, Spark, KQL
- Optimized for large-scale analytics
Memory trick: Synapse is the brain that connects all your data, making sense of the massive scale.