Data engineers and data analysts are working together on a data pipeline. The data engineer is working on the raw, bronze, and silver layers of the pipeline using Python, and the data analyst is working on the gold layer of the pipeline using SQL. The raw source of the pipeline is a streaming input. They now want to migrate their pipeline to use Delta Live Tables.
Which of the following changes will need to be made to the pipeline when migrating to Delta Live Tables?

• A. The pipeline will need to be written entirely in Python.
• B. The pipeline can have different notebook sources in SQL and Python.
• C. The pipeline will need to use a batch source in place of a streaming source.
• D. The pipeline will need to be written entirely in SQL.

A data scientist has asked a data analyst to create histograms for every continuous variable in a data set. The data analyst needs to identify which columns are continuous in the data set.
What describes a continuous variable?

• A. A quantitative variable Chat can take on a finite or countably infinite set of values
• B. A quantitative variable that never stops changing
• C. A categorical variable in which the number of categories continues to increase over time
• D. A quantitative variable that can take on an uncountable set of values

A data analyst wants to create a dashboard with three main sections: Development, Testing, and Production.
They want all three sections on the same dashboard, but they want to clearly designate the sections using text on the dashboard.
Which of the following tools can the data analyst use to designate the Development, Testing, and Production sections using text?

• A. Separate color palettes for each section
• B. Separate endpoints for each section
• C. Direct text written into the dashboard in editing mode
• D. Separate queries for each section
• E. Markdown-based text boxes

Which of the following is a benefit of Databricks SQL using ANSI SQL as its standard SQL dialect?

• A. It is more compatible with Spark ' s interpreters
• B. It is easy to migrate existing SQL queries to Databricks SQL
• C. It is more performant than other SQL dialects
• D. It allows for the use of Photon ' s computation optimizations
• E. It has increased customization capabilities

A data analyst has a managed table table_name in database database_name. They would now like to remove the table from the database and all of the data files associated with the table. The rest of the tables in the database must continue to exist.
Which of the following commands can the analyst use to complete the task without producing an error?

• A. DROP TABLE database_name.table_name;
• B. DELETE TABLE database_name.table_name;
• C. DELETE TABLE table_name FROM database_name;
• D. DROP TABLE table_name FROM database_name;
• E. DROP DATABASE database_name;