A data engineer needs to apply custom logic to identify employees with more than 5 years of experience in array column employees in table stores. The custom logic should create a new column exp_employees that is an array of all of the employees with more than 5 years of experience for each row. In order to apply this custom logic at scale, the data engineer wants to use the FILTER higher-order function.Which of the following code blocks successfully completes this task?
A data engineer has a Python variable table_name that they would like to use in a SQL query. They want to construct a Python code block that will run the query using table_name.They have the following incomplete code block:____(f"SELECT customer_id, spend FROM {table_name}")Which of the following can be used to fill in the blank to successfully complete the task?
A data engineer has created a new database using the following command:CREATE DATABASE IF NOT EXISTS customer360;In which of the following locations will the customer360 database be located?
A data engineer is attempting to drop a Spark SQL table my_table and runs the following command:DROP TABLE IF EXISTS my_table;After running this command, the engineer notices that the data files and metadata files have been deleted from the file system.Which of the following describes why all of these files were deleted?
A data engineer that is new to using Python needs to create a Python function to add two integers together and return the sum?Which of the following code blocks can the data engineer use to complete this task?
A data engineer has a Job that has a complex run schedule, and they want to transfer that schedule to other Jobs.Rather than manually selecting each value in the scheduling form in Databricks, which of the following tools can the data engineer use to represent and submit the schedule programmatically?
