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

A Data Analyst is working on employees_df and needs to add a new column where a 10% tax is calculated on the salary. Additionally, the DataFrame contains the column age, which is not needed.
Which code fragment adds the tax column and removes the age column?

• A.  employees_df = employees_df.withColumn( " tax " , employees_df.salary * 10).dropField( " age " )
• B.  employees_df = employees_df.withColumn( " tax " , employees_df.salary * 10).drop( " age " )
• C.  employees_df = employees_df.withColumn( " tax " , lit(0.1) * col( " salary " )).dropField( " age " )
• D.  employees_df = employees_df.withColumn( " tax " , employees_df.salary * 0.1).drop( " age " )

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

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

Which location can be used to determine the owner of a managed table?

• A.  Review the Owner field in the database page using Data Explorer
• B.  Review the Owner field in the table page using Catalog Explorer
• C.  Review the Owner field in the schema page using Data Explorer
• D.  Review the Owner field in the table page using the SQL Editor

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 is not one of the included query's SQL endpoint.
• B.  They can set up the dashboard's SQL endpoint to be serverless.
• C.  They can ensure the dashboard's SQL endpoint matches each of the queries' SQL endpoints.
• D.  They can turn on the Auto Stop feature for the SQL endpoint.
• E.  They can reduce the cluster size of the SQL endpoint.

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.1
• B.  products[1]
• C.  products.0
• D.  products[0]