Which of the following is true, when building a Databricks SQL dashboard?

• A.A dashboard can only use results from one query
• B.Only one visualization can be developed with one query result
• C.A dashboard can only connect to one schema/Database
• D.More than one visualization can be developed using a single query result
• E.A dashboard can only have one refresh schedule

Correct Answer: D

Explanation
the answer is, More than one visualization can be developed using a single query result.
In the query editor pane + Add visualization tab can be used for many visualizations for a single query result.
Graphical user interface, text, application Description automatically generated

Comment: *

Name: *

Email: *

Verification: *

A data architect has determined that a table of the following format is necessary:
Which of the following code blocks uses SQL DDL commands to create an empty Delta table in the above
format regardless of whether a table already exists with this name?

• A.1. CREATE TABLE table_name AS
  2. SELECT id STRING, birthDate DATE, avgRating FLOAT
• B.1. CREATE OR REPLACE TABLE table_name ( id STRING, birthDate DATE, avgRating FLOAT )
• C.1. CREATE OR REPLACE TABLE table_name AS
  2. SELECT id STRING, birthDate DATE, avgRating FLOAT USING DELTA
• D.1. CREATE TABLE IF NOT EXISTS table_name ( id STRING, birthDate DATE, avgRating FLOAT )
• E.1. CREATE OR REPLACE TABLE table_name
  2. WITH COLUMNS ( id STRING, birthDate DATE, avgRating FLOAT ) USING DELTA

Comment: *

Name: *

Email: *

Verification: *

Which of the following benefits does Delta Live Tables provide for ELT pipelines over standard data pipelines
that utilize Spark and Delta Lake on Databricks?

• A.The ability to access previous versions of data tables
• B.The ability to perform batch and streaming queries
• C.The ability to write pipelines in Python and/or SQL
• D.The ability to automatically scale compute resources
• E.The ability to declare and maintain data table dependencies

Comment: *

Name: *

Email: *

Verification: *

When defining external tables using formats CSV, JSON, TEXT, BINARY any query on the exter-nal tables caches the data and location for performance reasons, so within a given spark session any new files that may have arrived will not be available after the initial query. How can we address this limitation?

• A.UNCACHE TABLE table_name
• B.CACHE TABLE table_name
• C.REFRESH TABLE table_name
• D.BROADCAST TABLE table_name
• E.CLEAR CACH table_name

Comment: *

Name: *

Email: *

Verification: *

If you create a database sample_db with the statement CREATE DATABASE sample_db what will be the default location of the database in DBFS?

• A.Default location, DBFS:/user/
• B.Default location, /user/db/
• C.Default Storage account
• D.Statement fails "Unable to create database without location"
• E.Default Location, dbfs:/user/hive/warehouse

Correct Answer: E

Explanation
The Answer is dbfs:/user/hive/warehouse this is the default location where spark stores user data-bases, the default can be changed using spark.sql.warehouse.dir a parameter. You can also provide a custom location using the LOCATION keyword.
Here is how this works,
Graphical user interface, text, application, email Description automatically generated

Default location

FYI, This can be changed used using cluster spark config or session config.
Modify spark.sql.warehouse.dir location to change the default location
Graphical user interface, text, application Description automatically generated

Comment: *

Name: *

Email: *

Verification: *