SQL Server Big Data Cluster vs Analytics Platform System

Question

Whats the difference between SQL Server Big Data Cluster vs Analytics Platform System. I have 20TB of data, May I know which one will be suitable for Data Warehouse?

Answer 1

Hi SubhashiniKarurGunasekaran-2905,
Analytics Platform System is designed for simplicity which makes it easy to learn and to manage. PDW's PolyBase technology for analyzing Hadoop data, and its deep integration with Business Intelligence tools make it a comprehensive platform for building end-to-end solutions.

A SQL Server big data cluster is deployed as docker containers on a Kubernetes cluster.
Use SQL Server Big Data Clusters to:

• Deploy scalable clusters of SQL Server, Spark, and HDFS containers running on Kubernetes.
• Read, write, and process big data from Transact-SQL or Spark.
• Easily combine and analyze high-value relational data with high-volume big data.
• Query external data sources.
• Store big data in HDFS managed by SQL Server.
• Query data from multiple external data sources through the cluster.
• Use the data for AI, machine learning, and other analysis tasks.
• Deploy and run applications in Big Data Clusters.
• Virtualize data with PolyBase. Query data from external SQL Server, Oracle, Teradata, MongoDB, and ODBC data sources with external tables.
• Provide high availability for the SQL Server master instance and all databases by using Always On availability group technology.

Please refer to Overview of APS and What are SQL Server Big Data Clusters which might help.
Best Regards,
Amelia