Which of the following approaches can be used to ingest data directly from cloud-based object storage?

A. Create an external table while specifying the DBFS storage path to FROM

B. Create an external table while specifying the DBFS storage path to PATH

C. It is not possible to directly ingest data from cloud-based object storage

D. Create an external table while specifying the object storage path to FROM

E. Create an external table while specifying the object storage path to LOCATION

A data analyst needs to use the Databricks Lakehouse Platform to quickly create SQL queries and data visualizations. It is a requirement that the compute resources in the platform can be made serverless, and it is expected that data visualizations can be placed within a dashboard.

Which of the following Databricks Lakehouse Platform services/capabilities meets all of these requirements?

A. Delta Lake

B. Databricks Notebooks

C. Tableau

D. Databricks Machine Learning

E. Databricks SQL

Which of the following is an advantage of using a Delta Lake-based data lakehouse over common data lake solutions?

A. ACID transactions

B. Flexible schemas

C. Data deletion

D. Scalable storage

E. Open-source formats

Which of the following benefits of using Databricks SQL is provided by Data Explorer?

A. It can be used to run UPDATE queries to update any tables in a database.

B. It can be used to view metadata and data, as well as view/change permissions.

C. It can be used to produce dashboards that allow data exploration.

D. It can be used to make visualizations that can be shared with stakeholders.

E. It can be used to connect to third party BI cools.

Which of the following queries can be used to deduplicate the data from table_bronze and write it to a new table table_silver?

A. CREATE TABLE table_silver AS SELECT DISTINCT * FROM table_bronze;

B. CREATE TABLE table_silver AS INSERT * FROM table_bronze;

C. CREATE TABLE table_silver AS MERGE DEDUPLICATE * FROM table_bronze;

D. INSERT INTO TABLE table_silver SELECT * FROM table_bronze;

E. INSERT OVERWRITE TABLE table_silver SELECT * FROM table_bronze;

A business analyst has been asked to create a data entity/object called sales_by_employee. It should always stay up-to-date when new data are added to the sales table. The new entity should have the columns sales_person, which will be the name of the employee from the employees table, and sales, which will be all sales for that particular sales person. Both the sales table and the employees table have an employee_id column that is used to identify the sales person.

Which of the following code blocks will accomplish this task?

A. Option A

B. Option B

C. Option C

D. Option D

E. Option E

A data analyst has created a Query in Databricks SQL, and now they want to create two data visualizations from that Query and add both of those data visualizations to the same Databricks SQL Dashboard. Which of the following steps will they need to take when creating and adding both data visualizations to the Databricks SQL Dashboard?

A. They will need to alter the Query to return two separate sets of results.

B. They will need to add two separate visualizations to the dashboard based on the same Query.

C. They will need to create two separate dashboards.

D. They will need to decide on a single data visualization to add to the dashboard.

E. They will need to copy the Query and create one data visualization per query.

A data analyst has been asked to configure an alert for a query that returns the income in the accounts_receivable table for a date range. The date range is configurable using a Date query parameter.

The Alert does not work.

Which of the following describes why the Alert does not work?

A. Alerts don't work with queries that access tables.

B. Queries that return results based on dates cannot be used with Alerts.

C. The wrong query parameter is being used. Alerts only work with Date and Time query parameters.

D. Queries that use query parameters cannot be used with Alerts.

E. The wrong query parameter is being used. Alerts only work with dropdown list query parameters, not dates.

Which of the following statements about adding visual appeal to visualizations in the Visualization Editor is incorrect?

A. Visualization scale can be changed.

B. Data Labels can be formatted.

C. Colors can be changed.

D. Borders can be added.

E. Tooltips can be formatted.

In which of the following situations will the mean value and median value of variable be meaningfully different?

A. When the variable contains no outliers

B. When the variable contains no missing values

C. When the variable is of the boolean type

D. When the variable is of the categorical type

E. When the variable contains a lot of extreme outliers