Azure Data Explorer Flashcards
What is Azure Data Explorer?
- Fully managed data analytics service.
- For real-time analysis of large volumes of data.
- Suited for time series data
What are the three primary use cases for Azure Data Explorer?
- Log and telemetry data analysis
- Real-time data exploration
- Big data analytics.
What are four of the data sources Azure Data Explorer ingest from?
- Event Hub,
- Blob Storage,
- IoT Hub
- databases.
Explain how Azure Data Explorer stores its data.
- In a distributed columnar storage format
- optimized for high-performance querying
- Data at rest and memory is compression.
What is the query language used in Azure Data Explorer and what is it used for?
KQL is used to query data in Azure Data Explorer for real-time analysis.
Explain data retention in Azure Data Explorer?
Data can be retained for specific durations based on retention policies, allowing for time-bound data storage.
Explain how Azure Data Explorer scales?
It can scale horizontally by adding nodes and scale vertically by upgrading storage and compute resources.
Explain Azure Data Explorer security?
- Azure Active Directory (AAD) authentication
- RBAC for role-based access control (RBAC)
- Encryption at rest
- Encryption for data in transit
List Azure Data Explorer integrate with other Azure services?
It integrates with services such as Power BI, Azure Synapse, Azure Machine Learning, and Logic Apps.
What is the purpose of the Hot and Cold storage in Azure Data Explorer?
Hot storage is for fast query performance, while cold storage is for long-term retention of data at a lower cost.
How is disaster recovery implemented in Azure Data Explorer?
Azure Data Explorer supports geo-redundancy and automated backups to ensure disaster recovery.
How is governance implemented in Azure Data Explorer?
It includes features like access control, auditing, and data classification for governance.
How can data be ingested from IoT Hub into Azure Data Explorer?
IoT Hub data is ingested using a built-in connector that sends telemetry data directly into Azure Data Explorer.
What is the function of a cluster in Azure Data Explorer?
A cluster is a set of virtual machines that process and store data for querying in Azure Data Explorer.
What are the primary functions provided by Azure Data Explorer?
Real-time analytics, data exploration, monitoring, and alerting on large data volumes.
What types of data can be analyzed using Azure Data Explorer?
Azure Data Explorer can analyze structured, semi-structured, and unstructured data.
What is the role of data sharding in Azure Data Explorer?
Data sharding distributes data across multiple nodes for faster query processing and scalability.
How does Azure Data Explorer handle high availability?
High availability is achieved through cluster redundancy and automatic failover.
What is the purpose of Kusto Triggers in Azure Data Explorer?
Kusto Triggers are used to automate actions based on query results, such as sending alerts.
How does Azure Data Explorer optimize query performance?
It uses a columnar storage format, indexing, and data partitioning to optimize query performance.