Strengths

  • Provides governance, schema enforcement, and performance optimizations for analytics.
  • Supports ACID transactions, concurrency control, and SQL-based BI queries.
  • Purpose-built for BI and reporting

Downsides

  • No support for semi or unstructured data