← Back to exam page

Databricks-Certified-Data-Analyst-Associate – Databricks Certified Data Analyst Associate Exam

Loading demo links...

Showing 4–6 of 10 questions

Question 4

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

Select an option, then click Submit answer.

  • ○

    Review the Owner field in the table page using Catalog Explorer B. Review the Owner field in the database page using Data Explorer

  • ○

    Review the Owner field in the schema page using Data Explorer D. Review the Owner field in the table page using the SQL Editor

Question 5

A data analyst has set up a SQL query to run every four hours on a SQL endpoint, but the SQL endpoint is taking too long to start up with each run.

Which of the following changes can the data analyst make to reduce the start-up time for the endpoint while managing costs?

Select an option, then click Submit answer.

  • ○

    Reduce the SQL endpoint cluster size

  • ○

    Increase the SQL endpoint cluster size

  • ○

    Turn off the Auto stop feature

  • ○

    Increase the minimum scaling value

  • ○

    Use a Serverless SQL endpoint

Question 6

A data analyst has created a user-defined function using the following line of code:

CREATE FUNCTION price(spend DOUBLE, units DOUBLE)

RETURNS DOUBLE

RETURN spend / units;

Which of the following code blocks can be used to apply this function to the customer_spend and customer_units columns of the table customer_summary to create column customer_price?

Select an option, then click Submit answer.

  • ○

    SELECT PRICE customer_spend, customer_units AS customer_price FROM customer_summary

  • ○

    SELECT price FROM customer_summary

  • ○

    SELECT function(price(customer_spend, customer_units)) AS customer_price FROM customer_summary

  • ○

    SELECT double(price(customer_spend, customer_units)) AS customer_price FROM customer_summary

  • ○

    SELECT price(customer_spend, customer_units) AS customer_price FROM customer_summary