Which of the following approaches can be used to connect Databricks to Fivetran for data ingestion?

• A. Use Partner Connect ' s automated workflow to establish a SQL warehouse (formerly known as a SQL endpoint) for Fivetran to interact with
• B. Use Partner Connect ' s automated workflow to establish a cluster for Fivetran to interact with
• C. Use Workflows to establish a SQL warehouse (formerly known as a SQL endpoint) for Fivetran to interact with
• D. Use Workflows to establish a cluster for Fivetran to interact with
• E. Use Delta Live Tables to establish a cluster for Fivetran to interact with

An analyst writes a query that contains a query parameter. They then add an area chart visualization to the query. While adding the area chart visualization to a dashboard, the analyst chooses " Dashboard Parameter " for the query parameter associated with the area chart.
Which of the following statements is true?

• A. The area chart will use whatever is selected in the Dashboard Parameter while all or the other visualizations will remain changed regardless of their parameter use.
• B. The area chart will use whatever value is chosen on the dashboard at the time the area chart is added to the dashboard.
• C. The area chart will use whatever is selected in the Dashboard Parameter along with all of the other visualizations in the dashboard that use the same parameter.
• D. The area chart will convert to a Dashboard Parameter.
• E. The area chart will use whatever value is input by the analyst when the visualization is added to the dashboard. The parameter cannot be changed by the user afterwards.

Data professionals with varying titles use the Databricks SQL service as the primary touchpoint with the Databricks Lakehouse Platform. However, some users will use other services like Databricks Machine Learning or Databricks Data Science and Engineering.
Which of the following roles uses Databricks SQL as a secondary service while primarily using one of the other services?

• A. Data engineer
• B. Business analyst
• C. SQL analyst
• D. Data analyst
• E. Business intelligence analyst

A data analyst is working with a nested array column products in table transactions. The analyst wants to return the first item in the array for each row.
The data analyst is using the following incomplete command:
SELECT
transaction_id,
_____ AS first_product
FROM transactions;
Which line of code should the data analyst use to fill in the blank so that it successfully completes the task?

• A. products.0
• B. products[1]
• C. products[0]
• D. products.1

A data analyst has developed a query that runs against a Delta table. They want help from the data engineering team to implement a series of tests to ensure the data returned by the query is clean. However, the data engineering team uses Python for its tests rather than SQL.
Which of the following operations could the data engineering team use to run the query and operate with the results in PySpark?

• A. spark.delta.table
• B. There is no way to share data between PySpark and SQL.
• C. SELECT * FROM sales
• D. spark.table
• E. spark.sql