Online Access Free Databricks-Certified-Data-Engineer-Associate Practice Test

A data engineer is cleaning a Bronze table. The requirement is to eliminate rows where either the customer_email field or the customer_phone field is NULL. The cleaning must be performed in one operation using a single method call.
Which PySpark approach supports filtering multiple columns for NULL values in one call?

• A.df.dropna(subset=["customer_email", "customer_phone"])
• B.df.filter(col("customer_email").isNotNull() & col("customer_phone").isNotNull())
• C.df.na.drop(how="all")
• D.df.where("customer_email IS NOT NULL").where("customer_phone IS NOT NULL")

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?

• A.grant all privileges on table sales TO team;
• B.GRANT SELECT ON TABLE sales TO team;
• C.GRANT SELECT CREATE MODIFY ON TABLE sales TO team;
• D.GRANT ALL PRIVILEGES ON TABLE team TO sales;

Which of the following describes the storage organization of a Delta table?

• A.Delta tables are stored in a single file that contains data, history, metadata, and other attributes.
• B.Delta tables are stored in a collection of files that contain data, history, metadata, and other attributes.
• C.Delta tables are stored in a single file that contains only the data stored within the table.
• D.Delta tables are stored in a collection of files that contain only the data stored within the table.
• E.Delta tables store their data in a single file and all metadata in a collection of files in a separate location.

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?

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

A data engineer at a company that uses Databricks with Unity Catalog needs to share a collection of tables with an external partner who also uses a Databricks workspace enabled for Unity Catalog. The data engineer decides to use Delta Sharing to accomplish this.
What is the first piece of information the data engineer should request from the external partner to set up Delta Sharing?

• A.Their Databricks account password
• B.The name of their Databricks cluster
• C.The sharing identifier of their Unity Catalog metastore
• D.The IP address of their Databricks workspace