vuthanhdatt's Second Brain

32

10 min read

Questions and Answers

Question KlxnOyrvb3AA0KMD0Xdd

Question

A data engineer has been using a Databricks SQL dashboard to monitor the cleanliness of the input data to a data analytics dashboard for a retail use case. The job has a Databricks SQL query that returns the number of store-level records where sales is equal to zero. The data engineer wants their entire team to be notified via a messaging webhook whenever this value is greater than 0.

Which of the following approaches can the data engineer use to notify their entire team via a messaging webhook whenever the number of stores with $0 in sales is greater than zero?

Choices

  • A: They can set up an Alert with a custom template.
  • B: They can set up an Alert with a new email alert destination.
  • C: They can set up an Alert with one-time notifications.
  • D: They can set up an Alert with a new webhook alert destination.
  • E: They can set up an Alert without notifications.

Question 8ui8IqYHyZmzfqq2Oz26

Question

A data engineer wants to schedule their Databricks SQL dashboard to refresh every hour, but they only want the associated SQL endpoint to be running when it is necessary. The dashboard has multiple queries on multiple datasets associated with it. The data that feeds the dashboard is automatically processed using a Databricks Job.

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?

Choices

  • A: They can turn on the Auto Stop feature for the SQL endpoint.
  • B: They can ensure the dashboard’s SQL endpoint is not one of the included query’s SQL endpoint.
  • C: They can reduce the cluster size of the SQL endpoint.
  • D: They can ensure the dashboard’s SQL endpoint matches each of the queries’ SQL endpoints.
  • E: They can set up the dashboard’s SQL endpoint to be serverless.

Question GI1QbnbihFdSjhqMYWSy

Question

A data engineer needs access to a table new_table, but they do not have the correct permissions. They can ask the table owner for permission, but they do not know who the table owner is.

Which of the following approaches can be used to identify the owner of new_table?

Choices

  • A: Review the Permissions tab in the table’s page in Data Explorer
  • B: All of these options can be used to identify the owner of the table
  • C: Review the Owner field in the table’s page in Data Explorer
  • D: Review the Owner field in the table’s page in the cloud storage solution
  • E: There is no way to identify the owner of the table

Question zC6LIf2HM6fcKmE1afPj

Question

Which of the following data lakehouse features results in improved data quality over a traditional data lake?

Choices

  • A: A data lakehouse provides storage solutions for structured and unstructured data.
  • B: A data lakehouse supports ACID-compliant transactions.
  • C: A data lakehouse allows the use of SQL queries to examine data.
  • D: A data lakehouse stores data in open formats.
  • E: A data lakehouse enables machine learning and artificial Intelligence workloads.

Question ntux67Ie4BPUYYaxyCg8

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 of the following commands 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 USAGE ON TABLE sales TO team;
  • E: GRANT ALL PRIVILEGES ON TABLE team TO sales;

Graph View