Free Databricks Databricks-Certified-Data-Analyst-Associate Exam Dumps Questions & Answers

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

• A.  Alter the Query to return two separate sets of results.
• B.  Copy the Query and create one data visualization per query.
• C.  Add two separate visualizations to the dashboard based on the same Query.
• D.  Decide on a single data visualization to add to the dashboard.

Which of the following commands will return the location of database customer360?

• A.  ALTER DATABASE customer360 SET DBPROPERTIES ( ' location ' = ' /user ' );
• B.  USE DATABASE customer360;
• C.  DESCRIBE DATABASE customer360;
• D.  DESCRIBE LOCATION customer360;
• E.  DROP DATABASE customer360;

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 by uploading the file to cloud storage and then importing the data to Databricks.
• C.  Create a table by manually copying and pasting the data values into cloud storage and then importing the data to Databricks.
• D.  Create a table via a connection between Databricks and the desktop facilitated by Partner Connect.

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.  There is no way to share data between PySpark and SQL.
• B.  SELECT * FROM sales
• C.  spark.table
• D.  spark.sql
• E.  spark.delta.table

A data analyst is working on a DataFrame named dates_df and needs to add a new column, date, derived from the timestamp field.
Which code fragment should be used to extract the date from a timestamp?

• A.  dates_df.withColumn( " date " , f.to_date( " timestamp " )).show()
• B.  dates_df.withColumn( " date " , f.unix_timestamp( " timestamp " )).show()
• C.  dates_df.withColumn( " date " , f.from_unixtime( " timestamp " )).show()
• D.  dates_df.withColumn( " date " , f.date_format( " timestamp " , " yyyy-MM-dd " )).show()