Datatalks 3 - Hasselt

What are the names of our interns?

• Dorio, Librecht & Steve

• Dario, Librecht & Steven

• Darius, Brecht & Stef

• Dora, Bernd & Stefan

What is an MPP compute cluster?

• A cluster of nodes with their own compute and memory

• A cluster of nodes with shared compute and memory

• A cluster of Most Popular People

• A network switch used to provide high-speed connectivity

What is the advantage of Snowflakes' Zero-Copy Cloning?

• Personal sandbox per dev

• An exact replica of a snowflake, making it possible for mass-production purposes

• Automatic detection of duplicate data

• Automatic backups

Can you calculate costs upfront in Bigquery?

• No, you need a testing period.

• Yes, but only with the query validator.

• Yes, with the query validator and google cloud pricing calculator.

• No, Google doesn't want you to know the costs at all.

What happens when you keep adding more resources, such as compute or memory, to a workload, but the cost to performance ratio keeps increasing?

• Moore's Law

• Productivity loss

• Capital gains

• Diminishing returns

Which type of compute doesn't synapse offer?

• Apache Spark

• Serverless SQL

• Dedicated SQL

• NoSQL

Which platform is the best?

• Synapse

• Use case and workload dependant

• BigQuery

• Snowflake

According to our TPC-DS benchmark, which platform has the best cost to performance ratio?

• Snowflake

• Bigquery

• Synapse

Which cloud platforms are supported by Snowflake?

• Amazon Web Services

• Google Cloud Platform

• Microsoft Azure

• Alibaba Cloud

What is the biggest struggle in using Azure Synapse Analytics

• Performance

• Capabilities

• The flexibility and managing the costs of all those components

• Colour scheme