Azure Storage

Which Azure service provides object storage with a hierarchical namespace optimized for big data and analytics workloads?

Azure Data Lake Storage Gen2 (ADLS Gen2) combines Blob Storage’s scalable object storage with a hierarchical namespace, enabling POSIX-like directory structures and fine-grained access control lists (ACLs). This architecture is specifically optimized for big data and analytics workloads, such as those running Apache Spark, Hive, or Azure Databricks.

A company wants to migrate an on-premises SQL Server database to Azure. They require full administrative control over the database engine, including the ability to configure SQL Server Agent jobs and use cross-database queries. They also want to avoid patching the operating system.

Which Azure service should they choose?

Azure SQL Managed Instance provides near 100% compatibility with on-premises SQL Server, including full administrative control over the database engine. They also provide support for SQL Server Agent jobs, and cross-database queries (Azure SQL Database (PaaS) doesn’t).

A company needs to store and analyze large amounts of unstructured log data at low cost. Which Azure storage solution is MOST appropriate?

Azure Blob Storage at cool/cold tier

A company plans to migrate its on-premises SQL Server database to Azure. The database uses many features including SQL Server Agent jobs, cross-database queries, and CLR integration. The company wants a fully managed PaaS service that minimizes application code changes and supports native VNet integration without requiring a private endpoint. Which Azure service should the company use?

Azure SQL Managed Instance