DBSQL + Serverless Flashcards

1
Q

What is Databricks SQL?

A

Databricks SQL (DB SQL) is a serverless data warehouse on the Databricks Lakehouse Platform that lets you run all your SQL and BI applications at scale with up to 12x better price/performance, a unified governance model, open formats and APIs, and your tools of choice - no lock-in.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What is Serverless?

A

Endpoints that provide instant compute for SQL Queries within Databricks environment instead of Cloud environment.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What problem does DBSQL Solve?

A

Opens up the lakehouse to millions of technologists who know SQL but not Python or Scala, work in SQL vs Notebooks

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What problem does Serverless SQL solve?

A

Improves customer experience using DBSQL, reduces start up time from minutes to seconds which lowers cost and avoids long idle times for SQL endpoints

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Why do customers care about this?

A

1/Price Performance vs Data Warehouse
2/Breaks down Silos of data lake/Data warehouse by being able to access all the data in lakehouse via SQL
3/Built in Governance

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What to look for in positioning with customers?

A

1/If there is pain with current data warehouse solution
2/If there is pain collaborating across data warehouse and data lake solutions
3/If there is an objection to Databricks due to skillset

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Personas for DBSQL?

A

1/ Architects and DBAs monitoring data warehouses/platforms

2/Analysts/analytics engineers who use SQL to query and transform data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

How does it work?

A

1/Pick Existing SQL Endpoint, Use SQL for alerts and interactive dashboards
2/Integrates with Tableau,FiveTran

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Underlying factors

A

SQL Serverless runs on a compute platform that keeps a pool of servers running and ready providing secure and isolated for customers

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Misconceptions

A

Databricks is rumored to be complex, but DBSQL provides a simple way to build SQL and data warehousing on top of Lakehouse

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Lookouts of DBSQL

A

1/Qualify use cases that require low latency and high concurrency
2/Serverless significantly changes the architecture of data plane
3/Serverless is for instant compute on all clouds. AWS is ~15 seconds

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Competitors of DBSQL

A

1/Snowflake - Focus on price, performance, collaboration

2/Cloud DW (Redshift,BigQuery, Synapse - Multi Cloud vs single,

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

How much does DBSQL Cost?

A

1/AWS SQL is $.022 DBU List price
2/Serverless is $0.70DBU LIst Price
3/Serverless includes compute cost that would be incurred by cloud provider

How well did you know this?
1
Not at all
2
3
4
5
Perfectly