Practice Free Databricks Certified Data Analyst Associate Exam Online Questions
Which statement about subqueries is correct?
- A . Subqueries are not available in Databricks SQL
- B . Subqueries can be used like other user-defined functions to transform data into different data types.
- C . Subqueries can retrieve data without requiring the creation of a table or view.
- D . Subqueries can be used like other built-in functions to transform data into different data types.
A data analyst is using Databricks Unity Catalog. The datasets are tagged by sensitivity, and confidential data is marked with the tag key confidential. The data analyst needs to quickly find all tables tagged as confidential to review their access permissions in the Databricks workspace search bar.
Which search key text should the data analyst use to find these tables?
- A . confidential: true
- B . tag=confidential
- C . tag: confidential
- D . search tag = ‘confidential’
Where can an admin or data owner grant database, table, and view permissions to a group?
- A . Dashboard
- B . Data
- C . SQL Warehouses
- D . Settings
A stakeholder has provided a data analyst with a lookup dataset in the form of a 50-row CSV file. The data analyst needs to upload this dataset for use as a table in Databricks SQL.
Which approach should the data analyst use to quickly upload the file into a table for use in Databricks SOL?
- A . Create a table by uploading the file using the Create page within Databricks SQL
- B . Create a table via a connection between Databricks and the desktop facilitated by Partner Connect.
- C . Create a table by uploading the file to cloud storage and then importing the data to Databricks.
- D . Create a table by manually copying and pasting the data values into cloud storage and then importing the data to Databricks.
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 has opened the SQL Editor page and written a new SQL statement. The data analyst now wants to save that statement to easily refer back to it later and add it to a dashboard. The results of the SQL statement must be able to be displayed as a counter, table, or data visualization.
Which approach should the data analyst use to accomplish this task?
- A . Save the SQL statement as a Dashboard
- B . Save the SQL statement within a Notebook
- C . Save the SQL statement as a Query
- D . Save the SQL statement in the Query History page
A data analyst has come across a column in a table that contains personally identifiable information (PII). The data analyst should not have access to this type of PII data.
How should the data analyst proceed?
- A . Stop working with the data and delete the table and any existing metadata or data files.
- B . Stop working with the data and proceed with the project using other data.
- C . Stop working with the data and notify their supervisor to ensure the data is handled following organizational and legal best practices.
- D . Drop the column containing PII data and continue with the project without notifying anybody.
Which statement about visualizations is true?
- A . All visualizations must use the same data in order to be included in the same Databricks SQL dashboard.
- B . Line charts are the preferred visualization type for categorical data.
- C . Different visualizations can be used to tell different stories about the data.
- D . There is no difference between the bar chart and a histogram in Databricks SQL.
A data engineer wants to schedule their Databricks SQL dashboard to refresh once per day, but they only want the associated SQL endpoint to be running when it is necessary.
Which of the following approaches can the data engineer use to minimize the total running time of the SQL endpoint used in the refresh schedule of their dashboard?
- A . They can ensure the dashboard’s SQL endpoint matches each of the queries’ SQL endpoints.
- B . They can set up the dashboard’s SQL endpoint to be serverless.
- C . They can turn on the Auto Stop feature for the SQL endpoint.
- D . They can reduce the cluster size of the SQL endpoint.
- E . They can ensure the dashboard’s SQL endpoint is not one of the included query’s SQL endpoint.
Which of the following Structured Streaming queries is performing a hop from a Silver table to a Gold table?
A (
spark.readStream.load(rawSalesLocation)
.writeStream
.option("checkpointLocation", checkpointPath)
.outputMode("append")
.table("newSales")
)
B (
spark.table("sales")
.withColumn("avgPrice", col("sales") / col("units"))
.writeStream
.option("checkpointLocation", checkpointPath)
.outputMode("append")
.table("newSales")
)
C (
spark.table("sales")
.withColumn("avgPrice", col("sales") / col("units"))
.writeStream
.option("checkpointLocation", checkpointPath)
.outputMode("append")
.table("newSales")
)
D (
spark.table("sales")
.filter(col("units") > 0)
.writeStream
.option("checkpointLocation", checkpointPath)
.outputMode("append")
.table("newSales")
)
E (
spark.table("sales")
.groupBy("store")
.agg(sum("sales"))
.writeStream
.option("checkpointLocation", checkpointPath)
.outputMode("complete")
.table("newSales")
)
- A . Option A
- B . Option B
- C . Option C
- D . Option D
- E . Option E