Databricks Certified Data Engineer Associate V1

A data engineer wants to create a new table containing the names of customers that live in France. They have written the following command: A senior data engineer mentions that it is organization policy to include a table property indicating that the new table includes personally identifiable information (PII). Which...

A data engineer wants to create a data entity from a couple of tables. The data entity must be used by other data engineers in other sessions. It also must be saved to a physical location. Which of the following data entities should the data engineer create?A . DatabaseB ....

Which of the following Git operations must be performed outside of Databricks Repos?A . CommitB . PullC . PushD . CloneE . MergeView AnswerAnswer: E Explanation: Databricks Repos is a visual Git client and API in Databricks that supports common Git operations such as commit, pull, push, branch management, and...

A dataset has been defined using Delta Live Tables and includes an expectations clause: CONSTRAINT valid_timestamp EXPECT (timestamp > '2020-01-01') ON VIOLATION DROP ROW What is the expected behavior when a batch of data containing data that violates these constraints is processed?A . Records that violate the expectation are dropped...

Which of the following commands will return the location of database customer360?A . DESCRIBE LOCATION customer360;B . DROP DATABASE customer360;C . DESCRIBE DATABASE customer360;D . ALTER DATABASE customer360 SET DBPROPERTIES ('location' = '/user'};E . USE DATABASE customer360;View AnswerAnswer: C Explanation: The command DESCRIBE DATABASE customer360; will return the location of...

A data engineer needs to create a table in Databricks using data from their organization’s existing SQLite database. They run the following command: Which of the following lines of code fills in the above blank to successfully complete the task?A . org.apache.spark.sql.jdbcB . autoloaderC . DELTAD . sqliteE . org.apache.spark.sql.sqliteView...

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...

Which of the following describes when to use the CREATE STREAMING LIVE TABLE (formerly CREATE INCREMENTAL LIVE TABLE) syntax over the CREATE LIVE TABLE syntax when creating Delta Live Tables (DLT) tables using SQL?A . CREATE STREAMING LIVE TABLE should be used when the subsequent step in the DLT pipeline...

Which of the following Structured Streaming queries is performing a hop from a Silver table to a Gold table? A) B) C) D) E) A . Option AB . Option BC . Option CD . Option DE . Option EView AnswerAnswer: E Explanation: The best practice is to use "Complete"...

Which of the following describes the relationship between Bronze tables and raw data?A . Bronze tables contain less data than raw data files.B . Bronze tables contain more truthful data than raw data.C . Bronze tables contain aggregates while raw data is unaggregated.D . Bronze tables contain a less refined...