vuthanhdatt's Second Brain

8

6 min read

Questions and Answers

Question k8eQttkIK5BDO9afSVeO

Question

A data analysis team has noticed that their Databricks SQL queries are running too slowly when connected to their always-on SQL endpoint. They claim that this issue is present when many members of the team are running small queries simultaneously. They ask the data engineering team for help. The data engineering team notices that each of the team’s queries uses the same SQL endpoint.

Which approach can the data engineering team use to improve the latency of the team’s queries?

Choices

  • A: They can increase the cluster size of the SQL endpoint.
  • B: They can increase the maximum bound of the SQL endpoint’s scaling range.
  • C: They can turn on the Auto Stop feature for the SQL endpoint.
  • D: They can turn on the Serverless feature for the SQL endpoint.

Question 3dJzaPIlAAgF2Tm7R3e9

Question

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 approach can the data engineer use to minimize the total running time of the SQL endpoint used in the refresh schedule of their dashboard?

Choices

  • 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 ensure the dashboard’s SQL endpoint is not one of the included query’s SQL endpoint.

Question bmTM97yk8WstpK8Ezu0P

Question

An engineering manager wants to monitor the performance of a recent project using a Databricks SQL query. For the first week following the project’s release, the manager wants the query results to be updated every minute. However, the manager is concerned that the compute resources used for the query will be left running and cost the organization a lot of money beyond the first week of the project’s release.

Which approach can the engineering team use to ensure the query does not cost the organization any money beyond the first week of the project’s release?

Choices

  • A: They can set a limit to the number of DBUs that are consumed by the SQL Endpoint.
  • B: They can set the query’s refresh schedule to end after a certain number of refreshes.
  • C: They can set the query’s refresh schedule to end on a certain date in the query scheduler.
  • D: They can set a limit to the number of individuals that are able to manage the query’s refresh schedule.

Question Ar5UZG5yeTJumc5CuSTR

Question

A new data engineering team team has been assigned to an ELT project. The new data engineering team will need full privileges on the table sales to fully manage the project.

Which command can be used to grant full permissions on the database to the new data engineering team?

Choices

  • A: GRANT ALL PRIVILEGES ON TABLE sales TO team;
  • B: GRANT SELECT CREATE MODIFY ON TABLE sales TO team;
  • C: GRANT SELECT ON TABLE sales TO team;
  • D: GRANT ALL PRIVILEGES ON TABLE team TO sales;

Question ND681lHcOs0wu5R1W62o

Question

Differentiate between all-purpose clusters and jobs clusters.

A data engineering team has created a python notebook to load data from cloud storage, this job has been tested and now needs to be scheduled in production.

Which would be the best cluster to be used in this case?

Choices

  • A: All purpose cluster
  • B: Any Unity Catalog-enabled cluster
  • C: Jobs Cluster
  • D: Serverless SQL warehouse

Graph View